Related fields in a database are grouped to form a
data file.
data record.
menu.
bank.
Correct Answer :
B. data record.
Related Questions
A table that displays data redundancies yields ____________ anomalies
Insertion
Deletion
Update
All of the above
UML is stands for
Universal Modeling Language
Unified Modeling Language
United Modeling Language
Uni Modeling Language
A subschema expresses
the logical view.
the physical view.
the external view.
all of the above.
The language used in application programs to request data from the DBMS is referred to as the
DML
DDL
VDL
SDL
An entity set which have sufficient attributes to form a primary key
Tree structure
Subtree structure
Strong entity set
Table structure
Noisy channel has ……… .. types of protocols
two
three
four
none
The syntax to select all column from the table is
select all from tablename
select * from tablename
select from tablename
none of these
In an E-R diagram attributes are represented by
rectangle.
square.
ellipse.
triangle.
The maximum number of children in a B-tree of order m is
m+1
m
m-1
m/2
EEPROM
Electrically Extractable Programmable Read Only Memory
Electrically Erasable Programmable Read Only Memory
Electronically Erasable Programmable Read Only Memory
Electrically Erasable Programmable Read Only Memory
A transaction which may not complete its execution successfully is termed as
Failed
Aborted
Blocked
Finished
Database locking concept is used to solve the problem of
Lost Update
Uncommitted Dependency
Inconsistent Data
All of the above
Commit operation …………… writes the changes made to the database.
temporarily
permanently
none of these
all of the above
The statement in SQL which allows to change the definition of a table is
Select
Update
Create
Alter
Which of the following is not a constraint on a single relation?
check
unique
not null
is duplicate
which of the following is a binary operation?
project
select
rename
none of the above
What is ACID properties of Transactions?
Atomicity, Consistency, Isolation, Database
Atomicity, Consistency, Isolation, Durability
Atomicity, Consistency, Inconsistent, Durability
Automatically, Concurrency, Isolation, Durability
Which of the following works as a filter?
UPDATE
DROP
ALTER
SELECT
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.
Which of the following normalization is needed, if an attribute of a composite key is dependent on an attribute of the other composite key?
BCNF
Second
Third
Fourth
Radio frequencies below ............. are more suitable for omnidirectional applications.
300MHz
1GHz
5GHz
10 GHz
In an Entity-Relationship Diagram Diamonds represents
Attributes
Multi-valued attributes
Weak entity set
Relationship sets
Repeaters operate in
i) Physical layer
ii) Datalink layer
iii) Transport layer
iv) Network layer
i and ii only
ii and iii only
ii only
i only
In a Hierarchical model records are organized as
Graph.
List.
Links.
Tree.
A logical schema
is the entire database.
is a standard way of organizing information into accessible parts.
describes how data is actually stored on disk.
both A) and C)
Triggers are also called
active rules
passive rules
inferences
none of the above
View never contains derived columns.
True
False
Cant say
none
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 file organization provides very fast access to any arbitrary record of a file?
Ordered file
Unordered file
Hashed file
B-tree
Which of the following statement returns data to the host variables one at a time?
SELECT
RETURN
FETCH
GET