최신 1z0-497 무료덤프 - Oracle Database 12c Essentials

문제1

Which two statements are true when you execute an invoker's rights procedure?

A. The calling user must grant the INHERIT PRIVILEGES object privilege on the user owner of the procedure.

B. The owner must have the INHERIT PRIVILEGES object privilege on the invoking user, or the INHERIT ANY PRIVILEGES privilege.

C. Invoking users can control who can access their privileges when they run an invoker's rights procedure.

D. The calling user must be granted the INHERIT PRIVILEGES object privilege on the user owner of the procedure.

정답: B,C

설명: (DumpTOP 회원만 볼 수 있음)

문제2

You need to recover a database running In NOARCHIVELOG mode. Which two statements are true in this scenario?

A. You can perform complete recovery by using the command:
RESTORE DATABASE
FROM TAG"consistent_whole_backup";
RECOVER DATABASE;

B. You can perform incomplete recovery by using the command:
RESTORE DATABASE;
FROM TAG "consistent_whole_backup";
RECOVER DATABASE NOREDO;

C. Only consistent backups can be used for restoring a database in NOARCHIVELOG mode.

D. Media recovery is possible in most cases.

정답: B,C

설명: (DumpTOP 회원만 볼 수 있음)

문제3

For which database operation do you need the database to be in MOUNT state?

A. dropping a tablespace in your database

B. renaming the control files

C. dropping a user in your database

D. re-creating the control files

E. configuring the database instance to operate in ARCHIVELOG or NOARCHIVELOG mode

정답: E

설명: (DumpTOP 회원만 볼 수 있음)

문제4

Which two statements describe data dictionary views?

A. The VSFIXED_TABLEview can be queried to list the names of these views.

B. They are owned by the SYS user.

C. They are stored in the SYSTEM tablespace.

D. They speed up query and data manipulation language (DML) operations.

E. They are based on virtual tables.

정답: B,C

문제5

What happens if you execute these SQL statements?
SQL> show con_name
CON_NAME
CDB$ROOT
SQL> create user 1_freed identified by y container=current;

A. A local user is created in all the PDBs.

B. The second SQL statement fails because a local user cannot be created in the root container.

C. A common user is created in the root container.

D. A local user is created in the root container.

정답: B

문제6

Examine the output:
SQL> SELECT index_name, status FROM dba_indexes WHEREstatus='UNUSABLE';
INDEX_NAME STATUS
EIND UNUSABLE
Which two statements about this index are true?

A. The index cannot be rebuilt, and has to be re-created.

B. It is ignored by the query optimizer.

C. It is not used while the index is being rebuilt.

D. The index is automatically rebuilt when used the next time.

정답: B,C

설명: (DumpTOP 회원만 볼 수 있음)

문제7

Your customer is looking for zero-data-loss failover with maximum data protection and high availability for their primary database. Which two solutions would you recommend to the customer if the distance between the primary and the standby location is more than 300 miles?

A. Data Guard SQL Apply

B. Asynchronous redo transport with Data Guard

C. Active Data Guard Far Sync

D. Synchronous redo transport with Data Guard

정답: A,D

설명: (DumpTOP 회원만 볼 수 있음)

문제8

Identify two solutions that Oracle provides for patch conflict.

A. combine patch

B. merge patch

C. dual patch

D. overlay patch

E. super patch

정답: B,D

문제9

You are about to install Oracle Database 12c Enterprise Edition. Which statement is true?

A. You should not install the Oracle Database software into an existing Oracle home from a different release.

B. Oracle recommends that you back up the root. sh script after you complete the installation.

C. You can stop existing Oracle processes, including the listener and the database running in the Oracle home, before the database software installation.

D. Cloning an Oracle home is useful if you are performing multiple Oracle Database Installations.

E. A multitenant container database (CDB) can have several pluggable databases (PDBs) with different character sets.

정답: E

문제10

Which two statements about Database Express are true?

A. It has background tasks and processes that periodically collect information via FTP.

B. It can perform actions outside the database.

C. It uses internal infrastructure components, such as XDB and SQL*Net.

D. It has two new features: Performance Hub and Composite Active Reports.

E. It is not supported on Standard Edition (SE) and Express Edition (XE).

정답: C,D

설명: (DumpTOP 회원만 볼 수 있음)

최신 1z0-497 무료덤프 - Oracle Database 12c Essentials

우리와 연락하기

유용한 링크

최신 업데이트