Exam Tiger
APTITUDE TESTS - MENTAL ABILITY - SOLVED OBJECTIVE MCQ SETS - QUESTION ANSWER - PDF STUDY MATERIALS - SHORTCUT TIPS

SQL Multiple Choice Questions and Answer → Page 3

SQL Multiple Choice Questions and Answer solved MCQ sets : SQL MCQ Questions : Here you will get selected & important objective type MCQs on SQL in online quiz mode. These SQL mcqs will not only help the freshers, but will be also be useful to experienced during SQL intervie...READ MORE


INSTRUCTION: CLICK ON THE OPTION (A, B, C, D) TO SELECT IT AS YOUR ANSWER.


Q. Which of the following is a legal expression in SQL?
A.
SELECT NULL FROM SALES;
B.
SELECT NAME FROM SALES;

C.
SELECT * FROM SALES WHEN PRICE = NULL;
D.
SELECT # FROM SALES;


Show Answer
Q. DCL provides commands to performactionslike
A.
Change thestructureof Tables
B.
Insert, Update or Delete Records and Values

C.
Authorizing Access and othercontrolover Database
D.
None of Above


Show Answer
Q. The COUNT function in SQL returns the number of ______________
A.
Values
B.
Distinct values

C.
Group By
D.
Columns


Show Answer
Q. Which data type can store unstructured data in a column?
A.
RAW
B.
CHAR

C.
NUMERIC
D.
VARCHAR


Show Answer
Q. A SQL query will not work if there are no indexes on the relations - Is it true ?
A.
NO
B.
YES


Show Answer



Advertisement


eXTReMe Tracker