alternative
  • Home (current)
  • About
  • Tutorial
    Technologies
    SQL -Structured Query Language
    Python
    Ethical Hacking
    Java
    .net Framework
    Placement Preparation
    Quantitative Aptitude
    View All Tutorial
  • Quiz
    SQL -Structured Query Language
    Quantitative Aptitude
    Java
    View All Quiz Course
  • Q & A
    Quantitative Aptitude
    Java
    View All Q & A course
  • Programs
  • Articles
    Artificial Intelligence & Machine Learning Project
    How to publish your local website on github pages with a custom domain name?
    How to download and install Xampp on Window Operating System ?
    How To Download And Install MySql Workbench
    How to install Pycharm ?
    How to install Python ?
    How to download and install Visual Studio IDE taking an example of C# (C Sharp)
    View All Post
  • Tools
    Program Compiler
    Sql Compiler
    Replace Multiple Text
    Meta Data From Multiple Url
  • Contact
  • User
    Login
    Register

SQL -Structured Query Language - SQL Database - Use / Select Database Quiz

# Quiz
1
Discuss
Use / Select Database

A database application can perform which of the following activities?

  • 1]

    Add records

  • 2]

    Update records

  • 3]

    Read records

  • 4]

    All of the above

Solution
2
Discuss
Use / Select Database

An enterprise database is which of the following?

  • 1]

    A database designed to support only users external to an organization

  • 2]

    A database designed to support an entire organization

  • 3]

    A database designed to support a single PC

  • 4]

    A database designed to support a relatively small group

Solution
3
Discuss
Use / Select Database

Legacy data is which of the following?

  • 1]

    Data contained in a newly-installed system

  • 2]

    Data contained in a file system

  • 3]

    Data rejected during the installation of a new system

  • 4]

    Data contained by a system used prior to the installation of a new system

Solution
4
Discuss
Use / Select Database

Which of the following is true for a relational database?

  • 1]

    Data is represented by tables

  • 2]

    Complex programs have to be written for simple queries

  • 3]

    It is difficult to access data

  • 4]

    All of the above

Solution
5
Discuss
Use / Select Database

A shared database should

  • 1]

    be accurate and available

  • 2]

    be secure

  • 3]

    provide for backup and recovery

  • 4]

    All of the above

Solution
6
Discuss
Use / Select Database

A data warehouse uses

  • 1]

    partial operational data

  • 2]

    future operational data

  • 3]

    historical operational data

  • 4]

    health care data

Solution
7
Discuss
Use / Select Database

A database management system (DBMS) is a

  • 1]

    hardware system used to create, maintain and provide controlled access to a database

  • 2]

    a software system used to create, maintain and provide controlled access to a database

  • 3]

    hardware system used to create, maintain, and provide uncontrolled access to a database

  • 4]

    a software system used to create, maintain, and provide uncontrolled access to a database

Solution
8
Discuss
Use / Select Database

An enterprise data model is

  • 1]

    a graphical model that shows the high-level entities for an organization

  • 2]

    a graphical model that shows all entities for an organization

  • 3]

    a non-graphical model that shows the high-level entities for an organization

  • 4]

    a non-graphical model that shows all entities for an organization

Solution
9
Discuss
Use / Select Database

A data warehouse is which of the following?

  • 1]

    Can be updated by end users

  • 2]

    Contains numerous naming conventions and formats

  • 3]

    Organized around important subject areas

  • 4]

    Contains only current data

Solution
10
Discuss
Use / Select Database

An operational system is which of the following?

  • 1]

    A system that is used to run the business in real-time and is based on historical data

  • 2]

    A system that is used to run the business in real-time and is based on current data

  • 3]

    A system that is used to support decision making and is based on current data

  • 4]

    A system that is used to support decision making and is based on historical data

Solution
11
Discuss
Use / Select Database

The generic two-level data warehouse architecture includes which of the following?

  • 1]

    At least one data mart

  • 2]

    Data that can be extracted from numerous internal and external sources

  • 3]

    Near real-time updates

  • 4]

    All of the above

Solution
12
Discuss
Use / Select Database

The active data warehouse architecture includes which of the following?

  • 1]

    At least one data mart

  • 2]

    Data that can extracted from numerous internal and external sources

  • 3]

    Near real-time updates

  • 4]

    All of the above

Solution
13
Discuss
Use / Select Database

