4860363
| Question | Answer |
| What does an asterisk (*) do? | An asterisk (*) in the select clause denotes “all attributes” |
| What does DISTINCT do? | SQL allows duplicates in relations as well as in query results. To force the elimination of duplicates, insert the keyword DISTINCT after select. |
| What does ALL do? | The keyword ALL specifies that duplicates will not be removed. |
| What does FROM do? | It lists the relations to be scanned when evaluating the whole SELECT expression. |
| What does AS do? | The SQL mechanism for renaming relations and attributes is accomplished through the AS clause: old-name AS new-name |
| What does % do? | The % character matches any substring. |
| What does _ do? | The _ character matches any character. |
Want to create your own Flashcards for free with GoConqr? Learn more.