Oracle
9i
PART
–A
Q1. Oracle 9i belongs to :
A.
RDBMS B.
ORDBMS
C.
NDBMS D.
HDBMS
Q2. COMMIT command belongs to …………………….
Category of SQL.
A.
Data Definition Language B.
DML
C.
TCL D.
None of these
Q3. …………… command is used to remove table from
the database.
A.
Dekete B.
Drop
C.
Update D.
None of these
Q4. Maximum length of a table name is …………….
A.
10 B.
20
C.
30 D.
15
Q 5. A
table can have only …………. Primary key.
A.
One B.
Two
C.
Three D.
Any No.
Q6. ………………. Function
is not a date function.
A. Add_months B. To_Date
C. Months_Between D. None of these
Q7.
………………..command is used to set the page dimentions .
A. Newpage B. LineSize
C. PageSize D. All of these
Q8. A ………. Loop
can be used instead of explicit cursors to simplify coding.
A. For B. Cursor For
C. While D. None of these
Q9. A database
is divided into logical structures
called as :
A. Data Dictionary B. Table
spaces
C. Objects D. All of these
Q 10 ……………… is
created whenever a database is created.
A. Domain B. Object
C. Data Dictionary D. None of
these
Q 11.
Userdefined exceptions must be raised
explicitly by using :
A. RAISE B. EXPLICIT
C. CREATE D. DEFINE
Q12. Which of
these is not a type of segments :
A. Data segment B. Sequence
segment
C. Rollback segment D. Temporary
segment
Q 13. A group of shared memory structures that
contain data and control information for one Oracle database instance , is
called :
A. Primary Memory B. System Global
Area
C. System Process Storage D. None of these
Q 14. The
function of Process Monitor is :
A. Top cleanup abnormally terminated
processes.
B. Restart the computer
C. Both A and B
D. None of these
Q 15. The failed transactions are resolved by …………… process.
A. CheckPoint B. Recover(RECO)
C. arc0 D. All of these
Q 16. The node
that originates the distributed transaction, is called :
A. Client B. Local Coordinator
C. Global CoOrdinator D. None of these
Q 17 Which of
the following is true about a commit point site
:
A. The commit point site never
enters in the prepared state.
B. The commit point site has the
maximum commit strength point.
C. Both A and B.
D. None of these
Q 18 A
Distributed transaction can become in-doubt in the following ways :
A. A server machine running Oracle
software crashes.
B. An unhandled software error occurs.
C. Network connections , between
Oracle databases is disconnected.
D. All of the above.
Q 19 The
following process is used to resolve the in-doubt transations :
A. REDO B. RECO
C. LOG REDO D. None of these
Q 20. The …… is
used to managing request between HTML and Java
A. JDBC B. Servlets
C. CORBA D. All of the above
Q 21. In a
distributed database environment, database’s network domain is specified by :
A. DB_DOMAIN B. DOMAIN_NAME
C. NETWORK_DOMAIN D. None of these
Q 22. You can
not perform the following operations using database links :
A. Grant privileges on remote
objects
B. Analyze remote objects
C. Grant roles to users in a remote
database
D. All of the above
Q 23. Which of
the following is not a component of a global object name :
A. Object Name B. DataBase
name
C. Domain D. All of the above
Q 24. Which of
the following is a benefit of location transparency :
1. Access to remote data is simple.
2. Administrators can move database
objects with no impact on end-users.
3. Network speed improves.
A. 1,2 and 3 B. 1 and 3
C. 1 and 2 D. 2 and 3
Q 25. Each
commited transaction has an associated ……….. to uniquely identify the changes :
A. Transaction Change Number(TCN) B. System Change Number(SCN)
C. Transaction ID D. None of
these
Q 26 Distributed
query optimization is a feature that :
A. reduces the amount of data
transfer between sites.
B. performs the memory de-allocation
after transaction.
C. Both A and B
D. Neither A or B
Q 27. The …………function
is used to a string in upper case.
A. INITCAP() B. UPPER( )
C. TRANSLATE( ) D. UPPERALL( )
Q 28. The
following function is used to truncate spaces from a string :
A. TRIM( ) B. LTRIM( )
B. RTRIM( ) D. All of these
Q 29. The ………..
function return the User environment information .
A. ENVIRONMENT( ) B. USERENVIRONMENT(
)
C. USERENV( ) D. USERINFO( )
Q 30. The ………..
function is not a group value function.
A. COUNT( ) B. LAST( )
C. AVG( ) D. SQRT( )
Q 31 The ………….
Is responsible for REDO LOG Buffer management.
A. System Monitor(smon) B. Log Writer(lgwr)
C. Check Point (ckpt) D. All of These
Q 32 The
combination of several contiguous data blocks is called ……………….
A. Segments B. TableSpace
C. Extents D. None of these
Q 33. Which of
the following is not a client installation type?
A. Administrator B. RunTime
C. Custom D. Typical
Q 34. …………….. is
a DDL statement.
A. Update B. Create
C. Select D. All of these
Q 35. Select the
incorrect statement for table name :
A. First letter of a table name
should be an alphabet.
B. Maximum length is upto 32
characters.
C. Underscore and numbers are
allowed.
D. All of these are correct.
Q 36. NOT NULL
is a …………… constraint.
A.Entity Integrity B. Unique
C. Domain Integrity D. None of these
Q 37. A composite
unique key can contain upto …….. columns.
A. 8 B.
16
C. 20 D. 32
Q 39. Which of
the following is not related with referential integrity :
A. Child Table B.
Master Table
C. Parent Table D. Foreign
Key
Q 40. The size
of long data type object is :
A. 1 GB B. 2GB
C. 3GB D. 4GB
PART – B
Note : Each uestion in this section
carries 2 marks.
Q 41. …………… and
……… constraints fall under Domain Integrity Constraint.
A. Not Null, Primary Key B. Not Null, Check
C. Both A and B D. Neither A
nor B
Q 42. ……………
would be the output of Select mod(3,10) from dual.
A. 0 B.
1
C. 10 D. 3
Q 43. Locks can
be acquired at two different levels. They are………. And ………..
A. Attribute Level, Tuple Level B. Row Level, Table level
C. Both A and B D. None of
these
Q 44. There are
two types of exceptions. They are :
A. PreDefined, User-Defined B. Simple, Complex
C. Static, Dynamic D. None of
these
Q 45. ………………..
and ……….. are explicit cursor attributes.
A. %found and %notfound B. %isopen and %isclose
C. Both A and B D. None of
these
Q 46. ………….. and
………… are two types of programs, supported by PL/SQL.
A. Triggers, Sequence B. Procedures,
Functions
C. Both A and B D. None of
these
Q 47. An Oracle
9i database system has two types of processes namely ………… and ……
A. User, System B. User,
Oracle9i
C. System, Oracle 9i D. None of these
Q 48. Oracle 9i
database s a collection of ……. And is treated as a ………….
A. Domain, entity B. Data, Unit
C. Both A and b D. None of
these
Q 49. Two types
of failures are ….. and …….
A. Timing, Server Crash B. Client, Server
C. Both A and B D. None of
these
Q 50. ……………. And
……. Are security mechanism techniques :
A. Cryptography, Access Control B. Cryptography, Authentication
C. Authentication, Access Control D. All of these
PART – C
Note : Each question in this section
carries 4 marks.
Q 61. Match the
following :
Set A :
a. IN b. LIKE c. AND d. > e. +
Set B :
i. Arithmetic Operator ii. List of Values iii. Logical
iv. Character Pattern v. Relational
A. a-v, b-iv, c-iii, d=ii, e-I B. a-ii, b-iv, c-iii,
d-v, e-I
C. a-i, b-iv, c-iiii, d-ii, e-v D. a-v, b=I, c-ii,
d-iii, e-iv
Q 62. Which one
is a column or combination of columns included in the definition of referential
integrity that would refer to a referenced key ?
A. Referenced key B. Parent Key
C. Child table D.
Foreign key
Q 63. While
using the insert command :
1. values are separated by commas.
2. Datatypes number and date are
enclosed in apostrophes.
3. values must be entered in the
same order as they are defined in the table.
A. 1, 2 and 3 B. 2 and 3
C. 1 and 2 D, 1 and 3
Q 64. Which
operator are used in conditions to compare one expression with another ?
1 Arithmetic operator
2. Logical operator
3.
Comparison Operator
A. Only 2 B. 1 and 2
C. 2 and 3 D. only 3
Q 65. The
precedence of operators are given below:
1. Arithmetic operator
2. Comparison operator
3. NOT logic operator
4. AND logic operator
5. OR logic operator
A. 1,2,3,4,5 B. 1,2,4,3,5
C. 2,1,4,3,5 D. 2,1,5,4,3
Q 66. Following
are different types of join :
1. Simple Join
2. Inner join
3. Self join
4. Outer join
A. 1,2,3 and 4 B.
1,3,and 4
C. 2,3 and 4 D. 1.2 and 4
Q 67. Choose
improper statement with reference to index :
1. is a database object
2. may contain upto 18 colums
3. columns of type long, long raw
cannot be indexed.
4. are dependent of data
A. 1 and 3 B. 2 and 3
c. 2 and 4 D. 1,2,3, and 4
Q 68. Which is a
collection of one or more databases ?
1. Sequence
2. Tablespace
3.Synonym
4. Index
A. 1 and 2 B. Only 2
C. Only 3 D. 2 and 4
Q 69. privilege
:
1. is the right to execute
particular types of SQL statements.
2. is the right to access other’s
object.
3. can be granted by the database
administrator.
A. Only 1 B. 1 And 2
C. 1,2 and 3 D. Only 3
Q 70. Which of
the following does not belong to the types of lock ?
1. Row Level Lock
2. Column Level
3. Share Lock
4. Dead Lock
A. Only 4 B. Only 2
C. 2 and 3 D. 1 and 2
------------------------------------------------------------------------------------------------