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

Can we use PROCOPT on PCB and Segment field (SENSEG)?

  1. True

  2. False


Correct Option: A

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

What will be Output of the following query? select length(to_char('9999','999999.99')) from dual

  1. 9

  2. 10

  3. 4

  4. 8


Correct Option: B

If sysdate is ‘17/10/2009’and we run the following query,what will be the Output?

  1. 01/01/10

  2. 01/10/10

  3. 17/10/10

  4. It will throw an error


Correct Option: B

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

You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which statement accomplishes this task?

  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

Which syntax turns an existing constraint on?

  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
Explanation:

To turn on an existing constraint, option C is correct:

The correct syntax to turn on an existing constraint is:

C. ALTER TABLE table_name ENABLE CONSTRAINT constraint_name;

Option A is also a valid syntax for enabling a constraint.

Option B is incorrect because there is no "STATUS" option for the ALTER TABLE statement.

Option D is incorrect because there is no "TURN ON" option for the ALTER TABLE statement.

Therefore, the answer is: C. ALTER TABLE table_name ENABLE CONSTRAINT constraint_name;

A file can be member of only one filegroup.

  1. True

  2. False


Correct Option: A

CREATE TABLE statements are not allowed in a trigger.

  1. True

  2. False


Correct Option: A

A trigger cannot be created on a view.

  1. True

  2. False


Correct Option: A

Which one is correct for the following example shows how a stored procedure would be used with output parameters?

  1. {call swap_email_address (?, ?)}

  2. {call swap_email_address (?, ?)}

  3. {call swap_email_address (?, ?)}

  4. {call swap_email_address (?, ?)}


Correct Option: B

What is iBATIS?

  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

Every iBATIS application centers around an instance of SqlSessionFactory. A SqlSessionFactory instance can be acquired by using the ______________________

  1. SqlSessionFactoryBuilder

  2. SqlBuilder

  3. SqlFactoryBuilder

  4. SqlSessionBuilder


Correct Option: A

iBATIS does not encourages the direct use fo SQL and ensures that all the benefits of SQL are not overridder by the framework itself.

  1. True

  2. False


Correct Option: B
- Hide questions