databases Online Quiz - 201

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

It is possible to use Transactional control statements in Database Triggers?

  1. True

  2. False

Correct Option: B

Which of the following is not correct about Cursor ?

  1. Cursor is a named Private SQL area

  2. Cursor holds temporary results

  3. Cursor is used for retrieving multiple rows

  4. SQL uses implicit Cursors to retrieve rows

Correct Option: B
  1. Select … into

  2. Update

  3. Create

  4. Delete

Correct Option: C
  1. Only when it is Committed

  2. Only when it is Rolledback

  3. When it is Committed or Rolledback

  4. None of the above

Correct Option: C

Which command or action causes an automatic rollback?

  1. GRANT

  2. EXIT at pl/sql prompt

  3. Alter command

  4. System crash

  5. Commit before a system crash

Correct Option: D
  1. They indicate an optimized execution plan.

  2. They may be able to be tuned to use an index

  3. The full-table scan should be normalized from the database design

  4. A full-table scan is always sub-optimal.

Correct Option: B

IDMS is a ______________ type of database

  1. Relational

  2. Hierarchical

  3. Network

  4. What is IDMS

Correct Option: C
  1. Intergrated Data Management System

  2. India Department of Management Studies

  3. International Data Management System

  4. Integrated Data Management Services

Correct Option: A

READY command is for _______


  2. AREA


  4. PAGE

Correct Option: B
  1. AREA


  3. PAGE


Correct Option: D
  1. CHANGE PASSWORD USER bob OLD bobpass NEW newpass

  2. CONNECT TO sample USER bob USING bobpass NEW newpass

  3. CONNECT TO sample USER bob USING bobpass NEW newpass CONFIRM newpass

  4. No DB2 command can be used to change the password of a user ID

Correct Option: C

Which of the following privilege is required to create a new package in a database?


  2. BIND



Correct Option: D

Which of the following statement is true?

  1. a table is an ordered set of data records

  2. an index always accesses data in ascending order

  3. a view stores the data on a different tablespace

  4. an index can be used to enforce uniqueness in a table

Correct Option: D

CREATE DATABASE command creates some default table spaces. What are they? Choose all that apply.





Correct Option: B,C,D

Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) JOB_CAT VARCHARD2(30) SALARY NUMBER(8,2) Which statement shows the maximum salary paid in each job category of each department?

  1. SELECT dept_id, job_cat, MAX(salary) FROM employees WHERE salary > MAX(salary);

  2. SELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept_id, job_cat;

  3. SELECT dept_id, job_cat, MAX(salary) FROM employees;

  4. SELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept_id;

Correct Option: B
- Hide questions