Evaluate the following query: What would be the outcome of the above query? A. It produces an error because flower braces have been used. B. It produces an error because the data types are not matching. C. It executes successfully…

View the Exhibit and examine the data in the employees table: You want to display all the employee names and their corresponding manager names. Evaluate the following query: Which join option can be used in the blank in the above…

View the Exhibit and examine the structure of the customers table. Using the customers table, you need to generate a report that shows the average credit limit for customers in Washington and NEW YORK. Which SQL statement would produce the…

You execute the following commands: For which substitution variables are you prompted for the input? A. None, because no input required B. Both the substitution variables ‘hiredate’ and ‘mgr_id C. Only ‘hiredate’ D. Only ‘mgr_id’

Examine the types and examples of relationships that follow: 1. One-to-one a) Teacher to students 2. One-to-many b) Employees to Manager 3. Many-to-one c) Person to SSN 4. Many-to-many d) Customers to products Which option indicates the correctly matched relationships?…

Which normal form is a table in if it has no multi-valued attributes and no partial dependencies? A. First normal form B. Second normal form C. Third normal form D. Fourth normal form

View the Exhibit and evaluate the structure and data in the CUST_STATUS table. You issue the following SQL statement: Which statement is true regarding the execution of the above query? A. It produces an error because the AMT_SPENT column contains…

In the customers table, the CUST_CITY column contains the value ‘Paris’ for the CUST_FIRST_NAME ‘Abigail’. Evaluate the following query: What would be the outcome? A. Abigail PA B. Abigail Pa C. Abigail IS D. An error message

You want to display 5 percent of the employees with the highest salaries in the EMPLOYEES table. Which query will generate the required result? A. Option A B. Option B C. Option C D. Option D

Which three SQL statements would display the value 1890.55 as $1, 890.55? A. Option A B. Option B C. Option C D. Option D