Question 12 pts Which of the following does not change the c

Question 12 pts

Which of the following does not change the contents of a table?

Flag this Question

Question 22 pts

Which of the following is a basic principle of the database concept?

Flag this Question

Question 32 pts

In a relation ____.

Flag this Question

Question 42 pts

The values of the primary key of a relation ____.

Flag this Question

Question 52 pts

In a database, the attribute(s) that make up a foreign key in a relation ____.

Flag this Question

Question 62 pts

Which of the following is true about the matching columns used to join two relations?

Flag this Question

Question 72 pts

In the SQL SELECT command, the table(s) involved in the query is (are) specified in the ____ clause.

Flag this Question

Question 82 pts

All of the following are true about the use of AND and OR operators in an SQL SELECT command, except ____.

Flag this Question

Question 92 pts

The SQL SELECT GROUP BY clause is designed to ____.

Flag this Question

Question 102 pts

A subquery can be used to replace the use of a(n) ____.

Solution

12) retrieve
22)ability to achieve data integration without redundant data
32) columns must be arranged in single particular order
42)must be unique
52)must appear in another relation in database
62)they must have same domain if values
72)FROM
82)And or OR can be used with other comparison operators
92)group together the rows of relation that have common attribute values
102) join