Database Fundamentals 1

9 Questions | By Philanderson888 | Updated: Mar 22, 2022 | Attempts: 1394

Questions

Settings

Create your own 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
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