Reconciled data is which of the following?

  • 1]

    Data stored in the various operational systems throughout the organization

  • 2]

    Current data intended to be the single source for all decision support systems

  • 3]

    Data stored in one operational system in the organization

  • 4]

    Data that has been selected and formatted for end-user support applications

Solution
14
Discuss
Use / Select Database

Transient data is which of the following?

  • 1]

    Data in which changes to existing records cause the previous version of the records to be eliminated

  • 2]

    Data in which changes to existing records do not cause the previous version of the records to be eliminated

  • 3]

    Data that are never altered or deleted once they have been added

  • 4]

    Data that are never deleted once they have been added

Solution
15
Discuss
Use / Select Database

The extract process is which of the following?

  • 1]

    Capturing all of the data contained in various operational systems

  • 2]

    Capturing a subset of the data contained in various operational systems

  • 3]

    Capturing a subset of the data contained in various decision support systems

  • 4]

    Capturing all of the data contained in various decision support systems

Solution
16
Discuss
Use / Select Database

Data scrubbing is which of the following?

  • 1]

    A process to reject data from the data warehouse and to create the necessary indexes

  • 2]

    A process to load the data in the data warehouse and to create the necessary indexes

  • 3]

    A process to upgrade the quality of data after it is moved into a data warehouse

  • 4]

    A process to upgrade the quality of data before it is moved into a data warehouse

Solution
17
Discuss
Use / Select Database

The load and index are which of the following?

  • 1]

    A process to reject data from the data warehouse and to create the necessary indexes

  • 2]

    A process to load the data in the data warehouse and to create the necessary indexes

  • 3]

    A process to upgrade the quality of data before it is moved into a data warehouse

  • 4]

    A process to upgrade the quality of data after it is moved into a data warehouse

Solution
18
Discuss
Use / Select Database

Data transformation includes which of the following?

  • 1]

    A process to change data from a detailed level to a summary level

  • 2]

    Joining data from one source into various sources of data

  • 3]

    A process to change data from a summary level to a detailed level

  • 4]

    Separating data from one source into various sources of data

Solution
19
Discuss
Use / Select Database

A multifield transformation does which of the following?

  • 1]

    Converts data from one field into multiple fields

  • 2]

    Converts data from multiple fields into one field

  • 3]

    Converts data from multiple fields into multiple fields

  • 4]

    All of the above

Solution
20
Discuss
Use / Select Database

A star schema has what type of relationship between a dimension and fact table?

  • 1]

    One-to-one

  • 2]

    Many-to-many

  • 3]

    One-to-many

  • 4]

    All of the above

Solution
# Quiz
SQL -Structured Query Language

SQL -Structured Query Language

  • Introduction
  • Overview
    • How To Download And Install MySql Workbench
    • SQL Syntax
  • SQL Database
    • Create Database
    • Drop Database
    • Use / Select Database
  • SQL Table
    • Create Table
    • Alter - Rename Table
    • Alter - Add Column
    • Alter - Modify Column
    • Alter - Rename Column
    • Alter - Drop Column
    • Copy Table
    • Drop Table
  • SQL Insert
    • Insert Record
  • Sql Update
    • Update Record
  • Sql Select
    • Select Record
    • Select - Count
    • Select - Average
    • Select - Sum
    • Select - Min Max
    • Select - Distinct
    • Select - Limit
    • Select - First
    • Select - Last
  • Sql Clause
    • Like Clause
    • And Operator
    • Or Operator
    • Between & Not Between Operator
    • As or Alias
    • In Clause
    • Group By Clause
    • Having Clause
  • Sql Order By
    • Ascending
    • Descending
    • Random
    • Ascending Descending Multiple Column
  • SQL Joins
    • Joins and its type
    • Inner Join
    • Left Join
    • Right Join
    • Full Join
    • Cross Join
  • SQL View
    • Create View
    • Update View
    • Delete View
  • SQL Delete
    • Delete Table
    • Truncate Table
  • Sql Key & Constraint
    • Primary Key
    • Foreign Key
    • Unique Key
    • Not Null Constraint
    • Check Constraint
    • Default Constraint
  • Normalization
    • Overview
    • 1 NF
    • 2 NF
    • 3 NF
    • Boyce Codd normal form ( BCNF )

About Fresherbell

Best learning portal that provides you great learning experience of various technologies with modern compilation tools and technique

Important Links

Don't hesitate to give us a call or send us a contact form message

Terms & Conditions
Privacy Policy
Contact Us

Social Media

© Untitled. All rights reserved. Demo Images: Unsplash. Design: HTML5 UP.