DBMS MCQ Questions and Answer Set-9

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

1. Aggregate functions are functions that take a ___________ as input and return a single value. a) Collection of values b) Single value c) Aggregate value d) Both Collection of values & Single value Answer: a 2. SELECT __________FROM instructor WHERE dept name= ’Comp. Sci.’; Which of the following should be used to find the mean of the salary? a) Mean(salary) b) Avg(salary) c) Sum(salary) d) Count(salary) Answer: b 3. SELECT COUNT (____ ID) FROM teach...
Read More