HomeTech infoQuiz technology

Database test - Part 3

  1. Question 1. Choose which of the following statements is most appropriate:

    1. Data structures in 1NF relations allow for additional modifications conveniently.

    2. The data structure in 1NF relations hides information anomalies

    3. Data structure in 1NF relations makes it difficult to query information.

    4. Data structure in simple 1NF relations

  2. Question 2. The process of optimizing data query questions is the process:

    1. The results of operations are represented solely by a relation.

    2. It is necessary to change reasonable questions.

    3. Transform the question so that the cost of time and memory usage is the least.

    4. The cost of performing the operations is minimal.

  3. Question 3. Select the corresponding word / phrase to complete the following assertion: 'Data independence' . of application systems for changes in storage structure and data access strategy .

    1. Access method.

    2. Access strategies.

    3. Infomations.

    4. Immutability

  4. Question 4. Please select the corresponding word / phrase to complete the following definition: In the tree-shaped structure, when modifying some information in dependent records, you must browse the entire model, by searching in appeared. Leads to the appearance .

    1. Data integrity in storage.

    2. An data integrity.

    3. Information loss.

    4. Data inconsistency in storage.

  5. Question 5. Select the corresponding word / phrase to complete the following definition: Network data model is a relational entity model, in which the linkages are limited . Does not contain many - many links.

    1. Symmetry

    2. In type one - one and many - one

    3. In the type of a linked record type

    4. In the type of an entity record

  6. Question 6. Select the corresponding word / phrase to complete the following definition: Data independence in highly relational database systems, showing storage structure and access strategy can . but do not change the concept diagram and vice versa.

    1. Change

    2. Independent of each other

    3. Constant

    4. Interdependence

  7. Question 7. Please select the corresponding word / phrase to complete the following definition: Value of key components .

    1. Receiving multiple values

    2. Get the value of 'False'

    3. Get the value of monotherapy

    4. Get 'True' value

  8. Question 8. Select the corresponding word / phrase to complete the following assertion: If the SELECT statement contains GROUP BY, the system will . and perform grouping operations.

    1. Partitioning relationships into many separate groups

    2. Perform sorting according to the instruction after the ORDER BY clause

    3. Make a selection after the WHERE clause

    4. Perform a projection after the SELECT clause

  9. Question 9. Please select the corresponding word / phrase to complete the following statement: Data integrity means .

    1. Can implement data access strategies

    2. Data in the database is always accurate at all times

    3. Searchable at all times

    4. Ensure data independence at all times

  10. Question 10. Select the corresponding word / phrase to complete the following assertion: The most common way to identify users is the password .

    1. Ensure data integrity

    2. Only system and user know

    3. Only allowed to access the database

    4. And database protection rules

  11. Question 11. Data security can be understood as:

    1. Easy for data maintenance work

    2. Prevent unauthorized access, wrong regulations from inside or outside to .

    3. Unifying standards, procedures and data protection and safety measures

    4. Consistency and data integrity

  12. Question 12. External model is:

    1. Information content of the entire database

    2. Information content of the entire database under the view of the user

    3. Information content of a database part

    4. The information content of a piece of data is viewed by the user

  13. Question 13. The internal model is:

    1. Is one of the database representation models in the form of physical storage

    2. The model represents an abstract database at the conceptual level

    3. There are many ways to represent databases in physical storage

    4. Physical data storage model

  14. Question 15. Decentralized database model is model:

    1. Data is represented by pointers

    2. Data is represented by an entity relationship

    3. Data is represented by tables

    4. Data is represented by tree structure

4 ★ | 1 Vote
quizzesdatabasesgood questions

You should read it

May be interested

  • Test on database security P6Test on database security P6
    database is the most important component in every application system, data such as e-mail, documents, presentations, databases, graphics, audio files and spreadsheets are living resources also of most businesses today, thus ensuring database security is a very important job. the test below is with the network administrator to learn about this topic.
  • Create Active Directory accounts from the Exchange database (Part 1)Create Active Directory accounts from the Exchange database (Part 1)
    what can you do with a mailbox database? in an incident scenario, we lost the domain controller and didn't have any backups, an exchange server database would be very useful in this case and could save a lot of time in the future.
  • Database testDatabase test
    today network administrator will give you reading multiple choice questions around the topic of databases, with certain questions below you will have more useful knowledge.
  • Excel computer test - Part 3Excel computer test - Part 3
    after the second part of the excel test, the network administrator will continue to send you the 3rd part of the quiz series on this topic. let's work together to test your knowledge.
  • eQuiz - Multiple choice test on ASPeQuiz - Multiple choice test on ASP
    here 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 SQL Server with Windows PowerShell - Part 6Test SQL Server with Windows PowerShell - Part 6
    part 6 will show you how to check all existing databases in the sql server instance and query the database properties.
  • eQuiz - Multiple choice test on programming language C - part 1eQuiz - Multiple choice test on programming language C - part 1
    this is part 1 of a series of tests on knowledge of c programming language, in total there will be 15 questions with no time for answering each sentence.
  • Test about database security P11Test about database security P11
    testing 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 P12Test about database security P12
    testing 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
  • eQuiz - Multiple choice test on PHP Practice - part 1eQuiz - Multiple choice test on PHP Practice - part 1
    in the quiz below, we will introduce you to part 1 of the test series of basic knowledge about php practive with 15 questions.

Quiz technology