Blog

You are designing a table for the Sales department. You need to include a column that contains each sales total. Which data type should you specify for this column?

You need to enforce a relationship between the LOC_ID column in the FACILITY table and the same column in the MANUFACTURER table. Which type of constraint should you define on the LOC_ID column?

You want to create a table named TRAVEL that is a child of the EMPLOYEES table. Which of the following statements should you issue?

Which of the following SQL statements will display the index name, table name, and the uniqueness of the index for all indexes on the EMPLOYEES table?

Which of the following keywords cannot be used when creating a view?

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

Which statement about decreasing the width of a column is true?

Which statement about table and column names is true?

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

What will the following SQL Statement do? SELECT job_id, COUNT(*) FROM employees GROUP BY job_id;