Database Fundamentals 1
(156).jpg "Database Fundamentals 1")
A test to help students prepare for Software Development and Web Development 98-361 and 98-363 exams
- 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
Back to top