DBMS Tutorial Point
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
1. Which of the following relational algebra operations do not require the participating tables to be union-compatible? (A) ) Union (B) Intersection (C) Difference (D) Join Ans: (D) 2. Which of the following is not a property of transactions? (A) Atomicity (B) Concurrency (C) Isolation (D) Durability Ans: (B) 3. Checkpoints are a part of … Read more