Explain client/server database system.

Explain client/server database system. 
by

1 Answer

Answer :

image

1. It has two logical parts client and server. 

2. Computer networking allows some task to be executed on a server system and some tasks on client system. This leads to development of client server architecture. 

3. Server is the machine which serves to the clients. 

4. Server machine provide services to the client machine such as file access, printing, and database access. It is used to manage the database tables optimally among multiple clients who concurrently request the server for the same data. 

5. The clients are the machines which requests for the service to the server. 

6. There are different types of client/server architecture such as 

  • Two tier architecture 
  • Three tier architecture.
7. In two tier architecture, client systems directly approach database servers whereas in three tier architecture, there exists a middle layer which acts as application server to receive and send requests from client machine to database server and vice versa.
by

Related questions

Describe client server system with example.

Description : Describe client server system with example.

Last Answer : Client server system consists of two logical components. One is Client and the other one is Server . Clients are those who send the request to perform a specific task to the server. ... client's CPU and memory. But server runs a database management system which manages the whole database.

The reasons leading to popularity of client-server systems are: A) More powerful workstations on LANs B) Needed for graphical user interfaces of end users. C) Remove computing load for presentation services from the system managing a shared database resource. D) All

Description : The reasons leading to popularity of client-server systems are: A) More powerful workstations on LANs B) Needed for graphical user interfaces of end users. C) Remove computing load for presentation services from the system managing a shared database resource. D) All

Last Answer : D) All

Explain distributed database system with example.

Description : Explain distributed database system with example.

Last Answer : A distributed database is a database that consists of two or more files located in different sites either on the same network or on entirely different networks. Portions of the database ... Ignite, Apache Cassandra, Apache HBase, Couchbase Server, Amazon SimpleDB, Clusterpoint, and FoundationDB

State whether true or false. i) Multithreading is useful for application that perform a number of essentially independent tasks that do not be serialized. ii) An example of multithreading is a database server that listens for and process numerous client request. A) i-True, ii-False B) i-True, ii-True C) i-False, ii-True D) i-False, ii-False

Description : State whether true or false. i) Multithreading is useful for application that perform a number of essentially independent tasks that do not be serialized. ii) An example of multithreading is a database server that listens for ... B) i-True, ii-True C) i-False, ii-True D) i-False, ii-False

Last Answer : B) i-True, ii-True

Explain three level architecture of Database

Description : Explain three level architecture of Database

Last Answer : There are following three levels or layers of DBMS architecture: External Level : Describes part of the database that a particular user group is interested in. Conceptual Level: Describes structure of ... is the one that concerns the way the data are physically stored on the hardware.

Explain merits and demerits of Object Oriented Database model.

Description : Explain merits and demerits of Object Oriented Database model.

Last Answer : Object oriented models were introduced to overcome the shortcomings of conventional models like Relational, Hierarchical and network model. An object-oriented database is collection of objects whose behavior, state, ... . * There is no view mechanism * There is no adequate security mechanism.

Explain components of database in detail.

Description : Explain components of database in detail.

Last Answer : A database system involves four major components. 1. Data 2. Hardware 3. Software 4. Users

Explain three tier architecture of database with the help of diagram.

Description : Explain three tier architecture of database with the help of diagram.

Last Answer : Application server or Web server *Adds intermediate layer between client and the database server *Runs application programs and stores business rules Clients contain GUI interfaces and ... GUI format. Thus the user interfaces, application rules and the database acts as three tier. 

Describe centralized database system with example.

Description : Describe centralized database system with example. 

Last Answer : Centralized Database System: 1. A centralized database consists of a single data server into which all data are stored and from which all data are retrieved. All the data reside at a single location and ... is cheaper than other types of databases as it requires less power and maintenance. 

Compare file system and database system.

Description : Compare file system and database system. 

Last Answer : File system Database system  1. File processing don't contain any self describing feature and neither posses metadata.  1. Presence of Self-describing nature of a database system and Metadata. ... own file.  5. Controlling Redundancy is one of most important feature to use DBMS

Define Database. List advantages of database system.

Description : Define Database. List advantages of database system. 

Last Answer : A database is an organized collection of data so that it can be easily accessed, managed and updated. Advantages of database system are the following:  1. Controlling ... Providing Backup and Recovery facilities is provide by DBMS for recovering from hardware or software failures.

State characteristics of Database.

Description : State characteristics of Database.

Last Answer : The Characteristics of Database are: 1. Persistent Data 2. Meta Data and Self-describing nature of a DB 3. Insulation between programs and data (Data Independence) 4. Support ... Sharing of data and multiuser transaction processing 6. Access flexibility and Security. 7. Controlled Redundancy

