in Education by
Which of the following can be used as a primary key entry of the instructor relation. (a) DEPT_NAME (b) NAME (c) ID (d) All of the mentioned I had been asked this question in semester exam. This is a very interesting question from Querying database part-1 DDL in section Database Systems Design and Implementation of Database Management

1 Answer

0 votes
by
Right answer is (c) ID Explanation: The value ID can only be primary key unlike dept_name which is used as a foreign key.

Related questions

0 votes
    The relation with the attribute which is the primary key is referenced in another relation. The relation ... Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    Which of the following command is used to display the departments of the instructor relation? (a) ... chapter Database Systems Design and Implementation of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
    Am trying to perform an update and nothing seems to work. It has something to do with my callback ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Feb 11, 2022 in Education by JackTerrance
0 votes
    If every non-key attribute is functionally dependent primary key, then the relation will be in (a) First ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    Which one of the following attribute can be taken as a primary key? (a) Name (b) Street (c) Id ... and Answers, Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    In the section relation which of the following is used as a foreign key? (a) Course_id (b) ... Answers, Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    The department relation has the an entry budget whose type has to be replaced by (a) Varchar (20) ... Answers, Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    ____________ is a combination of two of more attributes used as a primary key (a) Composite Key (b) ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    In a __________ index, an index entry appears for only some of the search-key values. (a) Dense (b) ... from Ordered Indices in portion Indexing and Hashing of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
    The primary key must be (a) Unique (b) Not null (c) Both Unique and Not null (d) Either Unique ... and Answers, Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    In which of the following, a separate schema is created consisting of that attribute and the primary key ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    In which of the following, a separate schema is created consisting of that attribute and the primary key ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    9. Cancel button (x on formula bar) can be used to undo a cell entry after it has been completed (a) True (b) ... ) Alt+P (d) Ctrl+P Select the correct answer from above options...
asked Dec 13, 2021 in Education by JackTerrance
0 votes
    Which of the following can be useful for diagnosing data entry errors? (a) hat values (b) dffit (c) ... questions and answers pdf, Data Science interview questions for beginners...
asked Oct 29, 2021 in Education by JackTerrance
0 votes
    I have the following models: class Project(models.Model): name = models.CharField(max_length=300, unique= ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked May 22, 2022 in Education by JackTerrance
...