Question

In: Computer Science

SQL Program True/False Question 1. Which of the following is true of a many to many...

SQL Program True/False Question

1. Which of the following is true of a many to many relationship? T/F

2. Security is rarely a concern for most databases. T/F

3. A security requirement refers to the need to restrict who can access some of the database data. T/F

4. Report requirements refer to the input forms the database will need. T/F

5. Insert permission is the permission to add records to the database. T/F

6. A trigger is code usually written in SQL which is triggered by a database event such as an insert or delete. T/F

7. A data requirement refers to the need to gather data about the database. T/F

8. One to one relationships are the most common relationship in a relational database. T/F

9. If you have an attribute that can have multiple values you should just number them 1, 2, 3, etc. T/F

10. Ideally every attribute in a database should have a unique name. T/F

11. Lookup entities have no effect on data consistency and integrity T/F

Solutions

Expert Solution

· Security is rarely a concern for most databases. T/F

False

· A security requirement refers to the need to restrict who can access some of the database data. T/F

True

Explanation- Features like multiple views offer security to some extent where users are unable to access data of other users and departments. DBMS offers methods to impose constraints while entering data into the database and retrieving the same at a later stage. DBMS offers many different levels of security features, which enables multiple users to have different views with different features. For example, a user in the Sales department cannot see the data that belongs to the Purchase department. Additionally, it can also be managed how much data of the Sales department should be displayed to the user. Since a DBMS is not saved on the disk as traditional file systems, it is very hard for miscreants to break the code.

· Report requirements refer to the input forms the database will need. T/F

True

Explanation-A database report is the formatted result of database queries and contains useful data for decision-making and analysis

· Insert permission is the permission to add records to the database. T/F

True

· A trigger is code usually written in SQL which is triggered by a database event such as an insert or delete. T/F

True

Explanation- A trigger is either a stored PL/SQL block or a PL/SQL, C, or Java procedure associated with a table, view, schema, or the database itself. Oracle Database automatically executes a trigger when a specified event takes place, which may be in the form of a system event or a DML statement being issued against the table.

And hence DML have following commands to manage data

1. SELECT – retrieve data from the a database

2. INSERT – insert data into a table

3. UPDATE – updates existing data within a table

4. DELETE – deletes all records from a table, the space for the records remain

5. MERGE – UPSERT operation (insert or update)

6. CALL – call a PL/SQL or Java subprogram

7. LOCK TABLE – control concurrency

Hence true.

· A data requirement refers to the need to gather data about the database. T/F

False

Explanation-The Data Requirements Document provides a detailed description of the data model that the system must use to fulfill its functional requirements. ... Describe the type of information required to document the characteristics of each data element

· One to one relationships are the most common relationship in a relational database. T/F

True

· If you have an attribute that can have multiple values you should just number them 1, 2, 3, etc. T/F

False

Explanation-for multivalued attribute t you need another entity. The only way to handle multiple values of the same attribute is to create an entity in which you can store multiple instances, one for each value of the attribute.

· Ideally every attribute in a database should have a unique name. T/F

True

Explanation-Relation (table) must have a unique name.
Every attribute (field, column) must be atomic (not multivalued, not composite).
Every row (record) must be unique
Attributes within a relation (table) must have unique names.

· Lookup entities have no effect on data consistency and integrity T/F

True


Related Solutions

