File Info
| Exam | CIW v5 Database Design Specialist |
| Number | 1D0-541 |
| File Name | CIW.1D0-541.PracticeTest.2018-02-12.124q.tqb |
| Size | 5 MB |
| Posted | Feb 12, 2018 |
| Download | CIW.1D0-541.PracticeTest.2018-02-12.124q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
With regard to databases, what is normalization?
- The process of reducing the cardinality of a relation
- The process of organizing and refining relations
- The process of duplicating data to reduce the number of tables
- The process of limiting data stored in a table to a specific range of values
Correct answer: B
Question 2
Which three pieces of information did E.F. Codd describe as necessary to retrieve a data value from a relational database?
- Attribute, domain, and tuple
- Entity, relation name, and domain
- Table name, primary key, and entity
- Attribute, relation name, and primary key
Correct answer: D
Question 3
What is a virtual table?
- A virtual table is a relation created as the result of data manipulation; it exists only in computer memory, and is not a permanent part of the database.
- A virtual table is a relation stored in the database; it is used when multiple users access the same relation in a database.
- A virtual table is a relation derived from the database data dictionary; it contains metadata about a base relation. A virtual table is a relation derived from the database? data dictionary; it contains metadata about a base relation.
- A virtual table is a relation that consists of primary and foreign keys for a particular set of relations in a database.
Correct answer: A
