Oracle Database Administration I - 1Z0-082 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

Examine the description of the PROMOTIONS table:

You want to display the unique promotion costs in each promotion category.
Which two queries can be used? (Choose two.)

A. SELECT promo_cost, promo_category FROM promotions ORDER BY by 1; B. SELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2; C. SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1; D. SELECT DISTINCT promo_cost || ' in ` || DISTINCT promo_category FROM promotions ORDER BY 1; E. SELECT DISTINCT promo_category || ` has ` || promo_cost AS COSTS FROM promotions ORDER BY 1;

Discussion 0

Correct Answer: B,C Vote an answer

Question 2

Examine these SQL statements which execute successfully:

Which two statements are true after execution?

A. The primary key constraint will be enabled and immediate. B. The foreign key constraint will be disabled. C. The primary key constraint will be enabled and deferred. D. The foreign key constraint will be enabled and deferred. E. The foreign key constraint will be enabled and immediate.

Discussion 0

Correct Answer: B Vote an answer

Question 3

A database is configured to use automatic undo management with temporary undo enabled.
An UPDATE is executed on a temporary table.
Where is the UNDO stored?

A. in the SGA B. in the undo tablespace C. in the PGA D. in the temporary tablespace E. in the SYSAUX tablespace

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 4

Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three.)

A. Source Routing requires the use of a name server B. Load Balancing requires the use of a name server C. Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall D. Connect Time Failover requires the use of Transparent Application Failover (TAF) E. Connect Time Failover requires the connect string to have two or more listener addresses configured F. Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration

Discussion 0

Correct Answer: A,C,E Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 5

Which three statements are true about table data storage in an Oracle Database? (Choose three.)

A. A table row piece can be chained across several database blocks B. Multiple row pieces from the same row may be stored in the same block C. Multiple row pieces from the same row may be stored in different database blocks D. Data block free space is always contiguous in the middle of the block E. Data block headers contain their own Data Block Address (DBA) F. Index block free space is always contiguous in the middle of the block

Discussion 0

Correct Answer: A,C,D Vote an answer

Question 6

Evaluate these commands which execute successfully:

Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence?
(Choose two.)

A. If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS B. Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ C. Sequence ORD_SEQ is guaranteed not to generate duplicate numbers D. Column ORD_NO gets the next number from sequence ORD_SEQ whenever a row is inserted into ORD_ITEMS and no explicit value is given for ORD_NO E. Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times

Discussion 0

Correct Answer: B,C Vote an answer

Question 7

Which three failures do not require intervention for recovery? (Choose three.)

A. network interface card (NIC) failure B. media failure C. statement failure D. transaction failure E. user process failure

Discussion 0

Correct Answer: C,D,E Vote an answer

Question 8

Which four account management capabilities can be configured using Oracle profiles? (Choose four.)

A. the number of hours for which an account is locked after the configured number of login attempts has been reached B. the number of days for which an account is locked after the configured number of login attempts has been reached C. the maximum amount of CPU time allowed for a user's sessions before their account is locked D. the maximum number of sessions permitted for a user before the account is locked E. the number of days for which an account may be inactive before it is locked F. the ability to prevent a password from ever being reused G. the number of password changes required within a period of time before a password can be reused

Discussion 0

Correct Answer: B,D,F,G Vote an answer

Question 9

Which two statements are true about segment types in an Oracle Database?

A. Temporary segments are only stored in a temporary tablespace. B. Cluster segments may contain data from multiple tables. C. Table segments always have two or more extents. D. Index segments always have two or more extents. E. Undo segments are only stored in an undo tablespace.

Discussion 0

Correct Answer: A Vote an answer

Question 10

Which two statements are true about Enterprise Manager (EM) Express?

A. EM Express uses a separate repository database to store target database metadata. B. By default, EM express is available for a database after database creation using DBCA. C. You can use a single instance of EM Express to manage multiple database running on the same server. D. You cannot start up a database instance using EM Express. E. You can shut down a database instance using EM Express.

Discussion 0

Correct Answer: B,D Vote an answer

Question 11

A user complains about poor database performance. You suspect that the user's session is waiting for an event to complete.
You want to verify this.
Which two views may reveal for what the user's session is currently waiting? (Choose two.)

A. V$SESSION_EVENT B. V$SESSION_WAIT C. V$SESSION_WAIT_CLASS D. V$SYSTEM_EVENT E. V$SESSION

Discussion 0

Correct Answer: A,B Vote an answer

Question 12

The ORCL database has RESUMABLE__TIMEOUT = 7200 and
DEFERRED_SEGMENT_CREATION = FALSE
User U1 has a 1 MB quota in tablespace DATA.
U1 executes this command:
SQL> CREATE TABLE t1 AS
(SELECT object_name, sharing, created
FROM dba_objects);
U1 complains that the command is taking too long to execute.
In the alert log, the database administrator (DBA) finds this:
2017-03-06T12:15:17.183438+05:30
statement in resumable session 'User U1(136), Session 1, Instance 1'
was suspended due to ORA-01536: space quota exceeded for tablespace
'DATA'
Which are three actions any one of which the DBA could take to resume the session? (Choose three.)

A. Set DEFERRED_SEGMENT_CREATION to TRUE B. Set AUTOEXTEND ON for data files in DATA C. Add a data file to DATA D. Drop other U1 objects in DATA E. Increase U1's quota sufficiently in DATA F. Grant UNLIMITED TABLESPACE to U1

Discussion 0

Correct Answer: A,B,E Vote an answer