Discussion
Home ‣ Technical Questions ‣ Database Comments
- Question
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.
- Correct Answer
- All of the above as goals of OLE DB.
- 1. ________ is a simple object model that is easier to understand and use than OLE DB, and is frequently used for database applications.
Options- A. ASP
- B. XML
- C. ODBC
- D. ADO Discuss
- 2. The ODBC core API consists of which of the following functions?
Options- A. Commit or rollback transactions only
- B. Connect to data sources only
- C. Connect to data sources with driver-specific information only
- D. Both 1 and 2 above are in the OBDC core API. Discuss
- 3. An Oracle System Change Number (SCN):
Options- A. is a value that is incremented whenever a dirty read occurs.
- B. is incremented whenever a deadlock occurs.
- C. is a value that keeps track of explicit locks.
- D. is a value that is incremented whenever database changes are made. Discuss
- 4. Of the three ways to create an Oracle database, which one is the easiest and most recommended?
Options- A. Using the Oracle Database Configuration Assistant.
- B. Using the Oracle-supplied database creation procedures.
- C. Using the SQL CREATE DATABASE command.
- D. None of the above is correct. Discuss
- 5. What SQL command will allow you to change the table STUDENT to add the constraint named GradeCheck that states that the values of the Grade column must be greater than 0?
Options- A. ALTER TABLE STUDENT ALTER CONSTRAINT GradeCheck (Grade > 0);
- B. ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck (Grade > 0);
- C. ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0);
- D. None of the above is correct. Discuss
- 6. Which JDBC driver Type(s) is(are) the JDBC-ODBC bridge?
Options- A. Type 1
- B. Type 2
- C. Type 3
- D. Type 4 Discuss
- 7. A composite attribute is which of the following?
Options- A. An attribute that can be broken into components
- B. An attribute that cannot be broken into components
- C. Multiple attributes
- D. An identifier Discuss
- 8. A ternary relationship involves how many entities?
Options- A. 3 or less
- B. 3
- C. More than 3
- D. 3 or more Discuss
- 9. Which of the following is not a database object in MS Access?
Options- A. Reports
- B. Relationships
- C. Tables
- D. Queries Discuss
- 10. Which of the following is true about cloud computing?
Options- A. Cloud computing has brought about a drop in hardware and software sales, while augmenting service revenues
- B. You can access your data from any computer in the world, as long as you have an Internet connection.
- C. Both A & B
- D. It's always going to be less expensive and more secure than local computing. Discuss
Database problems
Search Results
Correct Answer: ADO
Correct Answer: Both 1 and 2 above are in the OBDC core API.
Correct Answer: is a value that is incremented whenever database changes are made.
Correct Answer: Using the Oracle Database Configuration Assistant.
Correct Answer: ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0);
Correct Answer: Type 1
Correct Answer: An attribute that can be broken into components
Correct Answer: 3
Correct Answer: Relationships
Correct Answer: Both A & B
Comments
There are no comments.More in Technical Questions:
Programming
Copyright ©CuriousTab. All rights reserved.