Janardan Rai Nagar Rajasthan Vidyapeeth 2005 M.Tech Computer Science MSDBO2 ORACLE 9i DATABASE - Question Paper

MASTER OF TECHNOLOGY
(SEMESTER - IV) (COMPUTER)
(SPL-1-OBJECT ORIENTED SOFTWARE DEVELOPMENT & DATABASE SYSTEM)
MSDBO2- ORACLE 9i DATABASE

GENERAL INSTRUCTIONS:
1. Question paper is divided into 3 groups
2. Each group is of 25 marks every
3. Figure to the right in bracket shows mark
4. Assume suitable data if necessary

GROUP A: ans any 3 ques.. ques. No. one is compulsory.
Q.1: What is the function of virtual private database. How it performs in Oracle 9i? (05)
Q.2 discuss in detail Reasonable space Allocation and Export / Import features. (10)
Q.3 How to switch primary Database to standby Role? Write six steps to switch from primary database to standby role. (10)
Q.4 Explain logMiner? discuss in detail about capability to use an online
Dictionary discuss (10)
Q.5 What is segment management? Automatic Global Index
Management. (10)

GROUP B: ans any 3 ques.. ques. No. six is compulsory.
Q.6 Explain Union Operator with example? (05)
Q.7 Explain Join statements, Cross Join, Equijoin with Natural join keywords and Equijoin with the using keyword with example? (10)
Q.8 Explain case statements, Null IF function, coalesce Function Distribution
function and Grouping set with example? (10)
Q.9 Explain Data Dictionary? To which Data dictionary view did oracle 9i add a new Column BLOCK-SIZE to find the block size used by every table space? A - V $ DBA – BLOCK-SIZES (10)
B - V $ DBA – TABLE SPACES
C – DBA – BLOCK- SIZES
D – DBA – TABLE SPACES

Q.10. What is Replication Enhancements? Draw and discuss the process to add a New master site without Quiescing? (10)
GROUP C: All ques. are Compulsory.
Q.11 Fill in the blanks (each ques. carries two marks)
(i) Oracle provides the _________ for you to find info about the session.
(ii) Minimal I/o recovery just applies the redo entries that pertain to the __________ at the time of the failure.
(iii) The _________ command is used a display RMAN configuration settings
(iv) Slip securing easels you to use the __________ index even when the index prefix column is omitted in the SQL statement.
(v) Oracle 9i introduce 2 new Unicode character encoding sets __________ and __________.

Q.12 Multiple option ques.. (Each ques. carries two marks)
(i) Which of the subsequent server manager commands is supported in SQL*Plus?
(a)STARTUP
(b)SET DATEWIDTH
(c)SET CHARWIDTH
(d)SET RERIES
(ii) One oracle9i enhancement to LogMiner is
(a)The DBMS_LOGMNR_D Package
(b)Tracking DDL commands
(c)Creating a dictionary file
(d)Tracking DML Commands
(iii) To use the Flashback feature, the database should be using
(a)Either automatic or manual undo management
(b)Manual undo management (rollback segments)
(c)Automatic undo management
(d)None of the above
(iv) Which of the subsequent is a privileged connection that was deprecated in oracle 9i?
(a)CONNECT DBA
(b)CONNECT AS DBA
(c)CONNECT AS INTERNAL
(d)CONNECT INTERNAL
(v) Which of the subsequent parameters used to manage instance recovery
prior to Oracle9i Was retired in Oracle 9i?
(a)LOG_CHECKPOINT_INTERVAL
(b)LOG_CHECKPOINT_TIMEOUT
(c)FAST_START_IO_TARGET
(d)DB_BLOCK_MAX_DIRTY_TARGET

Q.13 True or false (each ques. carries one mark).
(i) The TIMESTAMP data kind is the identical as the DATE data kind.
(ii) System statistics enable the optimizer to perform Rule-based optimization.
(iii) The parameter used to set the data base in AUM mode is undo management.
(iv) In Oracle 9i, the rado logs do NOT! Track the original DIL Statement.
(v) The secure application situation was introduced in Oracle 9i.

Earning:   Approval pending.