The index table has …… Columns.
1
2
3
4
Correct Answer :
B. 2
Related Questions
In mesh topology, if the number of devices is n , then the number of ports present in each device is
n
n+1
n-1
n/2
DBMS helps achieve
Data independence
Centralized control of data
Neither A) nor B)
both A) and B)
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.
A lock that allows concurrent transactions to access different rows of the same table is known as a
Field-level lock
Row-level lock
Table-level lock
Database-level lock
The collection of information stored in a database at a particular moment is?
View
Instance
Scheme
None of these
The command used to delete a particular column in a relation
UPDATE
DROP
ALTER
DELETE
Select the incorrect statement
BCNF is stronger than 3NF
Relational algebra is a non-procedural language
Every conflict serializable schedule is view serializable.
none of the above
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
A transaction which completes successfully is called
Granted
Committed
Compensated
Accomplished
.................. occurs due to velocity of propagation the frequency varies. Thus various frequency components of a signal arrive at the receiver at different times.
Noise
Delay distortion
Attenuation distortion
Dispersion
Data fragmentation is performed by the …… and each fragment is stored at…………..
DBMS, same site
OS ,same site
DBMS ,different site
OS ,different site
Tertiary storage
magnetic tape
juke box
optical disk
All of the above
Extended Entity Relationship model consists of which of the following
i) Specialization
ii) Generalization
iii) Categorization
i and ii only
ii and iii only
i and iii only
All i, ii iii
Which one of the following statements is false?
The data dictionary is normally maintained by the database administrator.
Data elements in the database can be modified by changing the data dictionary.
The data dictionary contains the name and description of each data element.
The data dictionary is a tool used exclusively by the database administrator.
Specialization is a
top-down approach.
bottom-up approach.
left-right approach.
none of the above
File organization that provides fast access to any arbitrary record
Hashed file
B-tree
Ordered file
Unordered file
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.
Tape storage is referred to as
sequential access storage
direct access storage
random access storage
none of the above
which of the following is a binary operation?
project
select
rename
none of the above
Natural mask for a Class A network
255.0.0.0
255.255.0.0
255.255.255.0
none of these
Data integrity refers to
the uniqueness of the data in a database
the correctness and completeness of the data in a database
the un redundancies of the data in a database
Data independence of the database
A …………… is a memory area where data are processed.
view
trigger
cursor
none of the above
Data stored in cursor is called ……………
record
active data set
object
none of the above
Which of the following Key is used to represent relationship between the tables?
Primary key
Secondary Key
Foreign Key
None of these
Which of the following is not a database object?
index
sequence
cursor
trigger
When all attributes in a relation tuple are not functionally dependent only on the key attribute. Which of the following normalization is needed?
first
second
third
fourth
A functional dependency between two or more non-key attributes is called
Transitive dependency
Partial transitive dependency
Functional dependency
Partial functional dependency
Electromagnetic spectrum included in radiowaves are
i) Super High Frequency (SHF)
ii) Very High Frequency (VHF)
iii) Ultra High Frequency (UHF)
iv) High Frequencies (HF)
i, ii and iii only
i, ii and iv only
ii, iii and iv only
i, iii and iv only
Related fields in a database are grouped to form a
data file.
data record.
menu.
bank.
Technique(s) used for data recovery after any failure
Logging
Recovery manager
Both A and B are true
Both A and B are false