Which process returns the database to a state that is known to be correct? a. recovery...
Which process returns the database to a state that is known to be correct?
| a. |
recovery |
|
| b. |
encryption |
|
| c. |
concurrent update |
|
| d. |
batch processing |
What strategy can programs employ to minimize the occurrence of deadlocks?
| a. |
Only unlock records at the end of the day. |
|
| b. |
Unlock records in the reverse order in which they were locked. |
|
| c. |
Use a random order record-locking strategy. |
|
| d. |
Lock records in the same order. |
Which of the following is true about distributed databases?
| a. |
it is preferable to send a large number of lengthy messages rather than a small number of short messages |
|
| b. |
it is preferable to send a small number of lengthy messages rather than a large number of short messages |
|
| c. |
it is preferable to send a large number of short messages rather than a small number of short messages |
|
| d. |
it is preferable to send a large number of short messages rather than a small number of lengthy messages |
Which of the following DBMS evaluation categories does the following question relate to: How many files can you open at the same time?
| a. |
Concurrent update |
|
| b. |
Security |
|
| c. |
Limitations |
|
| d. |
Integrity |
Which group performs additional testing of the database program after the programmers complete their testing?
| a. |
users |
|
| b. |
accounting |
|
| c. |
quality assurance |
|
| d. |
customers |
Homework Answers
Which process returns the database to a state that is known to
be correct?
Ans)a) recovery
What strategy can programs employ to minimize the occurrence of
deadlocks?
Ans)d) Locks records in the same order
Which of the following is true about distributed
databases?
Ans) b) it is preferable to send a small number of lengthy messages
rather than a large number of short messages
Which of the following DBMS evaluation categories does the
following question relate to: How many files can you open at the
same time?
Ans) c) Limitations
Which group performs additional testing of the database program
after the programmers complete their testing?
Ans)c)quality assurance
__________________________--Thank You
Add Answer to:
Which process returns the database to a state that is known to
be correct?
a.
recovery...
6. With respect to database systems, which of the following statement(s) is (are) true? a. The...
6. With respect to database systems, which of the following statement(s) is (are) true? a. The physical view of data is how people conceptually organize and understand the relationships among data items. b. The DML builds the data dictionary, creates the database, describes logical views for each user, and specifies security constraints. c. A record layout shows the items stored in a file, including the type of data stored and both the order and length of the data fields. d....
1. Shown below is the relational database schema for a database which contains details regarding bus...
1. Shown below is the relational database schema for a database which contains details regarding bus journeys from Tronoh to various destinations: BusOperator (opCode, opName) Journey(QpCode,GestinationCode price) Destination (destinationCode, destinationName, distance) a. Formulate the following queries using relational algebra: . Get the name of bus operators (e.g., Plusliner, Sri Maju etc.) that provide journeys which are priced at more than RM50.00. (3 marks ii. List the names of a destinations along with their prices provided by Plusliner. 3 marks] b....
Multiple Choice (a) [1 point) Which of the following would be a good candidate for an...
Multiple Choice (a) [1 point) Which of the following would be a good candidate for an interface? A. Modeling that robins, geese, and cardinals are birds B. Modeling that wheels are components of cars, trucks and buses C. Modeling that fish, people and dogs are able to swim D. Modeling that students, administrators, and faculty are all people (b) Choose the feature favored by supporters of the Agile Manifesto: The Aglie Manifesto reads; We are uncovering better ways of developing...
Which of the following is a process that a database designer would go through in order...
Which of the following is a process that a database designer would go through in order to make the storage of information more efficient with respect to storage space and updating ability? (a) Trimming (b) Pruning (c) Normalization (d) Buffering
9) Which of the following statements about building multiple regression models is true? (4) A) No...
9) Which of the following statements about building multiple regression models is true? (4) A) None of these. B) When comparing among competing multiple regression models, it is best to choose a small value of R2 regression model. have the highest values for se C) It is always preferable to include more rather than fewer predictor variables in a multiple D) When comparing among competing multiple regression models, the best models will
9) Which of the following statements about building...
Assignment: Which of the following statements accurately describe a link-state routing protocol? (Choose 3) A. The...
Assignment: Which of the following statements accurately describe a link-state routing protocol? (Choose 3) A. The link state database is used to calculate the paths with the highest bandwidths on the network. B. Link-state routing protocols respond quickly to network changes. C. In Link-state routing protocols, each router periodically sends messages to the network, listing the routers to which it is directly connected and also information about whether the link to each router is active. D. Link-state routing protocols send...
The table below shows a small database whose records correspond to flights departing from an airport....
The table below shows a small database whose records correspond to flights departing from an airport. (a). Are the attributes "Airline" and "Destination" a key for this database? (b). Give two examples of sets of attributes that are keys for this database. (c). Show the results of Select [Airlines = "JetGreen" and Destination = "Denver"]. (d). Show the results of Project [Airline, = "Gate]. (e). Show the results of Select [Destination = "Denver"] followed by Project Gate (f). What operations...
subject. Database system i need the answer for 8 & 9 please. 8. Improve the performance and backup plan for the CUNY database. This database student records enrolled in 24 Colleges. Propose...
subject. Database system
i need the answer for 8 & 9 please.
8. Improve the performance and backup plan for the CUNY database. This database student records enrolled in 24 Colleges. Propose four recommendations to correct or ems identified. You have no budget to purchase additional hardware. You need to make recommendations using hardware already available (15 points) includes 400,000 You will be evaluated based on your improvements in a) performance, b) security, c) backup and d) hardware utilization. You...
8. What are the relationships that the relational database is named for? Relationships between entities Relationships...
8. What are the relationships that the relational database is named for? Relationships between entities Relationships between databases b. Relationships between rows and Relationships between fields and columns records 9. A characteristic or quality describing an entity is called a (n): a. attribute c. Field b. Key field d uple __10. In a table for customers, the information about a single customer would reside in a single: a TOW c. field b. table. d. column 11. The device that acts...
4. The exams database: The following database contains multiple choice exam questions tables Questions and On...
4. The exams database: The following database contains multiple choice exam questions tables Questions and On Hons). Each question has a question Tert and each one of the options has and optid, which is an integer representing options A) (optid=1), B) (optid=2), C) (optid=3), etc. as well as the text of the option. The field correct is either Oor 1 and indicates which is the correct option for that particular question. courseThe exams have numbers 1, 2, 3, etc. Each...
6. With respect to database systems, which of the following statement(s) is (are) true? a. The physical view of data is how people conceptually organize and understand the relationships among data items. b. The DML builds the data dictionary, creates the database, describes logical views for each user, and specifies security constraints. c. A record layout shows the items stored in a file, including the type of data stored and both the order and length of the data fields. d....
1. Shown below is the relational database schema for a database which contains details regarding bus journeys from Tronoh to various destinations: BusOperator (opCode, opName) Journey(QpCode,GestinationCode price) Destination (destinationCode, destinationName, distance) a. Formulate the following queries using relational algebra: . Get the name of bus operators (e.g., Plusliner, Sri Maju etc.) that provide journeys which are priced at more than RM50.00. (3 marks ii. List the names of a destinations along with their prices provided by Plusliner. 3 marks] b....
Multiple Choice (a) [1 point) Which of the following would be a good candidate for an interface? A. Modeling that robins, geese, and cardinals are birds B. Modeling that wheels are components of cars, trucks and buses C. Modeling that fish, people and dogs are able to swim D. Modeling that students, administrators, and faculty are all people (b) Choose the feature favored by supporters of the Agile Manifesto: The Aglie Manifesto reads; We are uncovering better ways of developing...
9) Which of the following statements about building multiple regression models is true? (4) A) None of these. B) When comparing among competing multiple regression models, it is best to choose a small value of R2 regression model. have the highest values for se C) It is always preferable to include more rather than fewer predictor variables in a multiple D) When comparing among competing multiple regression models, the best models will
9) Which of the following statements about building...
The table below shows a small database whose records correspond to flights departing from an airport. (a). Are the attributes "Airline" and "Destination" a key for this database? (b). Give two examples of sets of attributes that are keys for this database. (c). Show the results of Select [Airlines = "JetGreen" and Destination = "Denver"]. (d). Show the results of Project [Airline, = "Gate]. (e). Show the results of Select [Destination = "Denver"] followed by Project Gate (f). What operations...
subject. Database system
i need the answer for 8 & 9 please.
8. Improve the performance and backup plan for the CUNY database. This database student records enrolled in 24 Colleges. Propose four recommendations to correct or ems identified. You have no budget to purchase additional hardware. You need to make recommendations using hardware already available (15 points) includes 400,000 You will be evaluated based on your improvements in a) performance, b) security, c) backup and d) hardware utilization. You...
8. What are the relationships that the relational database is named for? Relationships between entities Relationships between databases b. Relationships between rows and Relationships between fields and columns records 9. A characteristic or quality describing an entity is called a (n): a. attribute c. Field b. Key field d uple __10. In a table for customers, the information about a single customer would reside in a single: a TOW c. field b. table. d. column 11. The device that acts...
4. The exams database: The following database contains multiple choice exam questions tables Questions and On Hons). Each question has a question Tert and each one of the options has and optid, which is an integer representing options A) (optid=1), B) (optid=2), C) (optid=3), etc. as well as the text of the option. The field correct is either Oor 1 and indicates which is the correct option for that particular question. courseThe exams have numbers 1, 2, 3, etc. Each...
Most questions answered within 3 hours.
-
How does temperature affect ADH during enzyme
kinetics?
asked 3 minutes ago -
A $1000 par value convertible bond has a conversion price of
$25. It is currently selling...
asked 11 minutes ago -
Write a java program that declares 10 element array (of type
integers), creates and initializes the...
asked 8 minutes ago -
import java.util.Arrays;
import java.util.Random;
import java.util.Scanner;
/**
* TODO Write a summary of the role of...
asked 14 minutes ago -
Sodium hydroxide is a strong base and ammonium hydroxide is a
weak base. Which of the...
asked 19 minutes ago -
Glycerol, C3H8O3, is a substance used extensively in the
manufacture of cosmetics, foodstuffs, antifreeze, and plastics....
asked 22 minutes ago -
After moving through Chapter 1 of our textbook, what is a social
issue/area of concern that...
asked 22 minutes ago -
Please complete the implementation of the four functions IN
C.
//************************************************************************************/
//
// countNumberofOnes
//
//...
asked 43 minutes ago -
A memory test consists of 35 tasks. Each task is graded on a
scale of 1...
asked 23 minutes ago -
Construction Cost Analysis and Estimating:
A project requires 17,000 allowed hours. Location of the work is...
asked 32 minutes ago -
1: In 802.11b, Access Point (AP) delivers a nonce to the Station
(STA). This nonce is...
asked 33 minutes ago -
calculate change in entropy and change in enthalpy for freezing
1 mol of water at -10C...
asked 39 minutes ago