The size of a data item is called its _______, which can be a field of some record or may be a larger unit such as a record.
Similarity
Granularity
Dimensionality
Arity
Correct Answer :
B. Granularity
Related Questions
Grant and revoke are _____ statements.
TCL
DCL
DDL
DML
A ____ key specifies a uniqueness constraint that no two distinct tuples in any state r of relation R can have the same value for super key.
Sub
Parent
Candidate
Super
DBMS is a collection of _____ that enables user to create and maintain a database.
Keys
Program
Translators
Language Activity
The default level of consistency in SQL is
repeatable read
read committed
read uncommitted
serializable
In multiple granularity of locks SIX lock is compatible with
IX
IS
S
SIX
An outstanding functionality of SQL is its support for automatic_____ to the target data.
programming
navigation
functioning
notification
Which of the following is not a property of transactions?
Atomicity
Concurrency
Isolation
Durability
A list consists of last names, first names, addresses and pin codes. If all people in the list have the same last name and same pin code a useful key would be
the pin code
the last name
the compound key first name and last name
Tr from next page
In E-R Diagram total participation is represented by
Double lines
Single line
Dashed lines
Triangle
The transactions like adding an employee, enrolling a student in a course are examples of _______
Logical
Physical
None
Theoretical
The values of the attribute describes a particular
Entity set
File
Entity instance
Organization
The cost of reading and writing temporary files while evaluating a query can be reduced by
building indices
pipelining
join ordering
none of the above
The ______ indexes are forced to store only record IDs in the data structure and require at least one additional I/O Operation to retrieve the actual record.
Clustered
Hashed
Un-clustered
Collision
In 2NF
No functional dependencies (FDs) exist.
No multivalued dependencies (MVDs) exist.
No partial FDs exist.
No partial MVDs exist.
Shadow paging has
no redo
no undo
redo but no undo
neither redo nor undo
The data in the database at a particular moment of time is called the _______
Snapshot
Dynaset
Stateless
Stateful
______contains information that defines valid values that are stored in a column or data type.
Default
Index
Rule
View
The clause alter table in SQL can be used to
add an attribute
delete an attribute
alter the default values of an attribute
all of the above
A DBMS is a ____ user if at most one user can use the system and is mostly restricted to personal computer systems.
None
Multi
Single
Concurrent
The size of a data item is called its _______, which can be a field of some record or may be a larger unit such as a record.
Similarity
Granularity
Dimensionality
Arity
The _____ category includes storage media that can be operated on directly by the computers central processing unit.
Primary storage
Secondary Storage
All
Tertiary Storage
_____is a full form of SQL.
Standard query language
Sequential query language
Structured query language
Server side query language
In SQL the statement select * from R, S is equivalent to
Select * from R natural join S.
Select * from R cross join S.
Select * from R union join S.
Select * from R inner join S.
When an E-R diagram is mapped to tables, the representation is redundant for
weak entity sets
weak relationship sets
strong entity sets
strong relationship sets
The concept of mapping of ______ entity types is the concept in which the for each strong entity type E in the ER schema, create a relation R that includes all the simple attributes of E.
Regular
Irregular
None
Weak
Which one is true statement :
With finer degree of granularity of locking a high degree of concurrency is possible.
Locking prevents non-serializable schedules.
Locking cannot take place at field level.
An exclusive lock on data item X is granted even if a shared lock is already held on X.
Manager salary details are hidden from the employee .This is
Conceptual level data hiding.
External level data hiding.
Physical level data hiding.
None of these.
Data items grouped together for storage purposes are called a
record
string
title
list
A ______ module is typically designed so that it will run on a user workstation or personal computer.
Software
Server
Program
Client
Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are
distinct values
cannot have NULL
both (A) & (B)
same as primary key