Oracle 1z0-497 問題集

質問 1：
Which two statements about ADDM are true?
A. Regular ADDM uses AWR snapshots that are not yet purged.
B. Real-Time ADDM uses ASH recent activity from SGA data.
C. Real-Time ADDM uses AWR snapshots of the last 10 minutes.
D. Real-Time ADDM analyzes performance in a completely different fashion than regular ADDM.
正解：A,B

質問 2：
Examine the statements:
SQL> CREATE TABLESPACE MYTBS DATAFILE '/disk1/mytbs_l.dbf ' SIZE 10M;
SQL> CREATE TABLE mytab (id NUMBER, descr VARCHAR2 (100) )
PARTITION BY RANGE(id) (
partition pi values loss than (100000) tablespacemytbs storage (initial lm),
partition p2 values less than (MAXVALUE) tablespacemytbs storage (initial 1m)
);
When inserting data, you get the error:
ORA-01688: unable to extend table SYS.MYTAB partition P2 by 128 in tablespace MYTBS
Which three operations would allow you to insert data without getting the error message?
A. Extend the logical volume by 10 MB where the data files are stored;
# lvextend -L+10M /diskl
B. Add a data file:
SQL>ALTER TABLESPACE MYTBS ADD DATAFILE ' /disk1/mytbs_2 .dbf SIZE 10M;
C. Move a partition to another tablespace:
SQL> CREATE TABLESPACE ADDITIONAL_TBS DATAFILE '/disk1/additional_tbs_1 .dbf' SIZE
10M;
SQL> ALTER TABLE MYTAB MOVE PARTITION P2 TABLESPACE ADDlTIONAL_TBS;
D. Resize the existing data file:
SQL> ALTER DATABASE DATAFILE '/diskl/mytbs_l .dbf' RESIZE 20M;
E) Remove a data file:
SQL> ALTER TABLESPACE MYTBS DROP DATAFILE '/diskl/mytbs_l - dbf';
正解：B,C,D

質問 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：
Your customer is looking for zero-data-loss failover with maximum data protection and high availability for their primary database. Which two solutions would you recommend to the customer if the distance between the primary and the standby location is more than 300 miles?
A. Data Guard SQL Apply
B. Active Data Guard Far Sync
C. Synchronous redo transport with Data Guard
D. Asynchronous redo transport with Data Guard
正解：A,C
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Identify three outcomes of using the Oracle Multitenant option in Oracle Database 12c.
A. same time needed for patching and upgrade as in the previous release
B. less instance overhead
C. fast and easy provisioning
D. isolation
E. increased storage cost
F. minor application changes
正解：A,B,C

質問 6：
Which statement is true about loading data by using the conventional path of SQL*Loader?
A. Redo is not generated while performing conventional path loads.
B. INSERT triggers are disabled before the conventional path load and re-enabled at the end of the load.
C. Instead of performing transactions, SQL*Loader directly writes data blocks to the data files.
D. Only PRIMARY KEY, UNIQUE KEY, and NOT NULL constraints are checked,
E. No exclusive locks are acquired when the conventional path loads are performed.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Which three statements are true about System Global Area (SGA)?
A. SGA is read and written by server and background processes.
B. SGA is used to speed up queries by caching data blocks, program data, information about database objects, and query results
C. SGA is allocated automatically when a database is started.
D. SGA contains shared memory structures for all Oracle processes running on a single server.
E. Each server process has its own SGA.
F. SGA is allocated automatically when a database is mounted.
正解：A,B,C

質問 8：
Which two statements about Global Data Services (GDS) are correct?
A. GDS helps to perform database failovers, and does not require Data Guard Broker.
B. The GDSMGRL utility is a command-line interface for configuring and managing the Global Data Services framework.
C. GDS works seamlessly with any combination of Oracle RAC databases, single-instance databases, Oracle Data Guard, Oracle Active Data Guard, and Oracle Golden Gate.
D. GDS helps in performing data replication.
E. GDS allows scaling replication-aware application workloads beyond the cluster (that is, across replicated clusters).
正解：C,E
解説: (Topexam メンバーにのみ表示されます)

質問 9：
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. 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';
B. 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;
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;
正解：A,D
解説: (Topexam メンバーにのみ表示されます)