Exercise: Managing Databases With Oracle

Questions for: Managing Databases With Oracle

To see the contents of the SQL*Plus buffer, type:
A:
CONTENTS.
B:
BUFFER.
C:
CURRENT.
D:
LIST.
Answer: D
No answer description is available. Let's discuss.
📖
📝
💬
👁️
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: B
No answer description is available. Let's discuss.
📖
📝
💬
👁️
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: D
No answer description is available. Let's discuss.
📖
📝
💬
👁️
The default extension for an Oracle SQL*Plus file is:
A:
.txt.
B:
.pls.
C:
.ora.
D:
.sql.
Answer: D
No answer description is available. Let's discuss.
📖
📝
💬
👁️
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: D
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Ad Slot (Above Pagination)
Quiz