Tag: databases

Questions Related to databases

Null vales are displayed last in case of ascending and first in case of desc sequences
technology databases

  1. True

  2. False

Show answer
Correct Option: A

You can use a column alias in order by clause
technology databases

  1. True

  2. False

Show answer
Correct Option: A

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

technology databases

  1. True

  2. False

Show answer
Correct Option: A

SGA stands for

technology databases

  1. SYSTEM GLOBAL AREA

  2. SYNCHRONIZED GLOBAL AREA

  3. SORT GLOBAL AREA

  4. SCALABLE GLOBAL AREA

Show answer
Correct Option: A

Which from the following is not an ERP package?

technology databases

  1. SAP

  2. Peoplesoft

  3. Oracle 11g

  4. JD Edwards

Show answer
Correct Option: C

From below list which are the open source CMSs.

technology databases

  1. Drupal

  2. Joomla

  3. PHP

  4. Wordpress

Show answer
Correct Option: A,B,D

DATAFILE is a physical component of the DATABASE

technology databases

  1. True

  2. False

Show answer
Correct Option: A

PGA stands for
technology databases

  1. PRIMARY GLOBAL AREA

  2. PROGRAM GLOBAL AREA

  3. PRIME GLOBAL AREA

  4. PEAK GLOBAL AREA

Show answer
Correct Option: B

Identify VALID data types. Choose all that apply.

technology databases

  1. ROWID

  2. BFILE

  3. SHORT RAW

  4. VARCHAR2(size)

  5. LONG RAW

  6. POINTER

Show answer
Correct Option: A,B,D,E

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

technology databases

  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

Show answer
Correct Option: A,C,D