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.
Correct Answer :
B. Data elements in the database can be modified by changing the data dictionary.
Related Questions
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)
In RDBMS, Data is presented as a collection of
Relation
Table
Attribute
Entity
An entity set which have sufficient attributes to form a primary key
Tree structure
Subtree structure
Strong entity set
Table structure
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
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
The ________ states that a foreign key must either match a primary key value in another relation or it must be null.
entity integrity rule
referential integrity constraint
composite attribute
action assertion
Natural mask for a Class A network
255.0.0.0
255.255.0.0
255.255.255.0
none of these
Which of the following concurrency control schemes is not based on serializability property?
Two-phase locking
Timestamped based locking
Graph-based locking
none of the above
The control of concurrent execution is left with the
operating system
controller unit of the kernel
concurrency control component of the database system
none
Three SQL, DDL, CREATE commands are
Schema, Base and Table
Schema, Table and View
Base, Table and Schema
Key, Base and Table
What does a field or a combination of fields that has a unique value called ?
Foreign key
Secondary key
Primary key
Alternate key
An operation that will increase the length of a list is
insert
modify
lookup
none of the above
Multivalued dependency is removed in
4 NF
3 NF
2 NF
1 NF
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.
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.
Primary storage
magnetic disk
magnetic tape
juke box
cache
In an E-R diagram attributes are represented by
rectangle.
square.
ellipse.
triangle.
In defining the notion of the tuple variable, which one of the clause is useful?
as
by
from
none of the above
A …………… is a memory area where data are processed.
view
trigger
cursor
none of the above
In an Entity-Relationship Diagram Diamonds represents
Attributes
Multi-valued attributes
Weak entity set
Relationship sets
Mail services are available to network users through the
Session layer
Presentation layer
Application layer
Transport layer
The exists construct returns the value true, if the argument subquery is
empty
nonempty
contains null values
none of the above
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
Usenet is also known as
Newsgroups
10Km to 1Km
10^3Km to 100Km
100M to 10M
Which of the following is not an Aggregate function?
Min
Max
Select
Avg
A data manipulation command the combines the records from one or more tables is called
SELECT
PROJECT
JOIN
PRODUCT
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/are error-free channel(s)
i) Noisy channel
ii) Noiseless channel
i only
ii only
Both
None of these
The access protocol used by traditional Ethernet
CSMA/CA
CSMA/CD
CSMA
Token ring
Which of the following submit and execute query at run time?
Static SQL
Dynamic SQL
both
none of these