Discussion
Home ‣ Database ‣ JDBC, Java Server Pages, and MySQL See What Others Are Saying!
- Question
To run a compiled Java program, the machine must have what loaded and running?
Options- A. Java virtual machine
- B. Java compiler
- C. Java bytecode
- D. A Web browser
- Correct Answer
- Java virtual machine
- 1. What is not true of a Java bean?
Options- A. There are no public instance variables.
- B. All persistent values are accessed using getxxx and setxxx methods.
- C. It may have many constructors as necessary.
- D. All of the above are true of a Java bean. Discuss
- 2. With which type of SQL Server recovery model are all database changes logged?
Options- A. Differential recovery
- B. Full recovery
- C. Simple recovery
- D. Bulk-logged recovery Discuss
- 3. The DBMS acts as an interface between what two components of an enterprise-class database system?
Options- A. Database application and the database
- B. Data and the database
- C. The user and the database application
- D. Database application and SQL Discuss
- 4. A binary relationship cannot be which of the following?
Options- A. One-to-One
- B. One-to-Many
- C. Many-to-Many
- D. Zero-to-Zero Discuss
- 5. SQL Server supports three recovery modes: simple, full and Bulk.
Options- A. True
- B. False Discuss
- 6. The SQL statement to create a view is:
Options- A. CREATE VIEW.
- B. MAKE VIEW.
- C. SELECT VIEW.
- D. INSERT VIEW. Discuss
- 7. When using the SQL INSERT statement:
Options- A. rows can be modified according to criteria only.
- B. rows cannot be copied in mass from one table to another only.
- C. rows can be inserted into a table only one at a time only.
- D. rows can either be inserted into a table one at a time or in groups. Discuss
- 8. An application where only one user accesses the database at a given time is an example of a(n) ________ .
Options- A. single-user database application
- B. multiuser database application
- C. e-commerce database application
- D. data mining database application Discuss
- 9. When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):
Options- A. transitive dependency.
- B. insertion anomaly.
- C. referential integrity constraint.
- D. normal form. Discuss
- 10. Which type of entity represents a logical generalization whose actual occurrence is represented by a second, associated entity?
Options- A. Supertype entity
- B. Subtype entity
- C. Archetype entity
- D. Instance entity Discuss
More questions
Correct Answer: It may have many constructors as necessary.
Correct Answer: Full recovery
Correct Answer: Database application and the database
Correct Answer: Zero-to-Zero
Correct Answer: True
Explanation:
SQL Server provides three different recovery models that allow you to specify the way SQL Server manages log files and prepares your enterprise for a disaster. Each of these models represents a different approach to balancing the tradeoff between conserving disk space and providing for granular disaster recovery options. The three disaster recovery models offered by SQL Server are:
1. Simple Recovery Model
2. Full Recovery Model
3. Bulk-logged Recovery Model
Correct Answer: CREATE VIEW.
Correct Answer: rows can either be inserted into a table one at a time or in groups.
Correct Answer: single-user database application
Correct Answer: referential integrity constraint.
Correct Answer: Archetype entity
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.