1Z0-082 Online Practice Questions and Answers

Examine this command:

Which two statements are true? (Choose two.)

A. DML may be performed on tables with one or more extents in this data file during the execution of this command.

B. The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.

C. The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.

D. If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.

E. The file is renamed and stored in the same location

Which three statements are true about dropping and unused columns in an Oracle database? (Choose three.)

A. A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option.

B. An UNUSED column's space is reclaimed automatically when the block containing that column is next queried.

C. An UNUSED column's space is reclaimed automatically when the row containing that column is next queried.

D. Partition key columns cannot be dropped.

E. A DROP COLUMN command can be rolled back

F. A column that is set to UNUSED still counts towards the limit of 1000 columns per table

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

Which three statements are true about single-row functions? (Choose three.)

A. They can be used only in the WHERE clause of a SELECT statement

B. The argument can be a column name, variable, literal or an expression

C. The data type returned can be different from the data type of the argument

D. They can be nested to any level

E. They can accept only one argument

F. They return a single result row per table

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 DALLAS_DB

B. as SCOTT in BOSTON_DB

C. as SCOTT in BOSTON_DB and SYS in DALLAS_DB

D. as SYS in both the databases

E. as SCOTT in both the databases

Which three statements are true about inner and outer joins? (Choose three.)

A. A full outer join returns matched and unmatched rows

B. An inner join returns matched rows

C. Outer joins can only be used between two tables per query

D. A full outer join must use Oracle syntax

E. Outer joins can be used when there are multiple join conditions on two tables

F. A left or right outer join returns only unmatched rows

Examine this description of the TRANSACTIONS table:

Which two SQL statements execute successfully? (Choose two.)

A. SELECT customer_id AS "CUSTOMER-ID", transaction_date AS DATE, amount + 100 "DUES" FROM transactions;

B. SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount + 100 DUES FROM transactions;

C. SELECT customer_id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount + 100 "DUES AMOUNT" FROM transactions;

D. SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM transactions;

E. SELECT customer_id AS `CUSTOMER-ID', transaction_date AS DATE, amount + 100 `DUES AMOUNT' FROM transactions;

Which statement is true about aggregate functions?

A. Aggregate functions can be nested to any number of levels

B. The AVG function implicitly converts NULLS to zero

C. Aggregate functions can be used in any clause of a SELECT statement

D. The MAX and MIN functions can be used on columns with character data types

Which two are true about shrinking a segment online? (Choose two.)

A. It is not possible to shrink either indexes or Index Organized Tables (IOTs)

B. It always eliminates all migrated rows if any exist in the table

C. To shrink a table it must have a PRIMARY KEY constraint

D. To shrink a table it must have a UNIQUE KEY constraint

E. To shrink a table it must have row movement enabled

F. It must be in a tablespace that uses Automatic Segment Space Management (ASSM)

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