SQL MCQ Online Exam Quiz

Important questions about SQL MCQ. SQL MCQ MCQ questions with answers. SQL MCQ exam questions and answers for students and interviews.

1. The language used in application programs to request data from the DBMS is referred to as the

Options

A : DML

B : DDL

C : VDL

D : SDL

2. The language which has recently become the defacto standard for interfacing application programs with a relational database system is

Options

A : Oracle

B : SQL

C : DBase

D : 4GL

3. The DBMS language component which can be embedded in a program is

Options

A : The data definition language (DDL)

B : The data manipulation language (DML)

C : The data manipulation language (DML)

D : A query language

4. Count function in SQL returns the number of

Options

A : Values

B : Distinct values

C : Groups

D : Columns

5. It is possible to define a schema completely using

Options

A : VDL and DDL

B : DDL and DML

C : SDL and DDL.

D : VDL and DML

6. The statement in SQL which allows to change the definition of a table is

Options

A : Alter

B : Update

C : Create

D : Select

7. Which of the following is correct:

Options

A : a SQL query automatically eliminates duplicates.

B : SQL permits attribute names to be repeated in the same relation.

C : a SQL query will not work if there are no indexes on the relations

D : None of these

8. Which of the following is a valid SQL type?

Options

A : CHARACTER

B : NUMERIC

C : FLOAT

D : All of the above

9. Which of the following operations need the participating relations to be union compatible?

Options

A : UNION

B : INTERSECTION

C : DIFFERENCE

D : All of these

10. The full form of DDL is

Options

A : Dynamic Data Language

B : Detailed Data Language

C : Data Definition Language

D : Data Derivation Language

11. Which of the following is a legal expression in SQL?

Options

A : SELECT NULL FROM EMPLOYEE

B : SELECT NAME FROM EMPLOYEE

C : SELECT NAME FROM EMPLOYEE WHEN SALARY = NULL

D : None of the above

12. Which of the following is a comparison operator in SQL?

Options

A : =

B : LIKE

C : BETWEEN

D : All of the above

13. To delete a particular column in a relation the command used is:

Options

A : UPDATE TABLE

B : TRUNCATE COLUMN

C : ALTER , DROP

D : DELETE COLUMN

14. The ______ operator is used to compare a value to a list of literals values that have been specified.

Options

A : BETWEEN

B : ANY

C : IN

D : ALL

15. _____________ function divides one numeric expression by another and returns the remainder

Options

A : POWER

B : MOD

C : ROUND

D : REMAINDER

16. A data manipulation command the combines the records from one or more tables is called

Options

A : SELECT

B : PROJECT

C : JOIN

D : PRODUCT

17. _________ is a virtual table that draws its data from the result of an SQL SELECT statement

Options

A : View

B : Synonym

C : Sequence

D : Transaction

18. _________ data type can store unstructured data

Options

A : RAW

B : CHAR

C : NUMERIC

D : VARCHAR

Data Scientist - Practice Questions New more Online Exam Quiz

Copyright © 2021
Exam-GK-MCQ-Questions.Com | Contact Us | Privacy Policy | Terms of Use | Sitemap | 0.019134044647217