0

databases Online Quiz - 11

Description: databases Online Quiz - 11
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. SYSTEM GLOBAL AREA

  2. SYNCHRONIZED GLOBAL AREA

  3. SORT GLOBAL AREA

  4. SCALABLE GLOBAL AREA


Correct Option: A
  1. SAP

  2. Peoplesoft

  3. Oracle 11g

  4. JD Edwards


Correct Option: C
  1. Drupal

  2. Joomla

  3. PHP

  4. Wordpress


Correct Option: A,B,D

DATAFILE is a physical component of the DATABASE

  1. True

  2. False


Correct Option: A
  1. PRIMARY GLOBAL AREA

  2. PROGRAM GLOBAL AREA

  3. PRIME GLOBAL AREA

  4. PEAK GLOBAL AREA


Correct Option: B
  1. ROWID

  2. BFILE

  3. SHORT RAW

  4. VARCHAR2(size)

  5. LONG RAW

  6. POINTER


Correct Option: A,B,D,E

For CREATING a TABLE object, what are the pre-requisites? Choose all that apply

  1. A SCHEMA with CREATE SESSION system privilege

  2. CREATE SYNONYM system privilege

  3. A storage area with required access

  4. CREATE TABLE system privilege

  5. CREATE INDEX system privilege


Correct Option: A,C,D
  1. UPDATE the records in the table

  2. MODIFY the data type of the column

  3. DROP the table column

  4. DEFINE a default value for the column

  5. DELETE the records in the table

  6. ADD a new column to the table


Correct Option: B,C,D,F
  1. TRUNCATE is DDL and DELETE is DML

  2. TRUNCATE is DML and DELETE is DDL

  3. TRUNCATE is DCL and DELETE is DML

  4. TRUNCATE is DML and DELETE is DCL


Correct Option: A
  1. Can be defined on a single column or multiple columns in the table.

  2. Can be defined only on a single column in the table.

  3. A UNIQUE index is automatically created once PRIMARY KEY is defined on the table.

  4. A NON-UNIQUE index is automatically created once PRIMARY KEY is defined on the table.

  5. NOT NULL constraint is implicitly enforced on the columns which are part of the PRIMARY KEY

  6. NULL constraint is implicitly enforced on the columns which are part of the PRIMARY KEY


Correct Option: A,C,E

What is true about UNIQUE KEY? Choose all that apply

  1. Can be defined only on a single column in the table.

  2. Can be defined on a single column or multiple columns in the table.

  3. A UNIQUE index is automatically created once UNIQUE KEY is defined on the table.

  4. A NON-UNIQUE index is automatically created once UNIQUE KEY is defined on the table.

  5. NULL values are NOT acceptable on the columns, which are part of UNIQUE KEY

  6. NULL values are acceptable, which are part of UNIQUE KEY


Correct Option: B,C,F
  1. Must be defined as a part of column definition

  2. It's NOT necessary to define it as a part of column definition

  3. Can be applied to the column which may hold UNKNOWN data

  4. Can NOT be applied to the column which may hold UNKNOWN data


Correct Option: A,D
  1. Must evaluate to BOOLEAN expression

  2. Not necessarily evaluates to BOOLEAN expression

  3. Requires that a column (or combination of columns) satisfy a condition for every row in the table excluding nulls.

  4. Columns which, are part of CHECK constraint, may accept NULL values

  5. Columns which, are part of CHECK constraint, can NOT accept NULL values


Correct Option: A,C,D
  1. Defines relations between the tables

  2. The table that includes the foreign key is called the dependent or child table

  3. The table that includes the foreign key is called the parent table

  4. The table that is referenced by the foreign key is called the parent table

  5. The table that is referenced by the foreign key is called the dependent or child table


Correct Option: A,B,D

Using INSERT command only ONE record can be inserted during each execution.

  1. True

  2. False


Correct Option: B
- Hide questions