Tag: databases
Questions Related to databases
-
Restrict users' access to a subset of table data
-
Ensure that rows inserted remain within the scope of a definition
-
Produce an action as a result of a change to a table
-
Provide users with an alternate view of table data
-
Uncommitted Read
-
Cursor Stability
-
Read Stability
-
Repeatable Read
-
Backup purposes
-
Storing intermediate results
-
Staging area for load operations
-
Sharing result data sets between applications
-
Yes
-
No
-
It Depends
-
None of the above
-
The cursor is moved to another row
-
The row the cursor is on is deleted by the application
-
The row the cursor is on is deleted by another application
-
The row the cursor is on needs to be updated by another application
-
Space Issues
-
Data Issues
-
No records found while querying the table
-
Both a & b
-
The application must release the row-level Share lock it holds and acquire an Update lock on the row
-
The application must release the row-level Share lock it holds and acquire an Update lock on the table
-
The row-level Share lock will automatically be converted to a row-level Up-date lock
-
The row-level Share lock will automatically be escalated to a table-level Up-date lock
-
Check constraint
-
Default constraint
-
Unique constraint
-
Informational constraint