Database Fundamentals 1

9 Questions | Total Attempts: 662

SettingsSettingsSettings
Please wait...
Database Fundamentals 1

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

  • 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

  • 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

  • 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

  • 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

  • 6. 
    Name valid database providers
    • A. 

      Postgres

    • B. 

      Ingres

    • C. 

      Oracle

    • D. 

      Microsoft SQL

    • E. 

      MySQL open source

    • F. 

      Sybase

  • 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

  • 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

  • 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

Related Topics