Oracle 1Z0-082 問題集

質問 1：
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 ONLINE clause
B. Add the SEGMENT SPACE MANAGEMENT AUTO clause
C. Add the NOLOGGING clause
D. Make certain that the database operates in automatic undo management mode
E. Set UNDO_TABLESPACE to UNDOTBS01
正解：D,E

質問 2：
Examine the description of the BOOKS table:

The table has 100 rows.
Examine this sequence of statements issued in a new session:
INSERT INTO books VALUES ('ADV112', 'Adventures of Tom Sawyer', NULL, NULL); SAVEPOINT a; DELETE FROM books; ROLLBACK TO SAVEPOINT a; ROLLBACK; Which two statements are true? (Choose two.)
A. The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed
B. The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row
C. The second ROLLBACK command replays the delete
D. The second ROLLBACK command does nothing
E. The second ROLLBACK command undoes the insert
正解：A,E

質問 3：
Examine this description of the TRANSACTIONS table:

Which two SQL statements execute successfully? (Choose two.)
A. SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM transactions;
B. SELECT customer_id AS 'CUSTOMER-ID', transaction_date AS DATE, amount + 100 'DUES AMOUNT' FROM transactions;
C. SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount + 100 DUES FROM transactions;
D. SELECT customer_id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount + 100 "DUES AMOUNT" FROM transactions;
E. SELECT customer_id AS "CUSTOMER-ID", transaction_date AS DATE, amount + 100 "DUES" FROM transactions;
正解：A,C

質問 4：
Which two statements are true about UNDO and REDO? (Choose two.)
A. DML modifies Oracle database objects and only generates REDO
B. The generation of REDO generates UNDO
C. DML modifies Oracle database objects and only generates UNDO
D. DML modifies Oracle database objects and generates UNDO and REDO
E. The generation of UNDO generates REDO
正解：D,E
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which two statements are true regarding Oracle database space management within blocks managed by Automatic Segment Space Management (ASSM)? (Choose two.)
A. ASSM assigns blocks to one of four fullness categories based on what percentage of the block is allocated for rows
B. Insert operations always attempt to find blocks with free space appropriate to the length of the row being inserted
C. PCTFREE defaults to 10% for all blocks in all segments for all compression methods
D. A block will always be eligible for inserts if the row is short enough to fit into the block
E. Update operations always attempt to find blocks with free space appropriate to the length of the row being updated
正解：D,E

質問 6：
Which three statements are true about the Automatic Diagnostic Repository (ADR)?
A. The ADR base is specified In the diagnostic_dest database parameter.
B. It is only used for Oracle Database diagnostic information.
C. It is a file-based repository held outside any database.
D. It can be used for problem diagnosis of a database when that database's instance is down.
E. It Is held Inside an Oracle database schema.
正解：A,C,E

質問 7：
Which three activities are recorded in the database alert log? (Choose three.)
A. Data Definition Language (DDL) statements
B. deadlock errors
C. block corruption errors
D. session logins and logouts
E. non-default database parameters
正解：B,C,E