Informatics Practices
Fill in the blanks:
The _________ command can be used to select an existing database in SQL.
Related Questions
Which of the following types of table constraints will prevent the entry of duplicate rows?
- Unique
- Distinct
- Primary Key
- NULL
Ravisha has stored the records of all students of her class in a MYSQL table. Suggest a suitable SQL clause that she should use to display the names of students in alphabetical order.
- SORT BY
- ALIGN BY
- GROUP BY
- ORDER BY
Fill in the blanks:
The SQL keyword _________ is used to specify the table(s) that contains the data to be retrieved.
Fill in the blanks:
To remove duplicate rows from the result of a query, specify the SQL qualifier _________ in select list.