Top

Introduction to SQL

21.

ORDER BY can be combined with the SELECT statements.

Answer: A

No answer description available for this question.

Enter details here

22.

Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.

Answer: B

No answer description available for this question.

Enter details here

Answer: B

No answer description available for this question.

Enter details here

Answer: D

No answer description available for this question.

Enter details here

25.

Delete from r; r – relation This command performs which of the following action ?

Answer: B

Delete command removes the entries in the table.

Enter details here

26.

SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN.

Answer: A

No answer description available for this question.

Enter details here

27.

The ADD command is used to enter one row of data or to add multiple rows as a result of a query.

Answer: B

No answer description available for this question.

Enter details here

Answer: A

No answer description available for this question.

Enter details here

29.

Which one of the following is used to define the structure of the relation ,deleting relations and relating schemas ?

Answer: B

Data Definition language is the language which performs all the operation in defining structure of relation.

Enter details here

30.

COUNT(field_name) tallies only those rows that contain a value; it ignores all null values.

Answer: A

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