quiz 3 Flashcards
Which of the following best defines a surrogate key?
It is an arbitrary, random key with no business meaning
Which of the following is a permission that grants a user the right to view data?
Select
Which of the following best describes an artificially generated attribute used as a key?
Surrogate key
A requirement that refers to the need to restrict or grant access to data or database objects is called a:
Security requirement
Which of the following best defines a composite key?
It is made up of two or more attributes combined
Which best describes a trigger?
A program usually written in SQL that is triggered by a database event such as an insert or delete
Which of the following is important to do after you have identified all the requirements and business rules?
Review them with the relevant stakeholders to make sure they are complete and accurate
A program that requests services from another program is called:
A client
Which of the following is a permission that grants the user the right to change existing data?
Update
SQL code that executes in response to a database event is called:
A trigger
A requirement that refers to the attributes that must be stored in the database to fulfill business needs is called a:
Data requirement
Which of the following best defines the term problem domain?
The business problem the database is meant to solve
Which of the following represents an advantage of a natural key?
A natural key helps protect data integrity by preventing accidental entry of duplicate rows, A natural key belongs to and describes the entity
