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

DBMS-MCQ
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

DBMS MCQ Questions and Answer Set-7

DBMS-MCQ
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 – INIT_NAME, PAY_DT Which of the following queries will result in INDEX RANGE SCAN a) WHERE INIT_NAME LIKE '%ven' b) WHERE PAY_ID <> 200 c) WHERE PAY_MODE = 'online' d) WHERE INIT_NAME = 'Alice' and PAY_DT > '1-Jan-2015...
Read More

DBMS MCQ Questions and Answer Set-2

DBMS-MCQ
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) 1b) 2c) 3d) 4 ANS: b 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? a) Using ‘ALL...
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