0

databases Online Quiz - 236

Description: databases Online Quiz - 236
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. Returns current date

  2. Generate the access plan

  3. Suggests performance hints that can be implemented

  4. Drop and create the stored procedure


Correct Option: D

The table rows and column are also known as?

  1. Attributes and Fields

  2. Fields and Records

  3. Records and Fields

  4. Fields and Attributes


Correct Option: C

Normalization is…?

  1. A special way of selecting data

  2. The process of adding primary key to a table

  3. The process of arranging information stored in a database in a way, which removes redundancy and ambiguity.

  4. A special way of retrieving data


Correct Option: C
  1. Rollup

  2. Rollback

  3. CUBE

  4. I and III both


Correct Option: D

what are the minimum values that can be assigned to POSITIVE , NATURAL and SIGNTYPE data types respectively.

  1. 1 , 1 and 1

  2. 0 , 1 and 0

  3. 1 , 0 and -1

  4. 0 , 0 and -1


Correct Option: C
  1. NUMBER is the subtype of INTEGER data type

  2. PLS_INTEGER is the subtype of BINARY_INTEGER

  3. POSITIVE data type is defined in SYS package.

  4. None of the above.


Correct Option: B
  1. Only nested tables need initilization.

  2. Index-by tables is a persistent collection

  3. nested tables are known as associative arrays.

  4. VARRAYs hold fixed number of elements


Correct Option: D
  1. CURRVAL

  2. LEVEL

  3. ROWNUM

  4. COUNT


Correct Option: A,B,C
  1. ALTER TABLE DROP COLUMN

  2. ALTER TABLE DROP CONSTRAINT

  3. ALTER TABLE DISABLE CONSTRAINT

  4. -


Correct Option: A
  1. TABLE

  2. VARCHAR2

  3. SEQUENCE

  4. INDEX


Correct Option: A,C,D
  1. an XML file

  2. a Web Page

  3. an excel template

  4. a text file


Correct Option: C
- Hide questions