DBMS MCQ Questions and Answer Set-7

DBMS-MCQ

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

DBMS MCQ Questions and Answer Set-3

DBMS-MCQ

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

DBMS MCQ Questions and Answer Set-4

DBMS-MCQ

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