Discussion
Home ‣ Database ‣ JDBC, Java Server Pages, and MySQL See What Others Are Saying!
- Question
How does Tomcat execute a JSP?
Options- A. As a CGI script
- B. As an independent process
- C. By one of Tomcat's threads
- D. None of the above is correct.
- Correct Answer
- By one of Tomcat's threads
- 1. Which of the following is an SQL trigger supported by Oracle?
Options- A. BEFORE
- B. INSTEAD OF
- C. AFTER
- D. All of the above. Discuss
- 2. The primary mechanism for providing context for data is metadata.
Options- A. True
- B. False Discuss
- 3. Data scrubbing is which of the following?
Options- A. A process to reject data from the data warehouse and to create the necessary indexes
- B. A process to load the data in the data warehouse and to create the necessary indexes
- C. A process to upgrade the quality of data after it is moved into a data warehouse
- D. A process to upgrade the quality of data before it is moved into a data warehouse Discuss
- 4. The entity integrity rule states that:
Options- A. no primary key attribute may be null.
- B. no primary key can be composite.
- C. no primary key may be unique.
- D. no primary key may be equal to a value in a foreign key. Discuss
- 5. Replication may use either synchronous or asynchronous distributed database technologies, although asynchronous technologies are more typical in a replicated environment.
Options- A. True
- B. False Discuss
- 6. When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):
Options- A. LIKE only.
- B. IN only.
- C. NOT IN only.
- D. Both IN and NOT IN. Discuss
- 7. Static extract is used for ongoing warehouse maintenance.
Options- A. True
- B. False Discuss
- 8. Which of the following is true concerning an ODBMS?
Options- A. They have the ability to store complex data types on the Web.
- B. They are overtaking RDBMS for all applications.
- C. They are most useful for traditional, two-dimensional database table applications.
- D. All of the above. Discuss
- 9. Which of the following statements is true concerning routines and triggers?
Options- A. Both consist of procedural code.
- B. Both have to be called to operate.
- C. Both run automatically.
- D. Both are stored in the database. Discuss
- 10. With SQL Server, parameters and variables in T-SQL start with the "%" sign.
Options- A. True
- B. False Discuss
More questions
Correct Answer: All of the above.
Correct Answer: True
Correct Answer: A process to upgrade the quality of data before it is moved into a data warehouse
Correct Answer: no primary key attribute may be null.
Correct Answer: True
Correct Answer: Both IN and NOT IN.
Correct Answer: False
Correct Answer: They have the ability to store complex data types on the Web.
Correct Answer: Both consist of procedural code.
Correct Answer: False
Comments
There are no comments.More in Database:
Advanced SQLData and Database AdministrationData Modeling with ER ModelData Models into Database DesignsData WarehousingDatabase Design Using NormalizationDatabase Processing for BISDatabase RedesignDistributed DatabasesER Model and Business RulesIntroduction to DatabaseIntroduction to SQLJDBC, Java Server Pages, and MySQLLogical Database DesignManaging Databases with OracleManaging Multiuser DatabasesModeling Data in the OrganizationObject-Oriented Data ModelingObject-Oriented DatabaseODBC, OLE DB, ADO, and ASPPhysical Database DesignSQL for Database ConstructionSQL Server 2000The Client-Server DatabaseThe Database Development ProcessThe Database EnvironmentThe Internet Database EnvironmentThe Relational Model and NormalizationXML and ADO.NETProgramming
Copyright ©CuriousTab. All rights reserved.