Practice test

Data representation - Test Set 1

Review 20 exam-focused questions with detailed explanations, then start the interactive test when you are ready.

20 questions

Questions and explanations

  1. Question 1

    Which of the following is not a function of DBMS?
    1. Data storage
    2. Data reporting
    3. Data retrieval
    4. Data manipulation
    View explanation

    Sign In to See Explanations. Sign Up Here

  2. Question 2

    What is the primary function of a DBMS?
    1. Create new applications
    2. Generate reports
    3. Store and manage data
    4. Design user interfaces
    View explanation

    Sign In to See Explanations. Sign Up Here

  3. Question 3

    Which of the following is an advantage of using DBMS?
    1. Increased data inconsistency
    2. Increased data duplication
    3. Increased data redundancy
    4. Enhanced data security
    View explanation

    Sign In to See Explanations. Sign Up Here

  4. Question 4

    A collection of interrelated filed and a set of programs that allows users to access and modify these files is known as
    1. data analytic system
    2. database management systems
    3. data files
    4. system management
    View explanation

    Sign In to See Explanations. Sign Up Here

  5. Question 5

    What does normalization refer to in DBMS?
    1. Organizing data to reduce redundancy
    2. Adding more data to the database
    3. Creating a backup of the data
    4. Retrieving data from the database
    View explanation

    Sign In to See Explanations. Sign Up Here

  6. Question 6

    What is a “Tuple” in DBMS?
    1. A single column of data
    2. A table in a database
    3. A single row in a database table
    4. A data field in a database
    View explanation

    Sign In to See Explanations. Sign Up Here

  7. Question 7

    A collection of related files is called a ____________.
    1. record
    2. field
    3. database
    4. character
    View explanation

    Sign In to See Explanations. Sign Up Here

  8. Question 8

    Which SQL command is used to remove a table from a database?
    1. DELETE
    2. REMOVE
    3. ERASE
    4. DROP
    View explanation

    Sign In to See Explanations. Sign Up Here

  9. Question 9

    Which of the following is used to change the data in an existing record?
    1. UPDATE
    2. REPLACE
    3. MODIFY
    4. CHANGE
    View explanation

    Sign In to See Explanations. Sign Up Here

  10. Question 10

    Which command is used to insert data into a table in SQL?
    1. PUT
    2. INSERT
    3. ENTER
    4. ADD
    View explanation

    Sign In to See Explanations. Sign Up Here

  11. Question 11

    Which of the following is not an SQL command?
    1. DELETE
    2. SELECT
    3. REMOVE
    4. UPDATE
    View explanation

    Sign In to See Explanations. Sign Up Here

  12. Question 12

    Which of the following SQL commands is used to modify data in a table?
    1. EDIT
    2. CHANGE
    3. MODIFY
    4. UPDATE
    View explanation

    Sign In to See Explanations. Sign Up Here

  13. Question 13

    Which of the following is used to define the structure of a database?
    1. Data Definition Language (DDL)
    2. Data Query Language (DQL)
    3. Data Control Language (DCL)
    4. Data Manipulation Language (DML)
    View explanation

    Sign In to See Explanations. Sign Up Here

  14. Question 14

    Which of the following is an example of a database constraint?
    1. JOIN
    2. UNIQUE
    3. SELECT
    4. UPDATE
    View explanation

    Sign In to See Explanations. Sign Up Here

  15. Question 15

    Which of the following SQL commands is used to modify a table’s structure?
    1. UPDATE
    2. CHANGE
    3. ALTER
    4. MODIFY
    View explanation

    Sign In to See Explanations. Sign Up Here

  16. Question 16

    Which of the following is used to perform all SQL operations in DBMS?
    1. Transaction control language
    2. Data control language
    3. Data definition language
    4. Data manipulation language
    View explanation

    Sign In to See Explanations. Sign Up Here

  17. Question 17

    In database management system … is a query language for accessing and manipulating data.
    1. Data Manipulation Language (DML)
    2. Data Definition Language (DDL)
    3. Data Transaction Language (DTL)
    4. Data Control Language (DCL)
    View explanation

    Sign In to See Explanations. Sign Up Here

  18. Question 18

    Which of the following is a command for Data Definition Language in Structured Query Language?
    1. SELECT
    2. CREATE
    3. DELETE
    4. MAKE
    View explanation

    Sign In to See Explanations. Sign Up Here

  19. Question 19

    Which of the following database models is represented using data graph?
    1. Relational database model
    2. Hierarchical database model
    3. Network database model
    4. Object-oriented database model
    View explanation

    Sign In to See Explanations. Sign Up Here

  20. Question 20

    Which of the following is a feature of a Relational DBMS?
    1. It uses a network model.
    2. It uses a hierarchical model.
    3. It stores data in files.
    4. It uses a table-based structure.
    View explanation

    Sign In to See Explanations. Sign Up Here