Question 1

Which of the following is NOT a function of a DBMS?

Support data replication

Provide catalog services

Normalize the data

Recover Data

Question 2

The ability for a database to allow multiple connections to query a table is known as?

Two-phase locking

Concurrent update

Deadlock

Replication

Question 3

If a web application is connected to a database stored procedure, I can alter the stored procedure without un-deploying the application. This is an example of _______

Two-phase locking

Data Integrity

Data Persistence

Data Independence

Question 4

The journal or transaction log does NOT contain ________

If the transaction was committed.

A backup of the entire table before the transaction was completed.

What the data was after the transaction was completed.

what the data looked like before the transaction was completed.

Question 5

A valid reason to archive data is_____

If It's no longer actively used, but government regulation requires that we maintain it.

If the data hasn't been accessed in 30 days.

If its mandated by certified database administrators.

If the data contains personal information.

Question 6

The DBA of a company just downloaded the latest set of security patches for the database from the database vendor. What would be his next step?

Apply the patches to the production database and perform some testing

Apply the patches to the test database and perform some testing

Wait for the next major release

Apply the patches to production database, and since it's a patch from the vendor then no testing is needed

Question 7

Which of these is NOT considered a form of performance tuning?

Splitting the tables into domain specific tables

Adding an index to the tables

Demoralizing the table

Adding more processors to the hardware

Question 8

you had an emergency on the database server on Monday afternoon, and you have access the full database backup from Wednesday and the transaction log back from Thursday and Friday. What would you to restore the data?

It's not possible to restore the data

I would implement backward recovery

I would implement forward recovery

I would add recover from archive

Question 9

An alternative to locking on a PC DBMS, _____ assigns each update a unique _____ value.

two-phase locking, lock

Timestamping, time

Journaling, transaction

Concurrent update, deadlock

Question 10

A co-worker needs to query a table and review the first 4 columns, out of 10 overall columns. The first columns are don't have any personal data but the remaining 6 columns have personal information that the co-worker should not view. They would have to run this query every week. You are tasked with helping the co-worker. What should you do?

I would talk to the co-worker and make sure that they can keep a secret.

I would move the data that they need to see to a new table and give them read access to the new table.

I would create a weekly job to expert the data to a spreadsheet, then remove the personal columns each time before handing it to the co-worker.

I would create a SQL View, which only exposes the first 4 columns, give them the view and access to query the view and then remove select access from the original table.