Which of the following is not a database object?
index
sequence
cursor
trigger
Correct Answer :
C. cursor
Related Questions
A relation which is in 3NF is
in 1NF also
in 2NF also
free from transitive dependencies
All of these
Which of the following is also known as Offline storage ?
primary storage
secondary storage
tertiary storage
none of the above
Symbol to represent weak entity set in ER Model
Dotted rectangle
Square
Doubly outlined rectangle
Diamond
By default a user who has been granted some form of authorization
is allowed to pass them to others
is not allowed to pass them to others
may be or may not be allowed to pass them to others
none
Transaction access data using two operations
read(), print()
read(), write()
scan(), write()
none of the above
Object based data models are used in describing the abstraction of the following levels?
Conceptual and view
Only physical
Physical and conceptual
Only conceptual
The statement
Every foreign-key value must match a primary-key value in an associated table
Is related to
View
Cursor defination
Referential intergrity
Trigger
View never contains derived columns.
True
False
Cant say
none
Benefit of database normalization is
smaller number of tables
higher query processing efficiency
reduced I/O for most queries
reduced data redundancy
If the .................... is too much, the receiver may not be able to detect the signal at all or the signal may fall below the noise level.
Noise
Delay
Dispersion
Attenuation
The minimal set of super key is called
Primary key
Secondary key
Candidate key
Foreign key
Specialization is a
top-down approach.
bottom-up approach.
left-right approach.
none of the above
A transaction which completes successfully is called
Granted
Committed
Compensated
Accomplished
The exists construct returns the value true, if the argument subquery is
empty
nonempty
contains null values
none of the above
Data Manipulation Language DML) is not to
Create information table in the Database
Insertion of new information into the Database
Deletion of information in the Database
Modification of information in the Database
An entity set that does not have sufficient attributes to form a primary key is a
strong entity set.
weak entity set.
simple entity set.
primary entity set.
Which of the following produces the relation that has attributes of R1 and R2
Cartesian product
Difference
Intersection
Product
…………… is responsible for using that the database remains in a consistent state despite system failure.
Storage manager
Admin
Transaction manager
none of the above
Which of the following is also known as Offline storage ?
primary storage
secondary storage
tertiary storage
none of the above
Multivalued dependency is removed in
4 NF
3 NF
2 NF
1 NF
Authorization command in SQL
Allow
Access
Grant
none of the above
............... noise is caused by the random motion of the electrons in a wire and is avoidable.
Thermal
Intermodulation
Cross talk
Impulse
A table that displays data redundancies yields ____________ anomalies
Insertion
Deletion
Update
All of the above
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.
Commit operation …………… writes the changes made to the database.
temporarily
permanently
none of these
all of the above
Size of source and destination address in IP header
4 bits
8 bits
12 bits
32 bits
Transaction processing is associated with everything below except
producing detail, summary, or exception reports.
recording a business activity.
confirming an action or triggering a response.
maintaining data.
Log into a computer across an internet
IMAP
TELNET
POP3
Infrared
B-Tree is used for
searching data
storing data
both A and B
none of these
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)