List types of Database languages.

Description : List types of Database languages.

Last Answer : Four types of database languages are: 1. DDL (Data Definition Language) 2. DML (Data Manipulation Language) 3. DDL (Data Control Language) 4. TCL (Transaction control language)

Define the term Database Schema

Description : Define the term Database Schema

Last Answer : The overall design of the database is called the database schema. A schema diagram displays only names of record types (entities) and names of data items (attributes) and does not show the relationships among the various files. 

Distinguish between network database model and relational database model.

Description : Distinguish between network database model and relational database model. 

Last Answer : Network database model Relational database model Relationship between records is expressed in the form of pointers or links Relationship between records is represented by a relation that contains a key for ... logically in the form of rows and columns. Example:  Example: 

Define database model.

Description : Define database model. 

Last Answer : Definition of database model: A database model is a type of data model that determines the logical structure of a database. It also fundamentally determines in which manner data can be stored, organized and manipulated. 

Differentiate between Hierarchical Database model and network database model.

Description : Differentiate between Hierarchical Database model and network database model.

Last Answer : Hierarchical Database Model  Network Model Network Model represents tree like structure with one root. Network Model represents tree like structure with many roots. Reflects 1:N ( ... the use of pointers Record relationship implementation is complex due to the use of pointers

When a client computer sends a request to a Domain Name System (DNS) server, what type of packet is sent?

Description : When a client computer sends a request to a Domain Name System (DNS) server, what type of packet is sent?

Last Answer : DNS primarily uses the User Datagram Protocol (UDP) on port number 53 to serve requests. DNS queries consist of a single UDP request from the client followed by a single UDP reply from the server. ... the answer exceeds 512 bytes and both client and server support EDNS, larger UDP packets are used.

The.... controls a client computer's resources. 1) Application program 2) Instruction set 3) Operating System 4) Server application

Description : The.... controls a client computer's resources. 1) Application program 2) Instruction set 3) Operating System 4) Server application

Last Answer : 4) Server application

The.... controls a client computer's resources. 1 Application program 2 Instruction set 3 Operating System 4 Server application

Description : The.... controls a client computer's resources. 1 Application program 2 Instruction set 3 Operating System 4 Server application

Last Answer : 4 Server application

A client-server system uses a satellite network, with the satellite at a height of 40,000 kms. What is the best-case delay in response to a request? (Note that the speed of light in air is 3,00,000 km/second). (A) 133.33 m sec (B) 266.67 m sec (C) 400.00 m sec (D) 533.33 m sec

Description : A client-server system uses a satellite network, with the satellite at a height of 40,000 kms. What is the best-case delay in response to a request? (Note that the speed of light in air is 3,00,000 km/second). (A) 133.33 m sec (B) 266.67 m sec (C) 400.00 m sec (D) 533.33 m sec

Last Answer : (D) 533.33 m sec Explanation: The request has to go up and down, and the response has to go up and down. The total path length traversed is thus 160.000 km. The speed of light in air and vacuum is 300,000 km/sec, so the propagation delay alone is 160,000/300,000 sec or about 533 msec. 

Which instances of an SAP system require a running database during their startup? Note: there are 2 correct answered to this question. ? A. Java Central Services Instance B. Additional Application Server Instance C.ABAP Central Services Instance D. Primary Application Server Instance

Description : Which instances of an SAP system require a running database during their startup? Note: there are 2 correct answered to this question. ? A. Java Central Services Instance B. Additional Application Server Instance C.ABAP Central Services Instance D. Primary Application Server Instance

Last Answer : B. Additional Application Server Instance

Consider an SAP system based on AS ABAP How many monitoring segments are used for the CCMS Monitoring Infrastructure? A. There is one monitoring segment for each host B. There is one monitoring segment for each database used by an SAP system C. There is one monitoring segment for each application server D. There is one monitoring segment for each central services instance

Description : Consider an SAP system based on AS ABAP How many monitoring segments are used for the CCMS Monitoring Infrastructure? A. There is one monitoring segment for each host B. There is ... segment for each application server D. There is one monitoring segment for each central services instance

Last Answer : A. There is one monitoring segment for each host

What is the best and faster way to transfer a DataTable from server side to client side: using JSON format or pure HTML?

Description : What is the best and faster way to transfer a DataTable from server side to client side: using JSON format or pure HTML?

Last Answer : Unless there is a good reason to write the displayed data cient side, pure HTML should be more efficient. It should display in a browser faster. Also, the server side source code is visible to ... HTML generated client side will not be visible to any bot that does not have a JavaScript interpreter.

