Checking It

1:SQL*Plus can:

  1. Display data from the Oracle database

  2. Format data into reports

  3. Perform database administrative functions

  4. All of the above

2:In the SQL Buffer, the command I is short for INSERT.

True/False

3:The default behavior of the ORDER BY clause is ascending.

True/False

4:Which of the following LIKE commands will return the rows with a name like HOTKA

  1. WHERE ename LIKE '_HOT%'

  2. WHERE ename LIKE 'H_T%'

  3. WHERE ename LIKE '%TKA_'

  4. WHERE ename LIKE '%TOK%'

5:Which is the valid UPDATE statement?

  1. UPDATE emp SET SAL = SAL * 1.05

  2. UPDATE emp WHERE SAL = 20000

  3. UPDATE emp SET ENAME = 1234 WHERE DEPTNO = 10

  4. UPDATE emp WHERE DEPTNO = 10 SET ENAME = 'HOTKA'

6:Which of the following is NOT a valid data type:

  1. BLOB

  2. CHAR

  3. VARCHAR

  4. INTEGER

7:CREATE TABLE <table name> AS SELECT can create a duplicate object.

True/False

8:You change your mind on a DROP COLUMN command and return the column to the original object.

True/False

9:Selecting which field causes a SEQUENCE generator to increment?

  1. CURRVAL

  2. NEXTVAL

  3. LASTNUMBER

  4. PREVAL

10:Constraints are useful for:

  1. Ensuring parent/child table relationships

  2. Ensuring only certain kinds of data is in a field

  3. Ensuring uniqueness of column data

  4. All of the above

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.133.150.41