Discussion
Home ‣ Database ‣ Physical Database Design See What Others Are Saying!
- Question
Which of the following improves a query's processing time?
Options- A. Write complex queries.
- B. Combine a table with itself.
- C. Query one query within another.
- D. Use compatible data types.
- Correct Answer
- Use compatible data types.
- 1. A time stamp is a time value that is associated with a data value.
Options- A. True
- B. False Discuss
- 2. Database objects are almost always transient.
Options- A. True
- B. False Discuss
- 3. In ODBC, a file that can be shared among database users is called a:
Options- A. system data source.
- B. file data source.
- C. user data source.
- D. SQL text file. Discuss
- 4. What is an SQL virtual table that is constructed from other tables?
Options- A. Just another table
- B. A view
- C. A relation
- D. Query results Discuss
- 5. ________ was adopted as a national standard by ANSI in 1992.
Options- A. Oracle
- B. SQL
- C. Microsoft Access
- D. DBase Discuss
- 6. The most popular way to materialize XML documents is to use:
Options- A. DTD.
- B. XSLT.
- C. HTML.
- D. SOAP. Discuss
- 7. When the parent entity is required, a new parent row can always be inserted.
Options- A. True
- B. False Discuss
- 8. Table is synonymous with the term:
Options- A. record.
- B. relation.
- C. column.
- D. field. Discuss
- 9. Proper normalization eliminates duplicated data.
Options- A. True
- B. False Discuss
- 10. JDBC stands for Java Database Connectivity
Options- A. True
- B. False Discuss
More questions
Correct Answer: True
Correct Answer: False
Correct Answer: file data source.
Correct Answer: A view
Correct Answer: SQL
Correct Answer: XSLT.
Correct Answer: True
Correct Answer: relation.
Correct Answer: False
Correct Answer: True
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.