学習スタイルは人それぞれです。GoShikenでは1z1-497対策として、印刷して使えるPDF版、本番環境を再現するデスクトップテストエンジン、ブラウザで手軽に取り組めるオンラインテストエンジンの3つの形式で、Oracle Database 12c Essentialsの練習問題150問をご用意しています。

Oracle 1z1-497 試験概要:

Oracle 1z1-497 試験シラバストピック:

1z1-497受験者からよく寄せられる質問

Oracle Database 12c Essentials 認定 1z1-497 試験問題：

問題 #1

Which three tasks can you perform in Database Express?

A. Manage users and security.
B. Start up the database.
C. Shut down the database.
D. Create database structures.
E. View performance and status information about the database instance.

問題 #2

You execute the following command:
SQL> ALTER USER skd ACCOUNT LOCK;
Which two statements are correct?

A. Other users can access objects owned by the SKD user, to which they have access.
B. The objects owned by the SKD user are not accessible to any user.
C. The SKD user's password expires and the user is forced to change the password at the next login.
D. The SKD user cannot log in to the database instance.

問題 #3

Which two statements about switchover and failover are true?

A. A snapshot standby can be the target of a switchover or fast-start failover operation.
B. You can activate a standby database to test whether it is being updated correctly.
C. For fast-start failover, you must preselect the target standby database that will be used.
D. Neither a switchover nor a failover is possible to a far sync instance.

問題 #4

A standby database is in mounted state and you are required to perform a failover to the physical standby. Which solution is best suited forthis scenario?

A. ALTER DATABASE PREPARE TO SWITCHOVER and ALTER DATABASE COMMIT TO SWITCHOVER statements
B. ALTER DATABASE RECOVER MANAGED STANDBY DATABASE statement with the FINISH keyword
C. ALTER DATABASE RECOVER TO STANDBY DATABASE statement with the FINISH keyword
D. D) ALTER DATABASE PREPARE SWITCHOVER and ALTER DATABASE COMMIT TO SWITCHOVER Statements

問題 #5

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.

解説：