IndiaBIX

Database - The Client-Server Database

Exercise : The Client-Server Database - General Questions
1.
Which of the following statements is true about symmetric multiprocessing?
A single copy of the operating system resides in each processor.
Useful for situations where data must remain in memory to process.
Bottlenecks increase with uniprocessor systems because tasks are not shared.
The problems of memory contention are unlikely.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
2.
Which of the following items are not necessary for client/server?
Assure that tools will connect with middleware.
Understand the requirements.
Determine network bandwidth capabilities.
Include the use of a file server.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
3.
A benefit of the three-tier architecture is which of the following?
New modules can be built to support specific business needs
Performance improves for compiled SQL statements
Results in a thinner client and database server
All of the above.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
4.
Which of the following statements is true concerning JDBC?
It is language independent.
It is similar in concept to ODBC.
It is useful for all object-oriented languages.
It consists of three main layers.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
5.
A characteristic of a file server is which of the following?
Manages file operations and is shared on a network.
Manages file operations and is limited to one PC.
Acts as a fat client and is shared on a network.
Acts as a fat client and is limited to one PC.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers