Skip to main content
Menu
Home Quizzes Categories Current Affairs GK AI ToolsNEW Advertise Contact

Computer & Technology - Database

Quiz on databases, relational design, SQL, keys, normalization, transactions, indexes, and database architecture.

25 Questions
30 min Duration
40% To pass
1.00 Marks / correct

Instructions

  • This quiz has 25 questions.
  • Questions are picked at random from a bank of 50, so each attempt is different.
  • You have 30 minutes. The quiz submits automatically when time runs out.
  • You need 40% to pass.
  • There is no negative marking.
  • You can mark questions for review and return to them before submitting.
  • Correct answers and explanations are shown after you submit.

Sample Questions & Answers

A preview of 12 questions from this quiz, each with the correct answer and a written explanation. Attempt the full, timed quiz to be scored and earn XP.

  1. Question 1

    In Database, which option best describes Database?

    • An organized collection of data Correct answer
    • The SQL command used to define a table
    • The SQL clause used to group rows for aggregation
    • A data structure that can speed up certain queries
    Explanation: Database is correctly described by: An organized collection of data.
  2. Question 2

    In Database, which option best describes DBMS?

    • The SQL clause used to filter rows
    • A SQL operation combining related rows from multiple tables
    • A logical unit of database work
    • Database Management System software Correct answer
    Explanation: DBMS is correctly described by: Database Management System software.
  3. Question 3

    In Database, which option best describes Relational database?

    • The SQL clause used to sort results
    • Organizing data to reduce redundancy and improve integrity
    • A database organized around related tables Correct answer
    • A set of properties describing reliable database transactions
    Explanation: Relational database is correctly described by: A database organized around related tables.
  4. Question 4

    In Database, which option best describes Table?

    • The SQL clause used to group rows for aggregation
    • A structure containing rows and columns Correct answer
    • A data structure that can speed up certain queries
    • The transaction property that makes changes all-or-nothing
    Explanation: Table is correctly described by: A structure containing rows and columns.
  5. Question 5

    In Database, which option best describes Row?

    • A record in a table Correct answer
    • A SQL operation combining related rows from multiple tables
    • A logical unit of database work
    • The transaction property that preserves defined database rules
    Explanation: Row is correctly described by: A record in a table.
  6. Question 6

    In Database, which option best describes Column?

    • Organizing data to reduce redundancy and improve integrity
    • A set of properties describing reliable database transactions
    • The transaction property controlling interaction among concurrent transactions
    • An attribute or field in a table Correct answer
    Explanation: Column is correctly described by: An attribute or field in a table.
  7. Question 7

    In Database, which option best describes Primary key?

    • A data structure that can speed up certain queries
    • The transaction property that makes changes all-or-nothing
    • A key that uniquely identifies rows Correct answer
    • The transaction property that committed changes survive failures
    Explanation: Primary key is correctly described by: A key that uniquely identifies rows.
  8. Question 8

    In Database, which option best describes Foreign key?

    • A logical unit of database work
    • A field referencing a key in another table Correct answer
    • The transaction property that preserves defined database rules
    • A virtual table based on a stored query
    Explanation: Foreign key is correctly described by: A field referencing a key in another table.
  9. Question 9

    In Database, which option best describes Candidate key?

    • A minimal set of attributes capable of uniquely identifying a row Correct answer
    • A set of properties describing reliable database transactions
    • The transaction property controlling interaction among concurrent transactions
    • A database-side routine stored for execution
    Explanation: Candidate key is correctly described by: A minimal set of attributes capable of uniquely identifying a row.
  10. Question 10

    In Database, which option best describes Composite key?

    • The transaction property that makes changes all-or-nothing
    • The transaction property that committed changes survive failures
    • A database routine automatically invoked by specified events
    • A key made from multiple columns Correct answer
    Explanation: Composite key is correctly described by: A key made from multiple columns.
  11. Question 11

    In Database, which option best describes SQL?

    • The transaction property that preserves defined database rules
    • A virtual table based on a stored query
    • Structured Query Language Correct answer
    • Undoing changes made by a transaction
    Explanation: SQL is correctly described by: Structured Query Language.
  12. Question 12

    In Database, which option best describes SELECT?

    • The transaction property controlling interaction among concurrent transactions
    • The SQL command used to retrieve data Correct answer
    • A database-side routine stored for execution
    • Permanently applying a transaction's changes
    Explanation: SELECT is correctly described by: The SQL command used to retrieve data.

Login/Register to attempt the full quiz and earn XP.

Explore more: All Computer & Technology quizzes · Database

Artificial Intelligence and Machine Learning

AI and machine learning cover a wide range of ideas, from training data to predictive models and neural networks. This quiz offers a quick way to review the terminology and concepts behind modern AI.

Frequently Asked Questions

Each attempt serves 25 questions, drawn at random from a bank of 50, with 30 minutes.

You need at least 40% to pass this quiz.

No, there is no negative marking on this quiz.

Yes. You can attempt this quiz again at any time, though first-attempt XP bonuses apply only once.

Sign in to attempt this quiz and earn XP.

Login to Start Create free account

Related Quizzes