0

databases Online Quiz - 182

Description: databases Online Quiz - 182
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

maximum number of levels allowed in IMS DB?

  1. 1

  2. 15

  3. 255

  4. 1000


Correct Option: B

Each PSB consists of how many control blocks?

  1. 15

  2. 1

  3. 1 OR MORE

  4. 255


Correct Option: C

wHAT defines the types of access to the database?

  1. PCB

  2. SENSEG

  3. SENFLD

  4. PROCOPT


Correct Option: D

ALL OCCURENCES OF A SEGMENT TYPE UNDER A PARENT IS CALLED AS

  1. CHILD

  2. DEPENDENT

  3. TWIN

  4. SIBLINGS


Correct Option: C

Emp table has 10 rows. How many rows will be fetched against the following query? Select 10 from emp where rownum>=2

  1. 2

  2. 8

  3. 10

  4. None of the above


Correct Option: D

Round(159.63,-3) and Trunc(159.63,-3) will have following Outputs respectively:

  1. 200 and 100

  2. 100 and 100

  3. 160 and 150

  4. none of the above


Correct Option: D

Which three SELECT statements displays 2000 in the format "$2,000.00"? (Choose three)

  1. SELECT TO CHAR(2000, '$#,###.##')

  2. SELECT TO CHAR(2000, '$0,000.00')

  3. SELECT TO CHAR(2000, '$9,999.00')

  4. SELECT TO CHAR(2000, '$2,000.00')

  5. SELECT TO CHAR(2000, '$N,NNN.NN')

  6. SELECT TO CHAR(2000, '$9,999.99')


Correct Option: B,C,F

Which three are DATETIME data types that can be used when specifying column definitions? (Choose three.)

  1. TIMESTAMP

  2. . INTERVAL MONTH TO DAY

  3. INTERVAL DAY TO SECOND

  4. INTERVAL YEAR TO MONTH

  5. TIMESTAMP WITH DATABASE TIMEZONE


Correct Option: A,C,D
  1. ALTER TABLE students ADD PRIMARY KEY student_id;

  2. ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student _ id);

  3. ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student _ id);

  4. ALTER TABLE students ADD CONSTRAINT stud _ id _pk PRIMARY KEY (student _ id);

  5. ALTER TABLE students MODIFY CONSTRAINT stud _ id _pk PRIMARY KEY (student _ id);


Correct Option: D
  1. ALTER TABLE table_name ENABLE constraint_name;

  2. ALTER TABLE table_name STATUS = ENABLE CONSTRAINT constraint _ name;

  3. ALTER TABLE table_name ENABLE CONSTRAINT constraint _ name;

  4. ALTER TABLE table_name TURN ON CONSTRAINT constraint _ name;


Correct Option: C

A trigger cannot be created on a view.

  1. True

  2. False


Correct Option: A
  1. {call swap_email_address (?, ?)}

  2. {call swap_email_address (?, ?)}

  3. {call swap_email_address (?, ?)}

  4. {call swap_email_address (?, ?)}


Correct Option: B
  1. iBATIS is a O/R Mapping tool.

  2. iBATIS is a first class persistence framework with support for custom SQL, stored procedures and advanced mappings.

  3. iBATIS is a java development tool.

  4. iBATIS is a first class persistence framework, and will not support for custom SQL, but will support stored procedures.


Correct Option: B
- Hide questions