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

A. Uncommitted transactions will be rolled back after it completes.

B. Incremental backups can be used to roll forward the database while performing it.

C. Only RMAN backupsets can be used to restore a database as part of it.

D. It is possible only when the database is in MOUNT state

E. The database must have FLASHBACK enabled in order to perform it.

A. A full outer join returns matched and unmatched rows

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

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

D. An inner join returns matched rows

E. A full outer join must use Oracle syntax

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

A. Grant DBA to KING

B. Set OS_AUTHENT_PREFIX to OPS$

C. Unset REMOTE_LOGIN_PASSWORDFILE

D. Alter user KING to be IDENTIFIED EXTERNALLY

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

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

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

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

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

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

A. A compute node port can be enabled only if it is associated with an existing security rule.

B. New security rules can be defined to use only the TCP protocol but multiple port numbers.

C. The port used for HTTPS connections is enabled by default based on a predefined security rule.

D. A new database deployment on a compute node automatically enables a set of predefined security rules.

E. A security rule can restrict IP addresses that can connect to a database instance on a compute node.

A. db_cache_s:ze must be set to a size that is smaller than db_32k_cache_size.

B. d3_32k_cache_size should be set to a value greater than db_cache_size.

C. The /u02 file system must have at least lOOg space for the datafile.

D. The operating system must use a 32k block size.

E. db_32k_cache_size must be set to a value that can be accommodated in the SGA.

F. db_32r_cache_si2e must be less than db_ca=he_size.

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

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

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

D. The Oracle join syntax supports natural joins

E. The Oracle join syntax only supports right outer joins

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

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

A. A segment might have only one extent

B. The extents of a segment must always reside in the same datafile

C. A segment's blocks can be of different sizes

D. A segment can span multiple data files in some tablespaces

E. All tablespaces may have one or more data files

F. Segments can span multiple tablespaces

G. A smallfile tablespace might be bigger than a bigfile tablespace

A. NULLS are not ignored during duplicate checking

B. Duplicates are eliminated automatically by the UNION ALL operator

C. The names of columns selected in each SELECT statement must be identical

D. The output is sorted by the UNION ALL operator

E. The number of columns selected in each SELECT statement must be identical

A. the number of hours for which an account is locked after the configured number of login attempts has been reached

B. the ability to prevent a password from ever being reused

C. the maximum number of sessions permitted for a user before the account is locked

D. the number of password changes required within a period of time before a password can be reused

E. the maximum amount of CPU time allowed for a user's sessions before their account is locked

F. the number of days for which an account may be inactive before it is locked

G. the number of days for which an account is locked after the configured number of login attempts has been reached

A. Make certain that the database operates in automatic undo management mode

B. Add the SEGMENT SPACE MANAGEMENT AUTO clause

C. Add the ONLINE clause

D. Set UNDO_TABLESPACE to UNDOTBS01

E. Add the NOLOGGING clause