

Computer Science - Relational Database Management System
Exam Duration: 45 Mins Total Questions : 30
The users who maintain personal databases by using readymade program packages that provide easy-to-use menu or graphics based interface, known as
- (a)
Casual end user
- (b)
Native end user
- (c)
Sophisticated end user
- (d)
Stand alone user
Given, relations R(W,Y) and S(Y,Z) the result of Select distinct W,X
From R,S is guaranteed to be same as E, if
- (a)
R has no duplicates and S is non-empty
- (b)
R and S have no duplicates
- (c)
S has no duplicates and R is non-empty
- (d)
R and S have the same number of tuples
Generally speaking, for a weak entity set to be meaningful, it be part of a
- (a)
one to one relationship
- (b)
one to many relationship
- (c)
many to many relationship
- (d)
none of the above
With the help of which of the following relations operation set we can perform division on relations?
- (a)
\(\{ \pi ,\times ,-\} \)
- (b)
\(\{ \sigma ,\times ,-\} \)
- (c)
\(\{ \times ,-\} \)
- (d)
{X}
Consider the following relation scheme pertaining to the information about a student maintained by an university:
STDINF (Name, Course, Phone no.Major, Prof, Ggrade) then this scheme is decomposed into the relation schemes
STUDENT (Name, Phone no., Major, Grade)
Course (Course, prof)
Then select correct statement if, it is a bad decomposition
- (a)
due to loss of information
- (b)
due to redundancy and update anomaly
- (c)
The above decomposition is not at all bad
- (d)
Both a and b
Consider the relation R (A, B, C, D, E, F, G) satisfies the following functional dependencies
\(A\rightarrow B,BC\rightarrow DE,AEF\rightarrow G\) Which of the following statements is true?
- (a)
BC\(\rightarrow \)DC
- (b)
ACF\(\rightarrow \)DG
- (c)
A\(\rightarrow \)DG
- (d)
B\(\rightarrow \)DG
Consider the following log sequence of two transaction on a back account, with initial balance 12000, that transfer 2000 to a mortage payment and, then apply a 5% interest.
1. T1 start
2. T1 B old = 12000 new = 10000
3. T1 M old = 0 new = 2000
4. T1 commit
5. T2 start
6. T2 B old = 10000 new = 10500
7. T2 commit
Suppose the database system crashed just before log record 7 is written.When the system is restarted,which one statement is true of the recovery procedure?
- (a)
We must redo log record 6 set B to 10500
- (b)
We must undo log record 6 to set B to 100000 and then redo log records 2 and 3
- (c)
We need not redo log records 2 and 3 because transaction T1 has committed
- (d)
We can apply redo and undo operations in arbitary order because they are idempotent
Give the following relation instane
X | Y | Z |
1 | 4 | 2 |
1 | 5 | 3 |
1 | 6 | 3 |
3 | 2 | 2 |
Which of the following functional dependencies are satisfied by the instance?
- (a)
XY -> Z and Z -> Y
- (b)
YZ -> X and Y -> Z
- (c)
YZ -> X and X -> Z
- (d)
XZ -> Y and Y -> X
In the index allocation scheme of vblocks to a file,the maximum possible size of the file depends on
- (a)
the size of the blocks, and the size of the address of the blocks
- (b)
the number of blocks used for the index and the size of the blocks
- (c)
the size of the blocks, the number of blocks used for the index and the size of the address of the blocks
- (d)
None of the above
Consider a schema R (A,B,C,D) and functional dependencies A\(\rightarrow \)B and C\(\rightarrow \)D. Then the decomposition of R into R1 (AB) and R2 (CD) is
- (a)
dependency preserving and lossless join
- (b)
lossless join but not dependency preserving
- (c)
dependency preserving but not lossless join
- (d)
not dependence preserving and not lossless join
Cascading rollback can be avoided by
- (a)
two phase locking protocol
- (b)
strict two phase locking protocol
- (c)
cannot be avoided
- (d)
can be avoided but there is no actual protocol
In lock conversion what is true?
- (a)
Upgrade can be done in growing phase and downgrading in shrinking phase
- (b)
Upgrade can be done in shrinking phase
and downgrading in growing phase - (c)
Upgrade and downgrade cannot be possible
- (d)
Lock conversion can be allowed arbitraily
In vigorous two phase locking protocol a transaction
- (a)
release exclusive locks only at the end of transaction
- (b)
release all locks only at the beginning of transaction
- (c)
acquired all locks at the beginning of transaction
- (d)
acquired all exclusive locks at the beginning of transaction
In B tree file organization, the highest number of itm can be placed in leaf nodes is
- (a)
n/2
- (b)
(n-1)/2
- (c)
n-1
- (d)
n
In dense index, index record contains
- (a)
a search key value and a pointer to the first record
- (b)
longest search key value and a pointer to last record
- (c)
smallest search key value and a pointer to the first location
- (d)
None of the above
Commonly a database consists of a ....... process that provides data from secondary storage to one or more ........ process that are application using the data.
- (a)
slave, master
- (b)
master, slave
- (c)
client, server
- (d)
server, client
Information is known as
- (a)
Unorganized data
- (b)
Raw data
- (c)
Processed data
- (d)
Collection of data
In Star Base the entire collection of related data in one table is referred toas a
- (a)
File
- (b)
Record
- (c)
Field
- (d)
Structure
Hierarchical database structures is primarily used on
- (a)
micro computers
- (b)
None
- (c)
Super computers
- (d)
Main Frame computers
In general, human beings are liable to make computational and errors.
- (a)
Parallax
- (b)
Random
- (c)
Instrumental
- (d)
None of these
Which aredisplayed on the Right pane of Window's opening screen?
- (a)
Report
- (b)
Forms
- (c)
Queries
- (d)
Any one
A flat-file database consists of
- (a)
Several tables
- (b)
No tables
- (c)
Two tables
- (d)
One tables
A collection of programs that allows any number of users to access data is
- (a)
Management systems
- (b)
Star base
- (c)
database management system
- (d)
Database systems
Which is an example for attributes?
- (a)
style
- (b)
colour
- (c)
colour or style or size
- (d)
size
In a query the search conditions window is useful to specify
- (a)
Data
- (b)
Conditions
- (c)
value
- (d)
Statement
With the help of structured Query Language one can
- (a)
delete obsolete records
- (b)
list a subset of records
- (c)
search the database to locate records
- (d)
all the above
Which of the following window is similar to default to default filtet?
- (a)
from window
- (b)
report window
- (c)
condition window
- (d)
query condition windoe
A filter is also a type of
- (a)
table
- (b)
form
- (c)
report
- (d)
query
The flashing vertical bar in Star Office Writer is called
- (a)
Insertion point
- (b)
End of document maker
- (c)
cursor
- (d)
Insertion bar
How many differnt database are there in Star Office base?
- (a)
2
- (b)
4
- (c)
5
- (d)
3