Client Server Database(Ict-Basic)Q1

Which of the following statements is true about symmetric multiprocessing?

1 Mark(s)

Which of the following statements is a true statement concerning the open database connectivity standard (ODBC)?

1 Mark(s)

Each vendor desiring to be ODBC-complaint provides an ODBC driver.
All of the above.
Provides a programming interface that provides a common language for application programs to access and process SQL databases independent of the RDBMS accesse
Requires certain criteria to be met in order to establish an ODBC connection.

Which of the following is true concerning the mainframe?

1 Mark(s)

It is the same thing as client/server.
All of the above.
Mission-critical systems have tended to remain there.
Requires someone to decide which code should be on the workstation or the server.

A database server is responsible for which of the following?

1 Mark(s)

Three-tier architecture includes which of the following?

1 Mark(s)

Stored procedures have which of the following advantages?

1 Mark(s)

Result in thicker client and thinner database server.
It takes a longer time to write them as compared to writing Visual Basic Network traffic increases
Data integrity improves as multiple applications access the same stored procedure.

Client/server security includes which of the following?

1 Mark(s)

A characteristic of a file server is which of the following?

1 Mark(s)

A benefit of the three-tier architecture is which of the following?

1 Mark(s)

Which of the following is true concerning QBE?

1 Mark(s)

Which of the following items are not necessary for client/server?

1 Mark(s)

A server cannot serve on which of the following levels?

1 Mark(s)

An application program interface (API) is which of the following?

1 Mark(s)

The three different application logic components are which of the following?

1 Mark(s)

Which of the following statements is true concerning JDBC?

1 Mark(s)

Client Server Database(Ict-Basic)Q1 : Question 1 of 15