Advanced SQL Mcqs

Our collections of Multiple choice questions and answers focuses on study of ” Advanced SQL “. These questions are chosen from a collection of most authoritative and best reference books on DBMS.Our aim is to prepare an individual for competitive exams like NTS | GAT | ECAT | Data Warehouse jobs | Data Mining | DB administration jobs | Nadra Jobs | Software House and Data Base and Web Developer jobs | University and College entrance exams and various tests and job interviews. One should practice our Mcqs to assimilate DBMS Advanced SQL comprehensively.

  1. Home
  2. »
  3. Computer Science Mcqs
  4. »
  5. DBMS Mcqs
  6. »
  7. Advanced SQL Mcqs

What is the command used to define view in SQL?

Define view

New view

Create view

None of the mentioned

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

It creates a view named studentdet with 3 attributes

It creates a view named studentdet with 1 attribute

It creates a view named ID with 2 attributes

It is syntactically wrong and does not give a result

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

Instant views

Instantaneous views

Materialistic views

Materialized views

The process of maintaining views up to date is called _________

View maintenance

View updating

View materialization

View isolation

How can we insert data into a view?

Insert into (),

Create data values (),

Enter (),

Insert into values (),

The _______ statement makes the updates performed by the transaction permanent.

Finalize work

Finish work

Commit work

None of the mentioned

The _______ statement causes the statements to undo all the updates performed on the transaction

Undo work

Rollback work

Commit work

Replace work

What is the function of the not null constraint?

It prevents illegal data from being entered into the database

It ensures that data is entered into the database

It ensures that the data entered is unique

None of the mentioned

What is the function of the unique constraint?

It ensures that no two values under an attribute are identical

It ensures that all the attributes are perfectly unique in their data type

It ensures that all the relations in the database have a unique set of attributes

It does not have any function in SQL

What is the functions of on delete cascade?

It is used to delete a tuple in a table

It is used to specify the precise attribute that needs to be deleted in a single relation.

It is used to preserve referential integrity in a relation

It is used to execute sub-queries in the from clause.

What does the following condition do?check( name in( ‘Ryan’, ‘Cristiano’, ‘Leo’))

The condition checks whether the name attribute includes the three mentioned names

The condition allows the name attribute to possess only the three mentioned names

The condition checks whether the given names are sub-strings in at least one of the values

None of the mentioned

Referential integrity constraints are also called as _________

Functional dependencies

Subset dependencies

Superset dependencies

Primary dependencies

________ is a predicate that we expect the database to always satisfy





What statement is used to define a new assertion in SQL?

Create check

Create assertion where

Create where

Create assertion check

Scroll to Top