Oracle 1Z0-082 問題集

質問 1：
In which three situations does a new transaction always start? (Choose three.)
A. when issuing a DML statement after a DML statement failed in the same session
B. when issuing a CREATE TABLE statement after a SELECT statement was issued in the same session
C. when issuing a TRUNCATE statement after a SELECT statement was issued in the same session
D. when issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT statement was issued in the same session
E. when issuing a CREATE INDEX statement after a CREATE TABLE statement completed successfully in the same session
F. when issuing the first Data Manipulation Language (DML) statement after a COMMIT OR ROLLBACK statement was issued in the same session
正解：D,E,F
解説: (Topexam メンバーにのみ表示されます)

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

For customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed.
Which query should be used?
A. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level IS NOT NULLAND due_amount IS NOT NULL;
B. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level != NULLAND due_amount != NULL;
C. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level <> NULLAND due_amount <> NULL;
D. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level != NULLAND cust_credit_level !=NULL;
E. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level IS NOT NULLAND cust_credit_limit IS NOT NULL;
正解：E

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

質問 4：
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

質問 5：
The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.
Segment creation is not deferred.
You execute this command:

Which three statements must be true so that the SALES user can create tables in SALES_Q1? (Choose three.)
A. The sales user must have been granted the CREATE SESSION privilege
B. The sales user must have a quota on the TEMP tablespace
C. The sales user must have a quota on the SALES_Q1 tablespace to hold the initial extends of all tables they plan to create in their schema
D. The sales user must have been granted the CREATE TABLE privilege
E. The sales user must have their quota on the users tablespace removed
F. The sales user must have a quota on the SALES_Q1 tablespace to hold all the rows to be inserted into any table in their schema
正解：C,D,E

質問 6：
Examine the description of the CUSTOMERS table:

You want to display details of all customers who reside in cities starting with the letter D followed by at least two characters.
Which query can be used?
A. SELECT * FROM customers WHERE city LIKE 'D_%';
B. SELECT * FROM customers WHERE city = '%D_';
C. SELECT * FROM customers WHERE city LIKE 'D_';
D. SELECT * FROM customers WHERE city = 'D_%';
正解：A

質問 7：
Which two statements are true about the PMON background process? (Choose two.)
A. It registers database services with all local and remote listeners known to the database instance
B. It frees resources held by abnormally terminated processes
C. It kills sessions that exceed idle time
D. It records checkpoint information in the control file
E. It frees unused temporary segments
正解：B,C
解説: (Topexam メンバーにのみ表示されます)