Data.And.Inf.Manag 4

Choose the wrong answers. DML trigger runs each time when the data in the base table is changed by any operator:

• INSERT

• UPDATE

• DROP

• DELETE

• ALTER

What can you do while a database is being backed up? (Check all the correct answers)

• All normal processing.

• Anything that doesn’t affect the log.

• Queries only.

• All transactions, except non-logged operations.

• Absolutely nothing. All users are blocked during a backup.

When would you restore a database? (Check all the correct answers)

• Daily

• Weekly

• When it is required because a disaster ruined an existing database

• During a database migration

• When prompted to do so by Server

Which database maintenance tasks can be automated? (Check all the correct answers)

• Index rebuilds

• Updating of index statistics

• Database backups

• Transaction log backups

• None of the above

When do you need to back up the transaction log? (Check all the correct answers)

• Never.

• When the database gets too big.

• Weekly.

• When you need to recover the space it is taking up.

• When it starts to get too big.

Which operator can split the data of one table into the data of another table?

• division

• subtraction

• projection

• intersection

• cross join

What relational operator(-s) require(-s) a common type of attributes of the two relationships?

• selection, projection

• division

• cross join

• union

• subtraction

Which of these models is based not on records?

• object-relational

• relational

• object-oriented

• multivariate

• post-relational

What type of objects to which access rights are not granted?

• login on Windows OS level

• login on SQL Server 2008 level

• user on database level

• user on table level

• user on views level

What gives the result of the combination of entities?

• E/R scheme

• supertype

• relation

• attribute