Oracle Database Administration I - 1Z0-082 Exam Practice Test

Question 1

The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different locations.
Each database has a tnsnames.ora file defining DALLAS_DB as a service name.
Examine this command:
CREATE DATABASE LINK dblink1 CONNECT TO scott IDENTIFIED BY tiger USING
`dallas_db';
How do you execute the command so that only SCOTT in BOSTON_DB can access the SCOTT schema in DALLAS_DB?

A. as SCOTT in BOSTON_DB

B. as SCOTT in both the databases

C. as SCOTT in DALLAS_DB

D. as SCOTT in BOSTON_DB and SYS in DALLAS_DB

E. as SYS in both the databases

Correct Answer: E

Question 2

In one of your databases, user KING is:
1. Not a DBA user
2. An operating system (OS) user
Examine this command and its output:

What must you do so that KING is authenticated by the OS when connecting to the database instance?

A. Grant DBA to KING

B. Set OS_AUTHENT_PREFIX to OPS$

C. Have the OS administrator add KING to the OSDBA group

D. Unset REMOTE_LOGIN_PASSWORDFILE

E. Alter user KING to be IDENTIFIED EXTERNALLY

Correct Answer: D

Question 3

Which two statements are true about trace files produced by the Oracle Database server?
(Choose two.)

A. They can be written by server processes

B. All trace files contain error information that require contacting Oracle Support

C. Trace files are written to the Fast Recovery Area (FRA)

D. They can be written by background processes

E. Trace file names are based on the database name concatenated with a sequential number

Correct Answer: A,D

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

Question 4

Your database instance was shut down normally and then started in NOMOUNT state. You then execute this command:
ALTER DATABASE MOUNT;
Which two actions are performed? (Choose two.)

A. The initialization parameter file is read

B. The alert log records the execution details

C. The online redo logs are opened

D. The Oracle background processes are started

E. The online data files are opened

F. The control file is read

Correct Answer: D,F

Question 5

Which three statements are true about the naming methods and their features supported by Oracle database used to resolve connection information?

A. Local Naming requires setting the TNS_ADMIN environment variable on the client side.

B. Local naming can be used if Connect-Time Failover Is required.

C. Easy Connect supports TCP/IP and SSL.

D. Directory Naming can be used if Connect-Time Failover is required.

E. A client can connect to an Oracle database instance even If no client side network admin has been configured.

F. Directory Naming requires setting the TNS_ADMIN environment variable on the client side.

Correct Answer: B,E,F

Question 6

Table ORDER_ITEMScontains columns ORDER_ID, UNIT_PRICEand QUANTITY, of data type NUMBER.
Examine these SQL statements:
Statement 1:
SELECT MAX(unit_price * quantity) "Maximum Order"
FROM order_items;
Statement 2:
SELECT MAX(unit_price * quantity) "Maximum Order"
FROM order_items
GROUP BY order_id;
Which two statements are true?

A. Statement 1 returns only one row of output.

B. Both statements will return NULL if either UNIT_PRICE or QUANTITY contains NULL.

C. Statement 2 returns only one row of output.

D. Statement 2 may return multiple rows of output.

E. Both the statements give the same output.

Correct Answer: B,D

Question 7

Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces? (Choose three.)

A. Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR)

B. Online table segment shrink

C. Oracle Managed Files (OMF)

D. Automatic data file extension (AUTOEXTEND)

E. Online index segment shrink

Correct Answer: A,C,D

Question 8

Which two are true about complete recovery? (Choose two.)

A. Uncommitted transactions will be rolled back after it completes.

B. Incremental backups can be used to roll forward the database while performing it.

C. The database must have FLASHBACK enabled in order to perform it.

D. It is possible only when the database is in MOUNT state

E. Only RMAN backupsets can be used to restore a database as part of it.

Correct Answer: C,D

Question 9

Which three statements are true about roles?

A. Roles may be granted to roles.

B. The SET ROLE statement can disable one or more roles for a session.

C. Object privileges may not be granted to roles.

D. The SET ROLE statement can enable one or more roles for a session.

E. All roles granted to a user are set on by default when the user logs in,

F. Roles must be password protected.

Correct Answer: A,B,C

Question 10

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 DISTINCT promo_category || ` has ` || promo_cost AS COSTS FROM promotions ORDER BY 1;

B. SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;

C. SELECT DISTINCT promo_cost || ' in ` || DISTINCT promo_category FROM promotions ORDER BY 1;

D. SELECT promo_cost, promo_category FROM promotions ORDER BY by 1;

E. SELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2;

Correct Answer: B,E

Question 11

Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)

A. The data type group of each column returned by the second query must match the data type of the corresponding column returned by the first query.

B. The data type of each column returned by the second query must exactly match the data type of the corresponding column returned by the first query.

C. The names and number of columns must be identical for all SELECT statements in the query.

D. The data type of each column returned by the second query must be implicitly convertible to the data type of the corresponding column returned by the first query.

E. The number, but not names, of columns must be identical for all SELECT statements in the query.

Correct Answer: A,B

Question 12

Which statement is true about smallfile tablespaces?

A. Segments can span multiple tablespaces.

B. Maximum file size can be set to unlimited only if the logical volume manager supports striping.

C. Extent location metadata is stored in the data dictionary by default.

D. Segments can span multiple data files.

E. The number of data files is constrained only by the size of the storage array.

Correct Answer: D

Question 13

Which two statements are true regarding the UNION and UNION ALL operators? (Choose two.)

A. The names of columns selected in each SELECT statement must be identical

B. NULLS are not ignored during duplicate checking

C. The output is sorted by the UNION ALL operator

D. The number of columns selected in each SELECT statement must be identical

E. Duplicates are eliminated automatically by the UNION ALL operator

Correct Answer: B,D

Question 14

Which three statements are true about external tables in Oracle 18c and later releases? (Choose three.)

A. External table files can be used for other external tables in a different database

B. They support UPDATEs but not INSERTs and DELETEs

C. They cannot be partitioned

D. The ORACLE_DATAPUMP access driver can be used to load data into a database from an external table

E. The ORACLE_DATAPUMP access driver can be used to unload data from a database into an external table

F. The ORACLE_LOADER access driver can be used to unload data from a database into an external table

Correct Answer: A,B,F

Oracle Database Administration I - 1Z0-082 Exam Practice Test

Latest Update

Useful Links

Contact Us