0

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 _______

  1. VOLUME

  2. AREA

  3. RECORD

  4. PAGE


Correct Option: B
  1. AREA

  2. VOLUME

  3. PAGE

  4. RECORD


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?

  1. CONTROL

  2. BIND

  3. EXECUTE

  4. BINDADD


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.

  1. SYSLOGSPACE

  2. TEMPSPACE1

  3. USERSPACE1

  4. SYSCATSPACE


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