DBMS Tutorial Point
Database-management-system Tutorial .
1. Aggregate functions are functions that take a ___________ as input and return a single value. a) Collection of values b) Single value c) Aggregate value d) Both Collection of values & Single value Answer: a 2. SELECT __________FROM instructor WHERE dept name= ’Comp. Sci.’; Which of the following should be used to find the … Read more
This article includes the latest and most important DBMS MCQ questions which are very important regarding interviews. 1. Consider a Payment table with attributes PAY_ID (Primary Key), PAY_DT, PAY_AMT, BANK_ACCT, INIT_NAME, and PAY_MODE. Except for PAY_ID, no columns are unique. The table has three indexes as follows: IDX1 – PAY_ID IDX2 – BANK_ACCT, PAY_AMT IDX3 … Read more
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 … Read more
1) 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) 1 b) 2 c) 3 d) 4 ANS: B 3) What is the default … Read more
1. What operator tests the column for the absence of data? A. EXISTS operator B. NOT operator C. IS NULL operator D. None of these Answer: C 2. In SQL, which command(s) is (are) used to change a table’s storage characteristic? A. ALTER TABLE B. MODIFY TABLE C. CHANGE TABLE D. All of the above … Read more