Which of the following constitutes a basic set of operations for manipulating relational data?
Predicate calculus
Relational calculus
Relational algebra
SQL
Correct Answer :
C. Relational algebra
Related Questions
Shadow paging has
no redo
no undo
redo but no undo
neither redo nor undo
Which of the syntax is correct for insert statement?
i) insert into values
ii) insert into (column list) values
ii) insert into
i-only
ii-only
Both of them
None of them
A logical schema
is the entire database
Describes how data is actually stored on disk.
is a standard way of organizing information into accessible parts.
All of the above
Whenever two independent one-to-many relationships are mixed in the same relation, a __________ arises.
Functional dependency
Multi-valued dependency
Transitive dependency
Partial dependency
Which of the following concurrency control schemes is not based on the serializability property?
Two - phase locking
Graph-based locking
Time-stamp based locking
None of these .
______is a preferred method for enforcing data integrity
Constraints
Triggers
Stored procedure
Cursors
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
HSAM stands for ……….
Hierarchic Standard Access Method
Hierarchic Sequential Access Method
Hierarchic Sequential and Method
Hierarchic Standard and Method
An advantage of views is
Data security
Derived columns
Hiding of complex queries
All of the above
A relation is in attribute of other composite key. if an attribute of a composite key is dependent on an
2NF
3NF
BCNF
1NF
A relational database developer refers to a record as
an attribute
a tuple
a criteria
a relation
Which of the following addressing modes permits relocation without any change over in the code?
Indirect addressing
Indexed addressing
PC relative addressing
Base register addressing
In E-R Diagram total participation is represented by
Double lines
Single line
Dashed lines
Triangle
DBMS is a collection of _____ that enables user to create and maintain a database.
Keys
Program
Translators
Language Activity
E-R Modeling is achieved by using ____ diagrams
DFD
Flowcharts
Gantt Charts
E-R
Immediate database modification technique uses
Both undo and redo.
Undo but no redo.
Redo but no undo.
Neither undo nor redo.
The fact that information in the data warehouse changes far less often and may be regarded as non-real-time with periodic updating; This implies that data warehouses are _______
Volatile
Non - Volatile
Logical
Physical
In an ER model,_____ is described in the database by storing its data.
Entity
Attribute
Relationship
Notation
Which of the following is true for network structure?
It is a physical representation of the data.
It allows many to many relationship.
It is conceptually simple.
It will be the dominant database of the future.
The data in the database at a particular moment of time is called the _______
Snapshot
Dynaset
Stateless
Stateful
When an E-R diagram is mapped to tables, the representation is redundant for
weak entity sets
weak relationship sets
strong entity sets
strong relationship sets
The data models defined by ANSI/SPARC architecture are
Conceptual, physical and internal
Conceptual, view and external
Logical, physical and internal
Logical, physical and view
A _____ is used to define overall design of the database
code
data definition language
application program
schema
Employees in a company are each assigned their own office, i.e. for each employee there exists a unique office and for each office there exists a unique employee; This statement is an example of ____ type of relation.
1:1
1: Many
Many: One
Many : Many
A ____ key specifies a uniqueness constraint that no two distinct tuples in any state r of relation R can have the same value for super key.
Sub
Parent
Candidate
Super
Which of the following is not a logical database structure?
Chain
Network
Tree
Relational
In SQL the word natural can be used with
inner join
full outer join
right outer join
all of the above
______ keyword is used to find the number of values in a column.
TOTAL
ADD
COUNT
SUM
Tree structures are used to store data in
Network model.
Relational model.
Hierarchical model.
File based system.