Explore topic-wise MCQs in Rdbms.

This section includes 6 Mcqs, each offering curated multiple-choice questions to sharpen your Rdbms knowledge and support exam preparation. Choose a topic below to get started.

1.

revoke select on takes from amit;
What does the above query perform?

A. tIt revokes all authorizations from amit
B. tIt revokes select authorization from amit
C. tIt revokes takes authorization from amit
D. tIt gives an error
Answer» C. tIt revokes takes authorization from amit
Discussion
2.

The _________ statement is used in SQL to confer authorization.

A. tgrant
B. tconfer
C. timplement
D. tpermit
Answer» B. tconfer
Discussion
3.

What does the following statement do?
create table temp_inst like institute

A. tIt creates a new relation temp_inst with all the tuples and attributes of the institute relation
B. tIt creates a new relation temp_inst with the same schema as that of the institute relation
C. tIt creates a new relation named temp_inst with institute as its only attribute
D. tIt does not create any relations and returns an error
Answer» C. tIt creates a new relation named temp_inst with institute as its only attribute
Discussion
4.

Which of the following is an illegal data type in SQL

A. tnumber
B. tclob
C. tblob
D. tlint
Answer» E.
Discussion
5.

What does p indicate in the following data type?
time(p)

A. tThe amount of delay that needs to be added to the time
B. tThe number of fractional digits for the seconds
C. tThe maximum number of allowed hours
D. tNone of the mentioned
Answer» C. tThe maximum number of allowed hours
Discussion
6.

Which of the following is not a valid Date and Time data type?

A. tdate
B. ttime
C. tdatestamp
D. ttimestamp
Answer» D. ttimestamp
Discussion