Range variables are designed using the
TO clause
FROM clause
RANGE clause
none of the above
Correct Answer :
C. RANGE clause
Related Questions
Mail services are available to network users through the
Session layer
Presentation layer
Application layer
Transport layer
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
The types of noiseless channels are
i) Selective Reject ARQ
ii) simplest protocol
iii) Go-Back-N ARQ
iv) Stop-and-Wait Protocol
i, ii only
ii and iv only
ii and iv only
i, iv only
Related fields in a database are grouped to form a
data file.
data record.
menu.
bank.
Consider the join of a relation R with relation S. If R has m tuples and S has n tuples,
then the maximum size of join is:
mn
m+n
m+n)/2
2 m+n)
The database environment has all of the following components except:
users.
separate files.
database.
database administrator.
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)
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
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 language used in application programs to request data from the DBMS is referred to as the
DML
DDL
VDL
SDL
Secondary storage
magnetic disk
magnetic tape
juke box
cache
An advantage of the database management approach is
data is dependent on programs.
data redundancy increases.
data is integrated and can be accessed by multiple programs.
none of the above.
A subschema expresses
the logical view.
the physical view.
the external view.
all of the above.
Data stored in cursor is called ……………
record
active data set
object
none of the above
Commit operation …………… writes the changes made to the database.
temporarily
permanently
none of these
all of the above
Multivalued dependency is removed in
4 NF
3 NF
2 NF
1 NF
In E-R diagram Generalization is represented by
Circle
Rectangle
Hyperbola
Triangle
The number of cursors depend on the
number of queries
number of attributes
size of memory area
none of these
Which of the following Key is used to represent relationship between the tables?
Primary key
Secondary Key
Foreign Key
None of these
The union of primary keys of a related entity becomes …………. Of a relation.
primarykey
superkey
candidatekey
foreignkey
A DBMS query language is designed to
support end users who use English-like commands.
support in the development of complex applications software.
specify the structure of a database.
all of the above.
Which of the following is not an Aggregate function?
Min
Max
Select
Avg
Triggers are also called
active rules
passive rules
inferences
none of the above
DBMS helps achieve
Data independence
Centralized control of data
Neither A) nor B)
both A) and B)
A transaction has following states
i) Active
ii) Fail
iii) Abort
iv) Commit
i and ii only
ii and iii only
i and iii only
iii and iv only
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
The statement in SQL which allows to change the definition of a table is
Select
Update
Create
Alter
The ability to modify the conceptual schema without causing any change to the application program is known as
Physical data independence
Logical data independence
External data independence
Static data
The left outer join takes all tuples
in the left relation which didnt match with any tuple in right relation
in the left relation which matched with a tuple in right relation
in the right relation which didnt match with any tuple in left relation
in the right relation which matched with a tuple in left relation
The collection of information stored in a database at a particular moment is?
View
Instance
Scheme
None of these