Deck 4: Oracle Physical Architecture and Data Dictionary Views

Question 1

The control file contains up-to-date information on the database structure,log files,and checkpoints.

Answer 1

True

Question 2

A LGWR background process is a process that writes data blocks from the redo log buffer to the online redo log file.

Answer 2

True

Question 3

If the control file is damaged,the database is damaged too.

Answer 3

False

Question 4

Oracle Replication has a level of complexity suited to failover and backup management.

Question 5

You must multiplex the control file to ensure against total loss of the file.

Question 6

You cannot recreate a control file from scratch.

Question 7

Partitioning allows individual tables and their associated indexes to be split into separate physical chunks.

Question 8

Datafiles are the physical files stored in the underlying operating system.

Question 9

Oracle streams cannot be updated.

Question 10

You cannot rename or relocate a control file.

Question 11

The datafiles on a tablespace must be stored on the same disk drive.

Question 12

A new control file can be added at any time.

Question 13

You can fix a control file by replacing the faulty or missing control file with a valid copy of the control file.

Question 14

The initialization parameter DB_CREATE_ONLINE_LOG_DEST_n is required to be set for the database to function properly.

Question 15

Multiple tablespaces can share the same datafile.

Question 16

Various types of operations can be performed on partitions individually,affecting only small physical parts of very large tables.

Question 17

The SYSAUX tablespace was added in Oracle 9.

Question 18

Tablespaces can be transported across different platforms and operating systems.

Question 19

Each tablespace can contain multiple datafiles.

Question 20

The REUSE clause of the CREATE CONTROLFILE command is required.

Question 21

Sometimes,you may need to manually trigger a log switch.

Question 22

The users SYS and SYSTEM are the default DBA users.

Question 23

____ contain transaction records of all database changes.

A) Parameter files
B) Redo logs
C) Archive logs
D) Control files

Question 24

The ____ tablespace is created by default in the DBCA tool,and is intended to contain application structures and data.

A) UNDO
B) USERS
C) SYSTEM
D) SYSAUX

Question 25

____ contain pointers to all datafiles and log files used for synchronization between all of those files.

A) Parameter files
B) Redo logs
C) Archive logs
D) Control files

Question 26

You can use data dictionary views to help you build queries,debug SQL problems,and review naming conventions.

Question 27

A database should have at least five redo log groups containing at least one file each.

Question 28

The status of a redo log group can be CLEARING_CURRENT if it is in the process of being re-created after the ALTER DATABASE CLEAR LOGFILE command has been used.

Question 29

The ____ tablespace contains all the metadata,or the data about the data,such as the structures of user application tables.

A) UNDO
B) USERS
C) SYSTEM
D) SYSAUX

Question 30

____ are the physical layer of an Oracle database.

A) Datafiles
B) Tablespaces
C) Archive log files
D) Control files

Question 31

DBA prefixed views are solely for database administration use,allowing access to everything in the database,regardless of who owns it.

Question 32

____ contain historical copies of recycled redo logs,maintaining a complete history of all database change activity.

A) Parameter files
B) Redo logs
C) Archive logs
D) Control files

Question 33

Renaming a redo log file may be done to keep up with new naming standards or simply to make the filenames more meaningful to you.

Question 34

____ allows automated creation and dropping of underlying datafiles,in addition to automated management of both redo log files and control files.

A) OMF
B) OFA
C) Metadata
D) The data dictionary

Question 35

A standby database is a database clone of the current database.

Question 36

____ partitioning splits a table based on distinct ranges of values,such as quarters in a year.

A) Hash
B) Composite
C) Range
D) List

Question 37

Data dictionary views are based on tables owned by the SYSDBA user that are updated automatically by the Oracle 10g database.

Question 38

The ____ tablespace contains Oracle optional software metadata and data.

A) UNDO
B) USERS
C) SYSTEM
D) SYSAUX

Question 39

____ are the logical layer of an Oracle database.

A) Datafiles
B) Tablespaces
C) Redo log files
D) Control files

Question 40

Data dictionary views can be updated.

Question 41

____ lists the names of the control files in use by the database.

A) V$CONTROLFILE
B) V$CONTROLFILE_RECORD_SECTION
C) V$PARAMETER
D) V$DATABASE

Question 42

____ handles the names and locations of files created in association with the database.

A) ASM
B) RAC
C) OFA
D) OMF

Question 43

____ simplifies maintenance of storage space and optimizes for I / O performance.

A) RAC
B) ASM
C) Oracle Transportable Tablespaces
D) OMF

Question 44

The ____ clause of the CREATE CONTROLFILE command tells Oracle 10g to read the log files and save their settings from the last time they were used.

A) MAX
B) SET DATABASE
C) REUSE
D) NORESETLOGS

Question 45

Oracle ____ are much like opening a direct pipeline between different servers and databases.

A) Transportable Tablespaces
B) Streams
C) RACs
D) OMFs

Question 46

____ partitioning divides partition values evenly based on hash values calculated from a column value or values in each row of a table.

A) Hash
B) Composite
C) Range
D) List

Question 47

____ lists current checkpoint numbers and control file sequence numbers.

A) V$CONTROLFILE
B) V$CONTROLFILE_RECORD_SECTION
C) V$PARAMETER
D) V$DATABASE

Question 48

____ mode restricts access to a database to administration level only.

A) Nomount
B) Mount
C) Safe
D) Admin

Question 49

____ are lists of information by categories within the control file.

A) Record sections
B) SCNs
C) Tables
D) Indexes

Question 50

