Blog

Which statement about constraints is true?

Evaluate this view definition: CREATE OR REPLACE VIEW part_name_v AS SELECT DISTINCT part_name FROM partsWHERE cost >= 45; Which of the following statements using the PART_NAME_V view will execute successfully?

The FACULTY table contains these columns:FACULTYID VARCHAR2(5) NOT NULL PRIMARY KEYFIRST_NAME VARCHAR2(20)LAST_NAME VARCHAR2(20)ADDRESS VARCHAR2(35)CITY VARCHAR2(15)STATE VARCHAR2(2)ZIP NUMBER(9)TELEPHONE NUMBER(10)STATUS VARCHAR2(2) NOT NULLThe COURSE table contains these columns:COURSEID VARCHAR2(5) NOT NULL PRIMARY KEYSUBJECT VARCHAR2(5)TERM VARCHAR2(6FACULTYID VARCHAR2(5) NOT NULL FOREIGN KEYYou have been asked to compile a report that identifies all adjunct professors who will be teaching classes in the upcoming term. You want to create a view that will simplify the creation of this report. Which CREATE VIEW statements will accomplish this task?

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?