Top

Advanced SQL

Answer: C

No answer description available for this question.

Enter details here

3.

The code to create triggers and routines is stored in only one location and is administered centrally.

Answer: A

No answer description available for this question. 

Enter details here

Answer: A

No answer description available for this question.

Enter details here

5.

When AUTOCOMMIT is set on, changes will be made automatically at the end of each SQL statement.

Answer: A

No answer description available for this question. 

Enter details here

6.

Triggers are stored blocks of code that have to be called in order to operate.

Answer: B

No answer description available for this question.

Enter details here

7.

With the UNION clause, each query involved must output the same number of columns, and they must be UNION compatible.

Answer: A

No answer description available for this question.

Enter details here

Answer: D

No answer description available for this question.

Enter details here

9.

The joining technique is useful when data from several relations are to be retrieved and displayed and the relationships are not necessarily nested.

Answer: A

No answer description available for this question.

Enter details here

10.

Outer join is the same as equi-join, except one of the duplicate columns is eliminated in the result table.

Answer: B

No answer description available for this question.

Enter details here

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