SQL Extensions   «Prev  Next»

Creating Oracle Tables - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. Examine the numbered SQL statement. Which line contains a column constraint?
1 CREATE TABLE JOB_OPP
2 (JOB_ID NUMBER(10) NOT NULL,
3 COLLEGE_ED_FLAG CHAR(1),
4 APP_METHOD VARCHAR2(25) DEFAULT 'MAIL');
Please select the best answer.
  A. 1
  B. 2
  C. 3
  D. 4

2. Which column specification best fits the numeric values 155.13 and 35576.08?
Please select the best answer.
  A. CHAR(7,2)
  B. NUMBER(7,2)
  C. NUMBER(5,2)
  D. VARCHAR2(8)

3. Which item specifies a column default rather than a table physical attribute or a parameter of the STORAGE clause?
Please select the best answer.
  A. MAXEXTENTS
  B. DEFAULT
  C. PCTFREE
  D. NEXT

4. A permanent smallfile tablespace needs more capacity. Which statement is true?
Please select the best answer.
  A. A DBA can add another datafile to the tablespace, subject to database, operating-system, and storage limits.
  B. Neither the tablespace nor any of its datafiles can be enlarged.
  C. Every update to every table in the tablespace immediately fails.
  D. A nonpartitioned table segment automatically allocates its next extent in a different tablespace.

5. Examine this table property: PCTFREE 20. What does it mean?
Please select the best answer.
  A. Oracle reserves 20 percent of the entire tablespace exclusively for this table.
  B. Oracle reserves 20 percent of each table data block for future updates to existing rows.
  C. The table cannot grow beyond 20 percent of the tablespace.
  D. Each new extent must be 20 percent larger than the preceding extent.