IndiaBIX

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?
Open [FileName]
Show [FileName]
Alter [FileName]
Edit [FileName]
Answer: Option
Explanation:
No answer description is available. Let's discuss.
17.
The default extension for an Oracle SQL*Plus file is:
.txt.
.pls.
.ora.
.sql.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
18.
An Oracle System Change Number (SCN):
is a value that is incremented whenever a dirty read occurs.
is incremented whenever a deadlock occurs.
is a value that keeps track of explicit locks.
is a value that is incremented whenever database changes are made.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
19.
To obtain the structure of an Oracle table, the command to use is:
STRUCTURE [TableName].
DESCRIBE [TableName].
DESCRIBE STRUCTURE [TableName].
DESC TABLE [TableName].
Answer: Option
Explanation:
No answer description is available. Let's discuss.
20.
To see the contents of the SQL*Plus buffer, type:
CONTENTS.
BUFFER.
CURRENT.
LIST.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers