1Z0-082 Online Practice Questions and Answers

Which three statements are true regarding indexes? (Choose three.)

A. A UNIQUE index can be altered to be non-unique

B. A SELECT statement can access one or more indices without accessing any tables

C. A table belonging to one user can have an index that belongs to a different user

D. An update to a table can result in updates to any or all of the table's indexes

E. When a table is dropped and is moved to the RECYCLE BIN, all indexes built on that table are permanently dropped

F. An update to a table can result in no updates to any of the table's indexes

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

A. Duplicates are eliminated automatically by the UNION ALL operator

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

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

D. The output is sorted by the UNION ALL operator

E. NULLS are not ignored during duplicate checking

Which compression method is recommended for Direct-Path Insert operations?

A. COLUMN STORE COMPRESS BASIC

B. COLUMN STORE COMPRESS ADVANCED

C. ROW STORE COMPRESS BASIC

D. ROW STORE COMPRESS ADVANCED

Examine these commands:

Which two statements are true about the sqiidr execution?

A. It generates a sqi script that it uses to load data from EMP.DAT TO EMP.

B. It overwrites the data for Alan and adds data for Curl and Bob

C. It appends data from EMP.DAT TO EMP.

D. It overwrites all data in emp with data from emp.dat.

E. It generates a log that contains control file entries, which can be used with normal SQL'Loader operations.

Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION? (Choose two.)

A. Column positions must be used in the ORDER BY clause

B. Only column names from the first SELECT statement in the compound query are recognized

C. The first column in the first SELECT of the compound query with the UNION operator is used by default to sort output in the absence of an ORDER BY clause

D. Each SELECT statement in the compound query must have its own ORDER BY clause

E. Each SELECT statement in the compound query can have its own ORDER BY clause

Examine the description of the SALES table: The SALES table has 55,000 rows. Examine this statement:

Which two statements are true? (Choose two.)

A. SALES1 has NOT NULL constraints on any selected columns which had those constraints in the SALES table.

B. SALES1 has primary KEY and UNIQUE constraints on any selected columns which had those constraints in the SALES table.

C. SALES1 is created with 55,000 rows.

D. SALES1 is created with no rows.

E. SALES1 is created with 1 row.

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 undo tablespace

B. in the SYSAUX tablespace

C. in the SGA

D. in the PGA

E. in the temporary tablespace

Which two statements are true about the DUAL table? (Choose two.)

A. It can be accessed only by the SYS user

B. It consists of a single row and single column of VARCHAR2 data type

C. It can display multiple rows but only a single column

D. It can be used to display only constants or pseudo columns

E. It can be accessed by any user who has the SELECT privilege in any schema

F. It can display multiple rows and columns

Which three statements are true about connection strings and service names used to connect to an Oracle database instance?

A. A single database instance can support connections for multiple service names.

B. A service name is created by a listener.

C. A single connection string can refer to multiple database instances.

D. A connection string including a service name must be defined in the cnsnames.ora file.

E. A connection string must include the SID of a database Instance.

F. Different connection strings in the same tnsnames.ora file can contain the same service name, host and port parameters.

In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE.

Examine this command:

SQL> CREATE TABLE T1(c1 INT PRIMARY KEY, c2 CLOB);

Which segment or segments, if any, are created as a result of executing the command?

A. T1, an index segment for the primary key, a LOB segment, and a lobindex segment

B. no segments are created

C. T1 only

D. T1 and an index segment created for the primary key only

E. T1, an index segment for the primary key, and a LOB segment only