Which of the following is NOT true about the functional dependency A (B, C)?

Select one:

a. B is functionally dependent on A

b. A determines C

c. B and C together determine A

d. B and C are functionally dependent on A

Clear my choice

Question 27

Not yet answered

Marked out of 1.00

Flag question

Question text

Create Table EXAMS ( SUB_NO integer Not Null, STUDENT_NO integer Not Null, MARK decimal (3), DATE_TAKEN date );

The above SQL statement is used to create the EXAMS table. Considering the EXAMS table; which of the following SQL statements can be used to drop the DATE_TAKEN column of the EXAMS table?

Select one:

a. Alter Table EXAMS Drop DATE_TAKEN;

b. Alter EXAMS Drop DATE_TAKEN;

c. Alter Table DATE_TAKEN Drop EXAMS;

d. Alter Table Drop DATE_TAKEN;

Clear my choice

Question 28

Not yet answered

Marked out of 1.00

Flag question

Question text

Which of the following statements is wrong?

Select one:

a. AVG() outputs the average (arithmetic mean) of the column values addressed by the query.

b. MAX() outputs the maximum, the largest, column value from those that are addressed by the query.

c. SUM() outputs the sum total of all the column values that are addressed by the query. This function can be used with every column.

d. MIN() outputs the minimum, the smallest, column value from those that are addressed by the query.

Clear my choice

Question 29

Not yet answered

Marked out of 1.00

Flag question

Question text

tblProducts Table

ProductID	SupplierID	CategoryID	ProductName
1	1	1	Chai
2	1	1	Chang
3	1	2	Aniseed Syrup
4	2	2	Chef Anto's Cajun

Using the tblProducts Table shown above, which of the following SQL statements returns just the ProductID, CategoryID and ProductName of all the products with SupplierID of 1?

Select one:

a. Select * from tblProducts;

b. Select * from tblProducts Where ProductID=1;

c. Select ProductID, CategoryID, ProductName from tblProducts Where SupplierID =1;

d. Select ProductID=1, CategoryID, ProductName from tblProducts;

Clear my choice

Question 30

Not yet answered

Marked out of 1.00

Flag question

Question text

Using INSERT INTO statement, several rows can be added at a time.

Select one:

True

False