Database Fundamentals 1
-
Name types of valid database systems (Choose all that apply)
-
SQL Structured Query Language
-
MySQL
-
Oracle
-
Microsoft Access
-
A test to help students prepare for Software Development and Web Development 98-361 and 98-363 exams
(156).jpg "Database Fundamentals 1 - Quiz")
Quiz Preview
- 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?
-
Data Query
-
DataSet
-
Data Connection
-
Database
Correct Answer
A. DataSetExplanation
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?
-
Data Connection
-
DataReader
-
DataSet
-
Data Query
Correct Answer
A. DataReaderExplanation
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)
-
Show the source code of a data control
-
Update data in a database
-
Read data from a database
-
Enable JQUERY to update a database
Correct Answer(s)
A. Update data in a database
A. Read data from a databaseExplanation
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
-
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
-
A source of data like a database or XML document
-
The results of a search engine search eg output from a Google Data Search
Correct Answer
A. A source of data like a database or XML documentExplanation
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
-
Postgres
-
Ingres
-
Oracle
-
Microsoft SQL
-
MySQL open source
-
Sybase
Correct Answer(s)
A. Postgres
A. Ingres
A. Oracle
A. Microsoft SQL
A. MySQL open source
A. SybaseExplanation
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?
-
It's an Open Source model for connecting to MySQL
-
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.
-
Allows us to open databases to read them
Correct Answer
A. 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?
-
Allows us to have really small transactions processed very fast
-
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.
-
Allows us to use atoms to read and write data to miniature databases
-
It is a transaction which updates many databases at once
Correct Answer
A. 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?
-
Allows us to access any field immediately like in RAM
-
Allows us to select which fields can be linked to other databases
-
It a certificate to do business with, to prove our identity
-
It is a unique key which is an index to the data
Correct Answer
A. It is a unique key which is an index to the dataExplanation
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:
-
Quiz Review Timeline (Updated): Mar 22, 2023 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 22, 2023Quiz Edited by
ProProfs Editorial Team -
Jul 13, 2013Quiz Created by
Philanderson888
Back to top