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

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

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

The answer of What tasks make up the service role...

Question 9

How many tiers does the OEM have?

Accepted Answer

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

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

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

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

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

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

Question 19

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

Accepted Answer