Deck 11: Introduction to Oracle 10g Database Administration

Question 1

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.

Answer 1

True

Question 2

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.

Answer 2

False

Question 3

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

Answer 3

False

Question 4

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

Question 5

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

Question 6

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.

Question 7

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.

Question 8

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

Question 9

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.

Question 10

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

Question 11

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

Question 12

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

Question 13

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.

Question 14

The global database name is based on the database server workstation's Internet Protocol (IP)address or domain name.

Question 15

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

Question 16

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.

Question 17

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

Question 18

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

Question 19

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

Question 20

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.

Question 21

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.

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

Question 22

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

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

Question 23

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

Question 24

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

Question 25

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.

Question 26

An online backup requires shutting down the database,then copying all of the database files to an alternate location.

Question 27

What protocol is used by an Oracle Internet Directory Server?

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

Question 28

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.

Question 29

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

Question 30

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

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

Question 31

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

A)Oracle_home-network-naming
B)Oracle_Home-System-admin
C)Oracle_Home-naming-local
D)Oracle_Home-network-admin

Question 32

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

Question 33

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

Question 34

How many tiers does the OEM have?

A)1
B)3
C)4
D)5

Question 35

What uniquely identifies each database instance?

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

Question 36

How much space is required for the Oracle Home drive under NTFS when installing a basic installation?

A)100 MB
B)1.2 GB
C)1.4 GB
D)1.5 GB

Question 37

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

Question 38

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

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

Question 39

The ____ edition of Oracle is the most powerful.

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

Question 40

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.

Question 41

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

A)0
B)1
C)2
D)3

Question 42

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

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

Question 43

What is the file extension for a datafile?

A)dba
B)dbf
C)dat
D)ctl

Question 44

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

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

Question 45

How many redo log groups exist by default?

A)2
B)3
C)4
D)5

Question 46

What is the default name of a parameter file?

A)tnsnames.ora
B)init.ora
C)control01.ctl
D)data01.dbs

Question 47

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

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

Question 48

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

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

Question 49

What is contained in the Program Global Area?

A)database buffer cache
B)redo log buffer
C)Java pool
D)session information

Question 50

When performing DBA administrative tasks such as shutting down the database,the DBA must specify a connect role of SYSOPER or ____.

A)SYS
B)SYSMGR
C)SYSMON
D)SYSDBA

Question 51

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.

A)segmented
B)extended
C)automatic
D)partitioned

Question 52

Segments are made up of ____.

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

Question 53

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

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

Question 54

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

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

Question 55

The Oracle database is made up of several different types of file.Of which type does only a single copy exist?

A)parameter
B)control
C)datafile
D)redo log

Question 56

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

A)shared pool
B)database buffer cache
C)large pool
D)redo log buffer

Question 57

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

A)Administration
B)Users
C)Management
D)Network

Question 58

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

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

Question 59

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.

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

Question 60

Where are datafiles stored by default?

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

Question 61

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.

Question 62

When using the ____________________ approach for configuring connect strings,each client application contains a file named tnsnames.ora that contains the configuration information for connecting to the database server.

Question 63

What files should be backed up during an offline backup?

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

Question 64

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

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

Question 65

What is another name for an offline backup?

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

Question 66

Tier 1 of the OEM contains the ____________________,which is the workstation at which the DBA performs administration tasks.

Question 67

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

A)Read the parameter file
B)Open the datafiles and redo log files
C)Open and reads the database control files
D)Processes started

Question 68

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

Question 69

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

Question 70

Which state follows NOMOUNT during a normal database startup?

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

Question 71

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

Question 72

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

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

Question 73

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

A)BACKUP
B)RECOVERY
C)ARCHIVE
D)ARCHIVELOG

Question 74

What task can be performed by the SYSOPER user?

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 75

What does the database do first during a Normal shutdown?

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 76

A(n)____________________ server specifies the location of servers on a network.

Question 77

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

Question 78

What backup strategy is best?

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 79

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.

Question 80

A tablespace's ____________________ determines whether it is available to users.