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?
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 two methods can you use to get the required result?
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 required result?
You issue the following command to alter the country column in the departments table:Which statement is true?
Which two statements are true regarding constraints?
Evaluate the following SQL statement:Which statement is true regarding the outcome of the above query?
