1z1-497試験無料問題集（150題）「Oracle Database 12c Essentials 認定」

出題：1

Which three statements represent the benefits of multitenant architecture for database consolidation?

A. You can unplug a PDB from a development CDB and plug it into a production CDB, which allows for easier and more rapid movement of data and code.

B. In multitenant architecture, a PDB behaves the same as a non-CDB as seen from a client connecting with Oracle Net. No client modification is required.

C. You can consolidate shared database memory by combining multiple PDBs in a single CD

D. Patching individual PDBs requires the same amount of time as patching individual databases.

E. Consolidating separate databases into a single CDB requires the same amount of storage allocation.

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

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

出題：2

出題：3

Which process is responsible for writing the contents of database buffers to data files?

A. System Monitor process (SMON)

B. Listener Registration process (LREG)

C. Database Writer process (DBW)

D. Log Writer process (LGWR)

E. Process Monitor process (PMON)

F. Checkpoint process (CKPT)

正解：C 解答を投票する

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

出題：4

Your customer has three data centers in three different locations, location A has their production database running on Oracle Database 12c. They want to replicate the data from location A to location B.
which is 50 miles away and is used for disaster protection and database rolling upgrades. They also want to create a replica database at location C, which must be open in read-write mode, while synchronizing with the primary database.
Which two solutions would you recommend to your customer?

A. Oracle Active Data Guard

B. Oracle Advanced Replication

C. Oracle Streams

D. Oracle GoldenGate

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

出題：5

You are about to apply a patch to a database. Which recommended action is incorrect?

A. You should check the fifth digit of the release information to confirm that the Patch Set Update (PSU) is applied successfully.

B. You should stop all applications running from the software directory that is being patched.

C. You should install the latest O patch before applying the patch.

D. You should make sure that you have a good backup of the software, database, and configuration files.

E. You should check the patch conflict with installed patches before applying the patch.

正解：A 解答を投票する

出題：6

Exhibit below:

Which three statements are true about terminating a session?

A. Without any error, you can terminate the inactive session by executing:
SQL> ALTER SYSTEM KILL SESSION '12, 63';

B. You cannot terminate the active session. You have to wait until that session becomes inactive.

C. Without any error, you can terminate the active session by executing:
SQL> ALTER SYSTEM KILL SESSION '7, 15';

D. You cannot terminate the inactive session. You have to wait until that session becomes active
again.

E. When an inactive session is killed, the status of that session remains visible in VSSESSION
with status KILLED. The rowf the terminated session is removed from VSSESSION after the user
attempts to use the session again.

F. You can terminate the active session by executing:
SQL> ALTER SYSTEM KILL SESSION "7, 15';
But you also get the error message:
ORA-00028: your session has been killed

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

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

出題：7

Which two statements about Data Recovery Advisor are true?

A. Data Recovery Advisor cannot be used to diagnose and repair data corruptions in the root of a CD

B. Data Recovery Advisor can be used to diagnose and repair data corruptions in non-CDBs.

C. You can use the ADVISE FAILURE command to display repair options after running LIST FAILURE in an RMAN session.

D. Data Recovery Advisor can be used to diagnose and repair data corruptions in PDBs.

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

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

出題：8

You want to start a global service on your database. Which three conditions must be met?

A. The service has been disabled on that database.

B. The service has reached its cardinality defined by the number of preferred databases.

C. The database role is different from the role attribute of the service.

D. The database is open and registered with a global service manager.

E. No other database in the pool is a better candidate for starting the service.

F. The replication lag on the database does not exceed the maximum value specified for the service.

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

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

出題：9

Which two statements are true about listeners?

A. Listener-related errors can be traced only at the administrative level.

B. Multiple database instances can be registered with a single listener,

C. Multiple listener processes can run simultaneously on a host.

D. Listeners use only the TCP/IP protocol.

E. Only one database instance can be registered with a single listener at any time.

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

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

出題：10

Identify three key properties of a transaction in Oracle Database 12c.

A. manageability

B. scalability

C. isolation

D. concurrency

E. consistency

F. durability

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

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

1z1-497試験無料問題集「Oracle Database 12c Essentials 認定」