Tag: databases

Questions Related to databases

Teradata has been called a __________ architecture.
technology databases

  1. Anything Goes

  2. Shared Nothing

  3. Shared Everything

  4. Dual Redundant

Show answer
Correct Option: B

A column of a table is declared as NUMBER(10,2).For which of the following values oracle returns an error
technology databases

  1. 5392845.324

  2. 871039453.1

  3. 97234512.123

  4. 1234567.12

Show answer
Correct Option: B

Sub query cannot have which clause defined for it
technology databases

  1. where

  2. having

  3. order by

  4. none of the above

Show answer
Correct Option: C

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

  1. 2

  2. 1

  3. 0

  4. error

Show answer
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?
technology databases

  1. 14

  2. >14

  3. error

  4. <14

Show answer
Correct Option: D

You can declare this only by using table contraint syntax
technology databases

  1. Composite primarykey

  2. Not null

  3. unique

  4. check

Show answer
Correct Option: A

An interval literal specifies
technology databases

  1. a period of time

  2. a numerical difference

  3. a descriptive number

  4. a floating point number

Show answer
Correct Option: A

You use comments in a SQL statement to pass hints to the Oracle optimizer.
technology databases

  1. False

  2. This is hard to determine

  3. True

  4. None of the choices

Show answer
Correct Option: C

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

technology databases

  1. second

  2. century

  3. hour

  4. year

  5. date

  6. month

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

Sub query cannot have which clause defined for it
technology databases

  1. where

  2. having

  3. order by

  4. none of the above

Show answer
Correct Option: C