Students also studied
Study guides
Practice questions for this set
Which of the following is true about database columns?
Two columns can contain the same information
No two columns on the same table can have the same name
Database tables may not have more than thở three columns
Database columns must appear in alphabetical order
Which of the following should not use a domain name of text?
Birthdate
LastName
ZipCode
StreetAddress
Consider the following table. The area in the red rectangle represents which data element?
A relationship
A record
A table
An attribute
Which of the following issues tự we try to lớn address when designing database tables?
Data integrity
Data quality
Ensuring each table contains data about only one theme
Limiting duplicated data
Each of the above statements are true
The relational database model is named after the mathematical term for a two-dimensional table.
Consider the following table. The area in the red rectangle represents which data element?
A relationship
A record
A table
An attribute
Which of the following issues tự we try to lớn address when designing database tables?
Data integrity
Data quality
Ensuring each table contains data about only one theme
Limiting duplicated data
Each of the above statements are true
Each of the above statements are true
Which of the following is true about database columns?
Two columns can contain the same information
No two columns on the same table can have the same name
Database tables may not have more than thở three columns
Database columns must appear in alphabetical order
No two columns on the same table can have the same name
Which of the following would be an appropriate domain name for a table column that contains information about the age of people?
Any of these would be appropriate.
A mix of positive and negative numbers.
A mix of up to lớn 10 letters and numbers.
A mix of three-digit positive numbers.
A mix of three-digit positive numbers.
Which of the following is true about database rows?
Information about the same instance can be split across rows
They contain information about many instances of the table
They contain information about only one instance of the table
None of the above statements are true about database rows
They contain information about only one instance of the table
Which of the following best describes what a database management system tool is used for?
Used to lớn minimize data storage, enhance data quality, and provide access to lớn data.
Used to lớn maximize data storage, preserve data quality and prevent unwanted access to lớn data.
Used to lớn optimizes data storage, preserve data quality, and provide access to lớn data.
Used to lớn optimize data storage, enhance data quality, and prevent unwanted access to lớn data.
Used to lớn optimizes data storage, preserve data quality, and provide access to lớn data.
Why is it important to lớn Normalize data in a database?
Duplicate data can lead to lớn problems over time.
Reduces the need to lớn updated in multiple places.
Ensures that each table contains data about very specific things.
All of the above are important for a Normalized database.
All of the above are important for a Normalized database.
Which of the following would not be descriptive as a heading for a column that contained text about what an employee does?
Title
JobTitle
JobNumber
Position
Which of the following should not use a domain name of text?
Birthdate
LastName
ZipCode
StreetAddress