____ partitioning partitions can contain other subset partitions or subpartitions,allowing combinations of visibly split ranges or lists,with evenly spread hash partitioning.

A) Hash
B) Composite
C) Range
D) List

Question 51

____ displays initialization parameter values,including the current value of the CONTROL_FILES parameter.

A) V$CONTROLFILE
B) V$CONTROLFILE_RECORD_SECTION
C) V$PARAMETER
D) V$DATABASE

Question 52

A single redo log entry is stamped with a(n)____.

A) SCN
B) ID
C) RID
D) IDN

Question 53

The log writer process (____)updates the control file records whenever a new log sequence number is started.

A) WRITER
B) LGWR
C) LWRITER
D) LOGW

Question 54

The database name is defined either in the CREATE DATABASE command or the ____ initialization parameter.

A) NAME
B) V$_NAME
C) DB_NAME
D) PARAM_NAME

Question 55

There are ____ dynamic performance views that display the high-level contents of the control file.

A) two
B) three
C) four
D) five

Question 56

____ redo log files means that multiple redo log members,in each redo log group,are written to in parallel.

A) Multiplexing
B) Duplexing
C) Splitting
D) Replicating

Question 57

____ means making redundant copies of files to guarantee that if the original file is damaged,another can take its place immediately.

A) Splitting
B) Replicating
C) Multiplexing
D) Rollbacking

Question 58

The ____ clause of the CREATE CONTROLFILE command tells Oracle 10g to overwrite any existing control files it finds.

A) MAX
B) SET DATABASE
C) REUSE
D) NORESETLOGS

Question 59

Checkpoints can be made to recover up to a specific time or ____.

A) change number
B) stamp
C) rollback ID
D) SCN

Question 60

____ partitioning splits a table based on specific lists of values.

A) Hash
B) Composite
C) Range
D) List

Question 61

____ a redo log group ensures that you can perform a complete,up-to-the-minute recovery of your database in the event of catastrophic failure,such as the loss of a disk drive that held your SYSTEM tablespace.

A) Replicating
B) Multiplexing
C) Duplexing
D) Archiving

Question 62

The ____ control file view contains copies of recycled redo log files.

A) V$ARCHIVED_LOG
B) V$DATAFILE
C) V$LOG
D) V$LOGFILE

Question 63

All the data dictionary views except those starting with the ____ prefix have public synonyms and public permission to query.

A) GV$
B) V$
C) DBA
D) USER

Question 64

The ____ control file view contains redo log file information.

A) V$ARCHIVED_LOG
B) V$DATAFILE
C) V$LOG
D) V$LOGFILE

Question 65

The prefix ____ is used for dynamic performance views.

A) USER
B) ALL
C) DBA
D) V$

Question 66

The ____ data dictionary view contains source code for all stored objects,such as functions,Java source,and triggers.

A) DBA_SOURCE
B) SOURCE
C) USER_SOURCE
D) USR_SRC

Question 67

A(n)____ background process is a process that copies a completed online redo log file to an archived redo log file.

A) LGWR
B) log
C) ARCn
D) CKPT

Question 68

A(n)____ background process is a process that initiates flushing of buffers,causing the LGWR to write data blocks from the redo log buffer to the online redo log file

A) LGWR
B) log
C) ARCn
D) CKPT

Question 69

____ shows data held in the record section.

A) V$CONTROLFILE
B) V$CONTROLFILE_RECORD_SECTION
C) V$PARAMETER
D) V$DATABASE

Question 70

You can use the SQL*Plus DESCRIBE command (abbreviated to ____)to retrieve a list of column names and data types for any table or view,including the data dictionary views.

A) DES
B) DESC
C) DESCR
D) DSCR

Question 71

The status of a redo log group can be ____ if it is needed for crash recovery,but not currently in use by LGWR.

A) CURRENT
B) ACTIVE
C) CLEARING_CURRENT
D) CLEARING

Question 72

The ____ control file view contains online redo log group information.

A) V$ARCHIVED_LOG
B) V$DATAFILE
C) V$LOG
D) V$LOGFILE

Question 73

To drop a log file group you can use the ____ command.

A) DROP LOG
B) DROP LOGFILE
C) ALTER DATABASE
D) ALTER LOGFILE

Question 74

A database in ____ mode automatically archives redo log files.

A) REDOLOG
B) LOG
C) ARCHIVEREDOLOG
D) ARCHIVELOG

Question 75

When you type the ____ command,the redo log buffer's redo records are moved to the redo log files.

A) COMMIT
B) UPDATE
C) INSERT
D) CREATE TABLE

Question 76

The only required initialization parameter to achieve successful ARCHIVELOG mode is the ____ parameter.

A) LOG_ARCHIVE_START
B) LOG_ARCHIVE_DEST_n
C) LOG_ARCHIVE_DEST_STATE_n
D) LOG_ARCHIVE_FORMAT

Question 77

A(n)____ log file group has files in the group that cannot be dropped.

A) ACTIVE
B) INACTIVE
C) CURRENT
D) STATIC

Question 78

The status of a redo log group can be ____ if it is not needed for crash recovery.

A) CURRENT
B) INACTIVE
C) UNUSED
D) CLEARING

Question 79

There can be up to ____ archiver processes.

A) five
B) ten
C) twenty
D) thirty

Question 80

Oracle-managed log groups may be added to OMF databases by using the following command: ____.

A) ALTER DATABASE ADD LOG;
B) ALTER DATABASE ADD GROUP;
C) ALTER DATABASE ADD LOGFILE;
D) ALTER DATABASE ADD LOGGROUP;