DBMS helps achieve
Centralized control of data
Data independence
Both A and B
Neither A nor B
Correct Answer :
C. Both A and B
Related Questions
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
An advantage of views is
Data security
Derived columns
Hiding of complex queries
All of the above
Key to represent relationship between tables is called
primary key
secondary key
foreign key
none of the above
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
_______ product was acquired by Informix, integrated into its RDBMS and introduced as the Informix Universal Server an ORDBMS.
Star
llustar
SQL
Cygnus
In multiple granularity of locks SIX lock is compatible with
IX
IS
S
SIX
The common column is eliminated in
theta join
outer join
natural join
composed join
A list consists of last names, first names, addresses and pin codes. If all people in the list have the same last name and same pin code a useful key would be
the pin code
the last name
the compound key first name and last name
Tr from next page
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
______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
Instance
Program
Schema
Super Key
The data in the database at a particular moment of time is called the _______
Snapshot
Dynaset
Stateless
Stateful
The division operator divides a dividend A of degree m+n by a divisor relation B of degree n and produces a result of degree
m - 1
m + 1
m * m
m
The normalization was first proposed by .
Code
Codd
Boyce Codd
Boyce
Create a table with the following attributes: Employee(EMPNO integer, EMPNAME of 10 characters)
Create table Employee(EMPNO int, EMPNAME char(10));
Create table Employee(EMPNO integer, EMPNAME String(10));
Create table Emplo(EMPNO number, EMPNAME string);
Create table Emp(EMPNO int, EMPNAME char(10));
In an ER diagram the ___shape specifies the Attibute and a ____ shape specifies the primary key attribute.
Oval; An oval with an underlined attribute
Circle; A circle with bolded attribute inside it
Diamond; A bolded attribute
Square; An attribute within the square
DBMS is a collection of _____ that enables user to create and maintain a database.
Keys
Program
Translators
Language Activity
operator is used to compare a value to a list of literals values that have been specified.
Like
COMPARE
BETWEEN
IN
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 is not a characteristic of a relational database model?
Table
Tree like structure
Complex logical relationship
Records
The transactions like adding an employee, enrolling a student in a course are examples of _______
Logical
Physical
None
Theoretical
As per equivalence rules for query transformation, selection operation distributes over
Union.
Set difference.
Intersection.
All of the above.
Which of the following relational algebraic operations is not from set theory?
Union
Intersection
Cartesian Product
Select
Which of the following is a reason to model data?
Understand each user's perspective of data
Understand the data itself irrespective of the physical representation
Understand the use of data across application areas
All of the above
A table can have only one
Secondary key
Alternate key
Unique key
Primary key
The default level of consistency in SQL is
repeatable read
read committed
read uncommitted
serializable
HSAM stands for ……….
Hierarchic Standard Access Method
Hierarchic Sequential Access Method
Hierarchic Sequential and Method
Hierarchic Standard and Method
A relation is in attribute of other composite key. if an attribute of a composite key is dependent on an
2NF
3NF
BCNF
1NF
Maximum height of a B+ tree of order m with n key values is
Logm(n)
(m+n)/2
Logm/2(m+n)
None of these
Wait-for graph is used for
detecting view serializability.
detecting conflict serializability.
deadlock prevention
deadlock detection
Dependency preservation is not guaranteed in
BCNF
3NF
PJNF
DKNF