Every table in relational database contain a field or combination of fields that can uniquely identify each records, it is called

Related MCQs

• If I create ‘Student’ field in ‘Fees’ table to store ‘student_id’ of ‘Students’ table, then this ‘Student’ field in ‘Fees’ table is called:
• In relational database schema each tuple is divided into fields known as?
• In Access to Refresh the contents of a Lookup field (Lookup field: A field, used on a form or report in an Access database, that either displays a list of values retrieved from a table or query, or stores a static set of values.) list box or combo box
• How can you link a table with another so that a field in current table will display values in drop down box from another table while entering data:
• in a relational schema, each tuple is divided into fields called
• The key uniquely identifies each record in a table.
• You created a query with two tables that have relationship of One-To-Many with referential rules applied. The first table has 3 records and the second has 8. With using a right outer join, how many records will the resulting recordset have?
• You created a query with two tables that did NOT have a join line. The first table has 12 records and the second has 5. The resulting recordset would have how many records?
• This is the stage in database design where one gathers and lists all the necessary fields for the database project.
• This is the stage in database design where one gathers and list all the necessary fields for the database project.