database

Question 1
5 of 5 points

An alternative to combining tables by a subquery is to use a join.

Selected Answer:
True

Question 2
5 of 5 points

Regarding the interchangeability of subqueries and joins,

Selected Answer: a join can sometimes be used as an alternative to a subquery, and a subquery can sometimes be used as an alternative to a join.

Question 3
5 of 5 points

When making an SQL query, we are using SQL as a(n) ________.

Selected Answer: DML

Question 4
0 of 5 points

Every subquery can be alternatively expressed by a join.

Selected Answer:
False

Question 5
5 of 5 points

The clause SELECT COUNT (*) results in a table with a single row and a single column.

Selected Answer:
True

Question 6
5 of 5 points

Sorting is specified by the use of the SORT BY phrase.

Selected Answer:
False

Question 7
5 of 5 points

In an SQL query, which built-in function is used to compute the number of rows in a table?

Selected Answer: COUNT

Question 8
5 of 5 points

Given a table with the structure: EMPLOYEE (EmpNo, Name, Salary, HireDate), which of the following is not a valid ANSI SQL command?

Selected Answer: SELECT HireDate, COUNT(*)
FROM EMPLOYEE
WHERE Salary < 30000;

Question 9
5 of 5 points

Because SQL stored procedures allow and encourage code sharing among developers, stored procedures give database application developers the advantages of less work, standardized processing, and specialization among developers.

Selected Answer:
True

Question 10
5 of 5 points

The SQL command used to create a virtual table is ________.

Selected Answer: CREATE VIEW

Question 11

If the table PRODUCT has a column PRICE that has the data type Numeric (8,2), the value 12345 will be displayed by the DBMS as ________.

Selected Answer: