Top

Introduction to SQL

11.

The condition in a WHERE clause can refer to only one value.

Answer: B

No answer description available for this question.

Enter details here

12.

You can add a row using SQL in a database with which of the following?

Answer: C

No answer description available for this question.

Enter details here

13.

To remove a relation from an SQL database, we use the ______ command.

Answer: D

Drop table deletes the whole structure of the relation .purge removes the table which cannot be obtained again.

Enter details here

Answer: D

No answer description available for this question.

Enter details here

15.

The keyword BETWEEN can be used in a WHERE clause to refer to a range of values.

Answer: A

No answer description available for this question.

Enter details here

16.

SQL is a data sublanguage.

Answer: A

No answer description available for this question. 

Enter details here

17.

A dynamic view is one whose contents materialize when referenced.

Answer: A

No answer description available for this question.

Enter details here

18.

A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery.

Answer: B

No answer description available for this question.

Enter details here

19.

Which of the following do you need to consider when you make a table in SQL?

Answer: D

No answer description available for this question.

Enter details here

20.

To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.

Answer: C

No answer description available for this question.

Enter details here

Loading…
Tags: Introduction to SQL Questions and Answers || Introduction to SQL MCQ Questions and Answers || Introduction to SQL GK Questions and Answers || Introduction to SQL GK MCQ Questions || Introduction to SQL Multiple Choice Questions and Answers || Introduction to SQL GK || GK on Introduction to SQL || Database Questions and Answers || Database MCQ Questions and Answers || Database GK Questions and Answers || GK on Database