PREVIOUS triggers

INSTEAD OF triggers

BEFORE triggers

AFTER triggers

ERD

Database

DBMS

User

Properties of columns

Names of columns in a database and their associated tables

Names of tables in a database

Queries against records in the database tables

Monitoring the performance of the database system

Designing and implementing the DBMS software

Authorizing access to the database

Deciding on the storage structures and access strategies

All of the others

(An insertion of data into a database) and (A deletion of data in a database) only

A extraction of data in a database

A deletion of data in a database

Approving structual changes to the database

Designing data entry screens

Monitoring the performance of the system

Ensuring that an adequate back-up regime is in place

All of these answers

DELETE

UPDATE

INSERT, UPDATE

Entity integrity

Domain integrity

Referential integrity

User-defined integrity

It has the ability to references data another table

It maintains consistency between related data in the same table

It maintains the references established between to entities

All of these answers

You must create a login for a Microsoft Windows user or group before you grant the user or group database access using SQL Server Enterprise Manager

You can assign permissions directly to Windows groups

Only Microsoft SQL Server login accounts can be added to user-defined database roles

Restricting user access on a column basic has a smaller performance impact than using views or stored procedures