23:03
Oracle 10g Test
Which of the following
views provides the names of all the data dictionary views?
a. DBA_NAMES
b. DBA_TABLES
c. DICTIONARY
d. DBA_DICTIONARY
Which of the following
constitute the functions of an ASM instance?
a. Managing disk groups and
communicating file metadata to the Oracle database using ASM files
b. Managing database files
and communicating file metadata to the ASM instance using ASM files
c. Managing disk groups and
communicating file metadata to the RMAN
d. Protecting disk groups
Where can you find the non
default parameters when the instance is started?
a. Alert log
b. Online redo log
c. Archiver redo log
d. SYSTEM user's trace file
Which of the following
statements are correct with regard to Rebuilding Indexes?
a. The ALTER INDEX REBUILD
command is used to change the storage characteristics of an index
b. Using the ALTER INDEX
REBUILD is usually faster than dropping and recreating an index because it uses
the fast full scan feature
c. One cannot rebuild a
bitmap index that is marked INVALID
d. When building an index,
the NOLOGGING and UNRECOVERABLE keywords can be used concurrently to reduce the
time it takes to rebuild
What should you confirm
before changing the CURSOR_SPACE_FOR_TIME parameter (in your initialization
file) to TRUE?
a. The TIMED_STATISTICS
parameter is set to TRUE
b. The hit percentage in
the buffer cache is at least 95%
c. The OPEN_CURSOR
parameter is set to at least twice the default value
d. The value in the RELOADS
column of V$LIBRARYCACHE is consistently zero
The initialization
parameter UNDO_RETENTION is used:
a. To specify the length of
time for which Oracle must retain undo data in the undo tablespace
b. To specify the length of
time for which Oracle must retain undo data in the flash recovery area
c. To specify the length of
time for which Oracle must retain undo data in the data files
d. To specify the length of
time for which Oracle will retain undo data in the flashback database logs
What are two main
advantages of using bitmap indexes?
a. Bitmap indexes use less
storage space
b. Bitmap segments are
updated upon COMMIT, at the end of the transaction
c. Bitmap indexes work very
fast with multiple predicates that are combined with AND, OR, and NOT operators
d. None of the above
ASM disk groups provide:
a. Redundancy through
striping
b. Performance through
mirroring.
c. Redundancy through
mirroring
d. Performance through
striping
The SQL Access Advisor is
managed:
a. Through the DBMS_SQLTUNE
package
b. Through the DBMS_ADVISOR
package
c. Through the SQL_TUNE
package
d. Through the DBA_ADVISOR
package
Which background process
performs a checkpoint in the database by writing modified blocks from the
database buffer cache in the SGA to the data files?
a. LGWR
b. SMON
c. DBWn
d. CKPT
Where is the trace file
generated when a deadlock shutdown is detected by Oracle?
a. SQL_TRACE
b. TRACE_DEST
c. USER_DUMP_DEST
d. CORE_DUMP_DEST
The utility SQL*Loader
should not be used:
a. While loading selected
rows into each table
b. While loading data from
an export dump file
c. While loading data from
disk, tape, or named pipes
d. While the data is NOT
being inserted from a flat file
Examine the following SQL
statement:
CREATE TABLESPACE user_data
DATAFILE
'/u01/oradata/user_data_0l.dbf' SIZE 100M
LOCALLY MANAGED UNIFORM
SIZE 1M
AUTOMATIC SEGMENT SPACE
MANAGEMENT;
Which of the following
graphical DBA administration tools is used to tune an Oracle database?
a. SQL*Plus
b. Oracle Enterprise
Manager
c. Oracle Universal
Installer
d. Oracle Database
Configuration Assistant
In an Oracle database
environment, SGA is created:
a. When the database is
created
b. When the instance is
started
c. When the database is
mounted
d. When a user process is
started
Which part of the
tablespace will be of a uniform size (of 1 MB)?
a. Extent
b. Segment
c. Oracle block
d. Operating system block
You want to find the
following information about a user:
- The expiry date of the
user's account
- The user's default
tablespace name
- The user's profile name
Which tablespace is used as
a temporary tablespace if 'TEMPORARY
TABLESPACE' is not specified for a user?
a. TEMP
b. DATA
c. SYSTEM
d. ROLLBACK
Which of the following
helps you identify your statement in the DBA_TUNE_MVIEW view?
a. The STATEMENT variable
b. The STATEMENT_ID column
c. The VIEW_ID column
d. The TASK_NAME variable
Which data dictionary view
should be queried for the purpose?
a. DBA_USERS only
b. DBA_USERS and
DBA_PROFILES
c. DBA_USERS and
DBA_TABLESPACES
d. DBA_USERS,
DBA_TS_QUOTAS, and DBA_PROFILES
What is the default value
for the OPTIMIZER_MODE initialization parameter?
a. FIRST_ROWS
b. ALL_ROWS
c. CHOOSE
d. COST
Which of the following
statements are correct for rebuilding an index?
a. The resulting index may
contain deleted entries
b. A new index is built
using an existing index as the data source
c. Queries cannot use the
existing index while the new index is being built
d. During a rebuild,
sufficient space is needed to accommodate both the old and new indexes in their
respective tablespaces
Evaluate the following SQL:
CREATE USER sam IDENTIFIED
BY sam;
GRANT
CREATE ANY MATERIALIZED
VIEW,
CREATE ANY DIMENSION, DROP
ANY DIMENSION, QUERY REWRITE, GLOBAL QUERY REWRITE
TO dw_manager
WITH ADMIN OPTION;
GRANT dw_manager TO sam
WITH ADMIN OPTION;
Consider the following SQL
statement:
UPDATE employees SET
first_name = 'John'
WHERE emp_id = 1009;
COMMIT;
What happens when a user
issues the COMMIT in the above SQL statement?
a. The server process
places the commit record in the redo log buffer
b. Log Writer (LGWR) writes
the redo log buffer entries to the redo log files and data files
c. The user process
notifies the server process that the transaction is complete
d. The user process
notifies the server process that the resource locks can be released
Which of the following
actions is the user SAM able to perform?
a. Create and drop a
materialized view
b. Alter a materialized
view that you created
c. Can grant the role to
and from other users, but cannot revoke the role
d. Enable the role and
exercise any privileges in the role's privilege domain
The RMAN CATALOG command:
a. Helps create the image
copies of datafiles
b. Helps create the image
copies of current control files
c. Helps catalog the new
files that are not a part of the recovery catalog
d. Helps catalog only the
old files
Which of the following
constitute the types of segments?
a. Only LOBS
b. Only nested tables
c. Only index-organized
tables
d. Only LOBS and
index-organized tables
e. Nested tables, LOBS,
index-organized tables, and boot straps
Which of the following
commands revokes the ROLE_DATA role from all the users?
a. REVOKE role_data FROM
ALL;
b. REVOKE role_data FROM
PUBLIC;
c. REVOKE role_data FROM
default;
d. REVOKE role_data FROM
ALL_USERS;
Which of the following
items are stored in the flash recovery area?
a. Datafiles
b. Undo segments
c. Datafile copies
d. Archived redo log files
Which of the following
statements is correct with regard to index clusters?
a. Index clusters can only
be used for tables with low cardinality columns
b. Index clusters are
generally well suited for tables that have many full table scans
c. Normal B-Tree indexes do
not store null key values, whereas cluster indexes store null keys
d. A cluster index always
takes up much more storage space than a normal index for the same set of key
values
Which of the following is a
new initialization parameter for Oracle Database 10g?
a. UNDO_SUPPRESS_ERRORS
b.
PARALLEL_AUTOMATIC_TUNING
c. RESUMABLE_TIMEOUT
d. SHARED_SERVER
What will happen if you set
the value of the SGA_TARGET parameter higher than the value of the SGA_MAX_
SIZE parameter at instance startup?
a. The instance will not
start
b. SGA_TARGET will become
equal to the SGA_MAX_SIZE value
c. The database will ignore
the SGA_TARGET parameter
d. SGA_MAX_SIZE is
automatically raised, so it is equal to the SGA_TARGET value
Which of the following
statements is correct with regard to LOG_BUFFER initialization parameter?
a. The LOG_BUFFER parameter
can be changed dynamically
b. The minimum value for
the LOG_FILE parameter is 512KB
c. The LOG_BUFFER parameter
value must be a multiple of the database block size
d. The LOG_BUFFER parameter
value must be a multiple of the operating system block size
Which of the following data
dictionary views should be used to get a list of object privileges for all the
database users?
a. DBA_TAB_PRIVS
b. ALL_TAB_PRIVS
c. USER_TAB_PRIVS
d. ALL_TAB_PRIVS_MADE
What does the ARBn
background process do in an ASM instance?
a. Coordinates disk
activity
b. Performs disk rebalance
work
c. Coordinates disk
rebalance work
d. Manages the RBAL process
______________ is mandatory
for using the easy connect naming method.
a. Host name
b. Database name
c. Service name
d. Port number
What is the purpose of the
flashback technology in Oracle Database 10g?
a. Recovery from physical
corruption of a data file
b. Recovery from physical
and logical corruption of a data file
c. Recovery from logical
corruption of a data file
d. Recovery from a problem
brought on by a damaged disk drive
User Smith created indexes
on some tables owned by user John. You need to display the following:
Index names
Index types
Which data dictionary
view(s) would you query?
a. DBA_INDEXES only
b. DBA_IND_COLUMNS only
c. DBA_INDEXES and
DBA_USERS
d. DBA_IND COLUMNS and
DBA_USERS
No comments
Post a Comment