Question 1

An online backup requires shutting down the database,then copying all of the database files to an alternate location.

Accepted Answer

A) True 
 B)False  False

Question 2

From the MOUNTED state,the startup process opens the datafiles and redo log files,performs database recovery operations if necessary,and then starts the Oracle Net server process to service user requests.

Accepted Answer

A) True 
 B)False  True

Question 3

For an UPDATE action query,the redo log file contains a pre-image of the updated fields,which shows the data values before the update.

Accepted Answer

A) True 
 B)False  True

Question 4

How many redo log groups exist by default?

Accepted Answer

A) 2 
B) 3 
C) 4 
D) 5 
A) 2 
B) 3 
C) 4 
D) 5

Question 5

A tablespace's ____________________ determines whether it is available to users.

Accepted Answer

The answer of A tablespace's ____________________ determines whether it is...

Question 6

When performing DBA administrative tasks such as shutting down the database,the DBA must specify a connect role of SYSOPER or ____.

Accepted Answer

A) SYS 
B) SYSMGR 
C) SYSMON 
D) SYSDBA 
A) SYS 
B) SYSMGR 
C) SYSMON 
D) SYSDBA

Question 7

A(n)____________________ server specifies the location of servers on a network.

Accepted Answer

The answer of A(n)____________________ server specifies the location of servers...

Question 8

What tasks make up the service role for DBAs?

Accepted Answer

Install and upgrade the DBMS software on

Question 9

How many tiers does the OEM have?

Accepted Answer

A) 1 
B) 3 
C) 4 
D) 5 
A) 1 
B) 3 
C) 4 
D) 5

Question 10

What does the database do first during a Normal shutdown?

Accepted Answer

A) Closes all files 
B) Writes the contents of the data buffer cache to the datafiles 
C) Stops all background processes 
D) Writes the contents of the redo log buffer to the redo log files 
A) Closes all files 
B) Writes the contents of the data buffer cache to the datafiles 
C) Stops all background processes 
D) Writes the contents of the redo log buffer to the redo log files

Question 11

Tier 1 of the OEM contains the ____________________,which is the workstation at which the DBA performs administration tasks.

Accepted Answer

The answer of Tier 1 of the OEM contains the...

Question 12

What backup strategy is best?

Accepted Answer

A) offline backups only 
B) online backups only 
C) a combination of offline and online backups 
D) depends on the needs of the specific organization 
A) offline backups only 
B) online backups only 
C) a combination of offline and online backups 
D) depends on the needs of the specific organization

Question 13

The global database name is based on the database server workstation's Internet Protocol (IP)address or domain name.

Accepted Answer

A) True 
 B)False

Question 14

When shutting down an Oracle database,if the DBA specifies a(n)____________________ shutdown option,the instance does not accept any new connections,but allows current users to finish their transactions and log off normally.

Accepted Answer

The answer of When shutting down an Oracle database,if the...

Question 15

The Oracle database is made up of several different types of file.Of which type does only a single copy exist?

Accepted Answer

A) parameter 
B) control 
C) datafile 
D) redo log 
A) parameter 
B) control 
C) datafile 
D) redo log

Question 16

What is the default name of a parameter file?

Accepted Answer

A) tnsnames.ora 
B) init.ora 
C) control01.ctl 
D) data01.dbs 
A) tnsnames.ora 
B) init.ora 
C) control01.ctl 
D) data01.dbs

Question 17

How much space is required for the Oracle Home drive under NTFS when installing a basic installation?

Accepted Answer

A) 100 MB 
B) 1.2 GB 
C) 1.4 GB 
D) 1.5 GB 
A) 100 MB 
B) 1.2 GB 
C) 1.4 GB 
D) 1.5 GB

Question 18

You create ____ tables when a table contains a lot of records,and you want to store the data across multiple datafiles to improve database performance.

Accepted Answer

A) segmented 
B) extended 
C) automatic 
D) partitioned 
A) segmented 
B) extended 
C) automatic 
D) partitioned

Question 19

The OEM must be installed using the Universal Installer after installing a database.

Accepted Answer

A) True 
 B)False

Question 20