In WWW a client is called ……….. and a server is called ……… -Technology

Description : In WWW a client is called ……….. and a server is called ……… -Technology

Last Answer : Web browser, Web server

Which software model is best suitable for client server application? -Technology

Description : Which software model is best suitable for client server application? -Technology

Last Answer : Concurrent Process model is best suitable for client server application.

What is Client Server Architecture ?

Description : What is Client Server Architecture ?

Last Answer : Client Server Architecture There is always a host called Server. This server serves many other hosts , called clients. The client host does not need to be on all the time. A notable feature of ... server at any time. Notable examples of client server architecture are web , e-mail rematch login etc.

What are the features of client server network ?

Description : What are the features of client server network ?

Last Answer : Client Server Network Features The client-server network is easily expandable. This can be done for tens of thousands of users. Such networks have servers. Server computer hardware is generally advanced and these servers ... why the skills of network users are not so important.

What is a client server network ?

Description : What is a client server network ?

Last Answer : A client server network is a network that has a powerful computer or server for central control and data storage and all other computers or clients are connected to this server. One computer ... comply with the server's security policy. Client-server networks are also called server-based networks.

What approaches to server and client development do you know?

Description : What approaches to server and client development do you know?

Last Answer : Whenever you use an ATM to check your balance or withdraw some money, you are actually participating in a client-server interaction with a computer on your bank's network. A client-server network ... socket, locates the Web page requested and sends it over the Internet to the user's browser.

What is a client and a server?

Description : What is a client and a server?

Last Answer : Client and Server are computers which are connect on the same network it may be Local area network LAN or wide area network WAN, BUT the CLIENT IS THE REQUESTING MACHINE WHILE THE SERVER IS THE SUPPLYING MACHINE.

Is terminal server load balancing the responsibility of the client or the host?

Description : Is terminal server load balancing the responsibility of the client or the host?

Last Answer : Server load balancing is almost always the hosts responsibility. Even in the case of terminal severs, the host should ensure proper connections to the server.

A client of yours would like to expand with a small bistro in front of her catering kitchen. What do you tell her is one advantage to a peer-to-peer network over a client-server network in her case?

Description : A client of yours would like to expand with a small bistro in front of her catering kitchen. What do you tell her is one advantage to a peer-to-peer network over a client-server network in her case?

Last Answer : Peer-to-peer networking is less expensive and easier to upkeep.

The most important or powerful computer in a typical network is _____ 1) Desktop 2) Network client 3) Network server 4) Network station 5) None of these

Description : The most important or powerful computer in a typical network is _____ 1) Desktop 2) Network client 3) Network server 4) Network station 5) None of these

Last Answer : Answer :3

Where is a procedure return in an external pl/sql library executed at the client or at the server?

Description : Where is a procedure return in an external pl/sql library executed at the client or at the server?

Last Answer : At the client.

Where is the external query executed at the client or the server?

Description : Where is the external query executed at the client or the server?

Last Answer : At the server.

