Discussion
Home ‣ Technical Questions ‣ Database Comments
- Question
The load and index 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
- Correct Answer
- A process to load the data in the data warehouse and to create the necessary indexes
- 1. A benefit of the three-tier architecture is which of the following?
Options- A. New modules can be built to support specific business needs
- B. Performance improves for compiled SQL statements
- C. Results in a thinner client and database server
- D. All of the above. Discuss
- 2. A transaction for which all committed changes are permanent is called:
Options- A. atomic.
- B. consistent.
- C. isolated.
- D. durable. Discuss
- 3. In the relational model, relationships between relations or tables are created by using:
Options- A. composite keys.
- B. determinants.
- C. candidate keys.
- D. foreign keys. Discuss
- 4. An entity is a thing in the real world with an independent existence.
Options- A. TRUE
- B. FALSE Discuss
- 5. Which of the following describes a relational database?
Options- A. It retrieves data related to its queries
- B. It provides a relationship between floats
- C. It provides a relationship between integers
- D. It consists of separate tables or related data Discuss
- 6. To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.
Options- A. ONLY
- B. DISTINCT
- C. UNIQUE
- D. SINGLE Discuss
- 7. The ODBC Level 1 API contains which of the following functions?
Options- A. Browse possible connections and data sources only
- B. Connect to data sources with driver-specific information only
- C. Process a scrollable cursor only
- D. Both 1 and 3 above are in the OBDC Level 1 API. Discuss
- 8. Cloud computing uses Server virtualization.
Options- A. TRUE
- B. FALSE Discuss
- 9. Cloud computing is not suited for situations
Options- A. where complex legacy systems have to be ported
- B. characterized by limited-time tasks
- C. involving offloading of expensive computing tasks
- D. with no existing regulatory compliance issues Discuss
- 10. A data dictionary is a special file that contains
Options- A. The width of all fields in all files
- B. The data type of all fields in all file
- C. The name of all fields in all files
- D. All of the above Discuss
Database problems
Search Results
Correct Answer: New modules can be built to support specific business needs
Correct Answer: durable.
Correct Answer: foreign keys.
Correct Answer: TRUE
Explanation:
Entity is a real world object
Correct Answer: It consists of separate tables or related data
Explanation:
A relational database is a digital database based on the relational model of data, a database structured to recognize relations between stored items of information. A software system used to maintain relational databases is a relational database management system.
Computer database in which all data is stored in Relations which (to the user) are tables with rows and columns. Each table is composed of records (called Tuples) and each record is identified by a field (attribute) containing a unique value. Every table shares at least one field with another table in 'one to one,' 'one to many,' or 'many to many' relationships. These relationships allow the database user to access the data in almost an unlimited number of ways, and to combine the tables as building blocks to create complex and very large databases.
Correct Answer: DISTINCT
Correct Answer: Connect to data sources with driver-specific information only
Correct Answer: TRUE
Correct Answer: where complex legacy systems have to be ported
Explanation:
Cloud computing is not suited for situations where complex legacy systems have to be ported.
Correct Answer: All of the above
Explanation:
A data dictionary is a special file that contains a set of information describing the contents, format, and structure of a database and the relationship between its elements, used to control access to and manipulation of the database.
Comments
There are no comments.More in Technical Questions:
Programming
Copyright ©CuriousTab. All rights reserved.