![]() |
|
#1
|
||||
|
||||
|
Q# briefly describes the dynamic view. 5
Q# briefly explains the significance of not null constraint. 5 Q# what is truncation and what are ACID properties. 5 Q# briefly explains the mechanism of optimistic locking mod. 3 Q# writes the procedure following which the truncate command remove the data. 3 Q# why do we need meta data? 3 Q# name three difference classification of indexes? 3 Q# suppose you want to delete a table row by row and record an entry in the transaction log for each delete row. Which DML command will you use? 2 Q# write an SQL statement to remove an index called ‘IndexNumber’ ? 2 Q# what are the participant of a relationship? 2 Q# writes any tow similarities between materialized view and indexes? 2 |
![]() |
















Linear Mode


