DBMS MCQ Questions and Answer Set-9

Dbms_Mcq
It Includes the latest DBMS MCQ Questions and Answer.SQL Online test questions and answers. 1.Evaluate the SQL statement: SELECT ROUND (TRUNC (MOD (1600, 10),-1), 2) FROM dual; What will be displayed? a) 0 b) 1 c) C.0.00 d) D.an error statement Ans A 2.Evaluate the SQL statement: TRUNCATE TABLE DEPT; Which three are true about the SQL statement? A. It releases the storage space used by the table. B. It does not release the storage space used by the table. C. Y...
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 (A) Recovery measures. (B) Security measures. (C ) Concurrency measures. (D) Authorization measures. A...
Read More

DBMS MCQ Questions and Answer Set-6

DBMS-MCQ
1-A Database Management System (DBMS) is A. Collection of interrelated data B. Collection of programs to access data C. Collection of data describing one particular enterprise D. All of the above 2. Which of the following is not a level of data abstraction? A. Physical Level B. Critical Level C. Logical Level D. View Level 3. Disadvantages of File systems to store data is: A. Data redundancy and inconsistency B. Difficulty in accessing data C. Data isolation D. All o...
Read More