Exam 11: Introduction to Oracle 10g Database Administration

If you need to change the privileges of the users to whom the role has been granted,you simply change the role's privileges,and the user accounts automatically reflect the privilege change.

(True/False)

4.8/5

(34)

Question 41

All of the privileges assigned to a role must be directly assigned to that role.

(True/False)

4.9/5

(39)

Question 42

What is contained in the Program Global Area?

(Multiple Choice)

4.8/5

(35)

Question 43

The main pages of the OEM are Home,Performance,____,and Maintenance.

(Multiple Choice)

4.9/5

(40)

Question 44

To enable a new user to create new database objects,you must assign to the user account a tablespace quota for the user's default tablespace.

(True/False)

4.7/5

(42)

Question 45

What is the file extension for a datafile?

(Multiple Choice)

4.8/5

(36)

Question 46

Tablespaces in the Oracle 10g Release 1 database use dictionary-managed extent management,in which the tablespace maintains a bitmap in each datafile that represents whether each data block is free or used.

(True/False)

4.8/5

(42)

Question 47

The ____________________ files contain information about the database tablespaces,datafiles,redo log files,and the current state of the database.

(Short Answer)

4.9/5

(39)

Question 48

By default,where is the file tnsnames.ora stored when using local naming?

(Multiple Choice)

4.9/5

(32)

Question 49

Disk groups are managed by a special Oracle instance,called an OEM instance.

(True/False)

4.8/5

(31)

Question 50

What happens during the transition from the MOUNTED to OPEN state during startup?

(Multiple Choice)

4.9/5

(29)

Question 51

The Oracle Database Configuration Assistant is a utility that allows DBAs to configure client workstations so they can connect to database servers using Oracle Net.

(True/False)

4.8/5

(44)

Question 52

To use OEM to create a new user account,you navigate to the Administration property page,click the Users link under the Security heading,and then click Create.

(True/False)

4.8/5

(34)

Question 53

How many control files must be present for the database to start?

(Multiple Choice)

4.8/5

(37)

Question 54

In the System Global Area of memory,the ____ consists of large contiguous memory storage spaces for tasks such as backup and recovery operations.

(Multiple Choice)

4.8/5

(27)

Question 55

The ____________________ background process writes changed data from the database buffer cache to the datafiles.

(Short Answer)

4.9/5

(36)

Question 56

When performing an online backup,the database must be placed in ____ mode.

(Multiple Choice)

4.9/5

(38)

Question 57

Each ____________________ stores an individual database object,such as a table or an index.

(Short Answer)

4.9/5

(29)

Question 58

By default,an Oracle 10g database instance has two separate control files.

(True/False)

4.9/5

(39)

Question 59

Describe the information stored in the redo log file for INSERT,UPDATE,and DELETE action queries.

(Essay)

4.9/5

(37)

Question 60

Showing 41 - 60 of 100

If you need to change the privileges of the users to whom the role has been granted,you simply change the role's privileges,and the user accounts automatically reflect the privilege change.

All of the privileges assigned to a role must be directly assigned to that role.

What is contained in the Program Global Area?

The main pages of the OEM are Home,Performance,____,and Maintenance.

To enable a new user to create new database objects,you must assign to the user account a tablespace quota for the user's default tablespace.

What is the file extension for a datafile?

Tablespaces in the Oracle 10g Release 1 database use dictionary-managed extent management,in which the tablespace maintains a bitmap in each datafile that represents whether each data block is free or used.

The ____________________ files contain information about the database tablespaces,datafiles,redo log files,and the current state of the database.

By default,where is the file tnsnames.ora stored when using local naming?

Disk groups are managed by a special Oracle instance,called an OEM instance.

What happens during the transition from the MOUNTED to OPEN state during startup?

The Oracle Database Configuration Assistant is a utility that allows DBAs to configure client workstations so they can connect to database servers using Oracle Net.

To use OEM to create a new user account,you navigate to the Administration property page,click the Users link under the Security heading,and then click Create.

How many control files must be present for the database to start?

In the System Global Area of memory,the ____ consists of large contiguous memory storage spaces for tasks such as backup and recovery operations.

The ____________________ background process writes changed data from the database buffer cache to the datafiles.

When performing an online backup,the database must be placed in ____ mode.

Each ____________________ stores an individual database object,such as a table or an index.

By default,an Oracle 10g database instance has two separate control files.

Describe the information stored in the redo log file for INSERT,UPDATE,and DELETE action queries.

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