Logo 
Search:

Interview FAQs

Submit Interview FAQ
Home » Interview FAQsRSS Feeds
SQL
Comments: 0

What would happen if you created a table and granted select privileges on the table to public?

Everyone could select from your table, even users you may not want to be able to view your data.
Posted By:Shruti Sharma      Posted On: Dec 21

SQL
Comments: 0

Will using a savepoint in the middle of a transaction save all that happened before it automati

Will using a savepoint in the middle of a transaction save all that happened before it automatically?

No. A savepoint comes into play only if a ROLLBACK command is issued--and then only the changes made after the savepoint will be rolled back.
Posted By:Shruti Sharma      Posted On: Dec 21

SQL
Comments: 0

Can a COMMIT command be used by itself or must it be embedded?

A COMMIT command can be issued by itself or in the transaction.
Posted By:Shruti Sharma      Posted On: Dec 21

SQL
Comments: 0

If you issue the COMMIT command and then discover a mistake, can you still use the ROLLBACK com

If you issue the COMMIT command and then discover a mistake, can you still use the ROLLBACK command?

Yes and No. You can issue the command, but it will not roll back the changes.
Posted By:Shruti Sharma      Posted On: Dec 21

SQL
Comments: 0

When nesting transactions, does issuing a ROLLBACK TRANSACTION command cancel the current trans

When nesting transactions, does issuing a ROLLBACK TRANSACTION command cancel the current transaction and roll back the batch of statements into the upper-level transaction? Why or why not?


No. When nesting transactions, any rollback of a trans...
Posted By:Shruti Sharma      Posted On: Dec 21

SQL
Comments: 0

Can savepoints be used to "save off" portions of a transaction? Why or why not?

Can savepoints be used to "save off" portions of a transaction? Why or why not?

Yes. Savepoints allow the programmer to save off statements within a transaction. If desired, the transaction can then be rolled back to this savepoint instead of to t...
Posted By:Shruti Sharma      Posted On: Dec 21

  7  8  9  10  11  12  13  14  15  16  17