Oracle 1z0-497 問題集

質問 1：
Which two items are key for maintaining data consistency in Oracle Database 12c?
A. undo data
B. serializability
C. isolation level
D. lock mechanism
正解：C,D
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Which three events signal a database writer (DWR) to write buffers to disk?
A. A server process cannot find non-dirty blocks after scanning a threshold number of buffers.
B. The redo log buffer becomes full.
C. The database advances a checkpoint.
D. A tablespace is changed to read-only status.
E. The database is shut down in immediate mode.
F. A client process commits a transaction.
正解：A,C,E
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Your customer is looking for a solution that meets these four needs:
1 - Replicate data from source to target for reporting purposes.
2 -Replicate data from one source to multiple targets.
3 - Replicate data between two databases for instant failover.
4 - Replicate data from multiple sources to a single target for a data warehouse.
Which GoldenGate-supported topology would you recommended?
A. Uni-directional for 1 Broadcast for 2 Bi-directional for 3 Consolidation for 4
B. Peer-to-peer for 1 Broadcast for 2 Bi-directional for 3 Consolidation for 4
C. Uni-directional for 1 Peer-to-peer for 2 Bi-directional for 3 Consolidation for 4
D. Peer-to-peer for 1 Consolidation for 2 Broadcast for 3 Cascading for 4
正解：A

質問 4：
Which statement regarding Oracle Active Data Guard 12c is false?
A. Any application compatible with a read-only database can run on an Oracle Active Data Guard standby.
B. It supports different software patch levels between a primary database and its physical standby database for the purpose of applying and validating Oracle patches in a rolling fashion.
C. It supports multi master and bidirectional replication architectures where there are multiple databases that all contain the same data, even if they are not synchronized.
D. It provides new support for DML to global temporary tables and the use of sequences in the standby database.
E. It repairs block corruptions detected in the primary or standby database.
正解：C

質問 5：
YOU want to move all objects of the CONSULTANT user from the test database to theDB-USER schema of the production database. Which option of IMPDP would you use to accomplish this task?
A. SCHEMAS
B. FULL
C. TRANSFORM
D. REMAP_TABLESPACE
E. REMAP_SCHEMA
正解：E

質問 6：
All database users are currently connected to the database instance and are working. The HR user opens three database sessions and executes this command in one of the sessions:
SQL> UPDATE persons SET ccode='U031' WHERE ccode='U029';
123 rows updated.
SQL> DELETE FROM persons WHERE exp='Y';
3 rows deleted.
The SYS user opens a new session after HR executes the preceding commands. Which option represents the sessions that can see the effect of the UPDATE and DELETE commands?
A. all sessions of the HR user and the SYS user
B. all sessions for which database users have access privileges to the PERSONS table
C. the session of the HR user that executed the commands
D. all sessions of the HR user
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Examine the output:
SQL> SELECT index_name, status FROM dba_indexes WHEREstatus='UNUSABLE';
INDEX_NAME STATUS
EIND UNUSABLE
Which two statements about this index are true?
A. The index cannot be rebuilt, and has to be re-created.
B. The index is automatically rebuilt when used the next time.
C. It is ignored by the query optimizer.
D. It is not used while the index is being rebuilt.
正解：C,D
解説: (Topexam メンバーにのみ表示されます)

質問 8：
Which database feature can be used for organizing data when there is a very large amount of data?
A. Index
B. Database vault
C. Row-level security
D. Triggers
E. Partitioning
正解：E
解説: (Topexam メンバーにのみ表示されます)

質問 9：
You add the following code in the tnsnames.ora file on a client PC:
sales=
(DESCRIPTION=
(ADDRESS= (PROTOCOL=TCP)(HOST=salesdata) (PORT=1521) )
(CONNECT_DATA=
(SERVICE_NAME=sales.acme)))
Which statement is true about the code with respect to creating a new connect identifier?
A. It generates an error because the connect identifier name cannot be a part of SERVICE_NAME.
B. It is created for the SALESDATA database on the SALES server in the network domain called ACME.
C. It generates an error because the server configuration mode (dedicated or shared) is not specified.
D. It is created for the SALES database in the network domain ACME on the SALESDATA server.
正解：D
解説: (Topexam メンバーにのみ表示されます)