A data type that creates unique numbers for key columns in Microsoft Access is:

Related MCQs

• State true or false i) A candidate key is a minimal super key. ii) A candidate key can also refer to as surrogate key.
• A primary key is combined with a foreign key creates
• What will be the number of columns of CARTESIAN PRODCUT if the participating relations have 5 and 7 columns respectively?
• A relation is said to be in 3 NF if (i) it is in 2 NF (ii) non-key attributes are independent of one another (iii) key attribute is not dependent on part of a composite key (iv) has no multi-valued dependency
• In                                  of Oracle, the database administrator creates a user account in the database for each user who needs access.
• Which of the following is a structure that provides faster access to the rows of a table based on the values of one or more columns?
• Given the relation Supplier(s_id, p_order, s_name, qty) Given that there is a unique s_name for each s_id and that s_id, p_order is a composite key, find the correct statement among the following: i. this relation is a BCNF ii. this is 3 NF relation iii. this is a 2 NF relation iv. this is a 1 NF relation
• In a                clustering index, the index record contains the search-key value and a pointer to the first data record with that search-key value and the rest of the records will be in the sequential pointers.
• In a _______ clustering index, the index record contains the search-key value and a pointer to the first data record with that search-key value and the rest of the records will be in the sequential pointers.
• Which of the following are the process of selecting the data storage and data access characteristics of the database?