Logo 
Search:

Interview FAQs

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

In which object does Microsoft Visual C++ place its SQL?

In the CRecordSet object's GetDefaultSQL member. Remember, you can change the string held here to manipulate your table.
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

SQL
Comments: 0

If you have a trigger on a table and the table is dropped, does the trigger still exist?

If you have a trigger on a table and the table is dropped, does the trigger still exist?

No. The trigger is automatically dropped when the table is dropped.
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

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

  6  7  8  9  10  11  12  13  14  15  16