Question 1

In a block header,the ____ specifies which rows the block stores.

Accepted Answer

A) row directory 
B) row data 
C) table directory 
D) free space 
A) row directory 
B) row data 
C) table directory 
D) free space

Question 2

Before you start an Oracle 10g database instance,the instance is in the ____________________ state.

Accepted Answer

The answer of Before you start an Oracle 10g database...

Question 3

Every request that a client sends to a server must specify the server's IP address and the ____ of the server process to which the message is directed.

Accepted Answer

A) network address 
B) domain name 
C) port number 
D) connect descriptor 
A) network address 
B) domain name 
C) port number 
D) connect descriptor

Question 4

To grant a role to a new user account,you open the Role page in the Create User page,and grant the role to the user.

Accepted Answer

A) True 
 B)False

Question 5

In a(n)____________________ tablespace,when a tablespace datafile becomes full,it automatically grows,or extends,in response to new data insertions.

Accepted Answer

The answer of In a(n)____________________ tablespace,when a tablespace datafile becomes...

Question 6

The ____ location is the centralized location where components have been placed for installations.

Accepted Answer

A) console 
B) stage 
C) source path 
D) install 
A) console 
B) stage 
C) source path 
D) install

Question 7

To enable a new user to interact with an Oracle 10g database,the DBA must grant ____ privileges to the new user account.

Accepted Answer

A) system 
B) user 
C) object 
D) network 
A) system 
B) user 
C) object 
D) network

Question 8

Which state follows NOMOUNT during a normal database startup?

Accepted Answer

A) SHUTDOWN 
B) MOUNTED 
C) OPEN 
D) ONLINE 
A) SHUTDOWN 
B) MOUNTED 
C) OPEN 
D) ONLINE

Question 9

Most of the time,you start a database in ____________________ mode.

Accepted Answer

The answer of Most of the time,you start a database...

Question 10

The ____________________ Area is a memory area that all database connections use.

Accepted Answer

The answer of The ____________________ Area is a memory area...

Question 11

The IT department usually has two roles: a service role,to support users as they interact with the database in their daily activities,and a(n)____________________ role,to provide users with specific solutions to information management problems,such as database applications or reports.

Accepted Answer

The answer of The IT department usually has two roles:...

Question 12

The database instance can use the archive files to re-create all database transactions that have occurred since the last hot backup.

Accepted Answer

A) True 
 B)False

Question 13

When creating a new user,the ____________________ specifies how the database manages the user's connections and memory usage;the default value is DEFAULT,which is satisfactory for most users.

Accepted Answer

The answer of When creating a new user,the ____________________ specifies...

Question 14

The DBA must explicitly connect to the OEM by specifying a username,password,and connect role.

Accepted Answer

A) True 
 B)False

Question 15

The parameter file is a text file that specifies configuration information about an Oracle 10g database instance.

Accepted Answer

A) True 
 B)False

Question 16

The DBMS is the same as the database that stores the actual data values.

Accepted Answer

A) True 
 B)False

Question 17

When creating a new user account,by default,the Quota Size value is ____________________.

Accepted Answer

The answer of When creating a new user account,by default,the...

Question 18

To configure automated backups,you must designate an on-disk storage area for backup files,called the ____________________ recovery area.

Accepted Answer

The answer of To configure automated backups,you must designate an...

Question 19

A(n)____ database supports the widest range of applications.

Accepted Answer

A) Transaction Processing 
B) Data Warehouse 
C) General Purpose 
D) Internet 
A) Transaction Processing 
B) Data Warehouse 
C) General Purpose 
D) Internet

Question 20

To "____________________" the database means shutting down the database instance,modifying the database properties,and then restarting the database instance.

Accepted Answer

The answer of To "____________________" the database means shutting down...

In a block header,the ____ specifies which rows the block stores.

Before you start an Oracle 10g database instance,the instance is in the ____________________ state.

Every request that a client sends to a server must specify the server's IP address and the ____ of the server process to which the message is directed.

To grant a role to a new user account,you open the Role page in the Create User page,and grant the role to the user.

In a(n)____________________ tablespace,when a tablespace datafile becomes full,it automatically grows,or extends,in response to new data insertions.

The ____ location is the centralized location where components have been placed for installations.

To enable a new user to interact with an Oracle 10g database,the DBA must grant ____ privileges to the new user account.

Which state follows NOMOUNT during a normal database startup?

Most of the time,you start a database in ____________________ mode.

The ____________________ Area is a memory area that all database connections use.

The IT department usually has two roles: a service role,to support users as they interact with the database in their daily activities,and a(n)____________________ role,to provide users with specific solutions to information management problems,such as database applications or reports.

The database instance can use the archive files to re-create all database transactions that have occurred since the last hot backup.

When creating a new user,the ____________________ specifies how the database manages the user's connections and memory usage;the default value is DEFAULT,which is satisfactory for most users.

The DBA must explicitly connect to the OEM by specifying a username,password,and connect role.

The parameter file is a text file that specifies configuration information about an Oracle 10g database instance.

The DBMS is the same as the database that stores the actual data values.

When creating a new user account,by default,the Quota Size value is ____________________.

To configure automated backups,you must designate an on-disk storage area for backup files,called the ____________________ recovery area.

A(n)____ database supports the widest range of applications.

To "____________________" the database means shutting down the database instance,modifying the database properties,and then restarting the database instance.

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

In a block header,the ____ specifies which rows the block stores.

Before you start an Oracle 10g database instance,the instance is in the ____________________ state.

Every request that a client sends to a server must specify the server's IP address and the ____ of the server process to which the message is directed.

To grant a role to a new user account,you open the Role page in the Create User page,and grant the role to the user.

In a(n)____________________ tablespace,when a tablespace datafile becomes full,it automatically grows,or extends,in response to new data insertions.

The ____ location is the centralized location where components have been placed for installations.

To enable a new user to interact with an Oracle 10g database,the DBA must grant ____ privileges to the new user account.

Which state follows NOMOUNT during a normal database startup?

Most of the time,you start a database in ____________________ mode.

The ____________________ Area is a memory area that all database connections use.

The IT department usually has two roles: a service role,to support users as they interact with the database in their daily activities,and a(n)____________________ role,to provide users with specific solutions to information management problems,such as database applications or reports.

The database instance can use the archive files to re-create all database transactions that have occurred since the last hot backup.

When creating a new user,the ____________________ specifies how the database manages the user's connections and memory usage;the default value is DEFAULT,which is satisfactory for most users.

The DBA must explicitly connect to the OEM by specifying a username,password,and connect role.

The parameter file is a text file that specifies configuration information about an Oracle 10g database instance.

The DBMS is the same as the database that stores the actual data values.

When creating a new user account,by default,the Quota Size value is ____________________.

To configure automated backups,you must designate an on-disk storage area for backup files,called the ____________________ recovery area.

A(n)____ database supports the widest range of applications.

To "____________________" the database means shutting down the database instance,modifying the database properties,and then restarting the database instance.

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