Oracle Database Administration I - 1Z0-082 Free Exam Questions

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

B. Alter user KING to be IDENTIFIED EXTERNALLY

C. Grant DBA to KING

D. Unset REMOTE_LOGIN_PASSWORDFILE

E. Set OS_AUTHENT_PREFIX to OPS$

A. An index that is altered to be UNUSABLE will retain its segment

B. Private Temporary Tables (PTTS) store metadata in memory only

C. If they exist for a session, Private Temporary Tables (PTTs) are always dropped at the next COMMIT OR ROLLBACK statement

D. An index created with the UNUSABLE attribute has no segment

E. A table that is truncated will always have its segment removed

A. ORDER BY 1, LNAME DESC

B. WHERE city LIKE *%AN%*

C. ORDER BY last_narae DESC, city ASC

D. ORDER BY 1, 2

E. WHERE city IN (?AN%')

F. WHERE city = =%AN%'

A. stored procedures

B. clusters

C. index

D. sequences

E. tables

F. undo

A. You can reattach to it and monitor it

B. You can no longer monitor it

C. It terminates

D. It is paused and can be resumed

E. It continues to run in the background

A. PCTFREE defaults to 10% for all blocks in all segments for all compression methods

B. ASSM assigns blocks to one of four fullness categories based on what percentage of the block is allocated for rows

C. Update operations always attempt to find blocks with free space appropriate to the length of the row being updated

D. Insert operations always attempt to find blocks with free space appropriate to the length of the row being inserted

E. A block will always be eligible for inserts if the row is short enough to fit into the block

A. It has its own commands that are separate from any SQL statements.

B. It has both command-line and graphical user interfaces (GUI).

C. It can run scripts entered at the SQL prompt.

D. It must be downloaded from the Oracle Technology Network (OTN).

E. It can run Recovery Manager (RMAN) commands.

F. It can run scripts passed to it by a shell script.

A. Source Routing requires the use of a name server

B. Connect Time Failover requires the use of Transparent Application Failover (TAF)

C. Load Balancing requires the use of a name server

D. Connect Time Failover requires the connect string to have two or more listener addresses configured

E. Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration

F. Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall

A. It must be smaller than the smallest BIGFILE tablespace

B. Any data files added to the tablespace must have a size of 5 gigabytes

C. It is a locally managed tablespace

D. Free space is managed using freelists

E. It uses the database default blocksize

A. It can be accessed only by the SYS user

B. It can display multiple rows and columns

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

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

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

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

A. as SYS in both the databases

B. as SCOTT in both the databases

C. as SCOTT in BOSTON_DB and SYS in DALLAS_DB

D. as SCOTT in DALLAS_DB

E. as SCOTT in BOSTON_DB

A. SALES1 is created with 1 row.

B. SALES1 is created with 55,000 rows.

C. SALES1 has not NULL constraints on any selected columns which had those constraints in the sales table.

D. SALES1 is created with no rows.

E. SALES1 has primary key and unique constraints on any selected columns which had those constraints in the sales table.

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

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

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

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

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