Sail E0 Webinar

MCQs

Total Questions : 40 | Page 2 of 4 pages
Question 11. In OLE DB, which of the following represents characteristics of the recordset abstraction?
  1.    Properties
  2.    Collections
  3.    Methods
  4.    Abstractions
 Discuss Question
Answer: Option A. -> Properties
Question 12. The ODBC Level 1 API contains which of the following functions?
  1.    Both 1 and 3 above are in the OBDC Level 1 API
  2.    Process a scrollable cursor only
  3.    Browse possible connections and data sources only
  4.    Connect to data sources with driver-specific information only
 Discuss Question
Answer: Option D. -> Connect to data sources with driver-specific information only
Question 13. In ODBC, a file that can be shared among database users is called a:
  1.    file data source.
  2.    user data source.
  3.    system data source.
  4.    SQL text file.
 Discuss Question
Answer: Option A. -> file data source.
Question 14. ________ is an object-oriented interface that encapsulates data-server functionality.
  1.    ADO
  2.    ODBC
  3.    OLE DB
  4.    JPCD
 Discuss Question
Answer: Option C. -> OLE DB
Question 15. When using ODBC, which of the following serves as an intermediary between the application and the DBMS drivers?
  1.    Driver
  2.    Data source
  3.    Driver manager
  4.    OLE DB
 Discuss Question
Answer: Option C. -> Driver manager
Question 16. In OLE DB, a service provider:
  1.    is both a consumer and a provider of data only.
  2.    transforms data through OLE DB interfaces only.
  3.    All of these
  4.    does not own data only.
 Discuss Question
Answer: Option C. -> All of these
Question 17. The ODBC Level 2 API contains which the following functions?
  1.    All of these
  2.    Commit or rollback transactions only
  3.    Connect to data sources only
  4.    Connect to data sources with driver-specific information only
 Discuss Question
Answer: Option A. -> All of these
Question 18. In OLE DB, a tabular data provider:
  1.    transforms data through ODE DB interfaces.
  2.    exposes data via rowsets.
  3.    does not own data.
  4.    is both a consumer and a provider of data.
 Discuss Question
Answer: Option B. -> exposes data via rowsets.
Question 19. In ODBC, a data source that is local to a single computer is called a:
  1.    user data source.
  2.    system data source.
  3.    SQL text file.
  4.    file data source.
 Discuss Question
Answer: Option B. -> system data source.
Question 20. ________ is a cover for utilizing OLE DB that is designed for use by almost any language.
  1.    ODBC
  2.    JPCD
  3.    ADO
  4.    ASP
 Discuss Question
Answer: Option C. -> ADO

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

DSP Combined 1 Free Revision Test SAIL JO E-0
GPOE / GPA Combined 1 Free Revision Test SAIL JO E-0
BSP Plant Specific Review Test SAIL JO E-0
BSL Combined 1 Free Revision Test SAIL JO E-0
GFM Combined 1 Free Revision Test SAIL JO E-0