Top

Managing Databases with Oracle

1.

Sequences guarantee valid surrogate key values.

Answer: B

No answer description available for this question.

Enter details here

2.

What Oracle backup and recover file contains user and system 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

4.

Oracle maintains a System Change Number (SCN) which is a database-wide value that is incremented by Oracle whenever database changes are made.

Answer: A

No answer description available for this question. 

Enter details here

Answer: D

No answer description available for this question.

Enter details here

6.

When you type into SQL*Plus and press enter, the statement will be finished and executed.

Answer: B

No answer description available for this question.

Enter details here

7.

You can use the DROP statement to remove structures from the database.

Answer: A

No answer description available for this question.

Enter details here

8.

Indexes are created to enforce uniqueness on columns and to enable fast retrieval by column values.

Answer: A

No answer description available for this question. 

Enter details here

9.

Oracle does NOT support a CASCADE UPDATE constraint.

Answer: A

No answer description available for this question.

Enter details here

Answer: D

No answer description available for this question.

Enter details here

Loading…
Tags: Managing Databases with Oracle Questions and Answers || Managing Databases with Oracle MCQ Questions and Answers || Managing Databases with Oracle GK Questions and Answers || Managing Databases with Oracle GK MCQ Questions || Managing Databases with Oracle Multiple Choice Questions and Answers || Managing Databases with Oracle GK || GK on Managing Databases with Oracle || Database Questions and Answers || Database MCQ Questions and Answers || Database GK Questions and Answers || GK on Database