Explore topic-wise MCQs in Rdbms.

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

1.

Which command is used to create a new relation in SQL

A. create table( , …)
B. create relation( , …)
C. new table( , …)
D. new relation( , …)Answer: aExplanation: We use the create table command to create a new relation in the database. The syntax is create table( , …);
Answer» E.
Discussion
2.

Which of the following data types does the SQL standard not support?

A. char(n)
B. String(n)
C. varchar(n)
D. float(n)
Answer» C. varchar(n)
Discussion
3.

Which of the following information does an SQL DDL not specify?

A. The schema for each relation
B. The integrity constraints
C. The operations on the tuples
D. The security and authorization information for each relation
Answer» D. The security and authorization information for each relation
Discussion