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

A. You can shut down a database instance using EM Express.

B. You can use a single instance of EM Express to manage multiple database running on the same server.

C. You cannot start up a database instance using EM Express.

D. EM Express uses a separate repository database to store target database metadata.

E. By default, EM express is available for a database after database creation using DBCA.

A. Compressed objects in SALES01.DBF will be uncompressed In SALES02.DBF after the move.

B. The "to" clause containing the new file name must be specified even if Oracle Managed Files (OMF) is used.

C. Tables with one or more extents in this data file may be queried during the execution of this command.

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

E. It overwrites any existing file with the name SALES02.DBF.dbf in /u02 by default.

A. It is owned by the sys user.

B. It is owned by the system user.

C. All data dictionary view joins base tables to dynamic performance views.

D. Data dictionary views are always created with queries that join two or more base tables.

E. Data dictionary base tables can be queried directly.

A. It must be the name of the database to whose instance HR wishes to connect

B. It must be the name of the server running the database to whose instance HR wishes to connect

C. It must resolve to a valid connect descriptor in the client's tnsnames.ora file

D. It must resolve to a valid connect descriptor in the server's tnsnames.ora file

E. It must be the value of the SERVICE_NAMES parameter on the client side

A. transaction failure

B. user process failure

C. network interface card (NIC) failure

D. media failure

E. statement failure

A. The command succeeds and HR will be connected to the orcl and abc.sql databases

B. The command succeeds and HR will be connected to the orcl database instance, and the abc.sql script will be executed

C. The command fails and reports an error because @ is used twice

D. The command fails because the script must refer to the full path name

A. after successfully executing a commit or rollback followed by a DML statement

B. after successfully executing a create table statement followed by a create index statement

C. after successfully executing a truncate statement followed by a DML statement

D. after successfully executing a DML statement following a failed DML statement

E. after successfully executing a commit or rollback followed by a select statement

F. after successfully executing a create table as select statement followed by a select for update statement

A. It can execute in parallel.

B. It can export data into sequential media, such as tapes.

C. It makes use of client system resources.

D. It represents database metadata information as DDL statements in the dump file.

E. It can restart failed export jobs.

A. in the SPFILE, SPFILE, and memory

B. only in memory

C. only In the SPFILE

D. in the SPFILE and SPFILEc

E. in the SPFILE and in memory

A. It can optimize only SELECT statements.

B. It will only generate SQL Plan Directives specific to a given SQL statement.

C. It can re-optimize execution plans after previous executions detect suboptimal plans.

D. It determines the optimal table join order and method.

E. It updates stale object statistics in the Data Dictionary.

F. It generates execution plans for SQL statements based on relevant schema objects, system and session parameters, and information found in the Data Dictionary.

A. It displays all constraints that are defined for each column

B. It displays the NOT NULL constraint for any columns that have that constraint

C. It can be used only from SQL*Plus

D. It can be used to display the structure of an existing view

E. It displays the PRIMARY KEY constraint for any column or columns that have that constraint

F. It can be used from SQL Developer

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

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

C. A full outer join must use Oracle syntax

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

E. An inner join returns matched rows

F. A full outer join returns matched and unmatched rows

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 number, but not names, of columns must be identical for all SELECT statements in the 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 exactly match the data type of the corresponding column returned by the first query.

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

A. It frees resources held by abnormally terminated processes

B. It kills sessions that exceed idle time

C. It records checkpoint information in the control file

D. It frees unused temporary segments

E. It registers database services with all local and remote listeners known to the database instance