Sail E0 Webinar

MCQs

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

Latest Videos
Chapter 1 - GLOBAL STEEL SCENARIO & INDIAN STEEL INDUSTRY Part 1 : (13-04-2024) INDUSTRY AND COMPANY AWARENESS (ICA)
Direction Sense Test Part 1 Reasoning (Hindi)
Chapter 1 - RMHP / OHP / OB & BP Part 1 : (14-02-2024) GPOE
Cube & Cuboid Part 1 Reasoning (Hindi)
Data Interpretation (DI) Basic Concept Reasoning (Hindi)
Counting Figures Part 1 Counting Of Straight Lines Reasoning (Hindi)
Sail E0 free webinar Webinars
Real Numbers Part 7 Class 10 Maths
Real Numbers Part 1 Class 10 Maths
Polynomials Part 1 Class 10 Maths

Latest Test Papers

Pie Chart - Test Paper 1 Data Interpretation Reasoning & DI
Tabulation - Test Paper 2 Data Interpretation Reasoning & DI
Test Paper 1 Direction Sense Test Reasoning & DI
ICA , RDIC,GFM Free Modal Test Paper - Non - Technical Branch Old Syllabus 2022 - SAIL Junior Officer E0
GFM Combined 1 Free Revision Test SAIL JO E-0