DBMS MCQ Questions and Answer Set-2

Determine the highest possible normal form of the given relation: A -->BCDEF, BC --> ADEF, B -->F a) 1NF b) 2 NF c) 3NF d) BCNF ANS: a 2) How many types of Indexes are there in SQL Server? a) 1b) 2c) 3d) 4 ANS: b What is the default size of n in a column which is defined as VARCHAR(n)? a) NULL b) 0 c) 1 d) None of the above ANS: c 4) How can we get all records (redundant as well as non-redundant) from the union operator? a) Using ‘ALL...
Read More