Blog

For which column would you create an index?

Which statement about an index is true?

Evaluate this CREATE SEQUENCE statement:CREATE SEQUENCE order_id_seq NOCYCLE NOCACHE;Which statement is true?

You can view the columns used in a constraint defined for a specific table by looking at which data dictionary table?

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?