PT2520 Database Concepts Final Exam (ITT Tech)
Which of the following is a built-in database role that allows a user control over the database?
Which of the following best describes what would be returned by this query criterion? WHERE CustomerCity = Seattle OR CustomerLastName LIKE ‘M%’
The focus of a database, the business problem it is designed to solve, is called
You cannot enter data into a foreign key table unless it is related to an existing record in the primary key table, which action is most affected by this rule?
Which of the following is a term for an entity that resolves a many-to-many relationship?
What type of relationship is depicted in this ERD?
Which of the following best describes what would be returned by a query with the following criteria? WHERE CustomerLastName LIKE ‘T%’
Which of the following is a variable character type?
Which of the following best defines “security requirement”?
Which statement best defines a natural key?
Which of the following is the portion of SQL used to select and edit data?
Observing people at work to see how they interact with the data is called _
Which of the following best defines the term “aggregate function”?
A key that consists of two or more attributes combined to make a unique value is called a
In the SQL Management Studio you can create relationships by dragging between entities in the
Which term best describes the type of entity shown here?
Every action that occurs in the database is a
A database entity can best be described as
Which of the following is not acceptable to alias a column called CustomerFirstName?
Which of the following best defines the term “normalization”?
Which of the following is the type of join that uses the WHERE clause with an equal sign to relate tables?
Which of the following terms means determining if a user is who he or she claims to be?
A collection of related permissions is called a
In the following entity, what would be the best data type for BuildingAddress?
Which of the following is the normal form that removes all transient dependencies?
Which statement describes some of the advantages of enforcing “referential integrity”?
Which statement best describes the function of a primary key?
A document that has the primary purpose of summarizing and displaying data is called
What term best describes the entity Employee Dependent?
What is the error in the following SQL statement?
SELECT CustomerCity, Count (CustomerKey) FROM Customer GROUP BY CustomerCity WHERE Count (CustomerCity) > 20
Which phase best defines data integrity?
A deletion anomaly occurs
What would be the effect of this UPDATE statement?
UPDATE Customer SET CustomerLastName “Smith”
Which of the following is the best definition for the term “permission”?
Which of the following best defines the term “data type”?
A column specification that determines what kind of data can be stored in a column
Which statement best describes the function of a foreign key?
When you design a table you should allow nulls if
Redundancy refers to what database condition?
Which of the following is the normal form that removes all repeating groups and arrays?
Which of the following is the type of join that only returns related records from the joined tables?
Which phrase best defines the term “database requirement”?
Which of the following statements is an advantage of a natural key?
Which of the following best describes the use of the ” In SELECT *?
Which of the following is a serverlevel account?
Which of the following terms best describes an attribute or combination of attributes that could be used as the primary key for an entity?
Which statement best defines the function of SQL in a database?
Which of the following best defines the term “referential integrity”?
Which of the following best defines the term “null”?
When you encounter a many-to-many relationship you should always
Which of the following is the term for database design adapted to the features and limitations of the database management system?
No comments:
Post a Comment