Question 1 of 25
Hints left: 3
Q1
The ODBC core API consists of which of the following functions?
Q2
Which of the following are goals of OLE DB?
Q3
________ is a simple object model that is easier to understand and use than OLE DB, and is frequently used for database applications.
Q4
The only time that case matters is inside quotation marks of strings.
Q5
When using ODBC, which of the following serves as an intermediary between the application and the DBMS drivers?
Q6
In ODBC, a file that can be shared among database users is called a:
Q7
If there is only one statement and no ambiguity about what is wanted, Oracle will treat the semicolon and slash as the same.
Q8
When using ODBC, which of the following processes ODBC requests and submits specific SQL statements to a given type of data source?
Q9
An ODBC data structure that identifies a database and the DBMS that processes it is called a(n):
Q10
ODBC core SQL grammar contains which of the following?:
Q11
When you type into SQL*Plus and press enter, the statement will be finished and executed.
Q12
The ODBC Level 1 API contains which of the following functions?
Q13
Oracle, the world's most popular DBMS, is powerful and robust, running on many different operating systems.
Q14
Sequences guarantee valid surrogate key values.
Q15
ODBC minimum SQL grammar contains which of the following?
Q16
________ is an interface by which application programs can access and process SQL databases in a DBMS-independent manner.
Q17
________ is an object-oriented interface that encapsulates data-server functionality.
Q18
In OLE DB, which of the following represents characteristics of the recordset abstraction?
Q19
Oracle will let you define Notepad as your default editor, and whenever you type NOTEPAD, SQL*Plus will invoke Notepad.
Q20
________ is considered to be one of the foundations of data access in the Microsoft world.
Q21
In OLE DB, actions that an object can perform are called:
Q22
Oracle does NOT support a CASCADE UPDATE constraint.
Q23
Oracle allows the ORDER BY clause in view definitions.
Q24
You can use the DROP statement to remove structures from the database.
Q25
Oracle commands, column names, table names, view names and all other database elements are case sensitive.