Tag: databases

Questions Related to databases

  1. A view is a special stored procedure executed when certain event occurs

  2. A view is a database diagram

  3. A view is a virtual table which results of executing a pre-compiled query. A view is not part of the physical database schema, while the regular tables are

  4. All of above


Correct Option: C
  1. XML data types

  2. Table value parameters

  3. Transactions

  4. none of these


Correct Option: B
  1. online transfer processing

  2. online transfer process

  3. online transaction processing

  4. online train processing


Correct Option: C
  1. informatica, businessobjects,cognos

  2. datastage,hyperion,oracle builder

  3. informatica,datastage,abinitio

  4. abinitio,oraclebuilder,microstrategy


Correct Option: C
  1. slow change dimension

  2. slowly change direction

  3. Slowly changing dimension

  4. slow chance direction


Correct Option: C
  1. slow change dimension

  2. slowly change direction

  3. Slowly changing dimension

  4. slow chance direction


Correct Option: C

SCD refers to ?

  1. slow change dimension

  2. slowly change direction

  3. Slowly changing dimension

  4. slow chance direction


Correct Option: C
  1. SQL Server Integrated Server

  2. SQL Server Integration Services

  3. SQL Server Information Server

  4. SQL Server Information Service


Correct Option: B
  1. Relational

  2. Network

  3. Hierarchical

  4. None of the above


Correct Option: B
  1. Data Item

  2. Database Key

  3. Record Occurence

  4. Record Structure


Correct Option: A