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

문제1

Which logical storage relationship is correct?

A. Tablespace< Extent < Segment < Oracle Datablock

B. B) Segment < Extent < Oracle Datablock<Tablespace

C. Tablespace< Segment < Extent < Oracle Datablock

D. Data File <Tablespace< Segment < Extent < Oracle Datablock

정답: C

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

문제2

Which two statements are true about a buffer cache?

A. When a buffer is read from a buffer cache, it may be inconsistent and require undo data to make it consistent.

B. A buffer cache always resides completely in System Global Area (SGA).

C. A buffer cache stores copies of data blocks from all files of the database.

D. Buffer access is kept efficient by maintaining a least recently used (LRU) list for dirty and clean buffers.

E. A buffer cache contains exactly three pools: default, keep, and recycle pool.

정답: A,E

문제3

Which two statements are true about transactions in Oracle Database 12c?

A. Multiple transactions can use the same undo segment.

B. A transaction is assigned an undo segment when it is started.

C. Multiple transactions cannot share the same extent in an undo tablespace.

D. If all the segments in an undo tablespace are used, transactions use system undo segments to store undo data.

정답: A,B

문제4

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

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

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

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

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

정답: A

문제5

The session of user SCOTT receives the following error after executing an UPDATE command on the EMP table:
ERROR at line 1:
ORA-00060: deadlock detected while waiting for resource
You find out that a session opened by user JIM has a transaction that caused the deadlock. Which two statements are true about SCOTT's session in this scenario?

A. SCOTT has to re-execute the last command in the transaction after he commits the transaction.

B. SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.

C. The session is rolled back after receiving the error and JIM can continue with his transaction.

D. The session is terminated after receiving the error and JIM can continue with his transaction.

정답: A,B

문제6

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

A. It runs every 1 hour automatically.

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

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

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

정답: C

문제7

Examine the table: Table name: PRODUCTS
Schema: SCOTT
Tablespace: USERS
Organization: Standard (Heap Organized)
This table contains 20 rows. In the data that has been entered, the PROD_ID column contains only single-digit values, PROD_NAME has a maximum of five characters, and PROD_RATE has four-digit values for all rows.
Which two statements are true regarding the modifications that can be performed to the structure of the PRODUCTS table?

A. PROD_RATE size can be changed from NUMBER(4) to NUMBER(6, 2).

B. PROD_ID can be changed from CHAR to NUMBER data type.

C. None of the existing columns can be dropped because they contain data.

D. New columns can be added only if they have a NOT NULL constraint.

E. PROD_NAME size can be increased from five to 10 characters.

정답: A,E

문제8

Which three options correctly match environment variables with their specific functionality?

A. ORACLE_SID specifies the instance name.

B. ORACLE_BASE specifies the root of the Oracle Database directory tree in all platforms.

C. ORACLE_HOME specifies the directory containing only the Oracle software executables, but not the network files.

D. ORACLE_BASE specifies the root of the Oracle Database directory tree only in UNIX and Linux platforms.

E. ORACLE_HOME specifies the directory containing the Oracle software executables and network files.

F. ORACLE_SID specifies the global database name.

정답: A,B,E

문제9

Your database is down. You log in as the SYS user and issue this command:
SQL> STARTUP
What happens after the instance is started?

A. Nothing else happens.

B. The database is mounted but not opened.

C. The database is mounted and finally opened.

D. The database is opened and finally mounted.

정답: C

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

문제10

Which three events signal a database writer (DWR) to write buffers to disk?

A. The redo log buffer becomes full.

B. The database advances a checkpoint.

C. A client process commits a transaction.

D. A tablespace is changed to read-only status.

E. A server process cannot find non-dirty blocks after scanning a threshold number of buffers.

F. The database is shut down in immediate mode.

정답: B,E,F

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

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

우리와 연락하기

유용한 링크

최신 업데이트