| Wiki Articles | Tagged On |
| Shruti - What do you mean by primary key? Explain its significance. | Jan 20 |
| Shruti - What is a ’query’ in Access? State and explain the different... | Jan 20 |
| Shruti - From which two sources can you generate SQL scripts? | Dec 21 |
| Shruti - In Oracle, how can you find out what tables and views you... | Dec 21 |
| Shruti - What types of information are stored in the data dictionary? | Dec 21 |
| Shruti - How can you use performance statistics? | Dec 21 |
| Shruti - How can you avoid a full-table scan? | Dec 21 |
| Shruti - Why is the arrangement of conditions in an SQL statement... | Dec 21 |
| Shruti - If you have a trigger on a table and the table is dropped,... | Dec 21 |
| Shruti - What must be done after closing a cursor to return memory? | Dec 21 |
| Shruti - If you own a table, who can select from that table? | Dec 21 |
| Shruti - What does the # in front of a temporary table signify? | Dec 21 |
| Shruti - What would happen if you created a table and granted select... | Dec 21 |
| Shruti - Can a COMMIT command be used by itself or must it be... | Dec 21 |
| Shruti - If you issue the COMMIT command and then discover a mistake,... | Dec 21 |
|
| Shruti - Can savepoints be used to "save off" portions of a... | Dec 21 |
| Shruti - When using the HAVING clause, do you always have to use a... | Dec 21 |
| Shruti - Can you use ORDER BY on a column that is not one of the... | Dec 21 |
| Shruti - What is the function of the GROUP BY clause, and what other... | Dec 21 |
| Shruti - Using today's TEAMSTATS table, write a query to determine... | Dec 21 |
| Shruti - What will SELECT SUBSTR LASTNAME,1,5 FROM NAME_TBL; query... | Dec 21 |
| Shruti - What will SELECT COUNT(*) FROM TEAMSTATS; query return? | Dec 21 |
| Shruti - Assuming that they are separate columns, which function(s)... | Dec 21 |
| Shruti - Will SELECT SUM(LASTNAME) FROM CHARACTERS query work? | Dec 21 |
| Shruti - Which functions are also known by the name ? | Dec 21 |
| Shruti - Rewrite the query from exercise 1 so that the remarks will... | Dec 21 |
| Shruti - Using the CHECKS table, write a query to return all the... | Dec 21 |
| Shruti - Using the CHECKS table from earlier today, write a query to... | Dec 21 |
| Shruti - How can you tell whether a database is truly relational? | Dec 21 |
| Shruti - What can you do with SQL? | Dec 21 |