Free 1z0-082 Exam Dumps

Question 11

In one of your databases, the user HR has the password HRMGR.
You want to connect to a database instance whose listener listens on port 1531 by using this statement: CONNECT HR/HRMGR@orcl
No name server is used.
Which statement is true about ORCL?

A. It must be the value of the SERVICE_NAMES parameter on the client side
B. It must resolve to a valid connect descriptor in the server’s tnsnames.ora file
C. It must resolve to a valid connect descriptor in the client’s tnsnames.ora file
D. It must be the name of the database to whose instance HR wishes to connect
E. It must be the name of the server running the database to whose instance HR wishes to connect

Correct Answer:E

Question 12

Which three statements are true about the tools used to configure Oracle Net Services? (Choose three.)

A. The Oracle Net Configuration Assistant is only used when running the Oracle installer
B. Oracle Net Manager can be used to centrally configure listeners on any database server target
C. The lsnrctl utility requires a listener.ora file to exist before it is started
D. Oracle Net Manager can be used to locally configure naming methods on a database server
E. Enterprise Manager Cloud Control can be used to centrally configure listeners on any managed database server
F. Enterprise Manager Cloud Control can be used to centrally configure net service names for any databaseserver target

Correct Answer:BDE

Question 13

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. Add a data file to DATA
B. Drop other U1 objects in DATA
C. Increase U1’s quota sufficiently in DATA
D. Set DEFERRED_SEGMENT_CREATION to TRUE
E. Grant UNLIMITED TABLESPACE to U1
F. Set AUTOEXTEND ON for data files in DATA

Correct Answer:CDF

Question 14

Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)

A. A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.
B. GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.
C. GLOBAL TEMPORARY TABLE space allocation occurs at session start.
D. Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.
E. A GLOBAL TEMPORARY TABLE’S definition is available to multiple sessions.
F. A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.

Correct Answer:BCF

Question 15

Examine these commands:
1Z0-082 dumps exhibit
Which two statements are true about the sqlldr execution? (Choose two.)

A. It overwrites data in EMP with data in EMP.DAT
B. It uses the database buffer cache to load data
C. It generates a log that contains control file entries, which can be used with normal SQL*Loader operations
D. It generates a sql script that it uses to load data from EMP.DAT to EMP
E. It appends data from EMP.DAT to EMP

Correct Answer:BD