Dbmss Are Used Primarily For Modeling Data
Question: A database is a collection of integrated and related________.
fields
B. attributes
C. records
D. files
Answer: files
Question: DBMSs are used primarily for modeling data.
True
False
Answer: False
Question:
Answer: B and C
Question: A(n) ________ is a field or set of fields in a record that uniquely identifies the record.
A. attribute
B. entity
C. primary key
D. data item
Answer: primary key
Question: Drill down? (not roll up)
Answer: Starting from monthly sales data, if you wish to get weekly sales data, use the ________ feature.
A. roll up
B. drill down
C. slice and dice
D. extract data
Question: A _________ is a collection of instructions and commands used to define and describe data and relationships in a specific database.
A. data dictionary
B. schema
C. data definition language
D. data manipulation language
Answer: Data Definition Language
Question:
Answer: C. Database admin= service provider and Data admib=organziation
Question: A _______ is a subset of a data warehouse that is used by small and medium-sized businesses and departments within larger companies to support decision making.
A. data dictionary
B. data model
C. data mart
D. data mine
Answer: data mart
Question: Which is an example of a many to many relationship
A. Class and Students
B. Customers and orders
C. Faculty teaching several classes, but a class taught by one faculty
D. B and C only
E. All of the above
Answer: Class and Students
Question: To ensure reliability and integrity, SQL, databases conform to four specific properties. Which of the following is NOT one of those four properties?
A. atomicity
B. durability
C. isolation
D. currency
Answer: currency