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