最新的高品質 1Z1-082 考試練習題庫

Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION? (Choose two.)

• A. 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
• B. Each SELECT statement in the compound query can have its own ORDER BY clause
• C. Only column names from the first SELECT statement in the compound query are recognized
• D. Each SELECT statement in the compound query must have its own ORDER BY clause
• E. Column positions must be used in the ORDER BY clause

Examine this description of the books table containing 100 rows:

Now examine this sequence of statements Issued In a new session;

Examine this description of the books table containing 100 rows:
Which three statements are true?

• A. The first rollback command restores the 100 rows that were in the table originally.
• B. The second rollback command restores the 100 rows that were in the table originally.
• C. The second rollback command restores the row that was inserted.
• D. The first rollback command leaves the table's 100 original rows locked.
• E. The first rollback command leaves the inserted row locked.
• F. The first RollBack command restores the row that was inserted.
• G. The second rollback command rolls back the rollback to savepoint a command.

In one of your databases, user KING is:
1. Not a DBA user
2. An operating system (OS) user
Examine this command and its output:

What must you do so that KING is authenticated by the OS when connecting to the database instance?

• A. Set OS_AUTHENT_PREFIX to OPS$
• B. Alter user KING to be IDENTIFIED EXTERNALLY
• C. Grant DBA to KING
• D. Have the OS administrator add KING to the OSDBA group
• E. Unset REMOTE_LOGIN_PASSWORDFILE

Examine this command:
CREATE UNDO TABLESPACE undotbs01
DATAFILE `undotbs_01.dbf'
SIZE 100M
AUTOEXTEND ON;
Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.)

• A. Add the NOLOGGING clause
• B. Add the SEGMENT SPACE MANAGEMENT AUTO clause
• C. Add the ONLINE clause
• D. Set UNDO_TABLESPACE to UNDOTBS01
• E. Make certain that the database operates in automatic undo management mode

In one of your databases, you create a user, HR, and then execute this command:
GRANT CREATE SESSION TO hr WITH ADMIN OPTION;
Which three actions can HR perform? (Choose three.)

• A. Log in to the database instance
• B. Grant the CREATE SESSION privilege with ADMIN OPTION to other users
• C. Revoke the CREATE SESSION privilege from other users
• D. Execute DML statements in the HR schema
• E. Revoke the CREATE SESSION privilege from user HR
• F. Execute DDL statements in the HR schema