Oracle 1z0-497 問題集

質問 1：
Identify three key properties of a transaction in Oracle Database 12c.
A. concurrency
B. manageability
C. scalability
D. isolation
E. consistency
F. durability
正解：D,E,F
解説: (Topexam メンバーにのみ表示されます)

質問 2：
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. The ORDERS table is created in the USERS tablespace and a unique index is created on the OID column in the SYSTEM tablespace.
B. The ORDERS table is the only object created in the USERS tablespace.
C. The ORDERS table and a unique index are created in the USERS tablespace.
D. A NOT NULL constraint is created on the OID column.
E. A CHECK constraint is created on the OID column.
正解：C,D
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Which two statements represent where Oracle Net must reside?
A. On both the client and database server for traditional client/server applications.
B. Only on the client for traditional client/server applications
C. Only on the database server for web-based applications
D. On both the web server and database server for web-based applications
正解：A,C

質問 4：
Which two statements about multitenant architecture are true?
A. It allows central management and administration of single databases.
B. It is integrated with Enterprise Manager, but not with the Resource Manager.
C. It ensures full backward compatibility with non-CDBs.
D. It fully operates with RAC.
正解：A,B

質問 5：
You execute the following command:
SQL> ALTER USER skd ACCOUNT LOCK;
Which two statements are correct?
A. The SKD user's password expires and the user is forced to change the password at the next login.
B. The objects owned by the SKD user are not accessible to any user.
C. The SKD user cannot log in to the database instance.
D. Other users can access objects owned by the SKD user, to which they have access.
正解：C,D

質問 6：
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
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Your database is open and the listener is running. The DBA stops the listener by using the command:
LSNRCTL> STOP
What happens to the sessions that are currently connected to the database instance?
A. They are not affected and continue to function normally.
B. They are terminated and the active transactions are rolled back.
C. They are not allowed to perform any operations till the listener is started.
D. They can perform only queries.
正解：A

質問 8：
Your customer is planning for a maximum-availability architecture at their data center to address their planned downtime, unplanned downtime, and replication needs.
Consider these options:
-Instance, site recovery, and heterogeneous setup
-Inter-region and intra-region load balancing across replicated databases
-Fine-grained error investigation of incorrect results
-Integrated client and application failover
-Fastest and simplest database replication Which four options would you recommend?
A. Oracle Data Guard
B. Oracle Advanced Queuing
C. Oracle Flashback technology
D. Data Recovery Advisor
E. Oracle GoldenGate
F. Global Data Services
正解：A,C,E,F
解説: (Topexam メンバーにのみ表示されます)

質問 9：
John is a CDB administrator, and Mike and Tim are PDB administrators of their respective databases- John takes a complete CDB backup by using RMAN>Backup Database. Mike and Tim may need point-in-time recovery of their PDBs. Which statement is true?
A. Recovery of individual PDBs is not possible at all.
B. Mike and Tim need to individually take backups of their respective PDBs, because CDB-level backup does not include PDB data dictionary objects.
C. Mike and Tim do not need to worry, because recovery of individual PDBs is possible.
D. Recovery of individual PDBs is not possible, because John did not back up by using RMAN>Backup Pluggable database pdb1 pdb2. However, complete CDB recovery is still possible.
正解：D