Examine the resources consumed by a database instance whose current Resource Manager plan
is displayed.
SQL> SELECT name, active_sessions, queue_length,
Consumed_cpu_time, cpu_waits, cpu_wait_time
FROM v$rsrc_consumer_group;
NAMEACTIVE_SESSIONS QUEUE_LENGTH CONSUMED_CPU_WAITS
CPU_WAIT_TIME
———————————– ——————– ——————– ——————— —————-OLTP__ORDER__ENTRY1029690 467
6709
OTHES__GROUPS 0 059823664089
60425
SYS_GROUP 1 02420704 914
19540
DS.S_QUERIES4245946603004
55700
Which two statements are true?
A.
An attempt to start a new session by a user belonging to DSS_QUERIES fails with an error.
B.
An attempt to start a new session by a user belonging to OTHE_GROUPS fails with an error.
C.
The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group
waited for the CPU due to resource management.
D.
The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group
waited for the CPU due to I/O waits and latch or enqueue contention.
E.
A user belonging to the DSS__QUERIES resource consumer group can create a new session
but the session will be queued.
Explanation:
CE
C E
why C and E are correct?
C: Cumulative amount of time that sessions waited for CPU because of resource management. This does not include waits due to latch or enqueue contention, I/O waits, and so on. When CPU resources are not being actively managed, this value is set to zero.
E: Number of sessions waiting in the queue – the numbers are next to each other without any space, but u can clearly see, that queue_lenght is more than 0. That means, session can be established, but cannot be active at the moment (active session is defined as session that is running a query or has uncommited transaction)
btw. does any1 has any latest dumps of questions from iz0-062? I would really appreciate.
By the way, the chart (or exhibit) is awful… I can’t see there anything!
TKS
CE
CE
C E
http://docs.oracle.com/database/121/ADMIN/dbrm.htm#ADMIN027
Hello everyone…
These questions are real exam questions. Please help me to find the correct answers.
——————–
The HR schema exists in two databases, BOSTON and DENVER, and has the same password, HR. You have the CREATE DATABASE LINK and CREATE SESSION privileges on both the database. BOSTON is defined as a service name in the tnsnames.ora of both the databases.
You plan to use the command: CREATE DATABASE LINK hr_link CONNECT to hr IDENTIFIED BY hr USING ‘denver’;
What must be done to ensure only the HR user in the BOSTON database can access the HR schema in the DENVER database?
-Execute this command as HR user in the BOSTON database and SYS user in the DENVER database.
-Execute this command as HR user in the BOSTON database.
-Execute this command as SYS user in both the databases.
-Execute this command as HR user in the DENVER database.
————————–
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_lst (ordno NUMBER, ord_date DATE) PCTFREE 20;
How does the PCTFREE storage parameter influence data storage for this table?
-It minimizes row migration during existing row data updating.
-It automatically coalesces free space of a data block when it reaches 20% of available space.
-It minimizes row changing during row insertion.
-It allows only 80% of space to be occupied in all data blocks of this table.
————————–
Which three statements are about user account administration?
-A new user account can be created only by SYS or SYSTEM users.
-A user requires only the CREATE SESSION privilege to change his or her own password.
-Only users with the SYSDBA privilege can change the tablespace quota for other users.
-A user’s current session is not affected when the user’s profile is changed.
-A user’s quota can be set for any permanent tablespace but not for the default temporary tablespace.
—————————————-
What action must you take to ensure complete database recovery till the point of failure?
-Multiple the control files.
-Configure the database to run in ARCHIVELOG mode.
-Duplex the RMAN backup sets.
-Multiple the online redo log files.
————————————–
Examine the parameter for a database instance:
NAME TYPE VALUE
———————————— —————- ———————-
temp_undo_enabled boolean TRUE
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS1
Your database has three undo tablespaces and the default undo tablespaces is not autoextensible. Resumable space allocation is not enabled for any sessions in the database instance.
What is the effect on new transactions when all undo space in the default undo tablespace is in use by active transactions?
-Transactions write their undo in a temporary tablespace.
-Transactions wait until space becomes available in UNDOTBS1.
-Transactions write their undo in the SYSTEM undo segment.
-Transactions fail.
—————————————–
Which two statements are true about using SQL*Loader?
-It can load data from external files by using direct path only.
-It can load data into multiple tables using the same load statement.
-It can load data into only use table at a time.
-It can load data from external files by using conventional path only.
-It can generate unique sequential key values in specified columns.
—————————————————
You want to create a table, DAILY_ORDERS, for an OLTP application, where data should be compressed during both direct path INSERT and conventional DML. The table will also be used for queries.
Which compression option should be used?
-ROW STORE COMPRESS ADVANCED
-COLUMN STORE COMPRESS FOR QUERY
-ROW STORE COMPRESS
-COLUMN STORE COMPRESS FOR ARCHIVE LOW.
————————————–