Test about database security P5
- Question 1. Is it possible to insert information about a cable when not installed?
-
Unable to, because the key value is unknown
-
Can insert
-
Impossible, because of information conflicts.
-
Impossible, because of information anomalies
-
- Question 2. The relation R is called the normal form 3NF, when and only if:
-
Does not exist X Y F + , X + Ω, YX and Y are non-key attributes
-
Exist X Y F + , YX, or X is the key or Y is the key attribute
-
Existing X Y F + , X + Ω, YX and Y are non-key attributes
-
There is no X Y F + , YX, or X is the key or Y is the key attribute
-
- Question 3. Data manipulation language is:
-
A set of data representations
-
A set of operations used to update and supplement on database systems
-
A set of data representation rules
-
A set of operations used to manipulate database systems
-
- Question 4. The results of data manipulation operations are:
-
Data series
-
Data file
-
relationship
-
Database
-
- Question 5. Let Ω = {A, B, C} and F = {A - C, A - B}.
-
No key attributes exist
-
The above relationship has a standard form 2NF
-
There are unlocked properties
-
{A, C}, {B, E} is the key of the above relationship
-
- Question 6. PROJECT projection is an operation:
-
Create a new relationship, satisfying a new definition
-
Create a new relationship, the properties are transformed from the source relationship
-
Create a new relationship, attributes are source relationship attributes
-
Create a new relationship, the source relations sets remove duplicates
-
- Question 7. Select which of the following statements is best:
-
Data structure in simple 1NF relations
-
The data structure in 1NF relations hides information anomalies
-
Data structures in 1NF relations allow for additional modifications conveniently
- 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.
- Conceptual model
- Conceptual model
- Model in
- 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.
-
Language describes entities and linkages of entities
-
The set of operations has relational structures
-
Set of arithmetic operations
-
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.
-
Independent data
-
Information loss
-
Information security
- No information anomaly
-
You should read it
May be interested
- [QUIZ] Test your understanding of SQL - Part 6in order to serve your work and your study, along with sql lessons, quantrimang offers a variety of useful questions.
- Test of database security P10database is a data collection organized in a structured way related to each other and stored in a computer. the database is designed and built to allow users to store data, retrieve information or update data. here, please read more about this topic through our quiz below.
- Test of database security P9please read your knowledge and multiple choice questions about the database that the network administrator has edited below. certainly with this useful knowledge will help you work more effectively.
- [QUIZ] Test your understanding of SQL - Part 5multiple-choice questions on sql help you familiarize and review useful knowledge for work and learning sql language.
- Test on database security P7please read your knowledge of the database through the multiple choice questions below. hope with these interesting questions will give you lots of useful information.
- Test about database security P13please read your knowledge of the database through the multiple choice questions below. hope with these interesting questions will give you lots of useful information.
- A serious vulnerability on phpMyAdmin allows an attacker to destroy the databasea serious security vulnerability on phpmyadmin - one of the most popular mysql database management software will harm the database when the tricked administrator clicks on the link.
- Database security (common usage guidelines)recently, the database security issue has spread widely on the mass media and internet news network. the first is the slammer worm and most recently the illegal access to more than 8 million credit card numbers. many people put
- [QUIZ] Test your understanding of SQL - Part 7part 7 of the sql quiz goes into the sql practice exercises that follow the previous period.
- Test on database security P4today network administrator will give you reading multiple choice questions around the topic of databases, with certain questions below you will have more useful knowledge.