[2026] Oracle Database 12c Essentials - 1z0-497 무료 시험 문제

문제1

Which statement is true about Enhanced Real-Time ADDM in Oracle Database 12c?

A. It is shipped only with Oracle Enterprise Manager 12c.

B. The analyzed result is lost when the database instance is restarted.

C. It runs every 1 hour automatically.

D. It analyzes high CPU trend and identifies problems before they can threaten application performance.

정답: D

문제2

In Oracle Database 12c, when does a transaction begin?

A. when the first executable SQL statement is encountered

B. when a user explicitly issues a "begin" statement

C. when a transaction is assigned to an available undo data segment to record undo entries for the new transaction

D. when a transaction ID is allocated for it.

정답: D

문제3

Examine the command:
sqlplus /nolog
In which scenario would this command execute successfully?

A. from either a client or server, only if the database instance is up, and the command connects the session to the instance

B. only from the server, if the database instance is not up

C. from either a client or server, only if the database instance is up, but the command does not connect the session to the instance

D. from either a client or server, even if the database instance is not up

정답: D

문제4

Examine the commands:
SQL> CONNECT sys@CDBl AS SYSDBA
$QL>STARTUP MOUNT
SQL> ALTER DATABASE cdbl MOUNT;
Which four options represent what happens when these commands are executed?

A. The root is mounted.

B. The PDBs are mounted, and opened in READ WRITE mode, while the seed is opened In READ ONLY mode.

C. The CDB control files are opened for the instance.

D. The PDBs are mounted, and the seed is opened in READ ONLY mode.

E. The instance is started.

F. The PDBs are mounted.

G. The root is opened.

정답: A,C,E,F

문제5

You are installing OracleDatabase 12c on a machine. When you run the installer; Oracle Universal installer (OUI) shows a message that says one of the product-specific prerequisite checks has failed:
Checking available swap space requirements...
Expected result: 1512MB
Actual Result: 1018MB
Check complete. The overall result of this check is: failed <<
Problem: The system does not have the required swap space.
What happens to the installation in this situation?

A. It shows a message saying one or more prerequisite checks have failed and the installation aborts.

B. It can be continued.

C. It resizes the swap space automatically when you proceed further.

D. It can be continued, but the instance cannot be started without increasing swap space.

정답: B

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

문제6

All database users are currently connected to the database instance and are working. The HR user opens three database sessions and executes this command in one of the sessions:
SQL> UPDATE persons SET ccode='U031' WHERE ccode='U029';
123 rows updated.
SQL> DELETE FROM persons WHERE exp='Y';
3 rows deleted.
The SYS user opens a new session after HR executes the preceding commands. Which option represents the sessions that can see the effect of the UPDATE and DELETE commands?

A. all sessions of the HR user and the SYS user

B. all sessions of the HR user

C. the session of the HR user that executed the commands

D. all sessions for which database users have access privileges to the PERSONS table

정답: C

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

Oracle Database 12c Essentials - 1z0-497무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트