You need to ensure that the LAST_NAME column only contains certain character values. No numbers or special characters are allowed. Which type of constraint should you define on the LAST_NAME column?

Which type of constraint by default requires that a column be both unique and not null?

You need to add a row to an existing table. Which DML statement should you use?

You cannot modify data in a view if the view contains ______.

You need to create a report that lists all employees in department 10 (Sales) whose salary is not equal to $25,000 per year. Which query should you issue to accomplish this task?

Examine the data from the LINE_ITEM table: LINE_ITEM_ID ORDER_ID PRODUCT_ID PRICE DISCOUNT 890898 847589 848399 8.99 0.10 768385 862459 849869 5.60 0.05 867950 985490 945809 5.60   954039 439203 438925 5.25 0.15 543949 349302 453235 4.50   You query the LINE_ITEM table and a *value of 3 is returned. Which SQL statement did you execute?

You have been asked to create a report that lists all customers who have placed orders of at least $2,500. The report’s date should be displayed in the Day, Date Month, Year format (For example, Tuesday, 13 April, 2004 ). Which statement should you issue?

Which SELECT statement will NOT return a date value?

Evaluate this SELECT statement: SELECT p.player_id, m.last_name, m.first_name, t.team_name FROM player p LEFT OUTER JOIN player m ON (p.manager_id = m.player_id) LEFT OUTER JOIN team t ON (p.team_id = t.team_id); Which join is evaluated first?

Which statement concerning single row functions is true?