Free Download 1z0-082 Examp Dump: Oracle.1z0-082.SelfTestEngine.2020-02-27.54q.vcex

File Info

Exam	Oracle Database Administration I
Number	1z0-082
File Name	Oracle.1z0-082.SelfTestEngine.2020-02-27.54q.vcex
Size	733 KB
Posted	Feb 27, 2020
Download	Oracle.1z0-082.SelfTestEngine.2020-02-27.54q.vcex

How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase

Coupon: MASTEREXAM
With discount: 20%

Demo Questions

Question 1

You execute this command:

Sufficient storage is available in filesystem /u01.

Which two statements are true about the BIG_TBS tablespace? (Choose two.)

AUTOEXTEND is possible for the datafile
It must be bigger than the largest SMALLFILE tablespace
Additional data files may not be added
It will be a dictionary-managed tablespace by default
It will always have a 32K blocksize

Correct answer: AB

Question 2

Which statement is true about the INTERSECT operator used in compound queries?

Multiple INTERSECT operators are not possible in the same SQL statement
It processes NULLs in the selected columns
INTERSECT is of lower precedence than UNION or UNION ALL
It ignores NULLs

Correct answer: B

Question 3

In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1.

The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains:

Which statement is true?

Dynamic service registration cannot be used for this database instance
The LREG process registers services dynamically with the LISTENER_1 listener
LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration
There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances
The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration

Correct answer: C

Explanation:

Reference: https://docs.oracle.com/database/121/NETAG/listenercfg.htm#NETAG292

Question 4

Which three statements are true concerning logical and physical database structures? (Choose three.)

All tablespaces may have one or more data files
The extents of a segment must always reside in the same datafile
A smallfile tablespace might be bigger than a bigfile tablespace
A segment can span multiple data files in some tablespaces
A segment’s blocks can be of different sizes
A segment might have only one extent
Segments can span multiple tablespaces

Correct answer: CFG

Question 5

Which two statements are true regarding a SAVEPOINT? (Choose two.)

Rolling back to a SAVEPOINT can undo a CREATE INDEX statement
Rolling back to a SAVEPOINT can undo a TRUNCATE statement
Only one SAVEPOINT may be issued in a transaction
A SAVEPOINT does not issue a COMMIT
Rolling back to a SAVEPOINT can undo a DELETE statement

Correct answer: DE

Question 6

Which three functions are performed by dispatchers in a shared server configuration? (Choose three.)

writing inbound request to the common request queue from all shared server connections
checking for outbound shared server responses on the common outbound response queue
receiving inbound requests from processes using shared server connections
sending each connection input request to the appropriate shared server input queue
broadcasting shared server session responses back to requesters on all connections
sending shared server session responses back to requesters on the appropriate connection

Correct answer: ACD

Question 7

Which two statements are true about the SET VERIFY ON command? (Choose two.)

It can be used only in SQL*Plus
It displays values for variables used only in the WHERE clause of a query
It can be used in SQL Developer and SQL*Plus
It displays values for variables created by the DEFINE command
It displays values for variables prefixed with &&

Correct answer: AD

Question 8

Which three statements are true about a self join? (Choose three.)

The ON clause must be used
The query must use two different aliases for the table
It must be an equijoin
It must be an inner join
The ON clause can be used
It can be an outer join

Correct answer: BDE

Question 9

Examine the description of the CUSTOMERS table:

You want to display details of all customers who reside in cities starting with the letter D followed by at least two characters.

Which query can be used?

SELECT * FROM customers WHERE city LIKE ‘D_%’;
SELECT * FROM customers WHERE city = ‘%D_’;
SELECT * FROM customers WHERE city LIKE ‘D_’;
SELECT * FROM customers WHERE city = ‘D_%’;

Correct answer: A

Question 10

Examine this command:

Which two statements are true? (Choose two.)

DML may be performed on tables with one or more extents in this data file during the execution of this command.
The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.
The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.
If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.
The file is renamed and stored in the same location

Correct answer: AB