MCQs > Database Management > Database MCQs > Basic Database MCQs

Basic Database MCQ

1. The _____ model uses the term connectivity to label the relationship types.

Answer

Correct Answer: Entity relationship

Note: This Question is unanswered, help us to find answer for this one

2. The default comparison condition for the subtype discriminator attribute is the _____ comparison.

Answer

Correct Answer: Equality

Note: This Question is unanswered, help us to find answer for this one

3. ____________________ is a process to help reduce the likelihood of data anomalies.

Answer

Correct Answer: Normalization

Note: This Question is unanswered, help us to find answer for this one

4. A(n) ____ is a piece of data required by an action in a macro.

Answer

Correct Answer: Argument

Note: This Question is unanswered, help us to find answer for this one

5. Some very specialized applications may require normalization beyond the _____.

Answer

Correct Answer: 4NF

Note: This Question is unanswered, help us to find answer for this one

6. A/an ___________________ report shows a summary but no details.

Answer

Correct Answer: Aggregate

Note: This Question is unanswered, help us to find answer for this one

7. A(n) ____ is a query that is embedded (or nested) inside another query.

Answer

Correct Answer: Subquery.

Note: This Question is unanswered, help us to find answer for this one

8. The _____ component of a case tool produces the information system's input/output formats.

Answer

Correct Answer: Screen painter and report generator

Note: This Question is unanswered, help us to find answer for this one

9. The term _________________________ refers to scattered locations storing the same basic data.

Answer

Correct Answer: Islands of information

Note: This Question is unanswered, help us to find answer for this one

10. A programming language typically used for cgi scripts is ____.

Answer

Correct Answer: PERL

Note: This Question is unanswered, help us to find answer for this one

11. The crows feet notation on an erd is a type of _______ constraint.

Answer

Correct Answer: ​cardinality

Note: This Question is unanswered, help us to find answer for this one

12. To include all fields in a sql query, use the ____ symbol after the word select.

Answer

Correct Answer: Asterisk (*)

Note: This Question is unanswered, help us to find answer for this one

13. _____ refer to databases focused on addressing the concerns of a specific problem or business unit

Answer

Correct Answer: Data marts

Note: This Question is unanswered, help us to find answer for this one

14. A(n) ____ is an application programs or an individual users picture of the database.

Answer

Correct Answer: View

Note: This Question is unanswered, help us to find answer for this one

15. The sdlc phase in which the detailed conceptual data model is created is the ________ phase.

Answer

Correct Answer: Analysis

Note: This Question is unanswered, help us to find answer for this one

16. The relationships between tables are handled through ____________________ columns.

Answer

Correct Answer: Common

Note: This Question is unanswered, help us to find answer for this one

17. In a relational database, a row can be referred to as a(n) ____.

Answer

Correct Answer: Tuple

Note: This Question is unanswered, help us to find answer for this one

18. The relational database model enables you to view data ____ rather than ____.

Answer

Correct Answer: Logically, physically

Note: This Question is unanswered, help us to find answer for this one

search