Explore topic-wise MCQs in Rdbms.

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

1.

How can we insert data into a view?

A. insert into ();
B. create data values ();
C. enter ();
D. insert into values ();Answer: dExplanation: We can insert data into a view using the inset into values (); statement. This operation can be done only if the view is updatable.
Answer» C. enter ();
Discussion
2.

State true or false: One view can be used in the expression defining another view

A. True
B. False
Answer» B. False
Discussion
3.

create view studentdetselect ID, address, namefrom student; What is the result of the above query?

A. It creates a view named studentdet with 3 attributes
B. It creates a view named studentdet with 1 attribute
C. It creates a view named ID with 2 attributes
D. It is syntactically wrong and does not give a resultView Answer
Answer» E.
Discussion
4.

What is a view?

A. An brief description of the schema diagram.
B. A relation that is not a part of the schema but is a virtual relation
C. Any relation that is a part of the schema
D. A relation that is a part of the schema but which needs to be specified in every operation made on that particular relation.
Answer» C. Any relation that is a part of the schema
Discussion
5.

The process of maintaining views up to date is called _________

A. View maintenance
B. View updating
C. View materialization
D. View isolation
Answer» E.
Discussion
6.

If the actual relations used in the view definition change, the view is updated immediately. Such views are called _________

A. Instant views
B. Instantaneous views
C. Materialistic views
D. Materialized views
Answer» B. Instantaneous views
Discussion
7.

What is the command used to define view in SQL?

A. define view
B. new view
C. create view
D. none of the mentioned
Answer» D. none of the mentioned
Discussion