Sail E0 Webinar

MCQs

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

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