Data Warehouse

Description: Data warehouse
Number of Questions: 25
Created by:
Tags: DBMS Databases Programming
Attempted 0/25 Correct 0 Score 0

Which of the following commands is used in SQL to alter the definition of already existing table?

  1. Create table

  2. Insert into

  3. Commit

  4. Alter table


Correct Option: D
Explanation:

Alter table command is used in SQL to alter the definition of already existing table.

Which of the following transaction control commands defines breakpoints for the transaction to allow partial rollbacks?

  1. Commit

  2. Savepoint

  3. Rollback

  4. None of these


Correct Option: B
Explanation:

Savepoint defines breakpoints for the transaction to allow partial rollbacks.

Which of the following commands is used to delete table/view/synonym in SQL?

  1. Drop

  2. Delete

  3. Destroy

  4. None of these


Correct Option: A
Explanation:

Drop is used to delete table/view/synonym in SQL.

Which of the following is a collection of subject areas organized for decision support based on the needs of a given department?

  1. Data warehouse

  2. Data mart

  3. Meta data

  4. None of these


Correct Option: B
Explanation:

Data mart is a collection of subject areas organized for decision support based on the needs of a given department.

Which of the following constraints has to be used to assign pre-specified value to any column in SQL?

  1. Check constraint

  2. Primary key constraint

  3. Default constraint

  4. Unique constraint


Correct Option: C
Explanation:

A default value can be specified for a column using the default clause.

Which of the following data mining techniques places records into groups with similar characteristics?

  1. Association

  2. Clustering

  3. Sequential pattern

  4. None of these


Correct Option: B
Explanation:

This technique places records into groups with similar characteristics.

Which of the following views in Data Dictionary is a powerful set of views that allows those who may access it to see all database objects in the entire database?

  1. USER

  2. DBA

  3. ALL

  4. None of these


Correct Option: B
Explanation:

DBA is a powerful set of views allows those who may access them to see all database objects in the entire database.

Which of the following is the sorted list of data from one or more columns in the tables that are commonly used as selection criteria?

  1. Table

  2. View

  3. Index

  4. Synonym


Correct Option: C
Explanation:

 An index is a sorted list of data from one or more columns in the tables that are commonly used as selection criteria.

Which of the following data warehouse requirements ensures the server and the hardware to be enough to store your entire data warehouse?

  1. Performance

  2. Scalability

  3. Open interface

  4. Capacity


Correct Option: D
Explanation:

The capacity of the server and hardware must be enough to store your entire data warehouse.

Which of the following functions is used in SQL to return sign of a given number?

  1. ROUND()

  2. TRUNC()

  3. MOD()

  4. SIGN()


Correct Option: D
Explanation:

This function returns sign of a given number.

Which of the following data is typically stored in the format that makes analysis much easier in Data warehousing concepts?

  1. Operational data

  2. Informational data

  3. Data mart

  4. None of these


Correct Option: B
Explanation:

Informational data is typically stored in a format that makes analysis much easier in data warehousing concepts.

Which of the following indexing methods involves building a stream of bits, where each bit relates to a column in a single row of a table?

  1. Primary indexing

  2. Bit-mapped indexing

  3. Secondary indexing

  4. None of these


Correct Option: B
Explanation:

Bitmapped indexing involves building a stream of bits, each bit relates to a column in a single row of a table.

Which of the following functions is used to convert a given string into equivalent number in SQL?

  1. NVL

  2. TO-CHAR()

  3. TO-NUMBER()

  4. TO-DATE()


Correct Option: C
Explanation:

This function is used to convert a given string to equivalent number in SQL.

Which of the following properties of textbox allows multiple lines of text in the textbox?

  1. Password character

  2. Enabled

  3. Multiline

  4. Scrollbar


Correct Option: C
Explanation:

This property, if set to true, allows multiple lines of text in the textbox.

Which of the following form properties determines how the form window appears?

  1. Background colour

  2. Border style

  3. Enabled

  4. None of these


Correct Option: B
Explanation:

This property determines how the form window appears.

_________ is the prefix used with command control in VB while naming it.

  1. chk

  2. cmd

  3. cbo

  4. lbl


Correct Option: B
Explanation:

This prefix is used with command control while naming it.

Which of the following windows in VB shows how big a form is in relation to the screen?

  1. Form layout window

  2. Form designer window

  3. Project explorer window

  4. Properties window


Correct Option: A
Explanation:

The form layout window shows how big a form is in relation to the screen.

Which of the following projects in VB is used or created most commonly?

  1. ActiveX EXE

  2. Standard EXE

  3. ActiveX DLL

  4. None of these


Correct Option: B
Explanation:

This is the most commonly used project. This is clicked to create a standard executable file such as a basic windows application or to start a large application project.

Which of the following data types in VB can hold data of any datatype except strings that have fixed lengths or datatypes that have been created by user?

  1. Boolean

  2. Variant

  3. String

  4. None of these


Correct Option: B
Explanation:

Variant data type hold data of any datatype except strings that have fixed lengths or datatype that have been created by user.

Which of the following scopes of variables allows accessiblity to user available at all the modules and procedure in an application?

  1. Private scope

  2. Module scope

  3. Public scope

  4. None of these


Correct Option: C
Explanation:

Public scope of variables allows accessiblity to user, available at all the modules and procedure in an application.

__________ event in VB specifies that the user presses a keyboard key while an object has focus.

  1. KeyPress

  2. KeyDown

  3. KeyUp

  4. None of these


Correct Option: B
Explanation:

KeyDown event in VB specifies that the user presses a keyboard key while an object has focus.

Which of the following functions is used to fill extra characters to a given string on the left-hand side having the specified total width of the string?

  1. RPAD()

  2. LPAD()

  3. CONCAT()

  4. None of these


Correct Option: B
Explanation:

This function left-pads the given character to given string to reach at given width.

Which of the following programming approaches revolves around recognising the occurrence of events and then responding to those events by taking appropriate actions?

  1. Top-down approach

  2. Bottom-up approach

  3. Event-driven approach

  4. None of these


Correct Option: C
Explanation:

Event-driven approach revolves around recognising the occurrence of events and then responding to those events by taking appropriate actions.

Which of the following controls in VB provides a list of options from where an user can select an option?

  1. List Box control

  2. Combo Box control

  3. Check Box control

  4. None of these


Correct Option: A
Explanation:

List Box control in VB provides a list of options from where an user can select an option.

Which of the following is an invisible control in VB, which is added to a form if some task is to be repeated at regular intervals?

  1. Scroll bar

  2. Drive list box

  3. Line

  4. Timer


Correct Option: D
Explanation:

The timer is an invisible control in VB, which is added to a form if some task is to be repeated at regular intervals.

- Hide questions