Bissoy.com
Doctors Medicines MCQs Q&A

Related Questions

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?
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?
The statement given below describes which of the ACID properties of transactions? “The changes applied to the database by a committed transaction must persist in the database, and these changes must not be lost because of any failure”
In a survey of 25 students, it was found that 15 had taken Mathematics, 12 had taken Physics and 11 had taken Chemistry, 5 had taken Mathematics and Chemistry, 9 had taken Mathematics and Physics, 4 had taken Physics and Chemistry and 3 had taken all the three subjects. Find the number of students who had taken both Physics and Chemistry but not Mathematics.
In a survey of university students, 64 had taken Drama course, 94 had taken Dance course, 58 had taken a Singing course, 28 had taken Drama and singing course, 26 had taken Drama and dance course, 22 had taken Dance and singing course, and 14 had taken all the three courses. Find how many have taken only one course?
Two involute gears are designed to mesh for a given centre distance and a given angular velocity ratio (other than 1). During assembly, the centre distance has increased slightly. Then which of the following changes occur? (i) Velocity ratio changes (ii) Pressure angle changes (iii) Pitch circle diameter changes (iv) Working depth changes (v) Base circle radius changes Select the correct answer using the code given below.
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?
The police arrested four criminals - P, Q, R and S. The criminals knew each other. They made the following statements: P says “Q committed the crime.” Q says “S committed the crime.” R says “I did not do it.” S says “What Q said about me is false.” Assume only one of the arrested four committed the crime and only one of the statements made above is true. Who committed the crime?
Mundel's classes of change includes
1. Changes in body motions and positions
2. Changes in equipment and working arrangements
3. Changes in production sequence
4. Changes in finished product
5. Changes in raw material
A transaction is a series of actions to be taken on the database so that either all of them are performed successfully or none of them are performed at all.