1. Which of the following attributes can be considered as a choice for primary key?
2. What is the full form of SQL?
3. What is the full form of DDL?
4. What does DML stand for?
5. Which of the following keywords will you use in the following query to display the unique values of a column dept_name! Select ______dept_name from company;
6. The _______clause of select query allows us to select only those rows in the result that satisfy a specified condition
7. Consider following SQL statement. What type of statement is this? Select * from employee;
8. The term _____is used to refer to a field in a table
9. By default, ORDER by Clause lists the results in _______order
10. The ______keyword eliminates redundant data
11. The _________constraint provides a default value to column when the Insert into statement does not provide a specific value.
12. The __________constraint ensures that all values in a column are distinct.
13. The ___________constraint ensures that all values in column satisfy certain conditions.
14. ___________ is used to identify each row in table.
15. To delete some data from tables ________________command is used.
16. The _________command lets your drop a table from the database.
17. ____________Key is non-key column of a table (child table) that draws its values form primary key of another table (parent table)
No comments: