Home › Quizzes › Data Warehousing and Database Concepts

Data Warehousing and Database Concepts

Covers data warehouse concepts, SQL commands and functions, database management, indexing, and data mining techniques used in data warehousing environments.

15 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

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
Question 2 Multiple Choice (Single Answer)

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
Question 3 Multiple Choice (Single Answer)

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

  1. Drop
  2. Delete
  3. Destroy
  4. None of these
Question 4 Multiple Choice (Single Answer)

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
Question 5 Multiple Choice (Single Answer)

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
Question 6 Multiple Choice (Single Answer)

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
Question 7 Multiple Choice (Single Answer)

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
Question 8 Multiple Choice (Single Answer)

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
Question 9 Multiple Choice (Single Answer)

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
Question 10 Multiple Choice (Single Answer)

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

  1. ROUND()
  2. TRUNC()
  3. MOD()
  4. SIGN()
Question 11 Multiple Choice (Single Answer)

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
Question 12 Multiple Choice (Single Answer)

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
Question 13 Multiple Choice (Single Answer)

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()
Question 14 Multiple Choice (Single Answer)

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
Question 15 Multiple Choice (Single Answer)

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
← Back to Quizzes