Discussion
Home ‣ Technical Questions ‣ Database Comments
- Question
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
- Correct Answer
- DISTINCT
- 1. 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 Discuss
- 2. 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
- 3. A transaction for which all committed changes are permanent is called:
Options- A. atomic.
- B. consistent.
- C. isolated.
- D. durable. Discuss
- 4. 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
- 5. An entity is a thing in the real world with an independent existence.
Options- A. TRUE
- B. FALSE Discuss
- 6. 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
- 7. Cloud computing uses Server virtualization.
Options- A. TRUE
- B. FALSE Discuss
- 8. 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
- 9. 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
- 10. We Can still delete a row from primary table if there are related rows in secondary table once a refferential integrity is enforced
Options- A. TRUE
- B. FALSE Discuss
Database problems
Search Results
Correct Answer: A process to load the data in the data warehouse and to create the necessary indexes
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: 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.
Correct Answer: FALSE
Explanation:
Can?t delete a row from primary table if there are related rows in secondary table.
Comments
There are no comments.More in Technical Questions:
Programming
Copyright ©CuriousTab. All rights reserved.