Oracle 1Z0-082 問題集

質問 1：
In your data center, Oracle Managed Files (OMF) is used for all databases.
All tablespaces are smallfile tablespaces.
SALES_Q1 is a permanent user-defined tablespace in the SALES database.
Examine this command which is about to be issued by a DBA logged in to the SALES database:
ALTER TABLESPACE sales_q1 ADD DATAFILE;
Which are two actions, either one of which you could take to ensure that the command executes successfully? (Choose two.)
A. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify with at least 50 Mb of available space.
B. Add the AUTOEXTEND ON clause with NEXT set to 100M.
C. Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space.
D. Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb of available space.
E. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space.
正解：C,D

質問 2：
Which three statements are true about inner and outer joins? (Choose three.)
A. A left or right outer join returns only unmatched rows
B. A full outer join must use Oracle syntax
C. A full outer join returns matched and unmatched rows
D. Outer joins can only be used between two tables per query
E. Outer joins can be used when there are multiple join conditions on two tables
F. An inner join returns matched rows
正解：A,C,F

質問 3：
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 メンバーにのみ表示されます)

質問 4：
Examine the description of the PRODUCT_STATUS table:

The status column contains the values 'in stock' or 'out of stock' for each row.
Which two queries will execute successfully?
A. SELECT prod_id "CURRENT AVAILABILITY" II q'<'s not available)' FROM product_status WHERE status = 'OUT OF STOCK
B. SELECT prod_id Il q"'s not available" FROM product_status where status = 'OUT OF STOCK';
C. SELECT prod_id I I q' (*s not available)' "CURRENT AVAILABILITY" FROM product_status WHERE status = 'OUT OF STOCK
D. SELECT prod_id I I q' ('s not available) * 'CURRENT AVAILABILITY' FROM product_status WHERE status = 'OUT OF STOCK
E. SELECT prod_id q's not available" FROM product_status WHERE status = 'OUT OF STOCK*;
F. SELECT prod_id II q'l's not available)' FROM product_status WHERE status = 'OUT OF STOCK';
正解：C,F

質問 5：
You execute this query:
SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), 'MON'), 'dd "Monday for" fmMonth rrrr') What is the result?
A. It executes successfully but does not return any result
B. It generates an error
C. It returns the date for the first Monday of the next month
D. It returns the date for the last Monday of the current month
正解：C

質問 6：
Which two statements are true about views used for viewing tablespace and datafile information? (Choose two.)
A. Tablespace free space can be viewed in DBA_TABLESPACES
B. Tablespace free space can be viewed in V$TABLESPACE
C. V$TABLESPACE displays information about tablespaces contained in the data dictionary
D. V$TABLESPACE displays information that is contained in the controlfile about tablespaces
E. A datafile can be renamed when the database is in MOUNT state and the new file name is displayed when querying DBA_DATA_FILES after the database is opened
正解：D,E

質問 7：
Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)
A. Reversing the order of the intersected tables can sometimes affect the output
B. INTERSECT ignores NULLs
C. Column names in each SELECT in the compound query can be different
D. The number of columns in each SELECT in the compound query can be different
E. INTERSECT returns rows common to both sides of the compound query
正解：C,E
解説: (Topexam メンバーにのみ表示されます)