Which of the following command makes the updates performed by the transaction permanent in the database?

In a database system, unique timestamps are assigned to each transaction using Lamport’s logical clock. Let TS(T1) and TS(T2) be the timestamps of transactions T1 and T2 respectively. Besides, T1 holds a lock on the resource R, and T2 has requested a conflicting lock on the same resource R. The following algorithm is used to prevent deadlocks in the database system assuming that a killed transaction is restarted with the same timestamp. If TS(T2) < TS(T1) then T1 is killed else T2 waits. Assume any transaction that is not killed terminates eventually. Which of the following is TRUE about the database system that uses the above algorithm to prevent deadlocks?

A

The database system is both deadlock-free and starvation-free.

B

The database system is deadlock-free but not starvation-free.

C

The database system is starvation-free, but not deadlock-free.

D

The database system is neither deadlock-free nor starvation-free.

The _______ statement makes the updates performed by the transaction permanent.

A

Finalize work

B

Finish work

C

Commit work

D

None of the mentioned

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'

If @@TRANCOUNT is 1 ________ makes all data modifications performed since the start of the transaction a permanent part of the database.

A

COMMIT TRANSACTION

B

SAVE TRANSACTION

C

ROLLBACK TRANSACTION

D

None of the mentioned

You develop an enterprise application, called XYZApplication that includes a Windows Form presentation layer, middle-tier components for business logic and data access, and a Microsoft SQL Server database.
You are in the process of creating a middle-tier component that will execute the data access routines in your application. When data is passed to this component, the component will call several SQL Server stored procedures to perform database updates. All of these procedure calls run under the control of a single transaction.
The code for the middle-tier component will implement the following objects:
SqlConnection cn = new SqlConnection();
SqlTransaction tr;
If two users try to update the same data concurrently, inconsistencies such as phantom reads will occur. You must now add code to your component to specify the highest possible level of protection against such inconsistencies.
Which code segment should you use?

A

tr = cn.BeginTransaction(?ReadCommitted?);

B

tr = cn.BeginTransaction(IsolationLevel.ReadCommitted);

C

tr = cn.BeginTransaction(IsolationLevel.Serializable);

D

tr = cn.BeginTransaction(?Serializable?);

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.

Which TCL command undo all the updates performed by the SQL in the transaction?

A

ROLLBACK

B

COMMIT

C

TRUNCATE

D

DELETE

Which command undo all the updates performed by the SQL in the transaction?

A

ROLLBACK

B

COMMIT

C

TRUNCATE

D

DELETE

Which of the following features of the Permanent Settlements of 1793 is/are correct? 1. The Permanent Settlements vested land ownership rights in the peasants 2. The Permanent Settlement vested land ownership rights in the Zamindars 3. The Zamindars had to pay a fixed amount of rent by a particular date 4. The Zamindars benefited hugely from the Permanent Settlement while the peasants suffered Select the correct answer using the code given below:

A

1 only

B

2 and 3 only

C

4 only

D

1, 2 and 3

What command is used to stop RIP routing updates from exiting out an interface but still allow the interface to receive RIP route updates?

A

Router (config-if) # no routing

B

Router (config-if) # passive-interface

C

Router (config-router) # passive-interface s0

D

Router (config-router) # no routing updates

Which of the following command makes the updates performed by the transaction permanent in the database?

Related Questions