Discussion
Home ‣ Database ‣ Introduction to Database See What Others Are Saying!
- Question
Which of the following products was an early implementation of the relational model developed by E.F. Codd of IBM?
Options- A. IDMS
- B. DB2
- C. dBase-II
- D. R:base
- Correct Answer
- DB2
- 1. 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. Discuss
- 2. XML is which of the following?
Options- A. A scripting language that states the rules for tagging elements.
- B. A programming language that states the rules for tagging elements.
- C. A programming language that allows the creation of customized tags.
- D. A scripting language that allows the creation of customized tags. Discuss
- 3. To define what columns should be displayed in an SQL SELECT statement:
Options- A. use FROM to name the source table(s) and list the columns to be shown after SELECT.
- B. use USING to name the source table(s) and list the columns to be shown after SELECT.
- C. use SELECT to name the source table(s) and list the columns to be shown after USING.
- D. use USING to name the source table(s) and list the columns to be shown after WHERE. Discuss
- 4. Locking may cause which of the following problems?
Options- A. Erroneous updates
- B. Deadlock
- C. Versioning
- D. All of the above. Discuss
- 5. It is usually not very important to design the physical database to minimize the time required by users to interact with the information systems.
Options- A. True
- B. False Discuss
- 6. The UML notation is useful for graphically depicting an object-oriented analysis or design model.
Options- A. True
- B. False Discuss
- 7. The driver manager processes ODBC requests and submits specific SQL statements to a given type of data source.
Options- A. True
- B. False Discuss
- 8. Which of the following is true concerning the following statement: class Manager extends Employee
Options- A. Manager is a concrete class and a superclass.
- B. Manager is a concrete class and a subclass.
- C. Manager is an abstract class and a superclass.
- D. Manager is an abstract class and a subclass. Discuss
- 9. Which of the following refers to the SQL Server transaction isolation level which places and holds locks on all rows that are read?
Options- A. REPEATABLE READ
- B. SERIALIZABLE
- C. READ COMMITTED
- D. READ UNCOMMITTED Discuss
- 10. Data warehouse data are usually normalized.
Options- A. True
- B. False Discuss
More questions
Correct Answer: Use compatible data types.
Correct Answer: A scripting language that allows the creation of customized tags.
Correct Answer: use FROM to name the source table(s) and list the columns to be shown after SELECT.
Correct Answer: Deadlock
Correct Answer: False
Correct Answer: True
Correct Answer: False
Correct Answer: Manager is a concrete class and a subclass.
Correct Answer: REPEATABLE READ
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.