Test about database security P5

In the quiz below, join the Network Administrator to find out more about this topic through extremely interesting multiple choice questions.

Question 1. Is it possible to insert information about a cable when not installed?
1. Unable to, because the key value is unknown
2. Can insert
3. Impossible, because of information conflicts.
4. Impossible, because of information anomalies
Question 2. The relation R is called the normal form 3NF, when and only if:
1. Does not exist X Y F ⁺ , X ⁺ Ω, YX and Y are non-key attributes
2. Exist X Y F ⁺ , YX, or X is the key or Y is the key attribute
3. Existing X Y F ⁺ , X ⁺ Ω, YX and Y are non-key attributes
4. There is no X Y F ⁺ , YX, or X is the key or Y is the key attribute
Question 3. Data manipulation language is:
1. A set of data representations
2. A set of operations used to update and supplement on database systems
3. A set of data representation rules
4. A set of operations used to manipulate database systems
Question 4. The results of data manipulation operations are:
1. Data series
2. Data file
3. relationship
4. Database
Question 5. Let Ω = {A, B, C} and F = {A - C, A - B}.
1. No key attributes exist
2. The above relationship has a standard form 2NF
3. There are unlocked properties
4. {A, C}, {B, E} is the key of the above relationship
Question 6. PROJECT projection is an operation:
1. Create a new relationship, satisfying a new definition
2. Create a new relationship, the properties are transformed from the source relationship
3. Create a new relationship, attributes are source relationship attributes
4. Create a new relationship, the source relations sets remove duplicates
Question 7. Select which of the following statements is best:
1. Data structure in simple 1NF relations
2. The data structure in 1NF relations hides information anomalies
3. Data structures in 1NF relations allow for additional modifications conveniently
4. Data structure in 1NF relations makes it difficult to query information
Question 8. Please select the corresponding word / phrase to complete the following assertion: There are many ways to view data in the external model, but . showing all the information in the database is unique.
1. Conceptual model
2. Conceptual model
3. Model in
4. External model
Question 9. Select the corresponding word / phrase to complete the following definition: Relational data language is . manipulating data in relational form. Data is represented in a unique way.
1. Language describes entities and linkages of entities
2. The set of operations has relational structures
3. Set of arithmetic operations
4. Data representation language
Question 10. Select the corresponding word / phrase to complete the following definition: In relational database, storage operations are insert, modify, and remove operations. When manipulating . and ensuring data consistency and data integrity.
1. Independent data
2. Information loss
3. Information security
4. No information anomaly