Blog

Which of the following best describes the function of a CHECK constraint?

Which of the following privileges must be assigned to a user account in order for that user to connect to an Oracle database?

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?