In order to maintain transactional integrity and database consistency, what technology does a DBMS deploy?

Compare the following sentences: (1) He is a man of high professional integrity. (2) Our defense forces are determined to preserve our national Integrity. (3) His personal integrity is beyond question. Identify sentence (s) in which the word integrity implies the quality of honesty and strong moral principles.

A

(1)

B

(2)

C

(3)

D

(2) and (3)

Match the following with respect to RDBMS: A. Entity integrity 1. enforces some specific business rule that do not fall into entity or domain B. Domain integrity 2. Rows can’t be deleted which are used by other records C. Referential integrity 3. enforces valid entries for a column D. User defined integrity 4. No duplicate rows in a table

A

A - 3, B - 4, C - 1, D - 2

B

A - 4, B - 3, C - 2, D - 1

C

A - 4, B - 2, C - 3, D - 1

D

A - 2, B - 3, C - 4, D - 1

You are the administrator of a SQL Server 2000 computer. The server contains a database named FinanceData that is used by a client/server application. Each employee has a SQL Server login that the application uses to access the server.Your company hires a new employee named Andrew. You create a SQL Server login named Andrew. You also create a database user named Andrew in the database and grant the database user full permissions in the database.Whenever Andrew runs the client/server application, he receives the following error message: "Invalid object name." Andrew also reports that he cannot access the database by using the application.You need to ensure that Andrew can use the application. Which Transact-SQL statement should you execute?

A

EXEC sp_defaultdb 'Andrew','FinanceData'

B

GRANT ALL ON FinanceData TO Andrew

C

EXEC sp_addlogin 'Andrew'

D

EXEC sp_grantdbaccess 'FinanceData','Andrew'GOsp_addrolemember 'db_datareader','Andrew'

You are an administrator of a SQL Server 2000 computer. The server contains a database that stores inventory data. Another database administrator has created a number of scheduled jobs to maintain the inventory database. Each weeknight the following jobs occur.
- A BULK INSERT job imports data at 10:00 P.M
- Indexes are rebuilt at 10:15 P.M
- Data integrity checks are performed at 10:30 P.M
- A differential backup is performed at 10:45 P.M
- A DBCC SHRINKDATABASE job runs at 11:00 P.M.
You notice that the final job often fails and returns the following error message: "Server: Msg 3140, Level 16, State 3. Could not adjust the space allocation for file 'inventory_data'."You need to ensure that the final job runs without errors. What should you do?

A

Modify the DBCC SHRINKDATABASE job so that it uses DBCC SHRINKFILE statement to shrink each file individually.

B

Create a new DBCC SHRINKFILE job to shrink the inventory_data file. Schedule the new job to run at the same time as the DBCC SHRINKDATABASE job.

C

Increase the time between the differential backup and the DBCC SHRINKDATABASE job.

D

Increase the time between the data integrity checks and the differential backup.

You are the database administrator of a SQL Server 2000 computer. The server contains your company's Accounts database. Hundreds of users access the database each day.Because you have had power interruptions in the past, you want to protect the physical integrity of the Accounts database. You do not want to slow down server operations.What should you do?

A

Create a database maintenance plan to check database integrity and make repairs each night.

B

Enable the torn page detection database option for each database.

C

Disablewrite caching on all disk controllers.

D

Ensure that write caching disk controllers have battery backups.

Identify the correct option with reference to Software Quality Metrics. * (1 – security) b) Integrity = * (1 – security) c) Integrity = . d) Integrity = Sigma.

A

Integrity = * (1 – security)

B

Sigma(1 – threat)

C

Sigma(1 – threat)

D

Sigma(1 – threat)

In an Enterprise-class database system, business users interact directly with database applications that interact with the DBMS, which directly accesses the database data.

A

True

B

False

You have a reference computer that runs Windows 7. You plan to deploy an image of the computer. You create an answer file named answer.xml. You need to ensure that the installation applies the answer file after you deploy the image. Which command should you run before you capture the image?

A

Imagex.exe \/append answer.xml \/check

B

Imagex.exe \/mount answer.xml \/verify

C

Sysprep.exe \/reboot \/audit \/unattend:answer.xml

D

Sysprep.exe \/generalize \/oobe \/unattend:answer.xml

The three language components of a database management system (DBMS) like DDL, DCL, DML. Two different types of people (users and practitioners) are concerned with them. Which of them do users of a DBMS usually deal with?

A

DDL

B

DML

C

DDL and DCL

D

DCL and DML

The data warehouse DBMS needs to be the same DBMS used for the operational database.

A

True

B

False

In order to maintain transactional integrity and database consistency, what technology does a DBMS deploy?

Related Questions