Which command is used to cancel privileges granted through the GRANT command ?
CANCEL
OVER
STOP
REVOKE
Correct Answer :
D. REVOKE
Related Questions
DBMS utility which allows to reconstruct the correct state of database from the backup and history of transactions
Backup
Recovery
Grant
Troubleshooting
Data independence means
data is defined separately and not included in programs.
programs are not dependent on the physical attributes of data.
programs are not dependent on the logical attributes of data.
both B) and C).
Thermal noise is often referred to as ............... noise, because it affects uniformly the different frequencies.
Gray
White
Blue
Black
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
Mail services are available to network users through the
Session layer
Presentation layer
Application layer
Transport layer
Commit operation …………… writes the changes made to the database.
temporarily
permanently
none of these
all of the above
A transaction which completes successfully is called
Granted
Committed
Compensated
Accomplished
Which of the following is not an Aggregate function?
Min
Max
Select
Avg
Which of the following is not a database object?
index
sequence
cursor
trigger
The statement in SQL which allows to change the definition of a table is
Select
Update
Create
Alter
Size of source and destination address in IP header
4 bits
8 bits
12 bits
32 bits
A transaction which may not complete its execution successfully is termed as
Failed
Aborted
Blocked
Finished
The physical path over which a message travels
Thermal
Medium
Protocol
Impulse
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
Noisy channel has ……… .. types of protocols
two
three
four
none
A logical description of some portion of database that is required by a user to perform task is called as
System View
User View
Logical View
Data View
Cross Product is a:
Unary Operator
Binary Operator
Ternary Operator
none of the above
Log into a computer across an internet
IMAP
TELNET
POP3
Infrared
Select the incorrect statement
BCNF is stronger than 3NF
Relational algebra is a non-procedural language
Every conflict serializable schedule is view serializable.
none of the above
What is the max data capacity of STP?
1 Gbps
56 Mbps
100 Mbps
256 Mbps
A subschema expresses
the logical view.
the physical view.
the external view.
all of the above.
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
Specialization is a
top-down approach.
bottom-up approach.
left-right approach.
none of the above
The maximum number of children in a B-tree of order m is
m+1
m
m-1
m/2
A type of query that is placed within a WHERE or HAVING clause of another query is called
Super query
Sub query
Master query
Multi-query
In an E-R diagram attributes are represented by
rectangle.
square.
ellipse.
triangle.
In an Entity-Relationship Diagram Diamonds represents
Attributes
Multi-valued attributes
Weak entity set
Relationship sets
The host part in a class A type of an IP address has
12 bits
16 bits
24 bits
28 bits
Select the incorrect statement(s)
i) Foreign key values can be left blank
ii) In SQL duplicates may be present
iii) Theta join operation doesnt remove duplicate columns.
iv) NULL value means string of blank characters.
i ,iii only
ii, iv only
iii, iv only
ii, iii, iv
FDDI protocol operates in
i) Transport layer
ii) Network layer
iii) Datalink layer
iv) Physical layer
i and ii only
ii and iii only
i and iii only
iii and iv only