WorksheetsDBA - Week 12 Quiz - Client Server Model
Total questions: 15
Worksheet time: 11mins
Where capabilities and authentication data are exchanged
Connection Phase
Command Phase
Which accepts commands from the client and executes them
Command Phase
Connection Phase
Is a distributed application structure that partitions task or workload between the providers of a resource or service, called servers, and service requesters called clients.
The Client-server model
client-server architecture
When the client computer sends a request for data to the server through the internet, the server accepts the requested process and deliver the data packets requested back to the client.
The Client-server model
the client-server architecture
is a computer (Host) i.e. capable of receiving information
Client
Host
Server
the service providers
Client
Servers
Host
is a remote computer which provides information (data) or access to particular services.
Client
Host
Server
DNS Server.
DOMAIN NAME SYSTEM Server
DIGITAL NAME SYSTEM
DOMAIN NETWORK SERVER
URL stand for?
UNION RESOURCE LOCATOR
UNIFORM RESOURCE LOCATOR
UNIDENTIFIED RESOURCE LOCATION
DOM stands for ?
Document Object Model
Digital Object Model
Document Outlay Model
Advantages of Client-Server model
Cost efficient requires less maintenance cost and Data recovery is possible.
Data packets may be spoofed or modified during transmission.
Server-side Programming
Querying the database
Operations over networks
Client-side Programming
work as an interface between all servers
Sending request for data to server
The MySQL protocol is used between MySQL Clients and a MySQL Server. It is implemented by:
· Transparent encryption using SSL
· Communication between master and slave replication servers
The Connection Phase performs these tasks:
setup DNS communication channel if requested
exchange the capabilities of client and server
