Question 1 Which of the following is NOT a function of a DBMS? Support data repl

Question

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.

Explanation / Answer

Question 1   

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

Support data replication

Provide catalog services

Normalize the data

Recover Data

Data replication is copying or storing data in multiple location to avoid tolerance or to make more accessible to the users.

catalog services are provided to describe a DBMS, catalog would include descriptions of all tables, and relationship between them and key constraints used for each field.

Data Recovery this functionality is used to recover the data, and it will be done as two types, one is forward recovery and another one is backword recovery.

so except these three fourth option is Normalize the data this is not a function proved by DBMS.

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

The ability for a database to allow multiple connections to query a table is known Concurrent update that means two or more queries are executed at the same time of multiple conncetion.

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

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 Data Indepedence,  refers to the immunity of user applications to changes made in the definition and organization of data.

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.

Commit record notes a decision to commit a transaction and completion record what are the data after transation was completed and compensation log record notes what the data looked like before the transaction was completed. but journal record does not containe a backup of the entire table 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.

If data is no longer used then we need archive it for futher necessary. that why option "If It's no longer actively used, but government regulation requires that we maintain it" is correct

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

we are have been using that patch and we now downloaded latest verson then no need to test it again we can directly appy that patches to production database.

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.

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.