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

Computer MCQS

Sciences MCQS

1.
What is the command used to define view in SQL?

Define view

New view

Create view

None of the mentioned

Answer Discus (0)

2.
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

Answer Discus (0)

3.
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

Answer Discus (0)

4.
The process of maintaining views up to date is called _________

View maintenance

View updating

View materialization

View isolation

Answer Discus (0)

5.
How can we insert data into a view?

Insert into (),

Create data values (),

Enter (),

Insert into values (),

Answer Discus (0)

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

Finalize work

Finish work

Commit work

None of the mentioned

Answer Discus (0)

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

Undo work

Rollback work

Commit work

Replace work

Answer Discus (0)

9.
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

Answer Discus (0)

10.
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

Answer Discus (0)

11.
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.

Answer Discus (0)

12.
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

Answer Discus (0)

13.
Referential integrity constraints are also called as _________

Functional dependencies

Subset dependencies

Superset dependencies

Primary dependencies

Answer Discus (0)

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

Assertion

Reason

Mandate

Verify

Answer Discus (0)

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

Create check
,

Create assertion where
,

Create where
,

Create assertion check
,

Answer Discus (0)

Engineering MCQS

General Subjects MCQS

0Shares
0
Scroll to Top