Oracle8i Architecture and Administration Set 4

1.

Which database operation reads redo logs?

Commit Rollback Recover Shutdown abort

2.

How should you set the parameter LOG_CHECKPOINT_ to disable time-based checkpoints?

TIMEOUT to 0 INTERVAL to 0 TIMEOUT to FALSE INTERVAL to FALSE

3.

What would a DBA do to create the metadata for transportable tablespace?

Use the DBMS_TTS package.

Use the CREATE METADATA command.

Use the TRANSPORT_TABLESPACE export parameter.

Use the ALTER TABLESPACE tablespace METADATA

4.

Which role needs to be assigned to a user in order to export object owned by another user?

EXPORT_ALL

EXP_DATABASE

DBA_SYS_PRIVS

EXP_FULL_DATABASE

5.

You are shutting down a database with one tablespace offline. What is the status of this tablespace after
restarting the database?

It is lost. It is online. It is offline It is in recover mode.

6.

Which action physically relocates a tablespace?

Issuing the ALTER DATABASE MOVE TABLESPACE...command. Issuing the ALTER TABLESPACE RENAME DATAFILE...command. Issuing the ALTER TABLESPACE RENAME TABLESPACE...command. Using an operating system utility like copy or cp to copy the tablespace datafiles to another device.

7.

What can a temporary tablespace contain?

Only temporary segments. Only permanent segments. Both temporary and ordinary data files. Both permanent and temporary segments.

8.

Which statement about a tablespace is true?

A tablespace can be read-only. A tablespace must contain at least one segment. A tablespace can belong to more than one database. A read-only tablespace cannot be switched to read-write status. Any tablespace can be taken offline while the database is running.

9.

Which component is NOT part of the shared pool?

The library cache. The shared SQL area. The program global area. The data dictionary cache.

10.

Information about employees and departments is stored in two tables. Which of these business rules CANNOT
be enforces by means of declarative integrity constraints?

Employees must be assigned to an existing department. Employee hire dates must precede employee termination dates. Employee badge numbers are unique. Some employees do not have a badge number. When employee salaries are updates, the new salary cannot be less than the old salary. Employees are uniquely identified by their employee IDs. Every employee has an employee ID.

Oracle8i Architecture and Administration Set 4

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner

Oracle8i Architecture and Administration Set 4

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

Detail Form

COMPANY

Products

OTHERS

Partner