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

You can sort query results by more than one column. The sort limit is the number of columns in the given table.

  1. True

  2. False


Correct Option: A
  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

PGA stands for

  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

Identify the prefix of data dictionary views. Choose all that apply.

  1. ALL_

  2. USER_

  3. ORACLE_

  4. DBA_

  5. SCHEMA_


Correct Option: A,B,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

What is true about PRIMARY KEY? Choose all that apply

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

What is true about NOT NULL constraint? Choose all that apply

  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

What is true about CHECK constraint? Choose all that apply

  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

What is true about FOREIGN KEY constraint? Choose all that apply

  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 ALTER TABLE command one can only ADD or DROP a constraint, but NOT MODIFY it's structure.

  1. True

  2. False


Correct Option: A
- Hide questions