Which of the following describes the function of a data dictionary?

To store metadata, and information about fields, tables, and constraints.

Which is NOT an aspect of normalization?

graphic model helps ensure the new system meets needs

Which is not one of the basics of a relational database?

Primary keys can be a null value

What is a primary key?

The database attribute that uniquely identifies a specific row in a table

studbud

Chapter 4: Relational Databases

15 termsStudBud Administration11 plays

Imported from external platform

Flashcards15 cardsFPractice quizPHost liveL

Questions 15

Answers

1
Which of the following describes the function of a data dictionary?
It directly manipulates data for business transactions.
It provides an external user's view of the database.
It physically stores all records in a database.
To store metadata, and information about fields, tables, and constraints.
2
The conceptual-level schema provides an individual user’s view of the database, also known as a subschema.
True
False
3
The entity integrity rule says foreign keys must link to the value of a primary key in another table
False
True
4
Which is NOT an aspect of normalization?
graphic model helps ensure the new system meets needs
assumes everything is initially stored in one large table
turns initial table into a sec called third normal form
designs a relational database free from anomalies
5
Which of the following is not a type of attribute?
Formal
Non-key
Foreign
Primary
6
Which attribute would make the best primary key?
Customer ID
Customer Name
Customer Phone Number
Customer Address
7
Which of the following are examples of SQL commands?
SELECT
DELETE
INSERT
All of the above
8
What is the DBMS language that is responsible for creating the database and describing logical views?
Structured Query Language (SQL)
Data Manipulation Language (DML)
Online Transaction Processing Language (OTPL)
Data Definition Language (DDL)
9
Which of the following is NOT a type of anomaly?
Review
Delete
Update
Insert
10
Which is not one of the basics of a relational database?
Non-null foreign keys must have a corresponding primary key
Every column in a row must have a single value
All non-key attributes describe a characteristic of the object represented
Primary keys can be a null value
11
An advantage of databases over file-based systems is the elimination of data redundancy and inconsistency.
False
True
12
Which of these are common ways to create a query in Microsoft Access?
query design grid & SQL
query design grid & data analysis tab
C++ & SQL
SQL & Python
13
What does DBMS stand for?
Database moving software
Database management system
Database maintenance system
Database management software
14
What is a primary key?
The database attribute that uniquely identifies a specific row in a table
Any other attributes that store information about the entity
An attribute that pulls up the color of an item
An attribute that is also a primary key in another table
15
The logical view of a database determines how data is physically stored on a computer.
True
False

Chapter 4: Relational Databases Flashcards | StudBud