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-1

DBMS-MCQ
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 size of n in a column which is defined as VARCHAR(n)? a) NULL b) 0 c) 1 d) None of the above ANS: C 4) How can we get all records (redundant as well as non-redundant) from the union operator?...
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