questions :oracle 8 to 8i upgrade exams

ORACLE 8i
PASSING SCORE: 36
RAJESH KUKADIA’S SCORE CARD
Date 9th Jan 2001 mark (Raj's mark)
(1) Java in the Database 1 (1)
(2) Optimizer and Query Improvements 7 (5)
(3) Summary Management 6 (5)
(4) Indexes and Index-Organized Tables ------------------ 3 (2)
(5) Object Relational Features and LOBs 3 (3)
(6) Partitioning Improvements 6 (6)
(7) Oracle Universal Installer: Migration and Upgrade 3 (3)
(8) Tablespace Management 6 (6)
(9) Database Resource Manager ------------------ 2 (2)
(10) Manageability Enhancements 3 (2)
(11) Availability and Recoverability Enhancements 8 (7)
(12) Features of NET8 1 (0)
(13) SQL*Plus, PL/SQL, and NLS Enhancements 3 (3)
(14) Database Security 2 (1)

TOTAL 54 (46)

Q&A’s of 8i
(1) Which script to run to install JSERVER?
Initjvm.sql
(2) How space management is done in Locally Managed Tablespace?
Bitmap in each datafile
(3)In which tablespace Temporary LOBs will be created ?
User’s Temporary TS
(4) what is true for composite partition?
Data of composite partition is stored in Subpartition. It will not store at Partition or Table level.
(5) Which index can u create for Composite Partition table?
Local index and RANGE partition Global index
(6) If u want to access user’s own table in procedure, who’s owner is another user then which clause u use
CURRENT_USER
(7) Which command is not supported in future version of Oracle?
Connect internal
(8) what is fine grained access control based on?
Security at table level
(9) What is true about autonomous transaction?
Autonomous transaction is independent of main transaction
(10) How many arch destination can u define in Oracle 8i ?
5 (five)
(11)Which is true statement about STANDBY_ARCH_DEST ?
It stores archived log file of primary database in standby database if u have turn Automatic arch on
(12)Which statements r true about block mark as corrupt?
All the rows from the corrupt block r inaccessible
Constraint may be violated
(13)How can u start DB in Read only mode?
Alter database open Read only
(14) Log_archive_dest_1=optional. Then what is true for this ?
Redo logs can be overwritten if this archive destination is fail.
(15)how can u decrease time for instance or crash recovery?
FAST_START_TO_TARGET parameter
(16)U have issued Alter System Suspend . Which operation can u do on DB?
NO operation (DDL,DML,QUERY) is possible
(17)Why u r using Alter table drop column Cust_Detail
To free up space used by that column
(18)What r used by other vendors to install various product with Oracle?
Oracle Software Packager
(19) Which oracle product is used for creating duplicate DB?
Data configuration Assistant
(20)Why u r using utlrep.sql script after upgrading to oracle 8.0 to 8.1
To recompile pl/sql packages
(21) What is true for when u transport TS from one DB to another DB
U can change schema owner of Objects in that TS
(22)What is true for Partition ?
Partition may reside in Read only TS
Partition table can have non partitioned index
(23)What is ENABLE ROW MOVEMENT clause?
U can update partition key column
(24)If both table r partitioned which operation can be possible?
Full partition wise join
(25)What is true for Index on IOT?
Index can be created on any column of IOT
(26)Which operation is possible when rebuild IOT online?
Query operations
(27)How can u create statistics of index?
CREATE INDEX COMPUTE STATISTICS
(28)What is true for dimension?
Dimension can based on multiple tables
Multiple Hierarchy can be possible in single dimension
(29)Which information u can find with Summary Advisor?
Space requirement of Summary
Which Summaries to create,drop
(30)What Is true for Materialized View(MV)?
MV can compute Aggregation and stored in table
MV consume space
(31) Select deptno,job,sum(Sal) from emp
Group by(deptno,sal)
If u want to find sum of salary for department wise, subtotal and sum of salary for Job wise,subtotal then which aggregate function will u use?
CUBE or ROLLUP ?
Ans : CUBE
(32) Use_stored_outline=true then which Outline Category Oracle will use?
DEFAULT
(33)In which Schema Stored Outline will be stored?
OUTLN
(34) Questions on Parallel operation tuning parameter.
PARALLEL_AUTOMATIC_TUNING
PARALLEL_ADAPTIVE_MULTI_USER
(35)Which clause u can use with creation of LOBs
Logging and Nologging
(36) U r using automatic load balancing and failover.When client required connection with server which
file it will look ?
OPTIONS:: Tnsname.ora on server
Tnsname.ora on client
Listener.ora on Server
Listener.ora on client
(37)Use of Logminer.
To track change of DB
To Find When user dropped perticular table
(38) Question on Explain plan on Top – n SQL query.
Run explain plan utility on top –n sql query and check out what is out put of expalin plan
(39)Which four operation required for Transportable tablespace ?
Make TS read only
Export TS metadata
Transport TS to target TS
Import TS metadata on target DB
(40)Why u r using transport_set_check procedure of DBMS_TTS package ?
To check weather the TS sets r self contained or not?
(41) Which statement is true about locally managed TS with AUTOALLOCATE clause.
Dba or User don’t have to worry about extent allocation in that TS