Multiple Choice Questions for Data Manipulation Language (DML)
×
Hidden Questions!
Some MCQs are not visible. Usually teachers hides their visibility if they are few in number. Subject Expert recommends them to have more than 70+ questions against the topic and make them public.
1
Which of the following keyword is used while replacing the values of the column.
7
Which type of join includes, not only those matched rows from the left side table, but also those rows of the right table that are unmatched with rows from the first (left) table.
9
The sql statement “ Insert into studentsTable ( name, age) values ( ‘ Ali ’ ) ”, contains error. Which one best option of the following can be applied to remove the error, and to save the value(s) in studentsTable?
11
To display data from four tables which have linked records through primary key and foreign key relationships in the database, what exact number of join conditions are needed in the query?
12
If a tuple of a parent relation is deleted, referential integrity is lost if there exists a child tuple referencing the deleted parent tuple. In order to maintain the integrity, there are several strategies we can consider which of the following?