Home
10th Grade
11th And 12th
11th Grade
12th Grade
3rd Grade
4th Grade
5th Grade
6th Grade
7th Grade
8th Grade
9th Grade
Advance Accountancy
Auditing
Computer Aptitude
Direct And Indirect Taxation
Exams
General Hindi
Indian Finance System
Information Technology And Application In Business
Macro Economics
Town Planning
Aerospace And Aeronautical
Analytical Instrumentation
Banking Awareness
Banking Exam
Biochemistry
Bioinformatics
Biology
Biotechnology
Business Statistics
C Program
C Programming
C++ Programming
Career Aptitude Test
Cell Biology
Central Superior Service (css)
Chemical Engineering
Chemistry
Civil Engineering
Commerce
Computer
Computer Fundamentals
Computer Science
Cost Accounting
Css
Database
Drug And Pharmaceutical Biotechnology
Ecat And Mcat Entry Test
Economics
Electrical Engineering
Electrical Engineering Questions
Electrical Measurement And Instrumentation
Engineering
English
English Literature
Environment Management
Environmental Biotechnology
Enzyme Technology
Financial Management And Financial Markets
Gate
General Knowledge
Graduate Assessment Test (gat)
Health And Physical
Heat Transfer
Html
Human Anatomy And Physiology
Human And Cultural Diversity
Human Resource Management
Ias
Indian Economy
Indian Economy
Indian General Awareness
Indian Geography
Indian Geography
Indian History
Indian History
Indian Polity
Instrumentation Transducers
International Relations
Java Program
Javascript
Judiciary And Law
Life Sciences
Management
Marketing And Marketing Management
Mass Transfer
Mechanical Engineering
Mechanics Of Materials
Medical Subjects
Microbiology
Networking
Php
Placement Tests
Professional Communication
Quantitative Aptitude
Reasoning Aptitude
Renewable Energy
Science
Sociology
Sql
Surveying
Total Quality Management
Uidai Aadhaar Supervisor Certification
Virology
Notificatin
Exam
Blog
Contact Us
And Asp(Engineering > Computer Science And Engineering > Database System > Odbc > Ole Db ) Questions and Answers
Home
Topic
Engineering
Computer Science And Engineering
Database System
Odbc
Ole Db
And Asp
Question 1.
ODBC minimum SQL grammar contains which of the following?
Stored Procedures only
CREATE VIEW, DROP VIEW only
Literals for date, time and timestamp only
INSERT, UPDATE, DELETE only
Explanation:-
Answer: Option D. ->
INSERT, UPDATE, DELETE only
Question 2.
ODBC core SQL grammar contains which of the following?:
Full SELECT (includes subqueries) only
INSERT, UPDATE, DELETE only
Both 1 and 3 above are contained in the ODBC core SQL.
Stored procedures only
Explanation:-
Answer: Option C. ->
Both 1 and 3 above are contained in the ODBC core SQL.
Question 3.
The ODBC core API consists of which of the following functions?
Commit or rollback transactions only
Connect to data sources only
Both 1 and 3 above are in the OBDC core API
Connect to data sources with driver-specific information only
Explanation:-
Answer: Option C. ->
Both 1 and 3 above are in the OBDC core API
Question 4.
________ is a simple object model that is easier to understand and use than OLE DB, and is frequently used for database applications.
XML
ASP
ODBC
ADO
Explanation:-
Answer: Option D. ->
ADO
Question 5.
When using ODBC, which of the following processes ODBC requests and submits specific SQL statements to a given type of data source?
DBMS
Data source
Driver manager
Driver
Explanation:-
Answer: Option D. ->
Driver
Question 6.
________ is an interface by which application programs can access and process SQL databases in a DBMS-independent manner.
ODBC
ADO
JPCD
OLE DB
Explanation:-
Answer: Option A. ->
ODBC
Question 7.
An ODBC data structure that identifies a database and the DBMS that processes it is called a(n):
API.
driver.
driver manager.
data source.
Explanation:-
Answer: Option D. ->
data source.
Question 8.
________ is considered to be one of the foundations of data access in the Microsoft world.
JPCD
ADO
OLE DB
ODBC
Explanation:-
Answer: Option C. ->
OLE DB
Question 9.
Which of the following are goals of OLE DB?
Create object interfaces for DBMS functionality pieces only.
Object interface over any type of data only.
Increase flexibility only.
All of these
Explanation:-
Answer: Option D. ->
All of these
Question 10.
In OLE DB, actions that an object can perform are called:
properties.
methods.
abstractions.
collections.
Explanation:-
Answer: Option B. ->
methods.
1
2
3
4
Next →
One click Login
Login With Google
Old way of Login
Login With Email