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

出題：1

When executing shutdown abort in a pluggable database (PDB), you ____________.

A. shut down immediate the PDB

B. shut down abort the PDB

C. shut down abort the CDB

D. shut down immediate the CDB

正解：A 解答を投票する

出題：2

Identify three outcomes of using the Oracle Multitenant option in Oracle Database 12c.

A. less instance overhead

B. isolation

C. same time needed for patching and upgrade as in the previous release

D. fast and easy provisioning

E. minor application changes

F. increased storage cost

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

出題：3

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 common user is created in the root container.

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

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

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

正解：C 解答を投票する

出題：4

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 メンバーにのみ表示されます)

出題：5

Your database instance is running. db01 is a net service name. You issue a connection request by using the command:
SQL> CONNECT scott/tiger@db01
Which component receives the request and establishes the appropriate connection?

A. listener

B. server process

C. service name

D. user process

正解：A 解答を投票する

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

出題：6

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_NAME size can be increased from five to 10 characters.

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_RATE size can be changed from NUMBER(4) to NUMBER(6, 2).

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

出題：7

Examine the command below:
LSNRCTL> SERVICES LISTENER2
Connecting to (DESCRIPTION=(ADDRESS= (PROTOCOL=TCP) (HOST=estb. us. abc.com) (PORT=1525)))
Services Summary. . .
Service "orcl.oracle.com" has 1 instance(s).
Instance "oracle", status UNKNOWN, has 1 handler(s) for this service... Handler(s):
"DEDICATED" established:2 refused:0 LOCAL SERVER The command completed successfully
Which two statements are true about LISTENER2?

A. The number of current client connections handled by the service handler is two.

B. The ORCL instance is registered dynamically with the listener.

C. The ORCL instance is registered statically in the listener.ora file.

D. The total number of client connections handled so far by the service handler is two.

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

出題：8

Your customer has two CDBs: one for Production and one for development. You are asked to create a new development PDB (salesdev) from an existing production PDB (salesprd). Which two options would accomplish this?

A. You alter the salesprd source database to open in read-only mode, and start cloning the source
database:
SQL> ALTER PLUGGABLE DATABASE salesprd OPEN READ ONLY;
SQL> CREATE PLUGGABLE DATABASE salesdev FROM salesprd;

B. Connected as the salesprd local DBA, you create an XML using:
SQL> ALTER PLUGGABLE DATABASE salespdb UNPLUG INTO ' /tmp/salesprd-xml' ;
Copy the XML file and all salesprd-related files to the target CDB and start plugging the copy into
the development CDB using:
SQL> CREATE PLUGGABLE DATABASE salesdev USING' /tmp/salesprd.xml';

C. You copy all the PDBSSEEDdata files from the production CDB into the development CDB and
execute this on the development CDB;
SQL> CREATE PLUGGABLE DATABASE salesdev ADMIN USER salesdm IDENTIFIED by
password;

D. You alter the salesprd source database to open in read-only mode:
SQL> ALTER PLUGGABLE DATABASE salesprd OPEN READ ONLY;
In the development CDB, you create a databaselink "PRD" that connects to the root of the source
CDB, and start cloning the source PDB:
SQL> CREATE PLUGGABLE DATABASE salesdevFROM salesprd@prd;

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

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

出題：9

Which statement about Oracle patches is false?

A. Patch Set is the main way in which Oracle provides bug fixes in between releases. Oracle bundles a number of fixes, tests them thoroughly together, and packages, then together for easy download and installation.

B. Patch Set Update (PSU) is a collection of proactive, stabilizing, cumulative patches for a particular product version (base release or patch set). PSUs are cumulative and include all the security fixes from CPU patches, plus additional fixes.

C. Terminal Patch Set is an unsupported patch set by Oracle Lifetime Support policies.

D. Security Patch Update (SPU) is the primary means of releasing security fixes for Oracle products. SPUs are cumulative with respect to prior SPUs and generally contain only security fixes.

E. Interim patches, also known as "one-off" patches, are created to provide a specific fix between the releases of patch sets.

正解：C 解答を投票する

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

出題：10

Which two statements correctly distinguish between undo and redo data?

A. Redo reverses a change, whereas undo re-creates a change.

B. Redo protects against inconsistent reads, whereas undo protects against data loss.

C. Undo protects against inconsistent reads, whereas redo protects against data loss.

D. Undo reverses a change, whereas redo re-creates a change.

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

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