1Z0-082試験無料問題集（145題）「Oracle Database Administration I 認定」

出題：1

Which three statements are true about the Automatic Diagnostic Repository (ADR)?

A. It Is held Inside an Oracle database schema.

B. The ADR base is specified In the diagnostic_dest database parameter.

C. It can be used for problem diagnosis of a database when that database's instance is down.

D. It is only used for Oracle Database diagnostic information.

E. It is a file-based repository held outside any database.

正解：A,B,E 解答を投票する

出題：2

Which three statements are true about the Oracle join and ANSI join syntax? (Choose three.)

A. The Oracle join syntax supports natural joins

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

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

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

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

F. The Oracle join syntax only supports right outer joins

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

正解：D,E,G 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：3

Examine this command:

Which two statements are true? (Choose two.)

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

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

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

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

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

正解：C,E 解答を投票する

出題：4

Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)

A. A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.

B. A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.

C. GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.

D. Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.

E. A GLOBAL TEMPORARY TABLE'S definition is available to multiple sessions.

F. GLOBAL TEMPORARY TABLE space allocation occurs at session start.

正解：B,D,E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：5

Table ORDER_ITEMS contains columns ORDER_ID, UNIT_PRICE and QUANTITY, of data type NUMBER.
Examine these SQL statements:
Statement 1:
SELECT MAX(unit_price * quantity) "Maximum Order"
FROM order_items;
Statement 2:
SELECT MAX(unit_price * quantity) "Maximum Order"
FROM order_items
GROUP BY order_id;
Which two statements are true?

A. Statement 1 returns only one row of output.

B. Both statements will return NULL if either UNIT_PRICE or QUANTITY contains NULL.

C. Statement 2 returns only one row of output.

D. Both the statements give the same output.

E. Statement 2 may return multiple rows of output.

正解：A,E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：6

You need to calculate the number of days from 1st January 2019 until today.
Dates are stored in the default format of DD-MON-RR.
Which two queries give the required output? (Choose two.)

A. SELECT SYSDATE - TO_DATE('01-JANUARY-2019') FROM DUAL;

B. SELECT TO_DATE(SYSDATE, 'DD/MONTH/YYYY') - '01/JANUARY/2019' FROM DUAL;

C. SELECT ROUND(SYSDATE - TO_DATE('01/JANUARY/2019')) FROM DUAL;

D. SELECT ROUND(SYSDATE - '01-JAN-2019') FROM DUAL;

E. SELECT TO_CHAR(SYSDATE,'DD-MON-YYYY') - '01-JAN-2019' FROM DUAL;

正解：A,C 解答を投票する

出題：7

Examine this description of the TRANSACTIONS table:

Which two SQL statements execute successfully? (Choose two.)

A. SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount + 100 DUES FROM transactions;

B. SELECT customer_id AS "CUSTOMER-ID", transaction_date AS DATE, amount + 100 "DUES" FROM transactions;

C. SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM transactions;

D. SELECT customer_id AS 'CUSTOMER-ID', transaction_date AS DATE, amount + 100 'DUES AMOUNT' FROM transactions;

E. SELECT customer_id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount + 100 "DUES AMOUNT" FROM transactions;

正解：A,C 解答を投票する

出題：8

In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1.
The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains:

Which statement is true?

A. LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration

B. The LREG process registers services dynamically with the LISTENER_1 listener

C. The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration

D. There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances

E. Dynamic service registration cannot be used for this database instance

正解：B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：9

Examine the description of the BOOKS_TRANSACTIONS table:

A. WHERE borrowed_date = SYSDATE AND (transaction_type = 'RM* OR member_id IN ('A101', 'A102'));

B. WHERE borrowed_date = SYSDATE AND {transaction_type = 'RM* AND (raeraber_id = 'A101' OR member_id = 'A102));

C. WHERE borrowed_date = SYSDATE AND (transaction_ype = 'RM' AND .-neraber_id = 'A101' OR member_id = 'A102');

D. WHERE borrowed_date = SYSDATE AND transaction_type = 'RM*) OR member_id IN ('A101', 'A102');

正解：A,D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：10

You execute this command:

Sufficient storage is available in filesystem /u01.
Which two statements are true about the BIG_TBS tablespace? (Choose two.)

A. AUTOEXTEND is possible for the datafile

B. Additional data files may not be added

C. It will always have a 32K blocksize

D. It must be bigger than the largest SMALLFILE tablespace

E. It will be a dictionary-managed tablespace by default

正解：A,B 解答を投票する

1Z0-082試験無料問題集「Oracle Database Administration I 認定」