1. Other
  2. Other
  3. lease answer the following questions 2 pts each 1 what...

Question: lease answer the following questions 2 pts each 1 what...

Question details

lease answer the following questions (2 pts each).

1. What function does a where clause serve in a SQL query?

2. Which of the following words [‘Finance’, ‘Figures’, ‘Financial Dismay’, ‘Freelance’, ‘Fiscal’] will

“where words like ‘%nan%’” return?

3. An “in” predicate is used in what part of a SQL statement?

4. What does the special value NULL represent?

5. What is a candidate key?

6. What is the difference between a “left join” and an “inner join”?

7. What is a relation?

8. Why do data base designers perform normalization?

9. What is a relational database schema?

10. What is the difference between a superkey, candidate key, and a primary key in a normalized

database?

11. Describe in your words what a “group by column list” function is?

12. What is the default order of the “order by clause”?

13. Describe a “union all” and it’s function?

14. What is an “alias” used for?

F

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution