1z1-072無料問題集「Oracle Database 12cR2 Administration」

質問 1

You execute this command to connect to an instance from a client on a different machine:
CONNECT username/password@net_service_name
No name servers are configured.
Which two are true about net_service_name? (Choose two.)

（A）It must have the same name as the SERVICE_NAME defined in it.

（B）It must be defined in the tnsnames.ora file on the server side.

（C）It must contain the address protocol for only one listener.

（D）It must contain only one address protocol for one listener.

（E）It must be defined in the tnsnames.ora file on the client side.

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

質問 2

Which two are true about users who are granted SYSDBA or SYSOPER privileges? (Choose two.)

（A）Only users granted SYSDBA can query or update tables in all user schemas.

（B）Users granted either SYSDBA or SYSOPER connect to an instance as SYS.

（C）Users granted either SYSDBA or SYSOPER can mount or open a database.

（D）Only users granted SYSDBA can start up and shut down a database instance.

（E）Users granted either SYSDBA or SYSOPER can query data in all user schemas.

（F）Only users granted SYSDBA can take a complete backup of a database.

正解：B、F 解答を投票する

質問 3

Which two tasks can you perform by using DBCA for a new database?

（A）Enable flashback.

（B）Create user tablespaces.

（C）Configure incremental backups.

（D）Configure a nonstandard block size.

（E）Register it with an available Enterprise Manager Management server.

正解：B、E 解答を投票する

質問 4

Which two statements are true about VSTABLESPACE and DBA_ TABLESPACE?

（A）VSTABLESPACE and DBA_ TABLESPACES are view based on base tables in the data dictionary.

（B）VSTABLESPACE cab be queries by all users, but DBA_ TABLESPACEs cab be queries only by SYSDBA users.

（C）VSTABLESPACE is a dynamic view that is populated with data from th DBA_ TABLESPACE dictionary view.

（D）VSTABLESPACE metadata is lost at shutdown, but DBA_ TABLESPACE metadata persists across shutdowns.

（E）VSTABLESPACE is a dynamic view that is populated with data from the DBA_ TABLESPACES data queried only when a database is open.

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

質問 5

Which two are true about RETENTION GUARANTEE? (Choose two.)

（A）It is a tablespace attribute.

（B）It is a static parameter.

（C）It prevents "Snapshot too old" errors.

（D）It prevents FLASHBACK DATABASE operation failure.

（E）It prevents out-of-space errors.

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

質問 6

The ORCL database has DEFERRED_SEGMENT_CREATION set to TRUE.
UNDOTBS2 is the active undo tablespace.
Examine these commands:

USER1 executes DML, which generates more than 2 MB of UNDO.
What is the result and why?

（A）It suspends the transaction, which can be resumed by increasing the size of UNDOTBS2.

（B）It suspends the transaction, which can be resumed by setting UNDOTBS1 as the active undo tablespace.

（C）It returns an error because UNDOTBS2 is fixed size.

（D）It suspends the transaction, which can be resumed by increasing USER1's quota on UNDOTBS2.

（E）It returns an error because UNDOTBS2 has RETENTION GUARANTEE.

（F）It returns an error because UNDOTBS2 is fixed size and has RETENTION GUARANTEE.

正解：C 解答を投票する

質問 7

The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different locations.
Each database has a tnsnames.ora file defining DALLAS_DB as a service name.
Examine this command:
CREATE DATABASE LINK dblink1 CONNECT TO scott IDENTIFIED BY tiger USING 'dallas_db'; How do you execute the command so that only SCOTT in BOSTON_DB can access the SCOTT schema in DALLAS_DB?

（A）as SCOTT in DALLAS_DB

（B）as SYS in both the databases

（C）as SCOTT in both the databases

（D）as SCOTT in BOSTON_DB and SYS in DALLAS_DB

（E）as SCOTT in BOSTON_DB

正解：C 解答を投票する

質問 8

A user complains about poor database performance. You suspect that the user's session is waiting for an event to complete.
You want to verify this.
Which two views may reveal for what the user's session is currently waiting? (Choose two.)

（A）V$SESSION_WAIT_CLASS

（B）V$SYSTEM_EVENT

（C）V$SESSION_EVENT

（D）V$SESSION

（E）V$SESSION_WAIT

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

質問 9

EMP_IDX is an index on the EMP.ENO column.
EMP and EMP_IDX reside in the TBS1 tablespace.
During an INSERT into EMP, you get this error:
ERROR at line 1:
ORA-01654: unable to extend index USERS.EMP_IDX BY 8 in tablespace TBS1 Which two actions would you take to correct the space problem in TBS1 without affecting uncommitted transactions on EMP? (Choose two.)

（A）Coalesce EMP_IDX.

（B）Rebuild EMP_IDX online in a tablespace with sufficient space.

（C）Shrink TBS1.

（D）Shrink EMP.

（E）Drop and re-create EMP_IDX.

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

1z1-072 無料問題集「Oracle Database 12cR2 Administration」

弊社を連絡する

関連リンク

トップ試験