The Client-Server Database - General Questions Online Exam Quiz
The Client-Server Database - General Questions GK Quiz. Question and Answers related to The Client-Server Database - General Questions. MCQ (Multiple Choice Questions with answers about The Client-Server Database - General Questions
Which of the following statements is true about symmetric multiprocessing?
Options
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.
Which of the following items are not necessary for client/server?
Options
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.
A benefit of the three-tier architecture is which of the following?
Options
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.
Which of the following statements is true concerning JDBC?
Options
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.
A characteristic of a file server is which of the following?
Options
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.
Stored procedures have which of the following advantages?
Options
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.
Which of the following statements is a true statement concerning the open database connectivity standard (ODBC)?
Options
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.
Which of the following is true concerning QBE?
Options
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.
Client/server security includes which of the following?
Options
A : Physical security
B : Change control security
C : Measures taken to secure all systems
D : All of the above.
An application program interface (API) is which of the following?
Options
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.
Advanced SQL - General Questions more Online Exam Quiz
Object-Oriented Database - General Questions
Object-Oriented Data Modeling - General Questions
ODBC, OLE DB, ADO, and ASP - General Questions
Physical Database Design - General Questions
SQL for Database Construction - General Questions
The Database Development Process - General Questions
The Database Environment - General Questions
ER Model and Business Rules - General Questions