Accenture Interview Questions | If a emp table is having duplicate emp_id then can we make it primary key?
Question
TheDataMonk
Follow Me
About TheDataMonkGrand Master
I am the Co-Founder of The Data Monk. I have a total of 6+ years of analytics experience 3+ years at Mu Sigma 2 years at OYO 1 year and counting at The Data Monk I am an active trader and a logically sarcastic idiot :)Follow Me
Related questions
The Given Data set, Table has transitive dependencies. Explain Which Attributes are partially dependent. How will you overcome this? Explain the approach?
Write a query to Plot a Relationship between the highest followers in every country (Country Wise Highest Followers) and show which country has the highest followers and which country has the lowest one. Explain the approach?
Write a Query to Find the account with the highest number of followers in every country. Explain the approach?
Assign Rank To each Category by authentic engagement in each country and return the category with a rank less than 3. Explain the Approach?
Write a Query to check for Missing values in the given table? Explain how will you deal with the missing data for qualitative and quantitative data?
Answers ( 4 )
No a primary key should always be unique and non-null. Since in this table emp_id is containing duplicate values we cannot make it as a primary key of the table. Either we should remove the duplicate using the ACID property of RDBMS or use a combination of any other field with emp_id to make it unique and then make it the primary key of the table
No, we cannot make empid as primary key. By the definition of primary key, a primary key is one which is able to uniquely identify each tuple of the table. As the table contains dupilicate values of empid, so it cannot be made primary key.
No, we cannot make Empid as PRIMARY KEY because PRIMARY KEY has to be UNIQUE and don’t contain any NULL values.
As the Column Empid contains Duplicate values, It cannot be treated as the PRIMARY KEY.
Primary key should have distinct and non null values. If emp ID has duplicate values it cannot act as a primary key but combination of columns with emp ID which makes the row have unique identifier can act as primary key (combination of columns)