0

databases Online Quiz - 208

Description: databases Online Quiz - 208
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. where

  2. having

  3. order by

  4. none of the above


Correct Option: C

Select length(-1) from dual What is the output of the above sql stmt

  1. 2

  2. 1

  3. 0

  4. error


Correct Option: A

The standard EMP table contains 14 records corresponding to the employess of the corporation.One of those records has a NULL value stored in the MGR column.If Issue the following command on the table: select count(mgr) from emp; What is the count?

  1. 14

  2. >14

  3. error

  4. <14


Correct Option: D

You can declare this only by using table contraint syntax

  1. Composite primarykey

  2. Not null

  3. unique

  4. check


Correct Option: A

An interval literal specifies

  1. a period of time

  2. a numerical difference

  3. a descriptive number

  4. a floating point number


Correct Option: A
  1. False

  2. This is hard to determine

  3. True

  4. None of the choices


Correct Option: C

For each DATE value in an Oracle database, which of the following information is stored (choose all that apply):

  1. second

  2. century

  3. hour

  4. year

  5. date

  6. month


Correct Option: A,B,C,D,E,F

Sub query cannot have which clause defined for it

  1. where

  2. having

  3. order by

  4. none of the above


Correct Option: C

Select length(-1) from dual What is the output of the above sql stmt

  1. 2

  2. 1

  3. 0

  4. error


Correct Option: A

You can declare this only by using table contraint syntax

  1. Composite primarykey

  2. Not null

  3. unique

  4. check


Correct Option: A

An interval literal specifies

  1. a period of time

  2. a numerical difference

  3. a descriptive number

  4. a floating point number


Correct Option: A
  1. False

  2. This is hard to determine

  3. True

  4. None of the choices


Correct Option: C

For each DATE value in an Oracle database, which of the following information is stored (choose all that apply):

  1. second

  2. century

  3. hour

  4. year

  5. date

  6. month


Correct Option: A,B,C,D,E,F

Which of the following are the correct value for the column whose data type is declared as number(3,4)

  1. 123.21

  2. 0.001

  3. 0.01

  4. 123.01


Correct Option: C

Which of the following describes the difference between varchar and varchar2 data types

  1. varchar is used to store fixed length character data, varchar2 is for variable length character data

  2. varchar data type is not supported in oracle

  3. varchar data type is applicable only to PL/SQL

  4. maximum length for varchar is 2000 bytes and for varchar2 is 4000 bytes


Correct Option: D
  1. The Constraint condition is never checked

  2. The Constraint condition is checked only at the time of commiting the transaction

  3. The Constraint condition is checked only for newly inserted rows and will not be checked for already existing rows in the table

  4. The constraint condition is checked after a predefined time interval


Correct Option: B
  1. drop foreign keys

  2. cascade constraints

  3. this is not possible in oracle

  4. clear references


Correct Option: B

The table employee contains 20 records. What is the output of the query " Select 8 from Employee"?

  1. No Rows retrieved

  2. 8 is displayed 20 times

  3. 8 is displayed 1 time

  4. error message


Correct Option: B

The columns with unique constraint allows more than one null values to be inserted.

  1. True

  2. False


Correct Option: B
- Hide questions