The _______ is a set of programs to use and / or modify this data.
DBMS
System
Program
Software
Correct Answer :
A. DBMS
Related Questions
If an entity can belong to only one lower level entity then the constraint is
disjoint
partial
overlapping
single
_______ product was acquired by Informix, integrated into its RDBMS and introduced as the Informix Universal Server an ORDBMS.
Star
llustar
SQL
Cygnus
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
DROP is a statement in SQL.
Query
Embedded SQL
DDL
DCL
Which of the following relational algebraic operations is not from set theory?
Union
Intersection
Cartesian Product
Select
Which normal form is considered adequate for normal relational database design?
2NF
5NF
4NF
3NF
Processed data is called _____
Raw data
Source
Information
Useful data
According to the levels of abstraction, the schema at the intermediate level is called
Logical schema.
Physical schema.
Subschema.
None of the above.
………………… approach reduces time and effort required for design and lesser risk in database management.
Single global database
Multiple databases
Top-down approach
None of the above
Which of the following constitutes a basic set of operations for manipulating relational data?
Predicate calculus
Relational calculus
Relational algebra
SQL
The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify a given tuple.
Primary
Foreign
Candidate
Alternate
In b-tree the number of keys in each node is than the number of its children.
one less
same
one more
half
For correct behaviour during recovery, undo and redo operation must be
Commutative
Associative
idempotent
distributive
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
DBMS is a collection of _____ that enables user to create and maintain a database.
Keys
Program
Translators
Language Activity
The rule that a value of a foreign key must appear as a value of some specific table is called a
Referential constraint.
Index.
Integrity constraint.
Functional dependency.
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
The _____ category includes storage media that can be operated on directly by the computers central processing unit.
Primary storage
Secondary Storage
All
Tertiary Storage
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
Protection of data from unauthorized Disclosure results in loss of _______
Integrity
Availability
Confidentiality
Discretionary Security
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 .
_____ First proposed the process of normalization.
Edgar. W
Edward Stephen
Edgar F. Codd
Edward Codd
The ______ indexes are forced to store only record IDs in the data structure and require at least one additional I/O Operation to retrieve the actual record.
Clustered
Hashed
Un-clustered
Collision
Drop Table cannot be used to drop a table referenced by a ______ constraint.
Primary Key
Local Key
Foreign Key
Composite Key
The set of all values that can be taken by the attribute is called as _______ of the attribute.
Tuple
Cardinality
Degree
Domain
Immediate database modification technique uses
Both undo and redo.
Undo but no redo.
Redo but no undo.
Neither undo nor redo.
The default level of consistency in SQL is
repeatable read
read committed
read uncommitted
serializable
Which of the following is not a property of transactions?
Atomicity
Concurrency
Isolation
Durability
What is data integrity?
It is the data contained in database that is non redundant.
It is the data contained in database that is accurate and consistent.
It is the data contained in database that is secured.
It is the data contained in database that is shared.
______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
Instance
Program
Schema
Super Key