SQL 1
Which of the following is used to create and maintain the physical database?
Database Management System (DBMS)
If entity A in Figure 2 represents customers and entity B represents automobiles, which of the following statements is correct?
Each customer can own many cars, but each car can be owned by only one customer.
Which of the following is an example of an attribute?
a person's hair color
Data mining refers to ____.
analyzing data already stored in a database
Which of the following terms refers to a group of related records?
file
What name is used to denote a common field that exists between two tables, but is also the primary key for one of the tables?
foreign key
Which of the following is used to uniquely identify each record?
primary key
Data in first normal form (1NF) does not contain which of the following?
repeating groups
In which step of the Systems Development Life Cycle (SDLC) is the solution to the identified problem determined and understood?
systems analysis
In which step of the Systems Development Life Cycle (SDLC) are the logical and physical components defined?
systems design
The multi-step process used when creating a new system is referred to as ____.
the Systems Development Life Cycle
Two tables can be linked or joined together through a common field.
true
Which statement best describes the relationship shown in Figure 1?
For every occurrence of A, there can only be one occurrence of B.
What is added to a relational database to eliminate many-to-many relationships?
bridging table
A DBMS includes which of the following capabilities?
data dictionary, multiuser access, security
A ____ is a group of interrelated files.
database
A ____ is a storage structure designed to hold a collection of data.
database
What represents a characteristic or attribute that is being collected about an entity?
field
Data in second normal form (2NF) may contain which of the following?
transitive dependencies
Which of the following committees are responsible for establishing SQL guidelines?
ANSI and ISO
