Managing Databases with Oracle - General Questions

1.

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.

2.

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.

3.

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.

4.

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.

5.

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.

6.

What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles?

A.	Full backup
B.	Consistent backup
C.	Inconsistent backup
D.	Differential backup

Answer: Option B

Explanation:

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

7.

Which SQL phrase is not supported by Oracle?

A.	ON DELETE CASCADE
B.	ON UPDATE CASCADE
C.	CREATE SEQUENCE [SequenceName]
D.	DROP SEQUENCE [SequenceName]

Answer: Option B

Explanation:

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

8.

When using SQL*Plus, Oracle commands, column names, table names and all other database elements:

A.	are case insensitive.
B.	are case sensitive.
C.	must always be in lower case.
D.	must always be in upper case.

Answer: Option A

Explanation:

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

1
2
3