C:-Mysql
D:-Sql server
Correct Answer:- Option-A
Question41:-Which one of the following is used to create a virtual relation for storing a query?
A:-view
B:-function
C:-procedure
D:-table
Correct Answer:- Option-A
Question42:-which one of the following option clause is used with view to reject the tuples that do not satisfy the "where
condition"?
A:-with
B:-with check
C:-check
D:-none of these
Correct Answer:- Option-B
Question43:-When using Foreign Key, the ___ of one relation is referenced in another relation
A:-Foreign Key
B:-Primary Key
C:-Check constraint
D:-None of these
Correct Answer:- Option-B
Question44:-___is the preferred method for enforcing data integrity
A:-Constraints
-Triggers
C:-Cursors
D:-Stored Procedure
Correct Answer:- Option-A
Question45:-What values does the count(*)function ignore?
A:-null values
B:-Integer
C:-character
D:-none of these
Correct Answer:- Option-A
Question46:-The ___ statement is used in SQL for authorization
A:-implement
B:-revoke
C:-grant
D:-none of these
Correct Answer:- Option-C
Question47:-___ is executed when a table is modified
A:-procedure
B:-function
C:-trigger
D:-none of these
Correct Answer:- Option-C
Question48:-Which of the following command is used to delete a particular column in a relation?
A:-DELETE
B:-ALTER
C:-UPDATE
D:-DROP
Correct Answer:- Option-B
Question49:-A transaction completes its execution is said to be
A:-Saved
B:-Rolled
C:-Committed
D:-Loaded
Correct Answer:- Option-C
Question50:-The language used in application program to request for data from DBMS is