Menu
Home / CSE / Database System 2 - CS :: Client Server Database

CSE :: Database System 2 - CS

Database System 2 - CS - Advanced SQL
Database System 2 - CS - SQL Server 2000
Database System 2 - CS - Data Warehousing
Database System 2 - CS - XML and ADO.NET
Database System 2 - CS - Database Redesign
Database System 2 - CS - Introduction to SQL
Database System 2 - CS - Distributed Databases
Database System 2 - CS - Client Server Database
Database System 2 - CS - Data Modeling with ER
Database System 2 - CS - Logical Database Design
Database System 2 - CS - Introduction to Database
Database System 2 - CS - Object Oriented Database
Database System 2 - CS - Physical Database Design
Database System 2 - CS - The Database Environment
Database System 2 - CS - ODBC, OLE DB, ADO, and ASP
Database System 2 - CS - ER Model and Business Rules
Database System 2 - CS - Database Processing for BIS
Database System 2 - CS - Managing Multiuser Databases
Database System 2 - CS - Object Oriented Data Modeling
Database System 2 - CS - Managing Databases with Oracle
Database System 2 - CS - SQL for Database Construction
Database System 2 - CS - Data and Database Administration
Database System 2 - CS - Data Models into Database Designs
Database System 2 - CS - Modeling Data in the Organization
Database System 2 - CS - The Database Development Process
Database System 2 - CS - The Internet Database Environment
Database System 2 - CS - JDBC, Java Server Pages, and MySQL
Database System 2 - CS - Database Design Using Normalization
Database System 2 - CS - The Relational Model and Normalization
  1. Which of the following statements is true about symmetric multiprocessing?

    2. 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.

    View Answer

    Workspace

    Discuss Discuss in Forum

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

    3. 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.

    View Answer

    Workspace

    Discuss Discuss in Forum

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

    4. 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.

    View Answer

    Workspace

    Discuss Discuss in Forum

  4. Which of the following statements is true concerning JDBC?

    5. 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.

    View Answer

    Workspace

    Discuss Discuss in Forum

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

    6. 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.

    View Answer

    Workspace

    Discuss Discuss in Forum

  6. Stored procedures have which of the following advantages?

    7. 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.

    View Answer

    Workspace

    Discuss Discuss in Forum

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

    8. 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.

    View Answer

    Workspace

    Discuss Discuss in Forum

  8. Which of the following is true concerning QBE?

    9. 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.

    View Answer

    Workspace

    Discuss Discuss in Forum

  9. Client/server security includes which of the following?

    10. A.

     Physical security
    B.

     Change control security
    C.

     Measures taken to secure all systems
    D.

     All of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

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

    11. 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.

    View Answer

    Workspace

    Discuss Discuss in Forum

Java Programming Questions and Answers Interview Questions and Answers