Relational Algebra does not have
Selection operator.
Projection operator.
Aggregation operators.
Division operator.
Correct Answer :
C. Aggregation operators.
Related Questions
Which normal form is considered adequate for normal relational database design?
2NF
5NF
4NF
3NF
Drop Table cannot be used to drop a table referenced by a ______ constraint.
Primary Key
Local Key
Foreign Key
Composite Key
HSAM stands for ……….
Hierarchic Standard Access Method
Hierarchic Sequential Access Method
Hierarchic Sequential and Method
Hierarchic Standard and Method
Relational Algebra does not have
Selection operator.
Projection operator.
Aggregation operators.
Division operator.
Relationships among relationships can be represented in an-E-R model using
Aggregation
Association
Weak entity sets
Weak relationship sets
A _____ is a logical unit of database processing that includes one or more data access operations that can include insertion, deletion, modification or retrieval operations.
Database
Data
Transaction
Record
Manager salary details are hidden from the employee .This is
Conceptual level data hiding.
External level data hiding.
Physical level data hiding.
None of these.
DBMS is a collection of _____ that enables user to create and maintain a database.
Keys
Program
Translators
Language Activity
Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.
It will result in a deadlock situation.
It will immediately be rejected.
It will immediately be granted.
It will be granted as soon as it is released by A .
______is a preferred method for enforcing data integrity
Constraints
Triggers
Stored procedure
Cursors
Data independence means
data is defined separately and not included in programs.
programs are not dependent on the physical attributes of data
programs are not dependent on the logical attributes of data
both B and C
The _______ is a set of programs to use and / or modify this data.
DBMS
System
Program
Software
According to the levels of abstraction, the schema at the intermediate level is called
Logical schema.
Physical schema.
Subschema.
None of the above.
A DBMS is a ____ user if at most one user can use the system and is mostly restricted to personal computer systems.
None
Multi
Single
Concurrent
In an ER model,_____ is described in the database by storing its data.
Entity
Attribute
Relationship
Notation
Cascading rollback is avoided in all protocol except
strict two-phase locking protocol.
tree locking protocol
two-phase locking protocol
validation based protocol.
Shadow paging has
no redo
no undo
redo but no undo
neither redo nor undo
The full form of GUI is _________
Government Union Internet
Graphical Unit Interface
Graphical User Interface
Graphical University Interface
A data type or format is specified for each _________
Relation
Tuple
Database
Domain
The normalization was first proposed by .
Code
Codd
Boyce Codd
Boyce
If both the functional dependencies : X�Y and Y�X hold for two attributes X and Y then the relationship between X and Y is
M:N
M:1
1:M
Relations produced from an E-R model will always be
First normal form.
Second normal form.
Third normal form.
Fourth normal form.
Which of the following is not a recovery technique?
Deferred update
Immediate update
Two-phase commit
Shadow paging
Consider the join of relation R with a relation S. If R has m tuples and S has n tuples, then the maximum and minimum size of the join respectively are
m+n and 0
m+n and |m-n|
mn and 0
mn and m+n
If an entity can belong to only one lower level entity then the constraint is
disjoint
partial
overlapping
single
Processed data is called _____
Raw data
Source
Information
Useful data
Data items grouped together for storage purposes are called a
record
string
title
list
If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
left outer join
right outer join
full outer join
inner join
Which one is correct statement?
Logical data independence provides following without changing application programs:
(i) Changes in access methods.
(ii) Adding new entities in database
(iii) Splitting an existing record into two or more records
(iv) C
(i) and (ii)
(iv) only
(i) and (iv)
(ii) and (iii)
The values of the attribute describes a particular
Entity set
File
Entity instance
Organization