When using the ____________________ approach for configuring connect strings,each client application contains a file named tnsnames.ora that contains the configuration information for connecting to the database server.

Accepted Answer

The answer of When using the ____________________ approach for configuring...

An online backup requires shutting down the database,then copying all of the database files to an alternate location.

From the MOUNTED state,the startup process opens the datafiles and redo log files,performs database recovery operations if necessary,and then starts the Oracle Net server process to service user requests.

For an UPDATE action query,the redo log file contains a pre-image of the updated fields,which shows the data values before the update.

How many redo log groups exist by default?

A tablespace's ____________________ determines whether it is available to users.

When performing DBA administrative tasks such as shutting down the database,the DBA must specify a connect role of SYSOPER or ____.

A(n)____________________ server specifies the location of servers on a network.

What tasks make up the service role for DBAs?

How many tiers does the OEM have?

What does the database do first during a Normal shutdown?

Tier 1 of the OEM contains the ____________________,which is the workstation at which the DBA performs administration tasks.

What backup strategy is best?

The global database name is based on the database server workstation's Internet Protocol (IP)address or domain name.

When shutting down an Oracle database,if the DBA specifies a(n)____________________ shutdown option,the instance does not accept any new connections,but allows current users to finish their transactions and log off normally.

The Oracle database is made up of several different types of file.Of which type does only a single copy exist?

What is the default name of a parameter file?

How much space is required for the Oracle Home drive under NTFS when installing a basic installation?

You create ____ tables when a table contains a lot of records,and you want to store the data across multiple datafiles to improve database performance.

The OEM must be installed using the Universal Installer after installing a database.

When using the ____________________ approach for configuring connect strings,each client application contains a file named tnsnames.ora that contains the configuration information for connecting to the database server.

Clientserver Databases and the Oracle10g Relational Database

Creating and Modifying Database Tables

Using SQL Queries to Insert, update, delete, and View Data

Introduction to PlSQL

Introduction to Forms Builder

Creating Custom Forms

Creating Database Reports

Creating an Integrated Database Application

Advanced SQL and PlSQL Topics

Advanced Forms Builder Topics

Filters

Exam 11: Introduction to Oracle 10g Database Administration

An online backup requires shutting down the database,then copying all of the database files to an alternate location.

From the MOUNTED state,the startup process opens the datafiles and redo log files,performs database recovery operations if necessary,and then starts the Oracle Net server process to service user requests.

For an UPDATE action query,the redo log file contains a pre-image of the updated fields,which shows the data values before the update.

How many redo log groups exist by default?

A tablespace's ____________________ determines whether it is available to users.

When performing DBA administrative tasks such as shutting down the database,the DBA must specify a connect role of SYSOPER or ____.

A(n)____________________ server specifies the location of servers on a network.

What tasks make up the service role for DBAs?

How many tiers does the OEM have?

What does the database do first during a Normal shutdown?

Tier 1 of the OEM contains the ____________________,which is the workstation at which the DBA performs administration tasks.

What backup strategy is best?

The global database name is based on the database server workstation's Internet Protocol (IP)address or domain name.

When shutting down an Oracle database,if the DBA specifies a(n)____________________ shutdown option,the instance does not accept any new connections,but allows current users to finish their transactions and log off normally.

The Oracle database is made up of several different types of file.Of which type does only a single copy exist?

What is the default name of a parameter file?

How much space is required for the Oracle Home drive under NTFS when installing a basic installation?

You create ____ tables when a table contains a lot of records,and you want to store the data across multiple datafiles to improve database performance.

The OEM must be installed using the Universal Installer after installing a database.

When using the ____________________ approach for configuring connect strings,each client application contains a file named tnsnames.ora that contains the configuration information for connecting to the database server.

Clientserver Databases and the Oracle10g Relational Database

Creating and Modifying Database Tables

Using SQL Queries to Insert, update, delete, and View Data

Introduction to PlSQL

Introduction to Forms Builder

Creating Custom Forms

Creating Database Reports

Creating an Integrated Database Application

Advanced SQL and PlSQL Topics

Advanced Forms Builder Topics

Filters