Database - Managing Databases with Oracle

Exercise :: Managing Databases with Oracle - General Questions

16. 

You have linked SQL*Plus to an external text editor. To invoke the text editor for use within SQL*Plus, which command do you use?

A. Open [FileName]
B. Show [FileName]
C. Alter [FileName]
D. Edit [FileName]

Answer: Option D

Explanation:

No answer description available for this question. Let us discuss.

17. 

The default extension for an Oracle SQL*Plus file is:

A. .txt.
B. .pls.
C. .ora.
D. .sql.

Answer: Option D

Explanation:

No answer description available for this question. Let us discuss.

18. 

An Oracle System Change Number (SCN):

A. is a value that is incremented whenever a dirty read occurs.
B. is incremented whenever a deadlock occurs.
C. is a value that keeps track of explicit locks.
D. is a value that is incremented whenever database changes are made.

Answer: Option D

Explanation:

No answer description available for this question. Let us discuss.

19. 

To obtain the structure of an Oracle table, the command to use is:

A. STRUCTURE [TableName].
B. DESCRIBE [TableName].
C. DESCRIBE STRUCTURE [TableName].
D. DESC TABLE [TableName].

Answer: Option B

Explanation:

No answer description available for this question. Let us discuss.

20. 

To see the contents of the SQL*Plus buffer, type:

A. CONTENTS.
B. BUFFER.
C. CURRENT.
D. LIST.

Answer: Option D

Explanation:

No answer description available for this question. Let us discuss.

« Prev   1 2 3 4