Top

SQL for Database Construction

1.

The SQL statement used to create a view is CREATE VIEW.

Answer: A

No answer description available for this question.

Enter details here

Answer: C

No answer description available for this question. 

Enter details here

Answer: C

No answer description available for this question.

Enter details here

Answer: D

No answer description available for this question.

Enter details here

5.

If any required (NOT NULL) columns are missing from the view, the view cannot be used for inserting new data.

Answer: A

No answer description available for this question.

Enter details here

6.

A benefit of using a stored procedure is that it can be distributed to client computers.

Answer: B

No answer description available for this question. 

Enter details here

7.

SQL has a JOIN ON syntax that can be used to create inner joins and outer joins.

Answer: A

No answer description available for this question.

Enter details here

8.

A trigger is a stored program that is attached to a database.

Answer: B

No answer description available for this question.

Enter details here

9.

A updatable view has its own data.

Answer: B

No answer description available for this question.

Enter details here

Answer: A

No answer description available for this question.

Enter details here

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