최신Oracle Database Administration I - 1Z1-082무료샘플문제

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

B. It can display multiple rows and columns

C. It can be accessed only by the SYS user

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

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

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

A. The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables

B. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax

C. The Oracle join syntax supports natural joins

D. The Oracle join syntax performs less well than the SQL:1999 compliant ANSI join syntax

E. The Oracle join syntax only supports right outer joins

F. The Oracle join syntax supports creation of a Cartesian product of two tables

G. The SQL:1999 compliant ANSI join syntax supports natural joins

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

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

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

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

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

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

A. A block header contains a row directory pointing to all rows in the block.

B. Row data is stored starting at the end of the block.

C. A data block header is of a fixed length.

D. An index block can contain row data.

E. A table block must always contain row data.

A. You can no longer monitor it

B. It terminates

C. It continues to run in the background

D. You can reattach to it and monitor it

E. It is paused and can be resumed

A. Roles can be created only by SYS or SYSTEM.

B. Roles containing object privileges can be created only by the object owner.

C. A role can be password-protected only if it has been granted system privileges.

D. A role can be granted to other roles.

E. All roles belong to the SYSTEM schema.

A. index organized tables

B. partitioned tables

C. clustered tables

D. external tables

E. temporary tables

F. heap organized tables

A. A table can have only one primary key but multiple foreign keys

B. A table can have only one primary key and one foreign key

C. Primary key and foreign key constraints can be defined at both the column and table level

D. Only the primary key can be defined at the column and table level

E. It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted

F. The foreign key columns and parent table primary key columns must have the same names

G. It is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted

A. A RAC database must have two or more instances.

B. A RAC database can have instances on separate servers.

C. Two RAC databases can share their instances.

D. A RAC database can have one Instance.

E. A RAC database must have three or more Instances.

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

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

C. It can be used to perform database recovery

D. It is available only when the database is open

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

A. Oracle Net Manager can be used to locally configure naming methods on a database server

B. Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target

C. Oracle Net Manager can be used to centrally configure listeners on any database server target

D. Enterprise Manager Cloud Control can be used to centrally configure listeners on any managed database server

E. The lsnrctl utility requires a listener.ora file to exist before it is started

F. The Oracle Net Configuration Assistant is only used when running the Oracle installer

A. A substitution variable prefixed with & always prompts only once for a value in a session.

B. A substitution variable used to prompt for a column name must be enclosed in double quotation marks.

C. A substitution variable used to prompt for a column name must be enclosed in single quotation marks.

D. A substitution variable can be used only in a select statement.

E. A substitution variable can be used with any clause in a select statement.

F. A substitution variable prefixed with to prompts only once for a value in a session unless it is set to undefined in the session

A. Rolling back to a SAVEPOINT can undo a TRUNCATE statement

B. A SAVEPOINT does not issue a COMMIT

C. Rolling back to a SAVEPOINT can undo a CREATE INDEX statement

D. Only one SAVEPOINT may be issued in a transaction

E. Rolling back to a SAVEPOINT can undo a DELETE statement

A. network interface card (NIC) failure

B. transaction failure

C. media failure

D. statement failure

E. user process failure