Top

Introduction to SQL

31.

Most companies keep at least two versions of any database they are using.

Answer: A

No answer description available for this question.

Enter details here

32.

The rows of the result relation produced by a SELECT statement can be sorted, but only by one column.

Answer: B

No answer description available for this question.

Enter details here

33.

SQL provides the AS keyword, which can be used to assign meaningful column names to the results of queries using the SQL built-in functions.

Answer: A

No answer description available for this question.

Enter details here

34.

Which one of the following sorts rows in SQL?

Answer: C

No answer description available for this question.

Enter details here

Answer: A

No answer description available for this question.

Enter details here

36.

The basic data type char(n) is a _____ length character string and varchar(n) is _____ length character.

Answer: C

Varchar changes its length accordingly whereas char has a specific length which has to be filled by either letters or spaces .

Enter details here

Answer: A

No answer description available for this question. 

Enter details here

38.

The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries.

Answer: A

No answer description available for this question.

Enter details here

Answer: C

No answer description available for this question.

Enter details here

40.

The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows.

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