Database test
- Question 1. Advantages of database:
-
Reduce redundancy, consistency and integrity of data.
-
Attributes are described in many different data files.
-
Ability to appear inconsistent and inconsistent data.
-
Appeared anomalous information.
-
- Question 2. Anomalous information may:
-
Consistent data and integrity.
-
There are no conflicting information.
-
Lack of information in storage.
-
Reflect the true objective data.
-
- Question 3. Users can access:
-
The whole database
-
Limit
-
Part of the database
-
Depends on access
-
- Question 4. The DBMS (DataBase Management System) database management system is:
-
Software system controls access strategies and database storage organizations.
-
Create data structure corresponding to data model.
-
Update, insert, remove or modify file level data.
-
Ensure safety, data security and data integrity.
-
- Question 5. Characteristics of a data model:
-
Users have access at anytime, anywhere.
-
Stability, simplicity, need to check for redundancy, symmetry and have a solid theoretical basis.
-
Simple and unstructured data representation.
-
Simple data model.
-
- Question 6. When manipulating data manipulation language on hierarchical database:
-
There is a high probability of information volatility.
-
Ensure data independence
-
Ensure data integrity.
-
Ensure stability
-
- Question 7. The structural characteristics of the network model are:
-
Contains one - one, one - many and many - many links.
-
Contains one-to-one and one-to-many links.
-
Contains multiple links - one and one - many.
-
- Question 8. In the network database, when adding new records:
-
Ensure consistency and integrity of data.
-
Excess information.
-
Consistency and integrity of data is not guaranteed.
-
Conflict of information.
-
- Question 9. In the relational database model:
-
The order of the columns is not important.
-
The order of the rows is not important.
-
The order of the rows is important.
-
The order of columns is important.
-
- Question 10. X is a subset of attributes, symbol X Ω, when and only if:
-
For every attribute of Ω
-
If A Ω, deduce A X.
-
For every attribute of Ω, is also the property of X
-
For every attribute of X is also the attribute of Ω
-
- Question 11. X and Y are any two subsets of Ω. Then XY means:
-
When the argument is the same, the function has many values.
-
(r, s R) ((a X) (r (a) = s (a)) deduce (b Y) (r (b) = s (b))).
-
A value of Y is determined by a value of X.
-
(r, s R) (r (X) = s (X)) deduce r (Y) = s (Y)
-
- Question 12. Which of the following dependencies is fully dependent:
-
(Invoice number, customer code) Customer name
-
(ID card number, employee code) Working process
-
(Order number, class code) Student's full name.
-
(Newspaper code, customer code) Price quote
-
- Question 13. Which type of standard, name and address attributes does the relationship contain?
-
Standard format 2NF
-
Standard form 1NF, not 2NF
-
Standard 3NF format
-
Standard 2NF form, not 3NF
-
You should read it
May be interested
- eQuiz - Multiple choice test on ASPhere is a small test of asp web programming language, a total of 30 questions will be answered with no time to answer each sentence.
- Test about database security P11testing of databases will help you gain more useful knowledge about this topic to apply to learning and working. the question set will have 10 sentences to test your knowledge.
- Test about database security P12testing of databases will help you gain more useful knowledge about this topic to apply to learning and working. the question set will have 10 sentences to test your knowledge
- 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.
- [QUIZ] Check your understanding of SQL - Part 2continue series what do you know about sql? , part 2 continues with questions that revolve around basic knowledge in databases.
- 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.
- 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.
- What do you know about NoSQL Database?nosql was born as a patch for the shortcomings and shortcomings of the rdbms relational data model. so how much do you know about nosql? try your knowledge with quantrimang through the following multiple choice questions!
- Use the ALTER DATABASE command to migrate DATABASE in SQL Servertechnically, you can use the alter database syntax to move any system or user database files that define, initialize, except for the resource database.