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)
Correct Answer :
D. i) ii) iii)
Related Questions
The race condition occurs when
Two concurrent processes attempt to interact with each other.
Two concurrent processes interact with different data files.
Two concurrent processes attempt to hold a data item .
none of the above.
In two-phase locking protocol the two phases are
growing phase and shrinking phase
execution phase and blocking phase.
running phase and sleeping phase.
none of the above
Secondary storage
magnetic disk
magnetic tape
juke box
cache
Which of the following is logical topology?
Bus
Ring
Star
None of these
Related fields in a database are grouped to form a
data file.
data record.
menu.
bank.
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
An entity set which have sufficient attributes to form a primary key
Tree structure
Subtree structure
Strong entity set
Table structure
A relation that has no partial dependencies is in which normal form
First
Second
Third
BCNF
............... noise is caused by the random motion of the electrons in a wire and is avoidable.
Thermal
Intermodulation
Cross talk
Impulse
The union of primary keys of a related entity becomes …………. Of a relation.
primarykey
superkey
candidatekey
foreignkey
Range variables are designed using the
TO clause
FROM clause
RANGE clause
none of the above
Volatile storage
loses its contents when power is switched off.
doesnt loses its contents when power is switched off.
creates backup when power is switched off.
none
Symbol to represent weak entity set in ER Model
Dotted rectangle
Square
Doubly outlined rectangle
Diamond
Which of the following submit and execute query at run time?
Static SQL
Dynamic SQL
both
none of these
Radio frequencies below ............. are more suitable for omnidirectional applications.
300MHz
1GHz
5GHz
10 GHz
In client/server computing data are
sent only upon the client's request
sent in complete copies for the client to filter and sort
never sent to the client machine
sent in very large sections to save processing time
In which of the following transmissions, we can send data by grouping n bits at a time instead of a single bit?
parallel
serial
analog
digital
which of the following is a binary operation?
project
select
rename
none of the above
Specialization is a
top-down approach.
bottom-up approach.
left-right approach.
none of the above
As a side-effect of database update ,the system automatically executes a statement called
a view
a grant permission
a trigger
all of the above
Data fragmentation is performed by the …… and each fragment is stored at…………..
DBMS, same site
OS ,same site
DBMS ,different site
OS ,different site
Which of the following is the unit of signaling speed or modulation rate or the rate of symbol transmission?
Data rate
Bit rate
Signal to Noise Ratio
Baud rate
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
Select the incorrect statement
View is derived from other tables.
Once a transaction has executed commit work its effect cant be undone by rollback work .
The input to the aggregate function avg can be non numeric data types
A primary key can never be null.
A transaction which completes successfully is called
Granted
Committed
Compensated
Accomplished
Query processing is
converting data to insert in a database
translation of query to lower form
range of activities involved in extracting data from a database
none of the above
A type of query that is placed within a WHERE or HAVING clause of another query is called
Super query
Sub query
Master query
Multi-query
The statement in SQL which allows to change the definition of a table is
Select
Update
Create
Alter
Count function in SQL returns the number of
values.
distinct values.
groups.
columns.
Which of the following produces the relation that has attributes of R1 and R2
Cartesian product
Difference
Intersection
Product