The Client -Server Database Questions and Answers

Practice Mode
Showing 10 of 15 questions
Q1
 Which of the following statements is true about symmetric multiprocessing?
  • A A single copy of the operating system resides in each processor.
  • B Useful for situations where data must remain in memory to process.
  • C Bottlenecks increase with uniprocessor systems because tasks are not shared
  • D The problems of memory contention are unlikely.
Answer: Option B
Q2
 Which of the following items are not necessary for client/server?
  • A Assure that tools will connect with middleware.
  • B Understand the requirements.
  • C Determine network bandwidth capabilities.
  • D Include the use of a file server.
Answer: Option D
Q3
A benefit of the three-tier architecture is which of the following?
  • A New modules can be built to support specific business needs
  • B Performance improves for compiled SQL statements
  • C Results in a thinner client and database server
  • D All of the above.
Answer: Option A
Q4
Which of the following statements is true concerning JDBC?
  • A It is language independent.
  • B It is similar in concept to ODBC.
  • C It is useful for all object-oriented languages.
  • D It consists of three main layers.
Answer: Option B
Q5
A characteristic of a file server is which of the following?
  • A Manages file operations and is shared on a network.
  • B Manages file operations and is limited to one PC.
  • C Acts as a fat client and is shared on a network.
  • D Acts as a fat client and is limited to one PC.
Answer: Option A
Q6
Stored procedures have which of the following advantages?
  • A It takes a longer time to write them as compared to writing Visual Basic.
  • B Network traffic increases
  • C Data integrity improves as multiple applications access the same stored procedure.
  • D Result in thicker client and thinner database server.
Answer: Option C
Q7
Which of the following statements is a true statement concerning the open database connectivity standard (ODBC)?
  • A Each vendor desiring to be ODBC-complaint provides an ODBC driver.
  • B Requires certain criteria to be met in order to establish an ODBC connection.
  • C Provides a programming interface that provides a common language for application programs to access and process SQL databases independent of the RDBMS accessed.
  • D All of the above.
Answer: Option D
Q8
Which of the following is true concerning QBE?
  • A An official standard has been defined for QBE.
  • B QBE cannot be used for client/server systems.
  • C QBE does not give the programmer a visual programming environment.
  • D Complete applications can be written using QBE.
Answer: Option D
Q9
Client/server security includes which of the following?
  • A Physical security
  • B Change control security
  • C Measures taken to secure all systems
  • D All of the above.
Answer: Option D
Q10
An application program interface (API) is which of the following?
  • A The same thing as ODBC.
  • B Middleware that does not provide access to a database.
  • C Middleware that provides access to a database.
  • D The same thing as JDBC.
Answer: Option C

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test