____ is application software that makes people more productive by automating common or repetitive tasks.
A. Productivity software
B. Utility software
C. Operating system software
D. Shareware
Answer: A
You might also like to view...
To select a row, position the mouse pointer on the ____ edge of the row, then click.
A. top B. left C. right D. bottom
Data from one cable interferes with another cable. This is known as _______
Fill in the blank(s) with correct word
What will be output by the following statements?
double x{1.23456789}; cout << fixed; cout << setprecision(5) << x << endl; cout.precision(3); cout << x << endl; cout << x << endl; a. 1.2346 1.23 1.23 b. 1.23457 1.235 1.23456789 c. 1.2346 1.23 1.23456789 d. 1.23457 1.235 1.235
S1 returns the total number of credits for which Joe is registered, together with his Id. T maintains the integrity constraint “no student shall register for more than 20 credits.” If Joe has less than 20 credits, T executes S2 to increment the number of credits for which Joe has registered in a particular course. Suppose Joe executes two instances of T concurrently at the following isolation levels. In each case say whether or not the named violation of the constraint can occur and, if the answer is yes, explain how(e.g., what locks are or are not held).
A database has two tables:
Student(Id, Name, ...)—Id and Name are both unique Registered(Id, CrsCode, Credit, ...)—contains one rowfor each course each student is taking this semesterA transaction type, T, has two SQL statements, S1 followed by S2 (w ith local computations between them):
S 1 SELECT SUM(R.Credits), S.Id INTO :sum, :id FROM Student S, Registered R WHERE S.Name = ’Joe’ AND S.Id = R.Id GROUP BY S.Name, S.Id
S 2 UPDATE Registered SET Credits = Credits + 1 WHERE Id = :id AND CrsCode = :crsa. READ COMMITTED lost update b. REPEATABLE READ lost update c. SNAPSHOT lost update