You need to generate a list of all customer last names with their credit limits from the customers table. Those customers who do not have a credit limit should appear last in the list. Which two queries would achieve the…

You issue the following command to alter the country column in the departments table: Which statement is true? A. It produces an error because column definitions cannot be altered to add default values. B. It executes successfully and all the…

View the Exhibit and examine the structure of the CUSTOMERS table. You have been asked to produce a report on the customers table showing the customers details sorted in descending order of the city and in the descending order of…

View the Exhibit and examine the data in the products table. You need to display product names from the products table that belong to the ‘software/other’ category with minimum prices as either S2000 or S4000 and no unit of measure.…

Examine the structure of the customers table: CUSTNO is the primary key in the table. You want to find out if any customers’ details have been entered more than once using different CUSTNO, by listing all the duplicate names. Which…

You need to display the first names of all customers from the customers table that contain the character ‘e’ and have the character ‘a’ in the second last position. Which query would give the required output? A. Option A B.…

The customers table has the following structure: You need to write a query that does the following tasks: 1. Display the first name and tax amount of the customers. Tax is 5% of their credit limit. 2. Only those customers…

View the Exhibits and examine the structures of the products and sales tables. Which two SQL statements would give the same output? A. Option A B. Option B C. Option C D. Option D

Which statement is true regarding the default behavior of the order by clause? A. In a character sort, the values are case-sensitive. B. NULL values are not considered at all by the sort operation. C. Only those columns that are…

Examine the structure of the employees table: There is a parent/child relationship between EMPLOYEE_ID and MANAGER_ID. You want to display the name, joining date, and manager for all the employees. Newly hired employees are yet to be assigned a department…