Top

Introduction to SQL

51.

If you are going to use a combination of three or more AND and OR conditions, it is often easier to use the NOT and NOT IN operators.

Answer: A

No answer description available for this question. 

Enter details here

52.

Indexes can usually be created for both primary and secondary keys.

Answer: A

No answer description available for this question.

Enter details here

53.

To sort the results of a query use:

Answer: C

No answer description available for this question. 

Enter details here

Answer: A

No answer description available for this question.

Enter details here

55.

Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value.

Answer: B

No answer description available for this question.

Enter details here

56.

SQL data definition commands make up a(n) ________ .

Answer: A

No answer description available for this question. 

Enter details here

57.

SUM, AVG, MIN, and MAX can only be used with numeric columns.

Answer: B

No answer description available for this question.

Enter details here

58.

Microsoft Access has become ubiquitous, and being able to program in Access is a critical skill.

Answer: B

No answer description available for this question.

Enter details here

59.

Which of the following is the correct order of keywords for SQL SELECT statements?

Answer: A

No answer description available for this question. 

Enter details here

60.

SELECT DISTINCT is used if a user wishes to see duplicate columns in a query.

Answer: B

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