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:
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: