Discussion
Home ‣ Database ‣ Data Models into Database Designs See What Others Are Saying!
- Question
Which of the following situation requires the use of ID-dependent entities?
Options- A. Association relationships only
- B. Multivalued attributes only
- C. Archetype/instance relationships only
- D. All of the above use ID dependent entities
- Correct Answer
- All of the above use ID dependent entities
- 1. 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
- 2. Static extract is used for ongoing warehouse maintenance.
Options- A. True
- B. False Discuss
- 3. 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
- 4. 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
- 5. With SQL Server, parameters and variables in T-SQL start with the "%" sign.
Options- A. True
- B. False Discuss
- 6. The functional dependency R ? S means that the value of S can be determined when we are given a value of R.
Options- A. True
- B. False Discuss
- 7. A distributed database is which of the following?
Options- A. A single logical database that is spread to multiple locations and is interconnected by a network
- B. A loose collection of file that is spread to multiple locations and is interconnected by a network
- C. A single logical database that is limited to one location.
- D. A loose collection of file that is limited to one location. Discuss
- 8. Which of the following is NOT an Oracle-supported trigger?
Options- A. BEFORE
- B. DURING
- C. AFTER
- D. INSTEAD OF Discuss
- 9. A distributed database has which of the following advantages over a centralized database?
Options- A. Software cost
- B. Software complexity
- C. Slow Response
- D. Modular growth Discuss
- 10. ________ is considered to be one of the foundations of data access in the Microsoft world.
Options- A. ODBC
- B. OLE DB
- C. JPCD
- D. ADO Discuss
More questions
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
Correct Answer: True
Correct Answer: A single logical database that is spread to multiple locations and is interconnected by a network
Correct Answer: DURING
Correct Answer: Modular growth
Correct Answer: OLE DB
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.