Oracle Database 11g: Administration I
Question No: 91 – (Topic 2)
Which two statements are true about setting the FAST_START_MTTR_TARGET initialization parameter to a nonzero value? (Choose two.)
The MTTR advisor will be disabled
Automatic checkpoint tuning will be enabled
The value for the LOG_CHECKPOINT_INTERVAL initialization parameter will be override the value for FAST_START_MTTR_TARGET
The time taken to recover the instance after the crash is always exactly the same as the value given for the
FAST_START_MTTR_TARGET initialization parameter
Question No: 92 – (Topic 2)
A user, who is authenticated externally, logs in to a remote machine and connects to the database instance. What action would you take to ensure that a user cannot connect to the database instance by merely logging in to a remote machine?
Set REMOTE_OS_ROLES to FALSE
Set OS_ROLES parameter to FALSE
Set the REMOTE_OS_AUTHENT parameter to FALSE
Set the REMOTE_LOGIN_PASSWORD_FILE parameter to NONE
Question No: 93 – (Topic 2)
Which is the correct description of a pinned buffer in the database buffer cache?
The buffer is currently being accessed
The buffer is empty and has not been used
The contents of the buffer have changed and must be flushed to the disk by the DBWn process
The buffer is a candidate for immediate aging out and its contents are synchronized with the block contents on the disk
Question No: 94 – (Topic 2)
In which of the scenario will the DBA perform recovery? (Choose all that apply.)
The alert log file is corrupted
A tablespace is accidentally dropped
One of the redo log members is corrupted
A database user terminates the session abnormally
The hard disk on which the data files is stored is corrupted
Question No: 95 – (Topic 2)
Which two statements are true regarding a PL/SQL package body? (Choose two.)
It cannot be created without a package specification.
It cannot invoke subprograms defined in other packages.
It can contain only the subprograms defined in the package specification.
It can be changed and recompiled without making the package specification invalid.
Answer: A,D Explanation:
Package Specification and Body
Are separate from package specifications. Because of this, the code of the body can be changed and recompiled, and other objects that are dependent on the specification are not marked invalid.
Contain the code for subprograms defined in the package specification. This is where the work is done. The specification shows how to call subprograms within the package: the
body is the code section
Cannot be compiled unless the package specification has already been compiled. You can create a specification without a body- but you cannot create a body without a specification.
May be wrapped to hide details of the code. Wrap is a stand-alone program that obfuscates PL SQL source code so that you can deliver PL SQL applications without exposing your source code. For more information about the use of wrap, see the PL/SQL Packages and Types Reference.
Question No: 96 – (Topic 2)
Examine the following output:
Which two statements about the above index are true? (Choose two.)
It is ignored by the query optimizer.
It is not used while the index is being rebuilt.
The index cannot be rebuilt, and has to be re-created.
The index is automatically rebuilt when used the next time.
Question No: 97 – (Topic 2)
View the Exhibit.
You want to create a tablespace to contain objects with block size 16 KB. But while configuring the storage you find that the block size that you can provide is only 8 KB.
Which configuration could have enabled the block selection of 16 KB?
Choosing the extent allocation type to uniform
Choosing the Segment Space Management option to manual
Setting autoextension on for the data file mentioned for the tablespace
Setting the DB_16K_CACHE_SIZE parameter for the database instance to a nonzero value
Answer: D Explanation:
DB_16K_CACHE_SIZE parameter used to specify size of cache in 16K buffers i.e. other than default size specified by using DB_BLOCK_SIZE. This can be used only when DB_BLOCK_SIZE is not set 16384. Do not set this parameter value to zero if any
tablespace has block size as 16KB. This parameter can be set only when operating system specific minimum block size not restricted greater than 4KB.
Question No: 98 – (Topic 2)
Which two statements are true regarding transactions in an Oracle database? (Choose two.)
Multiple transactions can use the same undo segment.
A transaction is assigned an undo segment when it is started.
More than one transaction cannot share the same extent in the undo tablespace.
The transactions use system undo segment to store undo data if all the segments in the undo tablespace are used.
Answer: A,B Explanation:
The level of logical database storage above an extent is called a segment. A segment is a set of extents that are allocated for a certain logical structure. Different types of segments include:
Data segments: Each nonclustered. non-index-organized table has a data segment, with the exception of external tables, global temporary tables, and partitioned tables in which each table has one or more segments. All of the table#39;s data is stored in the extents of its data segment. For a partitioned table, each partition has a data segment. Each cluster has a data segment. The data of every table in the cluster is stored in the cluster#39;s data segment.
Index segments: Each index has an index segment that stores all of its data. For a partitioned index, each partition has an index segment.
Undo segments: One UNDO tablespace is created for each database instance. This tablespace contains numerous undo segments to temporarily store undo information. The information in an undo segment is used to generate read-consistent database information and. dining database recovery, to roll back uncommitted transactions for users.
Temporary segments: Temporary segments are created by the Oracle database when a SQL statement needs a temporary work area to complete execution. When the statement finishes execution, the temporary segment#39;s extents are returned to the instance for future
use. Specify either a default temporary tablespace for every user, or a default temporary tablespace that is used database-wide.
Transactions and Undo Data
When a transaction starts, it is assigned to an undo segment. Throughout the life of the transaction, when data is changed, the original (before the change) values are copied into the undo segment. You can see which transactions are assigned to which undo segments by checking the V$TRANSACTION dynamic performance view.
Undo segments are specialized segments that are automatically created by the instance as needed to support transactions. Like all segments, undo segments are made up of extents, which, in turn, consist of data blocks. Undo segments automatically grow and shrink as needed, acting as a circular storage buffer for their assigned transactions.
Transactions fill extents in their undo segments until a transaction is completed or all space is consumed. If an extent fills up and more space is needed, the transaction acquires that space from the next extent in the segment. After all extents have been consumed, the transaction either wraps around back into the first extent or requests a new extent to be allocated to the undo segment.
Question No: 99 – (Topic 2)
To make audit information more productive, the DBA executes the following command before starting an audit operations:
SQLgt;ALTER SYSTEM SET AUDIT_TRAIL=DB,EXTENDED SCOPE=SPFILE;
Which statement is true regarding the audit record generated when auditing starts after restarting the database?
It contains only the plan for the SQL statement executed by the user
It contains the SQL text executed by the user and the bind variables used with it
It contains the plan and statistics associated with the SQL statement executed by the user
It contains the plan for the SQL statement executed by the user and the bind variables used with it
Question No: 100 – (Topic 2)
View the Exhibit to examine the output for the CROSSCHECK BACKUP command.
Which statement is true about the output of the command?
The backup piece is expired as the new backup is available
The backup piece is expired because the operating-system file was not found
The backup piece is expired because the retention period for the backup has expired
The backup piece is expired because the backup set to which it belongs is not complete
Explanation: EXPIRED and AVAILABLE Status
You can view the status of backup sets and copies recorded in the RMAN repository through LIST, vs views, or recovery catalog views (if you use RMAN with a catalog). Table 2-4 describes the meaning of each status.
The crosscheck command only processes files created on the same device type as the channels used for the crosscheck. The crosscheck command checks only objects marked available or expired in the repository by examining the files on disk for disk channels or by querying the media manager for sbc channels.
The CROSSCHECK command only processes files created on the same device type as the channels used for the crosscheck. The CROSSCHECK command checks only objects marked AVAILABLE or EXPIRED in the repository by examining the files on disk for DISK channels or by querying the media manager for sbt channels.
Use the CROSSCHECK command to synchronize the physical reality of backups and copies with their logical records in the RMAN repository.
|Lowest Price Guarantee||Yes||No||No|
|Free VCE Simulator||Yes||No||No|