Database Fundamentals 1

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Philanderson888
P
Philanderson888
Community Contributor
Quizzes Created: 7 | Total Attempts: 7,351
Questions: 9 | Attempts: 1,692

SettingsSettingsSettings
Database Fundamentals 1 - Quiz

A test to help students prepare for Software Development and Web Development 98-361 and 98-363 exams


Questions and Answers
  • 1. 

    Name types of valid database systems (Choose all that apply)

    • A.

      SQL Structured Query Language

    • B.

      MySQL

    • C.

      Oracle

    • D.

      Microsoft Access

    Correct Answer(s)
    A. SQL Structured Query Language
    B. MySQL
    C. Oracle
    D. Microsoft Access
    Explanation
    The given answer lists SQL Structured Query Language, MySQL, Oracle, and Microsoft Access as types of valid database systems. SQL Structured Query Language is a programming language used for managing and manipulating databases. MySQL is an open-source relational database management system. Oracle is a relational database management system developed by Oracle Corporation. Microsoft Access is a database management system provided by Microsoft. All of these options are valid examples of database systems.

    Rate this question:

  • 2. 

    What is the name of the item that can store data from various databases to be used as a fast table in memory to read and write data from?  

    • A.

      Data Query

    • B.

      DataSet

    • C.

      Data Connection

    • D.

      Database

    Correct Answer
    B. DataSet
    Explanation
    A DataSet is an object in .NET that can store data from various databases. It acts as a fast table in memory, allowing users to read and write data efficiently. It provides a disconnected, in-memory representation of data that can be manipulated and queried using various methods. It is commonly used in data-centric applications to store and manipulate data from multiple sources.

    Rate this question:

  • 3. 

    Which object reads data one record at a time from a database, and is unable to update the database by itself?

    • A.

      Data Connection

    • B.

      DataReader

    • C.

      DataSet

    • D.

      Data Query

    Correct Answer
    B. DataReader
    Explanation
    A DataReader is an object that reads data one record at a time from a database. It is unable to update the database by itself, meaning it cannot modify or make changes to the data in the database. The purpose of a DataReader is to efficiently retrieve and read data from a database, allowing for faster performance compared to other data access methods.

    Rate this question:

  • 4. 

    What is the purpose of a DataSource Control (Choose TWO)

    • A.

      Show the source code of a data control

    • B.

      Update data in a database

    • C.

      Read data from a database

    • D.

      Enable JQUERY to update a database

    Correct Answer(s)
    B. Update data in a database
    C. Read data from a database
    Explanation
    A DataSource Control is used to interact with a database and perform operations such as updating and reading data. It provides a convenient way to connect to a database and execute queries or commands. The purpose of a DataSource Control is to enable developers to easily update data in a database by executing insert, update, or delete statements, as well as retrieve data from a database by executing select statements. It abstracts the underlying database operations and provides a simplified interface for data manipulation. Additionally, a DataSource Control does not show the source code of a data control or enable JQUERY to update a database.

    Rate this question:

  • 5. 

    What is a Data Source

    • A.

      Source code to reach data, usually written in a web page eg PHP or ASP.NET C# code. It can be viewed with the View->Source command

    • B.

      A source of data like a database or XML document

    • C.

      The results of a search engine search eg output from a Google Data Search

    Correct Answer
    B. A source of data like a database or XML document
    Explanation
    A data source refers to a location or repository where data is stored and can be accessed. It can be in the form of a database or an XML document. This means that a data source provides the necessary information or content that can be retrieved and used for various purposes such as analysis, reporting, or application development. It serves as a reference point from which data can be obtained and utilized.

    Rate this question:

  • 6. 

    Name valid database providers

    • A.

      Postgres

    • B.

      Ingres

    • C.

      Oracle

    • D.

      Microsoft SQL

    • E.

      MySQL open source

    • F.

      Sybase

    Correct Answer(s)
    A. Postgres
    B. Ingres
    C. Oracle
    D. Microsoft SQL
    E. MySQL open source
    F. Sybase
    Explanation
    The given answer lists several valid database providers, including Postgres, Ingres, Oracle, Microsoft SQL, MySQL open source, and Sybase. These are all well-known and widely used database management systems that offer various features and capabilities for storing, organizing, and retrieving data. Each provider has its own strengths and weaknesses, and organizations may choose a specific provider based on their specific requirements and preferences.

    Rate this question:

  • 7. 

    What is ODBC Open Database Connectivity?

    • A.

      It's an Open Source model for connecting to MySQL

    • B.

      It's a standard way of connecting to a database regardless of the database beneath, to provide a uniform platform which is the same regardless of which underlying database is being used.

    • C.

      Allows us to open databases to read them

    Correct Answer
    B. It's a standard way of connecting to a database regardless of the database beneath, to provide a uniform platform which is the same regardless of which underlying database is being used.
    Explanation
    ODBC (Open Database Connectivity) is a standard method for connecting to databases, regardless of the specific database software being used. It provides a consistent platform that allows applications to access and manipulate data in a uniform manner. This means that developers can write code that works with multiple databases without needing to make significant changes. ODBC acts as a bridge between the application and the database, handling the communication and data retrieval processes. Overall, ODBC simplifies the process of connecting to and interacting with databases, making it more efficient and flexible for developers.

    Rate this question:

  • 8. 

    What is an ATOMIC database transaction?

    • A.

      Allows us to have really small transactions processed very fast

    • B.

      The idea is that an atom is a smallest fundamental particle and cannot be split up, so every transaction must either be completed fully or not completed at all. For example taking £10 out of an ATM machine it is not possible to have 'half' a transaction it is either fully completed or not at all.

    • C.

      Allows us to use atoms to read and write data to miniature databases

    • D.

      It is a transaction which updates many databases at once

    Correct Answer
    B. The idea is that an atom is a smallest fundamental particle and cannot be split up, so every transaction must either be completed fully or not completed at all. For example taking £10 out of an ATM machine it is not possible to have 'half' a transaction it is either fully completed or not at all.
    Explanation
    An ATOMIC database transaction is a transaction that must either be completed fully or not completed at all. It is based on the concept of an atom, which is the smallest fundamental particle that cannot be split up. Just like an atom, a transaction in an ATOMIC database must be processed as a whole, without any partial updates. For example, when taking £10 out of an ATM machine, the transaction is either fully completed or not completed at all, without the possibility of having a "half" transaction. This ensures data integrity and consistency in the database.

    Rate this question:

  • 9. 

    What is a primary key?

    • A.

      Allows us to access any field immediately like in RAM

    • B.

      Allows us to select which fields can be linked to other databases

    • C.

      It a certificate to do business with, to prove our identity

    • D.

      It is a unique key which is an index to the data

    Correct Answer
    D. It is a unique key which is an index to the data
    Explanation
    A primary key is a unique key that serves as an index to the data. It is used to uniquely identify each record in a database table. By having a primary key, we can ensure that each record has a unique identifier, which helps in efficient retrieval and organization of data. It allows for quick access to specific records and helps in maintaining data integrity.

    Rate this question:

Related Topics

Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.