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]

Correct Answer:  D. Edit [FileName]

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

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

Correct Answer:  D. .sql.

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.

Correct Answer:  D. is a value that is incremented whenever database changes are made.

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].

Correct Answer:  B. DESCRIBE [TableName].

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

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

Correct Answer:  D. LIST.

Leave A Comment?

15 + ten =