1.3.2b SQL, data management, referential integrity and ACID transactions Quiz: OCR Computer Science, Unit 3

The 20 questions

1. Which SQL command is used to create a new database table?

   • CREATE TABLE
   • MAKE TABLE
   • NEW TABLE
   • BUILD TABLE

2. Which SQL command alters the structure of an existing database table?

   • UPDATE TABLE
   • MODIFY TABLE
   • ALTER TABLE
   • CHANGE TABLE

3. Which SQL command removes specified records from a database table?

   • CLEAR FROM
   • DROP TABLE
   • DELETE FROM
   • REMOVE FROM

4. Which SQL keyword is used to modify existing data within a table?

   • ALTER
   • UPDATE
   • CHANGE
   • MODIFY

5. Which rule ensures foreign keys always correspond to a valid primary key?

   • Entity integrity
   • Referential integrity
   • Domain integrity
   • Transactional integrity

6. What does the letter A represent in the ACID database acronym?

   • Availability
   • Accessibility
   • Atomicity
   • Authenticity

7. What does the letter C represent in the ACID database acronym?

   • Continuity
   • Compatibility
   • Concurrency
   • Consistency

8. What does the letter I represent in the ACID database acronym?

   • Immutability
   • Independence
   • Isolation
   • Integrity

9. Which clause filters individual records in a SELECT query based on conditions?

   • GROUP BY
   • WHERE
   • HAVING
   • ORDER BY

10. Which SQL operator searches for a specified pattern in a column?

    • MATCH
    • LIKE
    • REGEX
    • SEARCH

11. Which SQL clause sorts query results in ascending or descending order?

    • SORT BY
    • GROUP BY
    • ALIGN BY
    • ORDER BY

12. Which SQL clause groups rows with identical values into summary rows?

    • SELECT DISTINCT
    • GROUP BY
    • ORDER BY
    • COMBINE BY

13. What happens to related child records during a cascading delete operation?

    • Transaction aborted
    • Child records deleted
    • Foreign keys nulled
    • Parent record retained

14. Which ACID property guarantees committed data is permanently saved despite system failure?

    • Isolation
    • Consistency
    • Durability
    • Atomicity

15. Which standard SQL wildcard character represents zero or more characters?

    • ?
    • %
    • _
    • *

16. Which SQL clause is used to filter groups created by GROUP BY?

    • HAVING
    • WHERE
    • ORDER BY
    • FILTER

17. Which issue occurs when a transaction reads data modified by an uncommitted transaction?

    • Lost update
    • Non-repeatable read
    • Dirty read
    • Phantom read

18. Which SQL constraint ensures all values in a column are unique?

    • UNIQUE
    • CHECK
    • PRIMARY KEY
    • DISTINCT

19. Which SQL command permanently saves all changes made in a transaction?

    • COMMIT
    • ROLLBACK
    • SET TRANSACTION
    • SAVEPOINT

20. Which SQL command cancels all uncommitted changes made in a transaction?

    • REVERT
    • UNDO
    • COMMIT
    • ROLLBACK

Related quizzes

• Compression, encryption and hashing Quiz · 1.3.1 · 20 questions
• Database design: keys, entity relationships, normalisation and indexing Quiz · 1.3.2a · 20 questions
• Network characteristics, protocols, TCP/IP, DNS and protocol layering Quiz · 1.3.3a · 20 questions
• LANs, WANs, switching, network hardware, security and client-server Quiz · 1.3.3b · 20 questions
• HTML, CSS, JavaScript and client-side and server-side processing Quiz · 1.3.4a · 20 questions
• Search engine indexing and the PageRank algorithm Quiz · 1.3.4b · 20 questions
• Processor components: ALU, control unit, registers and buses Quiz · 1.1.1a · 20 questions
• Operating systems and memory management Quiz · 1.2.1a · 20 questions
• Primitive data types and binary number representation Quiz · 1.4.1a · 20 questions
• Data Protection Act 1998 and Computer Misuse Act 1990 Quiz · 1.5.1a · 20 questions