Questions(41-50)
QUESTION 41:
You company has four DBAs. You need to know which DBA added a column to the
JOB_HISTORY table. The database cannot be offline during work hours. Which
LogMiner command can you use to find out which user made the table change?
A. SELECT username,operation,sql_redo from V$logmnr_contents where
operation='DDL';
B. SELECT username,operation,sql_redo from V$logmnr_logs where operation='DDL';
C. You must wait until after hours, shut the database down, and issue the command
EXECUTE DBMS_LOGMNR_D.BUILD to extract the information from the
database.
D. The task cannot be done. LogMiner does not track DDL commands in Oracle9i.
Answer: A
Explanation:
Prior to Oracle9i, DDL statements were recorded as a set of DML statements on internal
tables.Oracle 9i records the original DDL statement in the redo logs, and LogMiner lists this DDL statement followed by the set of generated DML statements. When you query V$LOGMNR_CONTENTS, you can see DDL under the OPERATION column, and the DDL statement itself under the SQL_REDO column.
QUESTION 42:
Automatic Consumer Group Switching is an important new feature of the Database
Resource Manager. Which three plan directive parameters are used to control this
feature? (Choose three)
A. SWITCH_TIME
B. SWITCH_GROUP
C. MAX_SESS_POOL
D. SWITCH_ESTIMATE
Actualtests.com - The Power of Knowing
1Z0-032
Answer: A, B, D
Explanation:
You can specify the maximum estimated time to complete (in seconds) for an operation by
assigning a value the MAX_EST_EXEC_TIME parameter; the default value for this
parameter is UNLIMITED. Oracle will estimate the time the operation with table will take. It
the SWITH_ESTIMATE parameter is set to TRUE, and if Oracle's estimate is greater than
the value specified by MAX_EST_EXEC_TIME, Oracle will return an error and the operation
will not be started. If the SWITCH_ESTIMATE parameter is FALSE, Oracle will start the
operation even if Oracle's estimate is greater than the value specified by
MAX_EST_EXEC_TIME; Oracle will only switch groups based on other criteria being met.
The SWITCH_GROUP parameter specifies the group to which the session will be switched.
The SWITCH_TIME parameter specifies the amount of time a session can execute before it
must be switched to another group. The default for the SWITCH_GROUP parameter is
NULL; the default for the SWITCH_TIME parameter is UNLIMITED.
QUESTION 43:
How can you make a shared server-side initialization parameter file available to all
instances of a Real Application Clusters database?
A. Include an SPFILE parameter in each instance-specified initialization file.
B. Create an SPFILE copy on each client from which the instance will be started.
C. Store the SPFILE in a raw partition with a vendor-specifies location and name.
D. Use a single client to start the instances and create the SPFILE on this client.
Answer: A
Explanation:
You can make a shared server-side initialization parameter file available to all instances of a
Real Application Clusters database by including an SPFILE parameter in each instancespecific
initialization file. You still have to store a copy of the initialization parameter file on
each node to facilitate startup of the instances. You can avoid distributing copies by
converting this initialization parameter file into a Server Parameter File (SPFILE). Then you
put the one parameter, as shown here, in the initialization parameter file for each instance:
spfile = oracle/home:\config\spfile
QUESTION 44:
Examine the command:
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY)
COLUMNS;
What does the command accomplish?
A. Creates an additional copy of the database online redo log files.
B. Stores the primary key column values of each row involved in a DML operation in the
online redo log files.
C. Stores the primary key column values of each row involved in a DML operation in the
supplemental log files.
D. Stores the old and new primary key column values of each row involved in a DML
operation only when the primary key is modified in the online redo log files.
Answer: B
Explanation:
Database supplemental logging allows you to specify logging of primary keys, unique indexes
or both. With this enabled, whenever a DML is performed, the columns involved in the
primary key or unique index are always logged even if they were not involved in the DML.
This only takes effect for statements which have not yet been parsed. It also invalidates all
DML cursors in the cursor cache and therefore has an effect on performance until the cache is
repopulated.
QUESTION 45:
Consider this RMAN command:
RMAN> CONFIGURE RETENTION POLICY CLEAR;
What is the effect of this command?
A. Backups will never expire.
B. It removes any retention policy.
C. The DELETE OBSOLETE command will fail with an error.
D. It sets the retention policy to the default of REDUNDANCY 1.
Answer: D
Explanation:
This command sets retention policy to the default of REDUNDANCY 1.
QUESTION 46:
Examine the code:
CREATE ROLE readonly IDENTIFIES USING app.chk_readwrite ;
CREATE ROLE readwrite IDENTIFIED USING app.chk_readwrite ;
CREATE OR REPLACE PROCEDURE app.chk_readwrite
AUTHID CURRENT_USER IS
ipchk STRING(30);
BEGIN
IF sys_context('USERENV','ISDBA')='TRUE'
THEN DBMS_SESSION.SET_ROLE'READWRITE') ;
ELSE DBMS_SESSION.SET_ROLE('READONLY') ;
END;
/
Which three statements correctly describe the Secure Application role definition?
(Choose three) (The SYS_CONTEXT calls returns whether or not the session is a true
DBA session.)
A. No user or application has to remember or hide a password.
B. It prevents everyone except a true DBA session from acquiring the READWRITE
role.
C. app.chk_readwrite is called whenever a user tries to access rows protected by the
READONLY or READWRITE label.
D. app.chk_readwrite is called by users or applications when they want to enable the
READONLY or READWRITE role.
Answer: A, B, D
Explanation:
Oracle8i introduced the Secure Application Context to enable an application to tailor access
control based on using the attributes of the user's session. Oracle prevents users from
bypassing privileges validation procedure by restricting application attribute changes to the
procedure that implements the context. Oracle9i takes the concept of the application context
one step further; it provides a means of associating the application context with the security
role.
QUESTION 47:
Media recovery can sometimes be stopped by the inability to read past a certain point in
the redo stream. This is often referred to as "stuck recovery". Before Oracle9i, the
Database Administrator had few options to deal with stuck recovery. If the corrupt redo
could not be recovered from some other source, then all transactions that committed
after the corrupt point in the redo steam would be lost.
Oracle9i changes that with the Trial Recovery feature. Trial Recover is used to test the
application of the redo logs to the database.
What are three other characteristics of Trial Recovery (Choose three)
A. Speeds up subsequent media recover actions.
B. Writes any uncorrupted block to disk during the test recovery.
C. Can be invoked by adding the TEST option to any RECOVER command.
D. Allows the Administrator to determine how many blocks are affected by corruption.
E. Marks blocks as corrupt in memory, allowing the test recover to proceed to
completion.
Answer: C, D, E
Explanation:
Trial Recovery allows the Administrator to determine how many blocks are affected by
corruption, mark them as corrupt in memory to allow the test recovery proceed to completion.
By default, trial recovery always attempts to corrupt blocks in memory if this action allows
trial recovery to proceed. In other words, trial recovery by default can corrupt an unlimited
number of data blocks. You can specify the ALLOW n CORRUPTION clause on the RECOVER
TEST statement to limit the number of data blocks trial recovery can corrupt in memory. It can
be invoked by adding the TEST option to any RECOVER command. For example, you can
start SQL*Plus and then issue any of the following commands:
RECOVER DATABASE TEST
RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL TEST
RECOVER TABLESPACE users TEST
RECOVER DATABASE UNTIL CANCEL TEST
QUESTION 48:
Which two are regarding automatic space management segments? (Choose two)
A. You can create an automatic space management segment in a dictionary-managed
tablespace.
B. You can create an automatic space management segment only in a locally managed
tablespace.
C. You can successfully invoke the DBMS_SPACE.FREE_BLOCKS procedure on an
automatic space management segment.
D. You CANNOT successfully invoke the DBMS_SPACE.FREE_BLOCKS procedure
on an automatic space management segment.
Answer: B, D
Explanation:
You can create an automatic space management segment only in a locally managed
tablespace. The FREE_BLOCKS procedure refers to the blocks in a segment below the high
water mark whose number of rows falls below the PCTUSED attribute, and therefore are
candidate for new inserted rows. An automatic space management segment usage eliminates
the need to specify the PCTUSED, FREELISTS, and FREELIST GROUPS parameters. So
you CANNOT successfully invoke the DBMS_SPACE.FREE_BLOCKS procedure on an
automatic space management segment.
QUESTION 49:
The database was started up using a text parameter file. What will be the default scope
of changes made by using the SET clause of the ALTER SYSTEM statement?
A. Only MEMORY is updated.
B. Only SPFILE values are updated.
C. Only init
D. Both init
Answer: A
Explanation:
The default scope of changes made by using the SET clause of the ALTER SYSTEM
statement is only MEMORY scope. The MEMORY scope only makes changes in memory for
the current instance and not the SPFILE; it does not persist.
QUESTION 50:
Which three resource plan parameters are used to enable Automatic Consumer Group
Switching to estimate job execution times automatically, and to perform a switch to a
low priority consumer group before they are initiated? (Choose three)
A. SWITCH_TIME
B. SWITCH_GROUP
C. MAX_SESS_POOL
D. SWITCH_ESTIMATE
Answer: A, B, D
Explanation:
You can specify the maximum estimated time to complete (in seconds) for an operation by
assigning a value the MAX_EST_EXEC_TIME parameter; the default value for this
parameter is UNLIMITED. Oracle will estimate the time the operation with table will take. It
the SWITH_ESTIMATE parameter is set to TRUE, and if Oracle's estimate is greater than
the value specified by MAX_EST_EXEC_TIME, Oracle will return an error and the operation
will not be started. If the SWITCH_ESTIMATE parameter is FALSE, Oracle will start the
operation even if Oracle's estimate is greater than the value specified by
MAX_EST_EXEC_TIME; Oracle will only switch groups based on other criteria being met.
The SWITCH_GROUP parameter specifies the group to which the session will be switched.
The SWITCH_TIME parameter specifies the amount of time a session can execute before it
must be switched to another group. The default for the SWITCH_GROUP parameter is
NULL; the default for the SWITCH_TIME parameter is UNLIMITED.
Post a Comment