0

databases Online Quiz - 113

Description: databases Online Quiz - 113
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. Names starting with “a”

  2. Names with "a" as second character

  3. Last character as "a"

  4. Names with atleast two "a" at the start.


Correct Option: B

Which SQL keyword is used to specify conditional search?

  1. SELECT

  2. WHERE

  3. SEARCH

  4. FIND


Correct Option: B

The HAVING clause can be used only with

  1. DELETE clause

  2. INSERT clause

  3. SELECT clause

  4. JOIN clause


Correct Option: C
  1. Strong Query Language

  2. Standard Query Language

  3. Strict Query Language

  4. Structured Query Language


Correct Option: D

What does follow after the SQL WHERE clause?

  1. The name of the table we are selecting from

  2. list of columns to be selected

  3. Definition of the condition to be met for the rows to be returned

  4. None of above


Correct Option: C

What is a primary key?

  1. The primary key column is a column or combination of columns whose values can be non-unique

  2. The primary key is a column or combination of columns whose values uniquely identify each row in the table

  3. The primary key is a column that can have NULL values

  4. all of above


Correct Option: B
  1. An index is the same as alias

  2. An index is a database table attribute, which speeds-up data search within a table

  3. An index is a special way to join 2 or more tables

  4. None of above


Correct Option: B

What is a view?

  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

In sql server 2008, whats the new concepts?

  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

SSIS?

  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

what is the "basic unit of a record"?

  1. Data Item

  2. Database Key

  3. Record Occurence

  4. Record Structure


Correct Option: A

A data item describes a particular attribute of a record.

  1. True

  2. False


Correct Option: A
  1. None

  2. Record

  3. Record Structure

  4. Record Occurence


Correct Option: B,D
- Hide questions