Aptitude Tests, Mental Ability, Objective MCQ Sets, Questions and Answers, PDF, Shortcut Tips

SQL (Structured Query Language) → Page 3

SQL (Structured Query Language) 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 interview and SQL practical tests. You know that SQL is the short form of Structured Query Language. SQL (pronounced as 'es-q-el') is a s...READ MORE


TEST INSTRUCTION: CLICK OPTION (A, B, C, D) TO SEE ANSWER.


Q.

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

2. 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.

3. The COUNT function in SQL returns the number of ______________

A.
Values
B.
Distinct values

C.
Group By
D.
Columns


Show Answer
Q.

4. Which data type can store unstructured data in a column?

A.
RAW
B.
CHAR

C.
NUMERIC
D.
VARCHAR


Show Answer
Q.

5. A SQL query will not work if there are no indexes on the relations - Is it true ?

A.
NO
B.
YES


Show Answer




eXTReMe Tracker