Section 16 Database Design

WORKING WITH COLUMNS, CHARACTERS, AND ROWS
The concatenation operator ...
All of the above
          
In order to eliminate duplicate rows use the ________ keyword
DISTINCT
          
Which of the following is NOT BEING DONE in this SQL statement?
SELECT first_name || ' ' || last_name "Name"
FROM employees;
Concatenating first name, middle name and last name
          
The following is a valid SQL SELECT statement. True or False?
SELECT first_name || ' ' || last_name alias AS Employee_Name
FROM employees:
False
          
The structure of the table can be displayed with the _________ command:
Desc and Describe
          

LIMIT ROWS SELECTED
Which of the following are true?
Date values are enclosed in single quotation marks
Date values are format-sensitive
          
Which of the following is true?
Date values are enclosed in single quotation marks
          
How can you write not equal to in the WHERE-clause
All of the above
          
To restrict the rows returned from an SQL Query, you should use the _____ clause:
WHERE
          
Which of the following would be returned by this SELECT statement:
SELECT last_name, salary
FROM employees
WHERE salary < 3500;
LAST_NAME           SALARY
Davies 3100      

Which example would limit the number of rows returned?
SELECT title FROM d_songs WHERE type_code = 88;
          
Which of the following statements will work?
SELECT first_name ||' '||last_name NAME, department_id DEPARTMENT, salary*12 "ANNUAL SALARY"
FROM employees
WHERE last_name = 'King';
          
Which query would give the following result?
LAST_NAME           FIRST_NAME          DEPARTMENT_ID
King    Steven 90
SELECT last_name, first_name, department_id
FROM employees
WHERE last_name = 'King';
          

COMPARISON OPERATORS
Which of the following WHERE clauses would not select the number 10?
WHERE hours <>10
          
Which two statements would select salaries that are greater than or equal to 2500 and less than or equal to 3500?
WHERE salary >= 2500 AND salary <= 3500
WHERE salary BETWEEN 2500 AND 3500
          
When using the "LIKE" operator, the % and _ symbols can be used to do a pattern-matching, wild card search. True or False?
True
          
Which of the following are examples of comparison operators used in the WHERE clause?
all of the above