COMPUTER SCIENCE QUESTIONS AND ANSWERS PART-I

************ oracle ******************

1
A collection of related but physically independent databases is called as
2
______ data type stores floating point.
3
Which is NOT correct in the following for a View?
4
Is the Domain integrity to be inforced manually by the developer or administrator?
5
________ lock prevents other locks of any type on the same data.
6
When concurrent queries contend for the same resource, how are they handled in Oracle7?
7
A ______ is a collection of related privileges that an administrator can grant collectively to
database users.
8
A logical collection of related tables and views is called as
9
________ is used for database recovery.
10
________ middleware requires both client and server remain active during conversation.
11
Which process is responsible for cleaning up after a front-end server process abnormally
dies?
12
_________ is used to undo the changes made by current transaction.
13
SELECT SQR(25) FROM dual; will this return square root of 25 ?
14
In a PL/SQL, exceptions are handled by
15
_________ is used to create user-defined datatypes.
16
Procedures returns
17
An IN parameter in a Procedure
18
Which of the following is NOT a valid SQL*Loader command-line option?
19
Can a database name have $ sign?
20
_________ tool is used to generate the necessary network configuration files.
21
Is the Operating System Authentication same as Password Authentication?
22
Choose the one that fits best for a segment.
23
Which is NOT an extent storage parameter?
24
Is this true? "Row chaining improves disk I/O performance."
25
Can rollback segments be offline?
26
Which is NOT related to memory cache?
27
Shared pool is made of
28
SGA is
29
Is it possible to change the database block size, after creating the database?
30
A trigger body can contain any
31
A hint is represented by
32
Can a single SQL comment have more than one hint?
1
Client/Server computing model is also called as
2
A file server system has which of the following limitations for multiuser applications?
3
Database servers concentrate on
4
Validating data entry is done by
5
The Oracle7 database server is based on
6
A collection of related but physically independent databases is called as
7
Data integrity means
8
Is this true? "Integrity constraints automatically prohibit invalid data from existing."
9
Comments in a SQL statement begin with the character(s)
10
An Oracle7 database's logical structure is
11
Is this true? "Pre-relational database systems require users to program applications to
access data by using complicated physical addressing mechanisms."
12
Which of the following data types are NOT supported by Oracle7?
13
______ data type stores floating point.
14
______ data type stores binary strings.
15
Which is NOT correct in the following for a table space?
16
Is this correct? "Oracle7 uses the SYSTEM tablespace to hold the data dictionary."
17
Is this correct? 'Oracle7 does not allow administrators to back up a database at the
tablespace level'
18
Which is NOT correct in the following for a View?
19
View CANNOT be used to
20
A value in a column is a member of the column's domain, or legal set of values. This is
ensured by
21
_______ ensures "every row in a table must be unique."
22
Which is NOT valid for a Primary Key?
23
_______ ensures "the values in one column or set of columns refer to or must match the
values in a related column or set of columns."
24
Which of the following terms are used in Referential Integrity?
25
Is the Domain integrity to be inforced manually by the developer or administrator?
1
A stored procedure is
2
In Oracle SQL statements ______ is used as a statement terminator.
3
Is this true? "Every Oracle SQL statement must be terminated by the Statement
terminator."
4
Is "Trigger" a stored procedure?
5
Does Oracle7 has automatic concurrency control system?
6
When two operations contending for the same data, _______ occurs.
7
When concurrent transactions contend for the same resource, how are they handled in
Oracle7?
8
To maximize concurrency by minimizing data conflicts, Oracle7 uses
9
________ lock allows other transactions to acquire share locks on the same data.
10
________ lock prevents other locks of any type on the same data.
11
When concurrent queries contend for the same resource, how are they handled in Oracle7?
12
Is overriding of default locking mechanisms allowed in Oracle7?
13
________ are the key components that deliver multi-versioning.
14
Oracle7 maintains database security using
15
________ privilege gives a user the right to perform an operation on a database-wide
basis.
16
A ______ is a collection of related privileges that an administrator can grant collectively to
database users.
17
A logical collection of related tables and views is called as
18
________ is used for database recovery.
19
Is this correct? "A client application in a client/server system includes data management
component."
20
Which is NOT a query / reporting tool ?
21
An OCI program can control which of the following steps of SQL statement processing?
22
________ allows third-party CASE tools to work in an Oracle CASE development
environment.
23
Is this correct? "Vertical Client Applications are pre-built applications that work right out of
the box."
24
Is it a must that client and server use the same protocol to communicate with each other?
25
________ is Oracle's own middleware product.
26
________ middleware requires both client and server remain active during conversation.
1
________ writes data blocks that transactions modify in memory to the appropriate data
files.
2
Does DBWR writes to disk immediately?
3
Which of the following process is responsible for cleaning up after a front-end server
process abnormally dies?
4
Which is NOT a DML command?
5
Which is NOT a DCL command?
6
Is it valid? SELECT id, lname, fname FROM candidate WHERE id NOT IN (SELECT
candidateid FROM tests)
7
_________ is used to undo the changes made by current transaction.
8
SELECT SQR(25) FROM dual; will this return square root of 25?
9
Is SQL a nonprocedural language?
10
In a PL/SQL, exceptions are handled by
11
_________ is used to create user-defined datatypes.
12
_________ flow control statement is NOT supported by Oracle's PL/SQL
13
Oracle's PL/SQL raises ________ exception when it encounters divide by zero
14
Is this true? "Unhandled exceptions in a PL/SQL block are rolled back to the calling
environment."
15
Procedures returns
16
An IN parameter in a Procedure
17
Choose the one that best fits for a database trigger condition.
18
Is this correct? "Oracle7 fires a statement trigger's body once for every row the triggering
statement touches."
19
Which of the following is NOT a valid SQL*Loader control file option?
20
Which of the following is NOT a valid SQL*Loader command-line option?
21
SQL*Loader can load data into a database using
23
Can a database name have $ sign?
24
Which is NOT allowed in the following for a DB_NAME?
25
Is there a way to make a tablespace offline temporarily?
26
Which of the following types of configurations are available with Oracle7 ?
27
_________ tool is used to generate the necessary network configuration files.
1
Is this true? "Oracle7 dynamically adjusts the number of shared servers based on the
system load."
2
Is the Operating System Authentication same as Password Authentication?
3
Oracle7 database user can change his password by using the SQL command
4
Choose the one that fits best for a segment.
5
An extent is
6
Which is NOT an extent storage parameter?
7
Is this true? "Row chaining improves disk I/O performance."
8
_________ is used to control transaction access to data blocks.
9
Can rollback segments be stored in any tablespace of a database?
10
Can rollback segments be offline?
11
Which is NOT related to memory cache?
12
Oracle7 supports _______ cache.
13
Shared pool is made of
14
SGA is
15
Is it possible to change the database block size, after creating the database?
16
Is Database alerters same as Database triggers?
17
Oracle CDE tool set consists of
18
Oracle Forms has
19
Does Oracle Forms supports applications in bitmapped GUIs ?
20
A hint is represented by
21
Can a single SQL comment have more than one hint?
22
Oracle7 PL/SQL programs can include any
23
Oracle7 stores the compiler version of trigger in
24
A trigger's triggering statement is
25
A trigger body can contain any