Identify which of the following statements is true and which is false. 1) _________   For a...
Identify which of the following statements is true and which is false. 1) _________   For a set of numerical data, if the mean is larger than the median, this is evidence of right-skew. 2) _________   Negative values of the standard deviation indicate that the set of values is even less dispersed than would be expected by chance alone. 3) _________   For a set of numerical data, if the mean and the median are of equal value, this is evidence of...
Decide which of the following statements are true and which are false. 1. In order for...
Decide which of the following statements are true and which are false. 1. In order for two separate 1.0 L samples of O2(g) and H2(g) to have the same average velocity, the H2(g) sample must be at a higher temperature than the O2(g) sample. 2. At constant temperature, the heavier the gas molecules, the smaller the average kinetic energy. 3. As temperature decreases, the average kinetic energy of a sample of gas molecules increases. 4. At constant temperature, the lighter...
Decide which of the following statements are true and which are false. True False  Real gas molecules...
Decide which of the following statements are true and which are false. True False  Real gas molecules behave most ideally at low temperature and high pressure. True False  At constant temperature, the lighter the gas molecules, the smaller the average kinetic energy. True False  At constant temperature, the lighter the gas molecules, the smaller the average velocity. True False  In order for two separate 1.0 L samples of O2(g) and H2(g) to have the same average velocity, the O2(g) sample must be at a...
Question 1 Please select  which is true and which is false 1)In  order to maintain calcium homeostasis the...
Question 1 Please select  which is true and which is false 1)In  order to maintain calcium homeostasis the body exerts a strict regulation of intracellular calcium. 2)Your ability to store fat as adipose tissue is only  related to your consumption of fat. 3) The concentration of ionized calcium in the blood is half of the total concentration is the blood. 4)The receptor responsible for phosphate homeostasis is PTH receptor 5)The major role of vitamin D is calcium absorption of calcium from the small...
1. True or false? answer the following question by Putting a T or a F -...
1. True or false? answer the following question by Putting a T or a F - The more things a word or phrase applies to, the more opportunity the listener has of misapplying it. - For the best results you should always complete an outline of your essay before you complete the first draft. - According to the text, anything beyond three or four revisions to an essay is not worthwhile. - It is generally reasonable to accept an unsupported...
QUESTION 1 The following are not committees of a corporation: Executive. Bylaws, Finance. True False QUESTION...
QUESTION 1 The following are not committees of a corporation: Executive. Bylaws, Finance. True False QUESTION 2 An employee is the same thing as an Independent Contractor True False QUESTION 3 If a physician is not a full-time hospital employee, the hospital may still be liable for the Physician's negligence. True False QUESTION 4 The antitrust laws are based on the premise that free markets are a good thing. True False QUESTION 5 The FTC (Federal Trade Commission) is the...
Decide which of the following statements are true and which are false. 1. As temperature decreases,...
Decide which of the following statements are true and which are false. 1. As temperature decreases, the average kinetic energy of a sample of gas molecules decreases. 2. At constant temperature, the lighter the gas molecules, the smaller the average kinetic energy. 3. At constant temperature, the heavier the gas molecules, the smaller the average velocity. 4. In order for two separate 1.0 L samples of O2(g) and H2(g) to have the same average velocity, the H2(g) sample must be...
Decide which of the following statements are true and which are false. 1. As temperature decreases,...
Decide which of the following statements are true and which are false. 1. As temperature decreases, the average kinetic energy of a sample of gas molecules decreases. 2. At constant temperature, the lighter the gas molecules, the smaller the average kinetic energy. 3. At constant temperature, the heavier the gas molecules, the smaller the average velocity. 4. In order for two separate 1.0 L samples of O2(g) and H2(g) to have the same average velocity, the H2(g) sample must be...
True or False Determine if the following statements are true or false. _____ 1. A liquid...
True or False Determine if the following statements are true or false. _____ 1. A liquid takes the volume of its container. _____ 2. Particles of amorphous solids have no definite pattern. _____ 3. A beef steak is an example of a crystalline solid. _____ 4. Viscosity causes water to curve upward at the top rim of a glass. _____ 5. There is more gas than any other state of matter in the universe. _____ 6. All states of matter...
1. All mutations are harmful. a) True b) False 2. Which of the following is TRUE...
1. All mutations are harmful. a) True b) False 2. Which of the following is TRUE about mutations? a) Mutations are more likely to occur if they result in a useful trait b) Mutations can be inherited. c) Mutations only occur during DNA replication d) Mutations do not occur in organisms that reproduce asexually 3. Which of the following would increase the chances of getting a mutation? a) Wearing a hat outside b) Putting sunscreen on your face and arms...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT