Database Management System
Questions 221 to 230
221.
|
The relational
database model presents data in the form of __________
(a) Table (b) Record (c) Entities (d) Objects (e) Nodes.
|
A row in a relation
is called
(a) Record (b) Entity (c) Tuple (d) Table (e) Data.
|
|
Any set of
attributes that uniquely identifies each tuple in a relation is termed as
_________
(a) Foreign key (b) Primary key (c) Super key (d) Candidate key (e) Unique.
|
|
_______ is a set of
statements that allows SQL to be used with traditional programming languages.
(a) Common SQL (b) Embedded SQL (c)
SEQUEL
(d)
QBE (e) QUEL.
|
|
_______ is a
procedural language for manipulating relations.
(a) Relational algebra (b)
Rational algebra (c) DML
(d)
SQL (e) Domain algebra.
|
|
A database spread
among a network of geographically separated location is. ____________________
(a) OODBMS (b) Network DBMS (c) Distributed DBMS
(d)
DBMS (e) None of the above.
|
|
_______ constraints
maintains uniqueness in a record.
(a) Entity integrity (b) Referential
Integrity (c)
Domain Integrity
(d)
Check integrity (e) None.
|
|
_________ is a
predicate expressing a condition that always must be satisfied.
(a) Assertion (b) Trigger (c) Procedure
(d)
Function (e) Generalization.
|
|
The Subsystems
responsible for the allocation of buffer space is called __________
(a) Buffer manager (b)
Cache manager
(c) System manager
(d)
Disk manager (e) File manager.
|
|
________is a
unit program execution that can be accessed and possibly updated various data
items.
(a) Transactions (b) File (c) Database (d) Equerry (e) None.
|
Answers
231.
|
Answer : (c)
Reason : Recovery is not a acid property.
|
Answer : (b)
Reason : Skew is a major problem with increasing
degree of parallelism.
|
|
Answer : (b)
Reason : Inter query.
|
|
Answer : (b)
Reason : Location transparency.
|
|
Answer : (b)
Reason :
writing the buffered log to a disk is referred as log force.
|
|
Answer : (e)
Reason : Recovery Manager.
|
|
Answer : (b)
Reason : Three-phase commit protocol is used to avoid
blocking in two phase commit protocol.
|
|
Answer : (b)
Reason : Two
schemes are there for fragmenting a relation in distributed data
storage.
|
|
Answer : (c)
Reason : .CODASYL.
|
|
Answer : (a)
Reason : Database change Log contains before and after
images of records that have been modified by transactions.
|
Thanks for sharing it
ReplyDeleteI really like it this kind of information..........Great blog post and really helpful...... and your blog are very interesting and inspiring.
Midnightinfo
CRPF ASI Steno Answer key 2017
HPU BSc Nursing Answer Key 2017
GATE Application Form 2018
JCECEB Para Medical Answer Key 2017
Bihar TET Admit Card
TS EdCET Answer Key
APPSC Group 2 Answer Key
Nice information
ReplyDeletedbms interview questions
spring interview questions