Question 1

What is another name for an offline backup?

Accepted Answer

A) hot backup 
B) cold backup 
C) normal backup 
D) transactional backup 
A) hot backup 
B) cold backup 
C) normal backup 
D) transactional backup

Question 2

During a(n)____ shutdown,the instance does not accept any new user connections,and immediately terminates current user connections.

Accepted Answer

A) Normal 
B) Transactional 
C) Immediate 
D) Abort 
A) Normal 
B) Transactional 
C) Immediate 
D) Abort

Question 3

Describe the status of a tablespace.What are the possible values? What is the purpose of the status?

Accepted Answer

A tablespace's status determines whether

Question 4

The ____ background process has three primary functions: to recover lost data after a system hardware or software failure;to deallocate temporary memory areas that the database uses for sort operations;and to manage server disk space by periodically coalescing free space to make larger continuous extents for new data.

Accepted Answer

A) Database Writer 
B) System Monitor 
C) Process Monitor 
D) Checkpoint 
A) Database Writer 
B) System Monitor 
C) Process Monitor 
D) Checkpoint

Question 5

With Oracle 10g,a database ____________________ represents a set of processes and memory structures that manipulate the data in a database.

Accepted Answer

The answer of With Oracle 10g,a database ____________________ represents a...

Question 6

The database server stores the data for each tablespace in an extent.

Accepted Answer

A) True 
 B)False

Question 7

What uniquely identifies each database instance?

Accepted Answer

A) global database name 
B) SID 
C) IP address 
D) domain name 
A) global database name 
B) SID 
C) IP address 
D) domain name

Question 8

The ____ edition of Oracle is the most powerful.

Accepted Answer

A) Enterprise 
B) Systemwide 
C) Standard 
D) Personal 
A) Enterprise 
B) Systemwide 
C) Standard 
D) Personal

Question 9

By default,an Oracle 10g data block stores ____ bytes.

Accepted Answer

A) 512 
B) 1024 
C) 8192 
D) 9232 
A) 512 
B) 1024 
C) 8192 
D) 9232

Question 10

In the OEM,when you select the option button beside a datafile in the list and click the Edit button,the Edit Datafile property page opens,which allows you to edit properties of the datafile that is currently selected.

Accepted Answer

A) True 
 B)False

Question 11

The block ____________________ contains general block information,such as the block address within the operating system.

Accepted Answer

The answer of The block ____________________ contains general block information,such...

Question 12

You can grant a privilege with ____________________,which allows the user with a certain privilege to grant that privilege to other users.

Accepted Answer

The answer of You can grant a privilege with ____________________,which...

Question 13

To install any Oracle 10g product,you use Oracle Universal Installer (OUI).

Accepted Answer

A) True 
 B)False

Question 14

The SYSDBA or SYSOPER system privileges allow a user to access objects in the ____________________ tablespace.

Accepted Answer

The answer of The SYSDBA or SYSOPER system privileges allow...

Question 15

As part of the Oracle database installation,passwords must be specified for the following accounts: ____,SYSMAN,DBSNMP,and SYSTEM.

Accepted Answer

A) SYS 
B) SYSDBA 
C) SYSOPS 
D) SYSADMIN 
A) SYS 
B) SYSDBA 
C) SYSOPS 
D) SYSADMIN

Question 16

SYSOPER users can recover the database to a specific point in time,create new databases,or receive all system privileges with Admin Option.

Accepted Answer

A) True 
 B)False

Question 17

You should assign new users to the ____ tablespace or to a tablespace associated with applications that they will use.

Accepted Answer

A) SYS 
B) USERS 
C) GLOBAL 
D) PROGRAM 
A) SYS 
B) USERS 
C) GLOBAL 
D) PROGRAM

Question 18

When creating a cold backup,you would not make copies of ____________________ files.

Accepted Answer

The answer of When creating a cold backup,you would not...

Question 19

List and describe any two of the primary SGA memory areas.

Accepted Answer

Shared pool-Stores machine-language code

Question 20

Within the Program Global Area (PGA),the session information contains the values of the variables that the user declares in PL/SQL programs and other programs

Accepted Answer

A) True 
 B)False

What is another name for an offline backup?

During a(n)____ shutdown,the instance does not accept any new user connections,and immediately terminates current user connections.

Describe the status of a tablespace.What are the possible values? What is the purpose of the status?

With Oracle 10g,a database ____________________ represents a set of processes and memory structures that manipulate the data in a database.

The database server stores the data for each tablespace in an extent.

What uniquely identifies each database instance?

The ____ edition of Oracle is the most powerful.

By default,an Oracle 10g data block stores ____ bytes.

In the OEM,when you select the option button beside a datafile in the list and click the Edit button,the Edit Datafile property page opens,which allows you to edit properties of the datafile that is currently selected.

The block ____________________ contains general block information,such as the block address within the operating system.

You can grant a privilege with ____________________,which allows the user with a certain privilege to grant that privilege to other users.

To install any Oracle 10g product,you use Oracle Universal Installer (OUI).

The SYSDBA or SYSOPER system privileges allow a user to access objects in the ____________________ tablespace.

As part of the Oracle database installation,passwords must be specified for the following accounts: ____,SYSMAN,DBSNMP,and SYSTEM.

SYSOPER users can recover the database to a specific point in time,create new databases,or receive all system privileges with Admin Option.

You should assign new users to the ____ tablespace or to a tablespace associated with applications that they will use.

When creating a cold backup,you would not make copies of ____________________ files.

List and describe any two of the primary SGA memory areas.

Within the Program Global Area (PGA),the session information contains the values of the variables that the user declares in PL/SQL programs and other programs

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

What is another name for an offline backup?

During a(n)____ shutdown,the instance does not accept any new user connections,and immediately terminates current user connections.

Describe the status of a tablespace.What are the possible values? What is the purpose of the status?

With Oracle 10g,a database ____________________ represents a set of processes and memory structures that manipulate the data in a database.

The database server stores the data for each tablespace in an extent.

What uniquely identifies each database instance?

The ____ edition of Oracle is the most powerful.

By default,an Oracle 10g data block stores ____ bytes.

In the OEM,when you select the option button beside a datafile in the list and click the Edit button,the Edit Datafile property page opens,which allows you to edit properties of the datafile that is currently selected.

The block ____________________ contains general block information,such as the block address within the operating system.

You can grant a privilege with ____________________,which allows the user with a certain privilege to grant that privilege to other users.

To install any Oracle 10g product,you use Oracle Universal Installer (OUI).

The SYSDBA or SYSOPER system privileges allow a user to access objects in the ____________________ tablespace.

As part of the Oracle database installation,passwords must be specified for the following accounts: ____,SYSMAN,DBSNMP,and SYSTEM.

SYSOPER users can recover the database to a specific point in time,create new databases,or receive all system privileges with Admin Option.

You should assign new users to the ____ tablespace or to a tablespace associated with applications that they will use.

When creating a cold backup,you would not make copies of ____________________ files.

List and describe any two of the primary SGA memory areas.

Within the Program Global Area (PGA),the session information contains the values of the variables that the user declares in PL/SQL programs and other programs

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