Discussion
Home ‣ Technical Questions ‣ Database Comments
- Question
When assessing the table structure of an acquired set of tables with data, accessing the validity of possible referential integrity constraints on foreign keys is (part of) the:
Options- A. first step.
- B. second step.
- C. third step.
- D. fourth step.
- Correct Answer
- third step.
- 1. If a table has been normalized so that all determinants are candidate keys, then that table is in:
Options- A. 1NF
- B. 2NF
- C. 3NF
- D. BCNF Discuss
- 2. 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
- 3. The HAVING clause does which of the following?
Options- A. Acts like a WHERE clause but is used for groups rather than rows.
- B. Acts like a WHERE clause but is used for rows rather than columns.
- C. Acts like a WHERE clause but is used for columns rather than groups.
- D. Acts EXACTLY like a WHERE clause. Discuss
- 4. When an entity instance may be a member of multiple subtypes or it does not have to be a member of a subtype, it is which of the following?
Options- A. Disjoint with total specialization
- B. Disjoint with partial specialization
- C. Overlap with total specialization
- D. Overlap with partial specialization Discuss
- 5. To eliminate definition duplication, XML Schemas define:
Options- A. an intersection table.
- B. global elements.
- C. a normalized definition table.
- D. None of the above is correct. Discuss
- 6. Legacy data is which of the following?
Options- A. Data contained in a newly-installed system
- B. Data rejected during the installation of a new system
- C. Data contained in a file system
- D. Data contained by a system used prior to the installation of a new system Discuss
- 7. The command to eliminate a table from a database is
Options- A. REMOVE TABLE CUSTOMER;
- B. UPDATE TABLE CUSTOMER;
- C. DELETE TABLE CUSTOMER;
- D. DROP TABLE CUSTOMER; Discuss
- 8. 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
- 9. An entity is a thing in the real world with an independent existence.
Options- A. TRUE
- B. FALSE Discuss
- 10. 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
Database problems
Search Results
Correct Answer: BCNF
Correct Answer: Both IN and NOT IN.
Correct Answer: Acts like a WHERE clause but is used for groups rather than rows.
Correct Answer: Overlap with total specialization
Correct Answer: global elements.
Correct Answer: Data contained by a system used prior to the installation of a new system
Correct Answer: DROP TABLE CUSTOMER;
Explanation:
The SQL DROP TABLE statement is used to remove a table definition and all data, indexes,...
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: TRUE
Explanation:
Entity is a real world object
Correct Answer: foreign keys.
Comments
There are no comments.More in Technical Questions:
Programming
Copyright ©CuriousTab. All rights reserved.