Free OCP Practice Test

which of the following architecture is used to support the agent or the application tier?
simple
Two-tier
n-tier
Client server
What is the purpose of SET DBMSSERVER OUTPUT ON ?
TO PRINT
TO COPY
TO CONVERT
TO SEE THE RESULT OF PL/SQL PROGRAMS ON DISPLAY
SQL IS A PRODUCT OF ?
ANSCI
ASCII
ORACLE
SQL SERVER
How many normalization proess are available in RDBMS?
1
2
3
6
How many constraints are available in SQL?
1
2
3
5
Auto commit occurs on which of the following situations?
On any DML
On Any DDL
Up on staring
On DML & on DDL
What is a View?
Physical table
Logical table
Data dictionary object
Virtual table
When should you recommend changing the application in order to reuse more SQL?
When the GETHITRATIO in the V$LIBRARYCACHE view is above 0.99.
When the misses in the dictionary cache are greater than 1% of the hits.
When the ratio of GETHITS to GETS in the V$LIBRARYCACHE view is less then 0.9.
When the ratio of RELOADS to PINS in the V$LIBRARYCACHE view is less than 0.01.
What are two possible causes of lock contention?
Uncommitted changes & Too many rollback segments
Uncommitted changes & Improperly sized redo logs
Uncommitted changes & Other protocols imposing unnecessarily high locking levels.
Shared pool is sized too large & Other protocols imposing unnecessarily high locking levels.
Which component will NEVER allocate memory from the large pool?
Oracle Library Cache.
Oracle Parallel Query.
Oracle Recovery Manager.
Oracle Multithreaded Server.
Database Resource Manager uses resource plans to determine resource limits for the set of users. Which statement is true in reference to resource plans?
Resource plans are set using profiles.
Only one resource plan can be stored in the database at one time.
The database can have many resources plans, but only one can be active at any one time.
The database can have many resources plans, and each user chooses which plan to belong to.
Which one pf the following actions will not cause queries to place a table's blocks at the most-recently-used end of the LRU list for the DEFAULT pool?
Creating a table with the CACHE option
Querying the table by using a CACHE hint.
Altering an existing table to set the CACHE option.
Creating a separate database buffer cache to hold cached table.
What is the main reason to create a reverse key index on a column?
The column is populates using a sequence.
The column contains many different values.
The column is mainly used for value range scans.
The columns implementing an inverted list attribute.
Which type of table is the best candidate to be cached?
Small table rarely retrieved with a full table scan.
Large table rarely retrieved with a full table scan.
Small table frequently retrieved with a full table scan.
Large table frequently retrieved with a full table scan.
Which initialization parameter specifies the location of the alert log file?
UTL_FILE_DIR
B. USER_DUMP_DEST
C. LOG_ARCHIVE_DEST
D. BACKGROUND_DUMP_DEST
The NOLOGGING mode in SQL statements is a tool used to reduce redo operations, but NOLOGGING does not apply to every operation for which the attribute is set. Which of the following SQL Statements can not use the NOLOGGING mode to reduce redo operations?
UPDATE
CREATE INDEX
ALTER INDEX...REBUILD
REATE TABLE.... AS SELECT
Which two statements about database blocks are true?
DSS environment prefer a large block size & You can reduce the number of block visits by packing rows as closely as possible into blocks.
Small block sizes result in more block contention & Random access to large object favours a large block size.
You can reduce the number of block visits by packing rows as closely as possible into blocks & To change the database block size, you must shot down the instance and perform a STARTUP RESETLOGS after you make the change.
DSS environment prefer a large block size & Small block sizes result in more block contention.
The ORDERS table has millions of rows and is accessed very often with an index (ORDID_NDX) on a Primary key (ORD_ID). Where should ORDERS and ORDID_NDX be stores?
Same table space
Different table space on the same disk.
Table space containing a rollback segment.
Different tables paces on different disks.
Which two statements about row migration are true?
Row migration is caused by a PCTREE value set too low & Row migration can be resolved using the ANALYZE command
Row migration is caused by a PCTREE value set too low & Queries that use an index to select migrated rows perform additional I/O.
Queries that use an index to select migrated rows perform additional I/O & Row migration can be resolved using the ANALYZE command.
Row migration means that row pieces are stored in different blocks & Queries that use an index to select migrated rows perform additional I/O.
Which is not a indications of contention for the rollback segment header?
A nonzero value in the WAITS column of the V$ROLLSTAT view.
A nonzero value in the UNDO HEADER column of the V$WAITSTAT view.
A nonzero value in the Undo Segment TX Slot event of the V$SYSTEM_EVENT view.
A nonzero value in the ROLL_SEG_WAIT column of the V$ROLLSEGS view.
When tables are stored in locally managed table spaces, where is extent allocation information stored?
Memory
Data dictionary.
Temporary table space.
Within the locally managed table space
What is one difference between I/O slaves and DB Wn processes for the DB Writer?
In Oracle 9i, I/O slaves are not available; only DB Wn processes are available
I/O slaves perform the write function only, while DB Wn processes also perform date-gathering activity.
I/O slaves will work only with synchronous I/O, whereas DB Wn processes are available only within asynchronous I/0.
I/O slaves will work only with asynchronous I/O, whereas DB Wn processes are available only within synchronous I/0.
With reference to Oracle data storage structures, a cluster is defined as?
A group of table that each have more then 2 low cardinality columns.
A data structure where a group of one or more tables have their own dedicated table spaces.
A group of one or more tables which resides in a table space that is striped across multiple disks.
A group of one or more tables that share the same data blocks because they share common columns and are often used together in join queries.
You have a table with a million rows. You want to build an index on a column in the table that has a low cardinality. The table is part of a Decision Support System. Your goal is to build an index that would be efficient for queries using AND/OR predicates. Which type of index would be most suitable?
Binary Index
Bitmap Index.
Reverse Key Index.
Compresses Indexes.
What is the main benefit of index-organized tables?
Fast primary key-based access & Less storage is required because there is no duplication of primary key values.
More concurrency.
Faster full table scans.
Less contention on the segment header.
Description:

If you are about to embark on an Oracle certification. Here are some practice tests
Disclaimer: Content, such as images used in the questions (if any), have been picked up from various places for the sole purpose of Instruction.

Discussion

naidu

thanks

2998 days 8 hours 11 minutes ago

anju joshi

tough 1..

3502 days 16 hours 19 minutes ago

Ahmad Al-Baik

Thanks.

3608 days 14 hours 33 minutes ago

Your Facebook Friends on WizIQ

More Tests By Author

ASP Server Controls
10 Questions | 667 Attempts

ASP.NET, Namespaces ASP.NET
10 Questions | 2028 Attempts

An ASP.NET Application
10 Questions | 437 Attempts

Explore Similar Courses

Oracle ADF Online

Price:$100