adplus-dvertising
frame-decoration

Question

Which action will optimize your databaseperformance?

a.

Set the record set type to Snapshot

b.

Use the compact and repair database tool

c.

Create a replica of the database

d.

All of the above

Posted under DBMS

Answer: (b).Use the compact and repair database tool

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. Which action will optimize your databaseperformance?

Similar Questions

Discover Related MCQs

Q. What is the first step in creating a form or report with the form wizard or report wizard?

Q. How can you add a table to the relationship window?

Q. In access, the best types of queries to use for data analysis are:

Q. How do you update Pivot Table report data after changes are made to the source data?

Q. What is a fast way to adjust the width of a column?

Q. How do you filter by selection?

Q. In a relational schema, each tuple is dividedinto fields called

Q. Which of the following terms does not describe a database structure used by a DBMS to link data from several files?

Q. Data items groped together for storage purposes are called a

Q. A subset of characters within a data field is known as

Q. The executive responsible for the data processing function in an organization is

Q. Which of the following is not a data type ?

Q. A computer language for informing the DBMS regarding the data structure used is

Q. What is the name of the Visual Basic Editor utility that allows you to view the Microsoft Access type librarys available objects and members?

Q. What is the corresponding text for the <#1/1/ 95# validation rule setting?

Q. Which of the following is a database management system?

Q. The way a particular application views thedata from the database that the applicaton uses is a

Q. Which program do you use to edit code for data access pages?

Q. Which control does access use to link data access page components to access data?

Q. Customers, Orders. Whats their best relationship?