Computer Science Engineering Test Preparations On Database Programming Part 2

Test Preparation on Computer Science Engineering Test Preparations On Database Programming Part 2

1.

SQL Server program code that is executed after an SQL command has been processed is called a(n):

1INSTEAD OF trigger.
2BEFORE trigger.
3AFTER trigger.
4BEGIN trigger.

2.

Which of the following refers to the SQL Server transaction isolation level which places and holds locks on all rows that are read?

1REPEATABLE READ
2SERIALIZABLE
3READ COMMITTED
4READ UNCOMMITTED

3.

What type of join is needed when you wish to include rows that do not have matching values?

1Equi-join
2Natural join
3Outer join
4All of the above.

4.

What type of join is needed when you wish to return rows that do have matching values?

1Equi-join
2Natural join
3Outer join
4All of the above.

Check your progress:


Right Ans	Wrong Ans	Not Attempted

Prev Question Next Question Show Answer