Discussion
Home ‣ Database ‣ ODBC, OLE DB, ADO, and ASP Comments
- Question
________ is an interface by which application programs can access and process SQL databases in a DBMS-independent manner.
Options- A. ODBC
- B. OLE DB
- C. JPCD
- D. ADO
- Correct Answer
- ODBC
- 1. What type of failure occurs when Oracle fails due to an operating system or computer hardware failure?
Options- A. Application failure
- B. Instance Failure
- C. Media Failure
- D. Rollback failure Discuss
- 2. Which SQL phrase is not supported by Oracle?
Options- A. ON DELETE CASCADE
- B. ON UPDATE CASCADE
- C. CREATE SEQUENCE [SequenceName]
- D. DROP SEQUENCE [SequenceName] Discuss
- 3. SQL*Plus will finish the statement and execute it when the user types in this:
Options- A. A left slash ( \ ) followed by [Enter].
- B. A colon ( : ) followed by [Enter].
- C. A semicolon ( ; ) followed by [Enter].
- D. A period ( . ) followed by [Enter]. Discuss
- 4. To obtain the structure of an Oracle table, the command to use is:
Options- A. STRUCTURE [TableName].
- B. DESCRIBE [TableName].
- C. DESCRIBE STRUCTURE [TableName].
- D. DESC TABLE [TableName]. Discuss
- 5. Which of the following is not true of SQL views?
Options- A. Oracle views cannot use the ORDER BY clause in view definitions.
- B. Oracle views are created using the standard SQL-92 CREATE VIEW command.
- C. Oracle views can by queried.
- D. The SQL-92 standard does not allow the use of the ORDER BY clause in view definitions. Discuss
- 6. In OLE DB, a tabular data provider:
Options- A. does not own data.
- B. transforms data through ODE DB interfaces.
- C. is both a consumer and a provider of data.
- D. exposes data via rowsets. Discuss
- 7. ________ is an object-oriented interface that encapsulates data-server functionality.
Options- A. ODBC
- B. OLE DB
- C. JPCD
- D. ADO Discuss
- 8. Which of the following are goals of OLE DB?
Options- A. Create object interfaces for DBMS functionality pieces only.
- B. Increase flexibility only.
- C. Object interface over any type of data only.
- D. All of the above as goals of OLE DB. Discuss
- 9. An ODBC data structure that identifies a database and the DBMS that processes it is called a(n):
Options- A. data source.
- B. driver manager.
- C. driver.
- D. API. Discuss
- 10. In OLE DB, which of the following represents characteristics of the recordset abstraction?
Options- A. Properties
- B. Collections
- C. Methods
- D. Abstractions Discuss
ODBC, OLE DB, ADO, and ASP problems
Search Results
Correct Answer: Instance Failure
Correct Answer: ON UPDATE CASCADE
Correct Answer: A semicolon ( ; ) followed by [Enter].
Correct Answer: DESCRIBE [TableName].
Correct Answer: Oracle views cannot use the ORDER BY clause in view definitions.
Correct Answer: exposes data via rowsets.
Correct Answer: OLE DB
Correct Answer: All of the above as goals of OLE DB.
Correct Answer: data source.
Correct Answer: Properties
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.