Section 13 Database Programming with PL/SQL.Section 14 Database Programming with PL/SQL.Section 15 Database Programming with PL/SQL.Semester 2 Final Exam Database Programming with PL.Which symbol in the WHERE clause means "Not Equal To"? (Choose Two) Mark for Review Which of the following are TRUE regarding the logical AND operator? Mark for Reviewĥ. WHERE cd_id != 90 or cd_id != 91 or cd_id!= 92 WHERE cd_id NOT IN(90, 91, 92) Mark for Review Find the clause that will give the same results as:SELECT * Which keyword should you include in the ORDER BY clause? Mark for Reviewģ. You need to change the default sort order of the ORDER BY clause so that the data is displayed in reverse alphabetical order. WHERE salary > 24999.99 AND salary 25000 OR salary =" SELECT last_name, first_name, team_id, salary Which statement should you use to display the desired result? Mark for Review The results must be sorted by team id from lowest to highest and then further sorted by salary from highest to lowest. You must display the player name, team id, and salary for players whose salary is in the range from 25000 through 100000 and whose team id is in the range of 1200 through 1500. Select the Alignment tab, and then clear the Merge cells check box. In the Alignment group on the Home tab, select the Alignment dialog box launcher. Select the entire range you want to sort. The PLAYERS table contains these columns:PLAYERS TABLE: Each merged cell in the range must occupy the same number of rows and columns as the other merged cells in the range. Incorrect Incorrect! See Section 3 Lesson 3.Ĩ. The following statement represents a multi-row function. The conversion function TO_CHAR is a single row function. Null email values will be displayed first in the result.Ħ. Null email values will not be displayed in the result. Null email values will be displayed last in the result. If the EMAIL column contains null values, which statement is true? Mark for Review Evaluate this SELECT statement:SELECT last_name, first_name, email The results will be sorted ascending by LAST_NAME and FIRST_NAME only.ġ5. The results will be sorted ascending by the LAST_NAME column only. The results will be sorted ascending by LAST_NAME, FIRST_NAME, and SALARY. The database will display the rows in whatever order it finds it in the database, so no particular order. How will the results of this query be sorted? Mark for Review Evaluate this SELECT statement:SELECT last_name, first_name, salary None, the database always sorts from highest to lowest on the salary column.ġ4.
What clause must you place in a SQL statement to have your results sorted from highest to lowest salary? Mark for Review SELECT employee_id, last_name, first_name, salary 'Yearly Salary' (*)ġ3. Which clause contains an error? Mark for Review Evaluate this SELECT statement:SELECT employee_id, last_name, first_name, salary 'Yearly Salary' The results are sorted alphabetically only.ġ2. The results are sorted alphabetically and then numerically. The results are sorted numerically and then alphabetically. What occurs when the statement is executed? Mark for Review Evaluate this SQL statement:SELECT product_id, product_name, price
0 kommentar(er)
