SQL -Chapter 1 Part 1 – Flashcards
Unlock all answers in this set
Unlock answersquestion
When you use SQL to access a MySQL database, what is the system called?
answer
Client/Server System
question
What are the three hardware components of a client/server system?
answer
1. Clients
2. Network
3. Server
question
What are the clients in the client/server system?
answer
The clients are usually the PCs that are available on desktops throughout a company. Clients can also be mobile devices like laptops, tablets, and smartphones.
question
What is the network in the client/server system?
answer
The network is the cabling, communication lines, network interface cards, hubs, routers, and other components that connect the clients and the server.
question
What is the server in the client/server system?
answer
The server is a computer that has enough processor speed, internal memory (RAM), and disk storage to store the files and databases of the system and it provides services to the clients of the system.
question
What three things does an enterprise system contain?
answer
An enterprise system contains:
1. Networks
2. Midrange systems
3. Mainframe systems
All of which are spread throughout the country or world.
question
How does a server backup the files of a client/server system?
answer
The server has a backup disk drive or some other form of offline storage.
question
What other things does the server contain?
answer
The server has one or more printers or specialized devices that can be shared by the users of the system.
The server provides services such as email that can be accessed by all the users of the system.
question
In a simple client/server system, what type of network do the clients and the server use?
answer
Local Area Network (LAN)
question
How can two or more LANs that reside at separate geographical locations be connected?
answer
They can be connected by using a larger network such as a wide area network (WAN)
question
How can individual systems or networks be connected?
answer
Through the Internet
question
What kind of system can the server be?
answer
The server can be a mid-range system, like an IBM System x or a Unix system or a mainframe system
question
What are two examples of a database management system (DBMS)?
answer
1. MySQL
2. Microsoft SQL server
question
What does a DBMS do?
answer
A DBMS, database management system, manages databases that are stored on the server.
question
What do clients require to perform useful work?
answer
Clients require application software to perform useful work.
question
What data does the application software use?
answer
Although the application software is run on the client, it uses data that is stored on the server.
question
How does the application software use data stored on the server?
answer
It uses a data access API (application programming interface).
question
What does SQL stand for?
answer
SQL stands for Structured Query Language
question
What does SQL do?
answer
SQL lets any application communicate with any DBMS
question
How does the client communicate with the server after the software are installed?
answer
Once the software for both client and server is installed, the client communicates with the server via SQL queries that are passed to the DBMS through the API
question
What happens after the client sends a query to the DBMS?
answer
After the client sends a query to the DBMS, the DBMS interprets the query and sends the results back to the client
question
Who does the processing in a client/server system?
answer
In a client/server system, the processing is divided between the clients and the server.
question
How are databases stored and managed on a client/server system?
answer
To store and manage the databases of the client/server system, each server requires a database management system (DBMS) like MySQL.
question
What is the processing done by DBMS called?
answer
The processing that's done by the DBMS is typically referred to as back-end processing, and the database server is referred to as the back end.
question
What does application software do?
answer
The application software does the work that the user wants to do. This type of software can be purchased or developed.
question
What does the data access API (application programming interface) do?
answer
The data access API provides the interface between the application program and the DBMS.
question
What is the most common data access API for Java Applications?
answer
On Java Applications, the most common data access API for MySQL is JDBC (Java Database Connectivity)
question
What do SQL queries do?
answer
SQL queries are used by the application software to communicate with the DBMS through the data access API
question
What is front-end processing and the front end?
answer
The processing that's done by the client software is typically referred to as front-end processing, and the client is typically referred to as the front end
question
What does the DBMS do when it receives a query?
answer
When the DBMS receives a query, it provides a service like returning the requested data (the query results) to the client
question
What is the standard language for working with a relational database?
answer
SQL stands for Structured Query Language, and it is the standard language for working with a relational database.
question
In a file handling system, who does the processing?
answer
In a file-handling system, all of the processing is done on the clients. None of the processing is done by the server.
question
Are client/server systems the same as file handling systems?
answer
No, they are two different systems and not the same.
question
In its simplest form, what does a client/server system consist of?
answer
In it's simplest form, a client/server system consists of a single database server and one or more clients.
question
What are the three server types that a client/server system can contain?
answer
1. Database servers
2. Application Servers
3. Web Servers
question
What are application servers used for?
answer
Application servers are typically used to store business components that do part of the processing of the application.
question
What are the business components in application servers used for?
answer
These business components are used to process database requests from the user interface running on the client.
question
What are web servers used for?
answer
Web servers are typically used to store web applications and web services.
question
What are web applications?
answer
Web applications are applications that are designed to run on a web server.
question
Are web services the same as business components?
answer
Web services are like business components, except that they are designed to run on a web server.
question
What are the two sets a web browser does in a web-based system?
answer
1. A web browser running on a client sends a request to a web server over the internet.
2. The web server processes the request and passes any requests for data on to the database server.
question
What do more complex system architectures include?
answer
More complex system architectures can include two or more application servers, web servers, and database servers.
