Chapter 4

Question 1

Which symbol is used to bring two columns together to form a single column?

a. -
b. %
c. &
d. /

Answer 1

c. &

This is the ampersand, which is a character operator used to bring two columns together to form a single column.

Question 2

Which of the following SQL statements will not work?

a. SELECT Count() AS as FROM equipment;
b. SELECT count() as tottall FROM storage;
c. SELECT COUNT() as Total FROM Materials;
d. select Count() as totalpeople from people;

Answer 2

SELECT Count(*) AS as FROM equipment;

You can not use keyword (AS) to name a column.

Question 3

Which of the following is used to assign an alias?

a. AS
b. ASC
c. AND
d. LIKE

Answer 3

a. AS

To assign an alias, you use the AS keyword.

Question 4

Which of the following is an arithmetic function?

a. MAX()
b. COUNT()
c. SQRT()
d. SYSDATE()

Answer 4

c. SQRT()

This is an arithmetic function that returns the square root of a number.

Question 5

Which of the following should you use to remove extra spaces from the left of a value?

a. RTRIM()
b. TO_CHAR()
c. Brackets
d. LTRIM()

Answer 5

d. LTRIM()

This is a character function that removes extra spaces from the left of a value.