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

出題：1

In this SQL statement, what is the partitioning criteria?
CREATE TABLE books_part
PARTITION BY RANGE (cell_id) ( PARTITION p0l VALUES LESS THAN (2),
PARTITION p02 VALUES LESS THAN (3) ,
. . .
PARTITION pl4 VALUES LESS THAN (15),
PARTITION pl5 VALUES LESS THAN (16),
PARTITION pl6 VALUES LESS THAN (MAXVALUE)
)
AS SELECT * FROM books;

A. pxx

B. MAXVALUE

C. cell_id

D. There is no partitioning criteria.

E. books

正解：C 解答を投票する

出題：2

出題：3

Which three statements about replication options are true?

A. The Oracle GoldenGate software architecture is composed of three primary components: capture, propagate, and trail files.

B. Oracle Streams is deprecated in Oracle Database 12c Release 1.

C. The Oracle Streams information flow consists of three components: capture, redo transfer, arid consumption.

D. Oracle Database Advanced Queuing is independent of Oracle Streams.

E. Oracle Database Advanced Replication is deprecated in Oracle Database 12c Release 1, including multimaster replication, updatable materialized views, multitier materialized views, and deployment templates.

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

出題：4

To revoke unnecessary and unused privileges, you can use Privilege Analysis. Which sequence should you follow?
1 -Start the analysis.
2 - Set up the analysis policy type (database, role, context).
3 - Generate the results.
4 -View the results in DBA_USED_PRIVSand DBA_UNUSED_PRJVS.
5 - Stop the analysis.

A. 1, 2, 3, 4, 5

B. 2, 1, 5, 3, 4

C. 2, 3, I, 5, 4

D. 1, 2, 4, 5, 2

E. 5, 1, 2, 3, 4

正解：B 解答を投票する

出題：5

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

出題：6

You went to create a new CDB foe your customer. Which two statements are true about the seed pluggable database that will reside in the new CDB?

A. The seed pluggable database can be dropped.

B. The seed pluggable database is not required.

C. The seed pluggable database is not a container.

D. The seed pluggable database does not require data files.

E. You can use the new SEED FILE_NAME_CONVERTclause in the CREATE DATABASE statement.

F. You have to copy the seed data files yourself,

G. The seed pluggable database is always kept in READ ONLY mode.

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

出題：7

YOUR database crashes after a user accidentally kills a background process. What are three possible ways to restart your database?

A. S sqlplus / as sysdba SQL> startup immediate;

B. S srvctl start database -db SORACLE_SID

C. S sqlplus / as sysdba SQL> restart;

D. S sqlplus / as sysdba SQL> startup open recover;

E. S rman target / RMAN> Startup

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

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

出題：8

Examine the command:
SQL> CREATE TABLE orders(oid NUMBER (6) PRIMARY KEY, odato DATE, ccode NUMBER (6), oamt NUMBER (10, 2)) TABLESPACE users ;
Which two statements are true about the execution of the command?

A. A CHECK constraint is created on the OID column.

B. The ORDERS table is created in the USERS tablespace and a unique index is created on the OID column in the SYSTEM tablespace.

C. The ORDERS table is the only object created in the USERS tablespace.

D. The ORDERS table and a unique index are created in the USERS tablespace.

E. A NOT NULL constraint is created on the OID column.

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

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

出題：9

Several tables are accidentally deleted from a PDB. Which database would you immediately connect to, and as which user, to recover these tables?

A. the CDB as the CDBADMIN user

B. the PDB as the ROOT user

C. the PDB as the PDB Admin user

D. the CDB as the ROOT user

正解：C 解答を投票する

出題：10

Which is the default isolation level in Oracle Database 12c?

A. read uncommitted

B. serializable

C. read committed

D. read-only

正解：C 解答を投票する

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

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