The method by which the structure of the database is modified to eliminate hidden dependencies and replacing groups is
Normalization
Indexing
Enforcing referential integrity
Enforcing data integrity
Correct Answer :
A. Normalization
Related Questions
Which of the following is/are error-free channel(s)
i) Noisy channel
ii) Noiseless channel
i only
ii only
Both
None of these
In ………… paging we make copy of the current page table.
physical
logical
shadow
duplicate
The transaction consists of all statements executed between
the begin transaction and end transaction
the start transaction and end transaction
the begin transaction and finish transaction
none of the above.
Thermal noise is often referred to as ............... noise, because it affects uniformly the different frequencies.
Gray
White
Blue
Black
Which of the following is not proper state of transaction ?
Partially aborted
Partially committed
Aborted
Committed
The syntax to select all column from the table is
select all from tablename
select * from tablename
select from tablename
none of these
Which of the following aggregate function doesnt ignore NULLs in its results?
COUNT
COUNT(*)
MAX
none of these
Noiseless channel has ……… types of protocols.
2
3
4
5
The maximum number of children in a B-tree of order m is
m+1
m
m-1
m/2
A data dictionary contains:
i) The name of all fields in all files.
ii) The data type of all fields in all files.
iii) The width of all fields in all files.
only i)
only i) and ii)
only ii) and iii)
i) ii) iii)
A composite attribute is converted to individual attributes in which of the following normal form ?
first
Second
third
fourth
RAID
Redundant Arrays of Independent Disks
Redundant Arrays of Independent Drives
Redundant Arrays of Interconnected Drives
Redundant Arrays of Interconnected Disks
Expand the acronym OLAP
Object Linked Access Program
Organizational Architecture Processing
Online Analytical Processing
none of these
The degree of the table with 500 rows and 7 columns is
500
7
3500
none of these
The physical location of a record is determined by a mathematical formula that transforms
a file key into a record location is :
B-Tree File
Hashed File
Indexed File
Sequential file.
Authorization command in SQL
Allow
Access
Grant
none of the above
What does a field or a combination of fields that has a unique value called ?
Foreign key
Secondary key
Primary key
Alternate key
In two-phase locking
the data items are locked in growing phase.
the data items are released in shrinking phase.
Both A and B are true
Both A and B are false
It is possible to define a schema completely using
VDL and DDL.
DDL and DML.
SDL and DDL.
VDL and DML.
Which of the following produces the relation that has attributes of R1 and R2
Cartesian product
Difference
Intersection
Product
Which command is used to cancel privileges granted through the GRANT command ?
CANCEL
OVER
STOP
REVOKE
The privilege lists include
i) select
ii) insert
iii) update
iv) delete
only i)
only i) ii)
only i) ii) iii)
i) ii) iii) iv)
Which of the following statement returns data to the host variables one at a time?
SELECT
RETURN
FETCH
GET
What are the different types of radio waves that are used for computer network applications?
i) Spread spectrum
ii) High power, single frequency
iii) High power, multiple frequency
iv) Low power, single frequency
v) Low power, multiple frequency
i, ii and iii only
i, ii and iv only
ii, iii and iv only
i, iii and iv only
A transaction is said to have terminated if it has
either committed or aborted
either partially committed or aborted
either committed or failed
none of these
Which of the following layer uses trailer of the frame for error detection?
Transport layer
Network layer
Datalink layer
None of these
The method by which the structure of the database is modified to eliminate hidden dependencies and replacing groups is
Normalization
Indexing
Enforcing referential integrity
Enforcing data integrity
In an Entity-Relationship Diagram Ellipses represents
Attributes
Weak entity set
Relationship sets
Multi-valued attributes
Unwanted energy from source other than the transmitter.
Attenuation
Distortion
Delay
Noise
Which of the following will NOT eliminates the ambiguities of a null value?
Define the attribute as required
Define subtypes
Define each attribute as having an initial value that is recognized as blank
Define supertypes