The common column is eliminated in
theta join
outer join
natural join
composed join
Correct Answer :
C. natural join
Related Questions
The transactions like adding an employee, enrolling a student in a course are examples of _______
Logical
Physical
None
Theoretical
Which of the following aggregate functions does not ignore nulls in its results?.
COUNT .
COUNT (*)
MAX
MIN
Which one is true statement :
With finer degree of granularity of locking a high degree of concurrency is possible.
Locking prevents non-serializable schedules.
Locking cannot take place at field level.
An exclusive lock on data item X is granted even if a shared lock is already held on X.
The set of all values that can be taken by the attribute is called as _______ of the attribute.
Tuple
Cardinality
Degree
Domain
The cost of reading and writing temporary files while evaluating a query can be reduced by
building indices
pipelining
join ordering
none of the above
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 .
operator is used to compare a value to a list of literals values that have been specified.
Like
COMPARE
BETWEEN
IN
Relationships among relationships can be represented in an-E-R model using
Aggregation
Association
Weak entity sets
Weak relationship sets
Immediate database modification technique uses
Both undo and redo.
Undo but no redo.
Redo but no undo.
Neither undo nor redo.
The ______ language consists of SQL statements for operating on the data (insert, Modify, Delete) in tables that already exist.
Data Manipulation
Data Definition
Data Control
None
Wait-for graph is used for
detecting view serializability.
detecting conflict serializability.
deadlock prevention
deadlock detection
Which normal form is considered adequate for normal relational database design?
2NF
5NF
4NF
3NF
The fact that all employees of a particular organization should not have salaries more than $10000 is a _____ constraint.
Schema
Tuple
Domain
Relational
The collection of information stored in a database at a particular moment is called as ......
schema
instance of the database
data domain
independence
_____ database is used to provide statistical information or summaries of values based on various criteria.
Statistical
Mathematical
Normalized
Un normalized
In 2NF
No functional dependencies (FDs) exist.
No multivalued dependencies (MVDs) exist.
No partial FDs exist.
No partial MVDs exist.
The middleware databases in which the business rules act are applicable to _______ tier architectures
Single
Three
Two
None
A ______ module is typically designed so that it will run on a user workstation or personal computer.
Software
Server
Program
Client
The statement that is executed automatically by the system as a side effect of the modification of the database is
backup
assertion
recovery
trigger
By ______ an area on disk in certain ways, one can make it represent a bit value of either zero (0) or one (1).
Vulcanizing
Galvanizing
Magnetizing
Passing UV rays
In multiple granularity of locks SIX lock is compatible with
IX
IS
S
SIX
An outstanding functionality of SQL is its support for automatic_____ to the target data.
programming
navigation
functioning
notification
In a relational schema, each tuple is divided into fields called
Relations
Queries
Domains
All of the above
Which of the following is not a recovery technique?
Deferred update
Immediate update
Two-phase commit
Shadow paging
_____ First proposed the process of normalization.
Edgar. W
Edward Stephen
Edgar F. Codd
Edward Codd
What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are Base union compatible and all the rows of a are common to B? Assume A has 4 columns and 10 rows; and B has 4 columns and 15 rows
4,0
0,0
4,5
8,5
The clause in SQL that specifies that the query result should be sorted in ascending or descending order based on the values of one or more columns is
View
Order by
Group by
Having
The normal form that is not necessarily dependency preserving is
2NF
3NF
BCNF
4NF
The relational model is based on the concept that data is organized and stored in two-dimensional tables called ______
Fields
Records
Relations
Keys
Which of the following ensures the atomicity of the transaction?
Transaction management component of DBMS
Application Programmer
Concurrency control component of DBMS
Recovery management component of DBMS