MISY 5300 Oracle Academy DP Section 3 Quiz well answered rated A+ 2023/2024

MISY 5300 Oracle Academy DP Section 3 QuizWhat will be the results of the following selection? SELECT *FROM employees WHERE last-named NOT LIKE 'A%' AND last name NOT LIKE 'B%' - correct answer No rows will be returned. There is a syntax error All rows will be returned *A=All last names that do not begin with A or B All last names that begin with A or B Which statement about the logical operators is true? - correct answer The order of operator precedence is AND, NOT, and OR. The order of operator precedence is NOT, OR, and AND. *A=The order of operator precedence is NOT, AND, and OR. The order of operator precedence is AND, OR, and NOT. Which of the following best describes the meaning of the LIKE operator? - correct answer Display rows based on a range of values. To find Null values. To test for values in a list. *A=Match a character pattern. You need to change the default sort order of the ORDER BY clause so that the data is displayed in reverse alphabetical order. Which keyword should you include in the ORDER BY clause? - correct answer SORT ASC CHANGE *A=DESC Which statement about the ORDER BY clause is true? - correct answer *A=You can use a column alias in the ORDER BY clause. The ORDER BY clause should immediately precede the FROM clause in a SELECT statement The ORDER BY clause can only contain columns that are included in the SELECT list. The default sort order of the ORDER BY clause is descending. What value will the following SQL statement return? SELECT employee_idFROM employeesWHERE employee_id BETWEEN 100 AND 150OR employee_id IN(119, 175, 205)AND (employee_id BETWEEN 150 AND 200); - correct answer 200, 201, 202, 203, 204, 205, 206 No rows will be returned 19 *A=100, 101, 102, 103, 104, 107, 124, 141, 142, 143, 144, 149 Evaluate this SELECT statement: SELECT last_name, first_name, salaryFROM employees; How will the results of this query be sorted? - correct answer *A=The database will display the rows in whatever order it finds it in the database, so no particular order. The results will be sorted ascending by LAST_NAME, FIRST_NAME, and SALARY. The results will be sorted ascending by LAST_NAME and FIRST_NAME only. The results will be sorted ascending by the LAST_NAME column only. Evaluate this SELECT statement: SELECT first_name, last_name, emailFROM employeesORDER BY last_name; Which statement is true? - correct answer The rows will not be sorted. The rows will be sorted alphabetically by the FIRST_NAME and then the LAST_NAME values The rows will be sorted in reverse alphabetical order by the LAST_NAME values. *A=The rows will be sorted alphabetically by the LAST_NAME values. Evaluate this SELECT statement: SELECT last_name, first_name, department_id, manager_idFROM employees; You need to sort data by manager id values and then alphabetically by employee last name and first name values. Which ORDER BY clause could you use? - correct answer ORDER BY manager_id, first_name, last_name *A=ORDER BY manager_id, last_name, first_name