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

出題：1

Which three statements are true about inner and outer joins? (Choose three.)

A. A left or right outer join returns only unmatched rows

B. Outer joins can be used when there are multiple join conditions on two tables

C. Outer joins can only be used between two tables per query

D. An inner join returns matched rows

E. A full outer join returns matched and unmatched rows

F. A full outer join must use Oracle syntax

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

出題：2

You want to use table compression suitable for OLTP that will:
Compress rows for all DML statements on that table
Minimize the overheads associated with compression
Which compression option is best suited for this?

A. COLUMN STORE COMPRESS FOR QUERY LOW

B. ROW STORE COMPRESS BASIC

C. ROW STORE COMPRESS ADVANCED

D. COLUMN STORE COMPRESS FOR ARCHIVE LOW

E. COLUMN STORE COMPRESS FOR ARCHIVE HIGH

正解：C 解答を投票する

出題：3

Examine this command and some partial output:

Why does the DB01.abc.com service show unknown status?

A. The LOCAL_LISTENER database parameter is not set to a service name that refers to LISTENER_1

B. The listener is not listening on the default port 1521

C. The service DB01.abc.com is statically registered

D. The service DB01.abc.com is dynamically registered

E. The SID_LIST_LISTENER section is not contained in the LISTENER.ORA file

正解：C 解答を投票する

出題：4

You start your database instance in NOMOUNT state. Which two actions are performed?

A. The control files are opened.

B. SYS can access the database.

C. All required background processes are started.

D. The consistency of the database is checked.

E. Memory is allocated for the SG1

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

出題：5

Which three statements are true about the naming methods and their features supported by Oracle database used to resolve connection information?

A. Directory Naming requires setting the TNS_ADMIN environment variable on the client side.

B. Local naming can be used if Connect-Time Failover Is required.

C. A client can connect to an Oracle database instance even If no client side network admin has been configured.

D. Easy Connect supports TCP/IP and SSL.

E. Directory Naming can be used if Connect-Time Failover is required.

F. Local Naming requires setting the TNS_ADMIN environment variable on the client side.

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

出題：6

Examine the description of the EMPLOYEES table:

Which query is valid?

A. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id;

B. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id, join_date;

C. SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id;

D. SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id;

正解：B 解答を投票する

出題：7

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. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space.

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. Add the AUTOEXTEND ON clause with NEXT set to 100M.

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

出題：8

Which two statements are true about the configuration and use of UNDO_RETENTION with GURANTEED RETENTION? (Choose two.)

A. Active UNDO is always retained.

B. UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unexpired UNDO.

C. Unexpired UNDO is always retained.

D. UNDO_RETENTION specifies for how long Oracle attempts to keep unexpired UNDO.

E. UNDO_RETENTION specifies how long all types of UNDO are retained.

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

出題：9

Which three statements are true about external tables in Oracle 18c and later releases? (Choose three.)

A. The ORACLE_DATAPUMP access driver can be used to load data into a database from an external table

B. External table files can be used for other external tables in a different database

C. They support UPDATEs but not INSERTs and DELETEs

D. The ORACLE_LOADER access driver can be used to unload data from a database into an external table

E. They cannot be partitioned

F. The ORACLE_DATAPUMP access driver can be used to unload data from a database into an external table

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

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

出題：10

Your database instance is started with a PFILE.
Examine these parameters:

You want to increase the size of the buffer cache.
Free memory is available to increase the size of the buffer cache.
You execute the command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;
What is the outcome?

A. The value is changed only in the PFILE and takes effect at the next instance startup

B. Change is applied to the current instance, but does not persist after instance restart

C. The value is changed for the current instance and in the PFILE

D. It fails because the SCOPE clause is missing

正解：B 解答を投票する

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