Get Full Version of the Exam
http://www.EnsurePass.com/1z0-062.html
Question No.261
For which three requirements would you use the Database Resource Manager? (Choose three.)
-
specifying an idle time limit that applies to sessions that are idle and blocking other sessions
-
limiting the degree of parallelism of operations performed by user sessions in a consumer group
-
specifying the maximum number of concurrent sessions allowed for a user
-
limiting the CPU used per database call
-
specifying the amount of private space a session can allocate in the shared pool of the SGA.
Correct Answer: ABC
Explanation:
http://docs.oracle.com/cd/B19306_01/server.102/b14231/dbrm.htm
Question No.262
You are administering a database that supports an OLTP workload.
The default UNDO tablespace is a fixed size tablespace with the RETENTION NOGUARATNEE clause and undo retention set to 12 minutes.
The user SCOTT queries a large table during peak activity.
The query runs for more than 15 minutes and then SCOTT receives the following error: ORA-01555: snapshot too old
Which is possible reason for this?
-
The Oracle server is unable to generate a read-consistent image for a block containing updates.committed after the query began.
-
The query is unable to place data blocks in the UNDO tablespace.
-
The flashback data archive is not enabled for the table on which the query is issued.
-
There is not enough space in Fast Recovery Area.
-
The Oracle server is unable to generate a read-consistent image for a block containing uncommitted updates.
Correct Answer: A
Question No.263
You create a locally managed tablespace ORDERS_TBS with automatic segment management.
You then create the table DAILY_ORDS_LST in the ORDERS_TBS tablespace using the command.
CREATE TABLE daily_ords_1st(ordno NUMBER, ord_date DATE) PCTFREE 20; How does the PCTFREE storage parameter influence data storage for this table?
-
It allows only 80% of space to be occupied in all data blocks of this table.
-
It minimizes row chaining during row insertion.
-
It minimizes row migration during existing row data updation.
-
It automatically coalesces free space of a data block when it reaches 20% of available space.
Correct Answer: A
Question No.264
Which statement is true about profiles?
-
Resource limits specified in a profile assigned to a user are always enabled.
-
A user can exist without any profile.
-
A profile can be assigned only to one user.
-
Password management using profiles is always enabled.
Correct Answer: D
Question No.265
Which three statements are true about checkpointing? (Choose three.)
-
It prompts the Checkpoint (CKPT) process to write data to the data files and redo information to
the online redo log files.
-
It ensures that all dirty buffers are written to data files during consistent shutdown.
-
It reduces the time required for recovery in case of an instance failure.
-
Frequent thread checkpoints can degrade database performance.
-
It prompts the Database Writer (DBWn) process to write checkpoint information into data file headers and the control file.
Correct Answer: BCD
Question No.266
Which three tools or tasks are run by default as part automated maintenance tasks? (Choose three.)
-
Automatic Database Diagnostic Monitor
-
Optimizer statistics gathering
-
SQL Access Advisor
-
Segment Advisor
-
Automatic SQL Tuning Advisor
Correct Answer: BDE
Question No.267
Identify two prerequisites for configuring Enterprise Manager Database Express (EM Express).
-
Grant the APEX_PUBLIC_USER role to the SYSMAN user.
-
Use the DBMS_XDB_CONFIG.SETHTTPPORT procedure to configure a port number for Oracle HTTP Server.
-
Install Oracle HTTP Server.
-
Configure at least one dispatcher for the TCP/IP protocol.
-
Create a SYSMAN user with the SYSDBA privilege as an administrator for EM Express.
Correct Answer: BD
Question No.268
Which three statements are true about user account administration? (Choose three.)
-
A user#39;s current session is not affected when the user#39;s profile is changed.
-
Only users with the SYSDBA privilege can change the tablespace quota for other users.
-
A new user account can be created only by SYS or SYSTEM users.
-
A user#39;s quota can be set for any permanent tablespace but not for the default temporary tablespace.
-
A user requires only the CREATE SESSION privilege to change his or her own password.
Correct Answer: ADE
Question No.269
Which three statements are true about Automatic Workload Repository (AWR)? (Choose three.)
-
An AWR snapshot shows the SQL statements that are producing the highest load on the system, based on criteria such as elapsed time and CPU time.
-
AWR data is stored in memory and in a database.
-
All AWR tables belong to the SYSTEM schema.
-
The manageability monitor (MMON) process gathers statistics and creates an AWR snapshot that is used by the self-tuning components in a database.
-
An AWR snapshot contains system-wide tracing and logging information.
Correct Answer: ABD
Question No.270
Which statement is true about a database in ARCHIVELOG mode?
-
All backups taken prior to switching to ARCHIVELOG mode can be used to perform complete recovery.
-
Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.
-
A Fast Recovery Area (FRA) must be configured for the database.
-
Full database backups can be performed when the database is opened.
Correct Answer: D
Get Full Version of the Exam
1z0-062 Dumps
1z0-062 VCE and PDF