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

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

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

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

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

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

A. creating a user session in the System Global Area (SGA)

B. connecting a user process to a server process

C. returning the results of processing from the server process to the user process

D. verifying the service name in an incoming user request

E. maintaining the connection to a client's user process until the user request is completed

F. verifying a user's authentication credentials

A. qty_sold = `0554982' uses implicit conversion

B. qty_sold BETWEEN `101' AND '110' : uses implicit conversion

C. invoice_date = '15-march-2019' : uses implicit conversion

D. CONCAT (qty_sold, invoice_date) : requires explicit conversion

E. invoie_date > '01-02-2019' : uses implicit conversion

A. The same port number can be used for multiple Database Express configurations for multiple databases on the same host

B. It can be used to perform database recovery

C. The same port number can be used for Database Express configurations for databases on different hosts

D. It can be used to switch a database into ARCHIVELOGMODE

E. It is available only when the database is open

A. Usernames of all users including database administrators are stored in the data dictionary

B. The data dictionary is created and maintained by the database administrator

C. Data dictionary views are created by joins of dictionary base tables and DBA-defined tables

D. Views with the same name but different prefixes, such as CDB, DBA, ALL and USER, reference the same base tables from the data dictionary

E. Base tables can be queried directly

F. It is owned by the SYSTEM user

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

B. 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

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

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

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

A. Undo segments can extend when a transaction fills the last extent of the undo segment

B. Undo segments have a minimum of three extents

C. Undo segments must be stored in a BIGFILE tablespace

D. Undo segments can wrap around to the first extent when a transaction fills the last extend of the undo segment

E. An undo segment may be used by multiple transactions simultaneously

F. Undo segments must be stored in a SMALLFILE tablespace

G. A single transaction may use multiple undo segments simultaneously

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

B. Source Routing requires the use of a name server

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. Connect Time Failover requires the use of Transparent Application Failover (TAF)

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