Question 1

Various types of operations can be performed on partitions individually,affecting only small physical parts of very large tables.

Accepted Answer

A) True 
 B)False

Question 2

The ____ tablespace is created by default in the DBCA tool,and is intended to contain application structures and data.

Accepted Answer

A)  UNDO 
B)  USERS 
C)  SYSTEM 
D)  SYSAUX 
A)  UNDO 
B)  USERS 
C)  SYSTEM 
D)  SYSAUX

Question 3

To drop a log file group you can use the ____ command.

Accepted Answer

A)  DROP LOG 
B)  DROP LOGFILE 
C)  ALTER DATABASE 
D)  ALTER LOGFILE 
A)  DROP LOG 
B)  DROP LOGFILE 
C)  ALTER DATABASE 
D)  ALTER LOGFILE

Question 4

The MAXLOGHISTORY phrase applies only to Oracle Real _________________________.

Accepted Answer

Applicatio

Question 5

Why would you want to drop redo log members?

Accepted Answer

There are many reasons to drop redo log

Question 6

____ shows data held in the record section.

Accepted Answer

A)  V$CONTROLFILE 
B)  V$CONTROLFILE_RECORD_SECTION 
C)  V$PARAMETER 
D)  V$DATABASE 
A)  V$CONTROLFILE 
B)  V$CONTROLFILE_RECORD_SECTION 
C)  V$PARAMETER 
D)  V$DATABASE

Question 7

You can use data dictionary views to help you build queries,debug SQL problems,and review naming conventions.

Accepted Answer

A) True 
 B)False

Question 8

Data dictionary views are based on tables owned by the SYSDBA user that are updated automatically by the Oracle 10g database.

Accepted Answer

A) True 
 B)False

Question 9

Multiple tablespaces can share the same datafile.

Accepted Answer

A) True 
 B)False

Question 10

____ lists the names of the control files in use by the database.

Accepted Answer

A)  V$CONTROLFILE 
B)  V$CONTROLFILE_RECORD_SECTION 
C)  V$PARAMETER 
D)  V$DATABASE 
A)  V$CONTROLFILE 
B)  V$CONTROLFILE_RECORD_SECTION 
C)  V$PARAMETER 
D)  V$DATABASE

Various types of operations can be performed on partitions individually,affecting only small physical parts of very large tables.

The ____ tablespace is created by default in the DBCA tool,and is intended to contain application structures and data.

To drop a log file group you can use the ____ command.

The MAXLOGHISTORY phrase applies only to Oracle Real _________________________.

Why would you want to drop redo log members?

____ shows data held in the record section.

You can use data dictionary views to help you build queries,debug SQL problems,and review naming conventions.

Data dictionary views are based on tables owned by the SYSDBA user that are updated automatically by the Oracle 10g database.

Multiple tablespaces can share the same datafile.

____ lists the names of the control files in use by the database.

Oracle Architecture Overview

Tools and Architecture

Creating an Oracle Instance

Basic Storage Concepts and Settings

The Basics of Querying a Database

Basic Table Management

Advanced Table Management

Constraints, indexes, and Other Specialized Objects

Basic Data Management

Advanced Data Management

Security Management

Performance Monitoring

Proactive Maintenance

Backup and Recovery

Filters

Exam 4: Oracle Physical Architecture and Data Dictionary Views

Various types of operations can be performed on partitions individually,affecting only small physical parts of very large tables.

The ____ tablespace is created by default in the DBCA tool,and is intended to contain application structures and data.

To drop a log file group you can use the ____ command.

The MAXLOGHISTORY phrase applies only to Oracle Real _________________________.

Why would you want to drop redo log members?

____ shows data held in the record section.

You can use data dictionary views to help you build queries,debug SQL problems,and review naming conventions.

Data dictionary views are based on tables owned by the SYSDBA user that are updated automatically by the Oracle 10g database.

Multiple tablespaces can share the same datafile.

____ lists the names of the control files in use by the database.

Oracle Architecture Overview

Tools and Architecture

Creating an Oracle Instance

Basic Storage Concepts and Settings

The Basics of Querying a Database

Basic Table Management

Advanced Table Management

Constraints, indexes, and Other Specialized Objects

Basic Data Management

Advanced Data Management

Security Management

Performance Monitoring

Proactive Maintenance

Backup and Recovery

Filters