Databases MCQ with Answers

Databases MCQ with Answers

117) _________ is a virtual table that draws its data from the result of an SQLSELECT statement.

Answer is:

View

118) _________ data type can store unstructured data

Answer is:

RAW

119) A relational database contains two tables student and department in which student table has columns (roll_no, name and dept_id )and department table has columns (dept-id and dept-name). The following insert statements were executed successfully to populate the empty tables:
Insert into department values (1, 'Mathematics');
Insert into department values(1, 'Physics');
Insert into department values(1, 'Navin', 1);
Insert into student values (2, 'Ravi'

Answer is:

6 rows and 5 columns

120) Transaction processing is associated with everything below except

Answer is:

Confirming an action or triggering a response