Discussion
Home ‣ Database ‣ Introduction to Database See What Others Are Saying!
- Question
Microsoft Access is an enterprise-class database product.
Options- A. True
- B. False
- Correct Answer
- False
- 1. Which JDBC driver Type(s) can you use in a three-tier architecture and if the Web server and the DBMS are running on the same machine?
Options- A. Type 1 only
- B. Type 2 only
- C. Both Type 3 and Type 4
- D. All of Type 1, Type 2, Type 3 and Type 4 Discuss
- 2. Which type of entity cannot exist in the database unless another type of entity also exists in the database, but does not require that the identifier of that other entity be included as part of its own identifier?
Options- A. Weak entity
- B. Strong entity
- C. ID-dependent entity
- D. ID- independent entity Discuss
- 3. What is an advantage of placing computations in SQL views?
Options- A. To save users from having to write an expression.
- B. To ensure that the results are consistent.
- C. To accomplish both of the above.
- D. None of the above is correct - computations cannot be placed in a view. Discuss
- 4. The DROP TABLE statement:
Options- A. deletes the table structure only.
- B. deletes the table structure along with the table data.
- C. works whether or not referential integrity constraints would be violated.
- D. is not an SQL statement. Discuss
- 5. An OLE DB interface is specified by a set of objects and the properties and methods that they expose.
Options- A. True
- B. False Discuss
- 6. A constructor operation does which of the following?
Options- A. Creates a new instance of a class
- B. Updates an existing instance of a class
- C. Deletes and existing instance of a class
- D. All of the above. Discuss
- 7. Which of the following disallows both dirty reads and nonrepeatable reads, but allows phantom reads?
Options- A. Read committed
- B. Read uncommitted
- C. Repeatable read
- D. Serializable Discuss
- 8. An enterprise database is which of the following?
Options- A. A database designed to support only users external to an organization
- B. A database designed to support an entire organization
- C. A database designed to support a relatively small group
- D. A database designed to support a single PC Discuss
- 9. Data administrators are responsible for:
Options- A. physical database design.
- B. managing technical issues in the database environment.
- C. overall management of data resources in an organization.
- D. writing application programs. Discuss
- 10. Which of the following occurs when a transaction rereads data it has previously read and finds modification or deletions caused by a committed transaction?
Options- A. Nonrepeatable read
- B. Phantom read
- C. Dirty read
- D. Consistent read Discuss
More questions
Correct Answer: All of Type 1, Type 2, Type 3 and Type 4
Correct Answer: Weak entity
Correct Answer: To accomplish both of the above.
Correct Answer: deletes the table structure along with the table data.
Correct Answer: True
Correct Answer: Creates a new instance of a class
Correct Answer: Repeatable read
Correct Answer: A database designed to support an entire organization
Correct Answer: overall management of data resources in an organization.
Correct Answer: Nonrepeatable read
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.