Why are OPS$ accounts a security risk in a client/server environment? (for DBA

Description : Why are OPS$ accounts a security risk in a client/server environment? (for DBA

Last Answer : f you allow people to log in with OPS$ accounts from Windows Workstations, you cannot be sure who they really are. With terminals, you can rely on operating system passwords, with Windows, you ... of whether you have identified your ID with a password or defined it to be IDENTIFIED EXTERNALLY.

What is used to see if a client is still connected to a NetWare server? A. Spoofing TCP/SAP B. Watchdog packet C. GNS Round Robin D. DNS Round Robin

Description : What is used to see if a client is still connected to a NetWare server? A. Spoofing TCP/SAP B. Watchdog packet C. GNS Round Robin D. DNS Round Robin

Last Answer : Watchdog packet

. A _____ DBMS distributesdata processing tasks between the workstation anda network server. A. Network B. Relational C. Client Server D. Hierarchical E. None of the above

Description : . A _____ DBMS distributesdata processing tasks between the workstation anda network server. A. Network B. Relational C. Client Server D. Hierarchical E. None of the above

Last Answer : Client Server

In one of the pairs of protocols given below, both the protocols can use multiple TCP connections between thesame client and the server. Which one is that? a. HTTP, FTP b. HTTP, TELNET c. FTP, SMTP d. HTTP, SMTP

Description : In one of the pairs of protocols given below, both the protocols can use multiple TCP connections between the same client and the server. Which one is that? a. HTTP, FTP b. HTTP, TELNET c. FTP, SMTP d. HTTP, SMTP

Last Answer : a. HTTP, FTP

Consider different activities related to email: m1: Send an email from a mail client to a mail server m2: Download an email from mailbox server to a mail client m3: Checking email in a web browser Which is the application level protocol used in each activity? a. m1: HTTP m2: SMTP m3: POP b. m1: SMTP m2: FTP m3: HTTP c. m1: SMTP m2: POP m3: HTTP d. m1: POP m2: SMTP m3: IMAP

Description : Consider different activities related to email: m1: Send an email from a mail client to a mail server m2: Download an email from mailbox server to a mail client m3: Checking email in a web browser Which is the application ... FTP m3: HTTP c. m1: SMTP m2: POP m3: HTTP d. m1: POP m2: SMTP m3: IMAP

Last Answer : c. m1: SMTP m2: POP m3: HTTP

Which DNS client maps an address to a name or a name to an address especially when required by a host? a. Resolver b. Mapper c. Primary Server d. Secondary Server

Description : Which DNS client maps an address to a name or a name to an address especially when required by a host? a. Resolver b. Mapper c. Primary Server d. Secondary Server

Last Answer : a. Resolver

What is the main function of Session layer in OSI model? a. Defines how data is formatted between the devices b. Made physical connection between server and client c. Both a and b d. None of the above

Description : What is the main function of Session layer in OSI model? a. Defines how data is formatted between the devices b. Made physical connection between server and client c. Both a and b d. None of the above

Last Answer : a. Defines how data is formatted between the devices

In which layer of OSI client send request to the server? a. Application layer b. Presentation layerc. Session layer d. Transport layer

Description : In which layer of OSI client send request to the server? a. Application layer b. Presentation layer c. Session layer d. Transport layer

Last Answer : c. Session layer

SSL is not responsible for a. Mutual authentication of client & server b. Secret communication c. Data Integrity protection d. Error detection and correction

Description : SSL is not responsible for a. Mutual authentication of client & server b. Secret communication c. Data Integrity protection d. Error detection and correction

Last Answer : d. Error detection and correction

While transferring files between server and client, if the transmission rates along the path is 10Mbps, 20Mbps, 30Mbps, 40Mbps. The throughput is usually a. 20Mbps b. 10Mbps c. 40Mbps d. 50Mbps

Description : While transferring files between server and client, if the transmission rates along the path is 10Mbps, 20Mbps, 30Mbps, 40Mbps. The throughput is usually a. 20Mbps b. 10Mbps c. 40Mbps d. 50Mbps

Last Answer : b. 10Mbps

Find out the components of DHCP: 1) A protocol that delivers host-specific configuration parameters from a server to a host. 2) The client determines its own hardware address; this is normally in a ROM on the hardware. 3) A mechanism for the allocation of temporary or permanent network addresses to hosts. A. 1,2 B. 1,3 C. 2,3 D. 1,2,3

Description : Find out the components of DHCP: 1) A protocol that delivers host-specific configuration parameters from a server to a host. 2) The client determines its own hardware address; this is normally in a ROM on the hardware. 3) ... or permanent network addresses to hosts. A. 1,2 B. 1,3 C. 2,3 D. 1,2,3

Last Answer : B. 1,3

State weather the following statement is true or false for Sendmail. 1).Sendmail is a command-line tool designed for most UNIX-like operating systems. 2).It define a method of transferring mail, and acts as a client/server that supports multiple mail protocols 3). Sendmail exists in both open source and proprietary software packages. A. 1. True, 2. False, 3. true B. 1. true, 2. false, 3. false C. 1. false, 2. false, 3. false D. 1. true, 2. true, 3. false

Description : State weather the following statement is true or false for Sendmail. 1).Sendmail is a command-line tool designed for most UNIX-like operating systems. 2).It define a method of transferring mail, and acts as a client/server ... . false C. 1. false, 2. false, 3. false D. 1. true, 2. true, 3. false

Last Answer : A. 1. True, 2. False, 3. true

The Post Office Protocol is an ………... protocol with both client (sender/receiver) and …………...functions A. electronic mail, server (storage) B. three layer , server C. UDP, transfer D. TCP, server

Description : The Post Office Protocol is an ………... protocol with both client (sender/receiver) and …………...functions A. electronic mail, server (storage) B. three layer , server C. UDP, transfer D. TCP, server

Last Answer : A. electronic mail, server (storage)

The client code recognizes the SSL request and establishes a connection through TCP port ____ to the SSL code on the server A. 1023 B. 402 C. 443D. 8080

Description : The client code recognizes the SSL request and establishes a connection through TCP port ____ to the SSL code on the server A. 1023 B. 402 C. 443 D. 8080

Last Answer : C. 443