| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> OCP - 9i upgrade certification questions
Hi!
I am preparing for getting my certification upgraded to 9i (no, let's not talk about whether it is useful or not - the company pays for it, so why not go for it?) and I'm currently working with prep questions.
Some questions that I came across and am not perfectly sure what the correct answer is, are:
You are using multi-master asynchronous replication. When a row is inserted, an internal trigger is fired and creates an object. Referring to the scenario above, what is the object called?
Choice 1
Stored procedure
Choice 2
Deferred transaction
Choice 3
Deferred RPC
Choice 4
RPC
Choice 5
IPC
An Oracle database administrator is upgrading from Oracle 8.1.7 to Oracle
9i.
Referring to the scenario above, which one of the following scripts does
the Oracle database administrator run after verifying all steps in the
upgrade checklist?
Choice 1
u8.1.7.sql
Choice 2
u0900020.sql
Choice 3
u81700.sql
Choice 4
u0817000.sql
Choice 5
u0801070.sql
You need to change the archive log mode of Real Application Cluster to
ARCHIVELOG mode.
What server parameter needs to be changed before you perform the task
above?
Choice 1
ARCHIVELOG
Choice 2
LOG_ARCHIVE_FORMAT
Choice 3
CLUSTER_DATABASE
Choice 4
LOG_ARCHIVE_DEST
Choice 5
CLUSTER_ARCHIVELOG
You are the database administrator for a bank that has multiple locations in
different states. Each location has a copy of the data in an Oracle
database, and all of these databases need to be in synchronization. A fast
response time is critical at any fully functional site.
Referring to the scenario above, what replication type is needed for this
bank's databases?
Choice 1
Hybrid Multimaster and Materialized Views
Choice 2
Synchronous Multi-Master Replication
Choice 3
Asynchronous Multi-Master Replication
Choice 4
Materialized View Replication
Choice 5
Master Replication
You have partitioned the table ORDER on the ORDERID column using range
partitioning. You want to create a locally partitioned index on this table.
You also want this index to be unique.
Referring to the scenario above, what is required for the creation of this
unique locally partitioned index?
Choice 1
There can be only one unique locally partitioned index on the table.
Choice 2
The index has to be equipartitioned.
Choice 3
The table's primary key columns should be included in the index key.
Choice 4
The ORDERID column has to be part of the index's key.
Choice 5
A unique partitioned index on a table cannot be local.
What is supported by LogMiner?
Choice 1
Abstract Data Types
Choice 2
Collections (nested tables and VARRAYs)
Choice 3
Data types LONG and LOB
Choice 4
ROWID Datatype
Choice 5
Index Organized Tables
When transporting a tablespace, the tablespace needs to be self-contained.
Referring to the scenario above, in which one of the following is the
tablespace self-contained?
Choice 1
A corresponding index for a table is outside of the tablespace.
Choice 2
An index inside the tablespace is for a table outside of the tablespace.
Choice 3
A table inside the tablespace contains a LOB column that points to LOBs
outside the tablespace.
Choice 4
A referential integrity constraint points to a table across a set boundary.
Choice 5
A partitioned table is partially contained in the tablespace.
What do you use to "Warm the library cache" of a Real Application Cluster in
order to improve performance after a failover?
Choice 1
DBMS_CACHE_XFR
Choice 2
$ORACLE_HOME/bin/xfr_cache
Choice 3
$ORACLE_HOME/plsql/xfr_cache.sql
Choice 4
DBMS_XFRCACHE
Choice 5
DBMS_LIBCACHE
CREATE TABLE ORDERITEM (ORDERID NUMBER, ITEMID NUMBER)
PARTITION BY HASH(ITEMID)
(PARTITION OI_P1, PARTITION OI_P2);
CREATE TABLE ORDERLINEITEM (ORDERID NUMBER, ITEMID NUMBER);
Referring to the sample code above, which one of the following statements
is used to migrate the data in the OI_P1 partition of ORDERITEM to
ORDERLINEITEM and validate the rows?
Choice 1
ALTER TABLE ORDERITEM EXCHANGE PARTITION OLI_P1 WITH TABLE ORDERLINEITEM
WITH VALIDATION;
Choice 2
ALTER TABLE ORDERLINEITEM EXCHANGE PARTITION OI_P1 WITH TABLE ORDERITEM
WITH VALIDATION;
Choice 3
ALTER TABLE ORDERITEM EXCHANGE PARTITION OI_P1 WITH TABLE ORDERLINEITEM
VALIDATE;
Choice 4
ALTER TABLE ORDERITEM EXCHANGE PARTITION WITH TABLE ORDERLINEITEM WITH
VALIDATION;
Choice 5
ALTER TABLE ORDERITEM EXCHANGE PARTITION OI_P1 WITH TABLE ORDERLINEITEM
WITH VALIDATION;
An index-organized table has to be partitioned for performance improvement
reasons. It has been found that hash partitioning will be the most
beneficial for this table. The DBA has also been made aware that there are
frequent updates to the partitioning key of this table.
Referring to the scenario above, what clause do you use to enable the
frequent updates to this table in addition to the hash partitioning?
Choice 1
PARTITION BY HASH(column_name) ENABLE ROW UPDATE;
Choice 2
PARTITION BY HASH(column_name);
Choice 3
PARTITION BY HASH(column_name) ROW MOVEMENT ENABLE;
Choice 4
PARTITION BY HASH(column_name) ENABLE ROW MOVEMENT;
Choice 5
PARTITION BY HASH(column_name) ENABLE UPDATE;
What data are updated via a multi-table view?
Choice 1
Only data from key preserved tables can be updated via a multi-table view.
Choice 2
You cannot update data via a view.
Choice 3
Data from only one table at a time can be updated via a multi-table view.
Choice 4
Data from all tables included in a multi-table view can be updated via the
view.
Choice 5
Only primary keys can be updated via a multi-table view.
You need to implement a failover strategy using TAF. You do not have enough
resources to ensure that your backup Oracle instance will be up and running
in parallel with the primary.
Referring to the scenario above, what failover mode do you use?
Choice 1
FAILOVER_MODE=preconnect
Choice 2
FAILOVER_MODE=basic
Choice 3
FAILOVER_MODE=none
Choice 4
FAILOVER_MODE=auto
Choice 5
FAILOVER_MODE=manual
What dynamic view is accessed to find a buffer's state?
Choice 1
X$BH
Choice 2
V$BUFFER
Choice 3
X$KBH
Choice 4
V$BSTAT
Choice 5
V$BH
The network connection between a primary and standby database is
experiencing problems and has been down for more than eight hours.
Meanwhile, the users are using the primary database as usual. The network
connection is restored after eight hours and twenty-five minutes of
downtime.
Referring to the scenario above, what is the first task you need to do in
order to ensure proper activation of the standby database?
Choice 1
Execute "ALTER DATABASE ACTIVATE STANDBY DATABASE" on the standby database.
Choice 2
Execute "RECOVER AUTOMATIC STANDBY DATABASE" on the standby database.
Choice 3
Copy all the archived logs from the primary to the standby database.
Choice 4
Query the V$ARCHIVE_GAP to find out the sequence numbers of the ARCHIVE
GAP, if indeed there is a gap.
Choice 5
Execute "SHUTDOWN IMMEDIATE" on the primary database.
ttyl,
Helmut
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daiminger, Helmut INET: Helmut.Daiminger_at_KirchGruppe.de Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing ListsReceived on Fri Aug 23 2002 - 04:38:40 CDT
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
 |
 |