DBMS Tutorial Point
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
Very important DBMS MCQ Questions . 1. Which data manipulation command is used to combines the records from one or more tables? A. SELECT B. PROJECT C. JOIN D. PRODUCT 2. SQL permits attribute names to be repeated in the same relation. (True or False) A. FALSE B. TRUE 3. Which of the following operations … Read more
What is Candidate Key in DBMS? A Candidate Key in DBMS is a minimal set of columns/attributes that can be used to uniquely identify a single/every tuple or row in a relation. Candidate Keys are determined during database design based on the underlying business rules of the database. After finding all possible candidate keys in a relation.DBA chooses … Read more