Logo 
Search:

SQL Interview FAQs

Submit Interview FAQ
Home » Interview FAQs » SQLRSS Feeds
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

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

If you own a table, who can select from that table?

Only users with the select privilege on your table.
Posted By:Shruti Sharma      Posted On: Dec 21

SQL
Comments: 0

What does the # in front of a temporary table signify?

SQL Server uses the # to flag a temporary table.
Posted By:Shruti Sharma      Posted On: Dec 21

SQL
Comments: 0

What must be done after closing a cursor to return memory?

You must deallocate the cursor. The syntax is

SQL> deallocate cursor cursor_name;
Posted By:Shruti Sharma      Posted On: Dec 21

SQL
Comments: 0

Are triggers used with the SELECT statement?

Are triggers used with the SELECT statement?

No. They are executed by the use of UPDATE, DELETE, or INSERT.

Posted By:Shruti Sharma      Posted On: Dec 21

  1  2  3  4  5  6  7  8