Question 1

In Oracle 10g database administration terminology,a database storage data block is the smallest storage unit that the database can address.

Accepted Answer

A) True 
 B)False

Question 2

The connect role values are ____________________,which specifies that the DBA will be performing routine maintenance tasks;or SYSOPER or SYSDBA,which allows the DBA to perform administrative tasks.

Accepted Answer

The answer of The connect role values are ____________________,which specifies...

Question 3

Coalescing free space defragments the data on the hard drive,and moves all of the stored data so it is in contiguous memory blocks.

Accepted Answer

A) True 
 B)False

Question 4

A connect descriptor specifies the network communication protocol,the IP address of the database server,and the database instance name.

Accepted Answer

A) True 
 B)False

Question 5

Where are datafiles stored by default?

Accepted Answer

A) Oracle_Base-oradata-SID 
B) Oracle_Base-admin-SID-pfile 
C) Oracle_Base-network-admin 
D) Oracle_Base-data-files 
A) Oracle_Base-oradata-SID 
B) Oracle_Base-admin-SID-pfile 
C) Oracle_Base-network-admin 
D) Oracle_Base-data-files

Question 6

If users execute a lot of different SQL commands,the system needs a large ____.

Accepted Answer

A) shared pool 
B) Java pool 
C) large pool 
D) redo log buffer 
A) shared pool 
B) Java pool 
C) large pool 
D) redo log buffer

Question 7

How does a client application route database requests to the correct Oracle 10g database instance?

Accepted Answer

It does so by specifying the global data

Question 8

Recovery is necessary after a database failure caused by a software malfunction,such as a corrupted datafile or control file,or a hardware malfunction,such as a damaged hard drive.

Accepted Answer

A) True 
 B)False

Question 9

During an online backup,the commands to rebuild your control file are placed in a(n)____ file.

Accepted Answer

A) log 
B) trace 
C) parameter 
D) archive 
A) log 
B) trace 
C) parameter 
D) archive

Question 10

Segments are made up of ____.

Accepted Answer

A) datafiles 
B) tablespaces 
C) extents 
D) data blocks 
A) datafiles 
B) tablespaces 
C) extents 
D) data blocks

Question 11

When creating a new role,what is the default value for the role's authentication method?

Accepted Answer

A) Password 
B) Inherit 
C) None 
D) Kerberos 
A) Password 
B) Inherit 
C) None 
D) Kerberos

Question 12

Oracle Universal Installer is a(n)____________________-based graphical user interface (GUI)tool that enables you to install and remove Oracle software.

Accepted Answer

The answer of Oracle Universal Installer is a(n)____________________-based graphical user...

Question 13

The exact steps for installing an Oracle 10g database are the same for all three versions.

Accepted Answer

A) True 
 B)False

Question 14

What files should be backed up during an offline backup?

Accepted Answer

A) parameter and datafiles 
B) parameter and control files 
C) parameter,control,and datafiles 
D) parameter,control,datafiles,and redo logs 
A) parameter and datafiles 
B) parameter and control files 
C) parameter,control,and datafiles 
D) parameter,control,datafiles,and redo logs

Question 15

An object privilege allows a user to perform a specific task with the Oracle 10g database,such as connecting to the database or creating a new table.

Accepted Answer

A) True 
 B)False

Question 16

A rollback segment is made up of data blocks configured in a ____.

Accepted Answer

A) circle 
B) linked list 
C) B-tree 
D) set 
A) circle 
B) linked list 
C) B-tree 
D) set

Question 17

An Oracle 10g database stores rollback information in redo log files in a data structure called a(n)____________________.

Accepted Answer

The answer of An Oracle 10g database stores rollback information...

Question 18

The General page for a database instance provides information about the database instance,such as the host (server)name and database version.

Accepted Answer

A) True 
 B)False

Question 19

What task can be performed by the SYSOPER user?

Accepted Answer

A) Receive all system privileges with Admin Option 
B) Create a new database within an existing database instance 
C) Recover the database to a specific point in time 
D) Perform database recovery operations 
A) Receive all system privileges with Admin Option 
B) Create a new database within an existing database instance 
C) Recover the database to a specific point in time 
D) Perform database recovery operations

Question 20

What protocol is used by an Oracle Internet Directory Server?

Accepted Answer

A) IP 
B) TCP 
C) LDAP 
D) local naming 
A) IP 
B) TCP 
C) LDAP 
D) local naming

In Oracle 10g database administration terminology,a database storage data block is the smallest storage unit that the database can address.

The connect role values are ____________________,which specifies that the DBA will be performing routine maintenance tasks;or SYSOPER or SYSDBA,which allows the DBA to perform administrative tasks.

Coalescing free space defragments the data on the hard drive,and moves all of the stored data so it is in contiguous memory blocks.

A connect descriptor specifies the network communication protocol,the IP address of the database server,and the database instance name.

Where are datafiles stored by default?

If users execute a lot of different SQL commands,the system needs a large ____.

How does a client application route database requests to the correct Oracle 10g database instance?

Recovery is necessary after a database failure caused by a software malfunction,such as a corrupted datafile or control file,or a hardware malfunction,such as a damaged hard drive.

During an online backup,the commands to rebuild your control file are placed in a(n)____ file.

Segments are made up of ____.

When creating a new role,what is the default value for the role's authentication method?

Oracle Universal Installer is a(n)____________________-based graphical user interface (GUI)tool that enables you to install and remove Oracle software.

The exact steps for installing an Oracle 10g database are the same for all three versions.

What files should be backed up during an offline backup?

An object privilege allows a user to perform a specific task with the Oracle 10g database,such as connecting to the database or creating a new table.

A rollback segment is made up of data blocks configured in a ____.

An Oracle 10g database stores rollback information in redo log files in a data structure called a(n)____________________.

The General page for a database instance provides information about the database instance,such as the host (server)name and database version.

What task can be performed by the SYSOPER user?

What protocol is used by an Oracle Internet Directory 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

In Oracle 10g database administration terminology,a database storage data block is the smallest storage unit that the database can address.

The connect role values are ____________________,which specifies that the DBA will be performing routine maintenance tasks;or SYSOPER or SYSDBA,which allows the DBA to perform administrative tasks.

Coalescing free space defragments the data on the hard drive,and moves all of the stored data so it is in contiguous memory blocks.

A connect descriptor specifies the network communication protocol,the IP address of the database server,and the database instance name.

Where are datafiles stored by default?

If users execute a lot of different SQL commands,the system needs a large ____.

How does a client application route database requests to the correct Oracle 10g database instance?

Recovery is necessary after a database failure caused by a software malfunction,such as a corrupted datafile or control file,or a hardware malfunction,such as a damaged hard drive.

During an online backup,the commands to rebuild your control file are placed in a(n)____ file.

Segments are made up of ____.

When creating a new role,what is the default value for the role's authentication method?

Oracle Universal Installer is a(n)____________________-based graphical user interface (GUI)tool that enables you to install and remove Oracle software.

The exact steps for installing an Oracle 10g database are the same for all three versions.

What files should be backed up during an offline backup?

An object privilege allows a user to perform a specific task with the Oracle 10g database,such as connecting to the database or creating a new table.

A rollback segment is made up of data blocks configured in a ____.

An Oracle 10g database stores rollback information in redo log files in a data structure called a(n)____________________.

The General page for a database instance provides information about the database instance,such as the host (server)name and database version.

What task can be performed by the SYSOPER user?

What protocol is used by an Oracle Internet Directory 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