MockRounds Logo

SQL Fundamentals and Database Concepts Quiz Quiz

Test your knowledge of SQL basics, including database tables, SQL statements, and RDBMS concepts. This quiz helps you assess and reinforce understanding of SQL commands, structure, and syntax essential for anyone beginning structured query language for databases.

  1. Meaning of SQL

    What does the acronym SQL stand for in the context of databases?

    1. Systematic Query Logic
    2. Sequential Query List
    3. Structured Query Language
    4. Standard Query Locator

    Explanation: SQL stands for Structured Query Language, used for accessing and manipulating databases. Sequential Query List, Standard Query Locator, and Systematic Query Logic are incorrect because they do not represent the proper expansion of SQL and are fabricated terms.

  2. Case Sensitivity in SQL

    Which statement best describes how SQL treats keywords with respect to letter case?

    1. SQL keywords must be written in uppercase
    2. SQL keywords are not case sensitive
    3. SQL keywords must be written in lowercase
    4. SQL keywords are always case sensitive

    Explanation: SQL keywords are not case sensitive, meaning 'SELECT' is the same as 'select'. It is common to use uppercase for readability, but it's not required. The other options incorrectly claim mandatory lowercase, case sensitivity, or mandatory uppercase, which are not standards for SQL.

  3. RDBMS Definition

    What does the acronym RDBMS stand for when discussing database management systems?

    1. Random Database Modeling Structure
    2. Reserved Data Management Schema
    3. Redundant Data Block Memory Server
    4. Relational Database Management System

    Explanation: RDBMS stands for Relational Database Management System, storing data in tables with relationships. The other options are incorrect and either use incorrect words or do not make sense in a database context.

  4. SQL Statement Example

    Which SQL statement retrieves all records from a table named Customers?

    1. EXTRACT * FROM Customers;
    2. FETCH ALL FROM Customers;
    3. GET * FROM Customers;
    4. SELECT * FROM Customers;

    Explanation: The correct SQL statement to retrieve all records from a table is 'SELECT * FROM Customers;'. GET, FETCH, and EXTRACT are not valid SQL commands in this context, and would result in errors.

  5. Table Columns and Rows

    In a database table, what is the correct term for a single, vertically arranged set of values for a specific field?

    1. Index
    2. Row
    3. Column
    4. Record

    Explanation: A column is a vertical entity in a table representing a specific field's data for all records. A record or row is horizontal and gives one complete entry; index relates to searching data, and row is not vertical.

  6. SQL Data Retrieval

    Which of the following SQL commands is used to extract data from a database?

    1. INSERT INTO
    2. SELECT
    3. DELETE
    4. UPDATE

    Explanation: SELECT is used to extract or query data from one or more tables. DELETE is for removing records, UPDATE for modifying, and INSERT INTO for adding new records, so they do not retrieve data.

  7. Purpose of the WHERE Clause

    What is the purpose of using a WHERE clause in an SQL statement?

    1. To define the table's primary key
    2. To filter records based on specific conditions
    3. To delete a table structure
    4. To insert new rows into a table

    Explanation: WHERE specifies criteria to filter which records an SQL statement affects. It does not delete table structures, insert new rows, or define keys, which are done with other SQL constructs.

  8. Creating a New Table

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

    1. NEW TABLE
    2. INSERT TABLE
    3. CREATE TABLE
    4. MAKE TABLE

    Explanation: CREATE TABLE is the standard way to create a new table in SQL. MAKE TABLE, INSERT TABLE, and NEW TABLE are invalid SQL commands and would cause errors.

  9. Database Objects Storage

    Where in an RDBMS is data primarily stored for organization and retrieval?

    1. Tables
    2. Directories
    3. Modules
    4. Arrays

    Explanation: RDBMS stores data mainly in tables, which consist of rows (records) and columns (fields). Directories and modules relate to programming, and arrays are general programming constructs, not RDBMS-specific.

  10. Records in Database Tables

    In SQL, how is a single, complete set of related data in a table typically referred to?

    1. Cell
    2. Record
    3. Attribute
    4. Column

    Explanation: A record, also known as a row, is a horizontal entry in a table containing related data. A cell is one value, a column is a field across all records, and attribute is another term for a column, not a row.

  11. Inserting Data

    Which SQL statement is used to add new data entries into an existing table?

    1. CREATE DATA
    2. INSERT INTO
    3. NEW ENTRY
    4. ADD NEW

    Explanation: INSERT INTO is the correct SQL command for adding new data. ADD NEW, CREATE DATA, and NEW ENTRY are not recognized SQL statements and would cause errors.

  12. Modifying Data

    If you want to change existing records in a database table, which SQL command should you use?

    1. MODIFY
    2. UPDATE
    3. CHANGEREC
    4. ALTER

    Explanation: UPDATE allows you to modify existing data in specific records based on defined conditions. MODIFY and CHANGEREC are not valid SQL commands, and ALTER is for modifying table structures, not data.

  13. Deleting Data

    Which SQL statement removes records from a database table?

    1. ERASE FROM
    2. DROP RECORD
    3. DELETE
    4. REMOVE ENTRY

    Explanation: DELETE is the SQL command to remove records. REMOVE ENTRY and ERASE FROM are not valid SQL commands, and DROP RECORD is incorrect and would produce an error.

  14. SQL Statement Separator

    Why might a semicolon (;) be placed at the end of an SQL statement?

    1. To enforce lowercase keywords
    2. To define a primary key in a table
    3. To separate multiple SQL statements for execution
    4. To indicate a comment line

    Explanation: A semicolon is the standard separator for SQL statements, especially when multiple statements are executed together. It does not define keys, indicate comments, or affect keyword case in SQL.

  15. SQL Standard Compliance

    What is true about SQL language and its standards across different database systems?

    1. SQL is an ANSI standard, but databases may have their proprietary extensions
    2. SQL is only used for Microsoft Access databases
    3. The SQL standard requires only lowercase keywords
    4. Every database system uses a completely different SQL syntax

    Explanation: SQL is an ANSI standard, meaning the basics are similar, but different RDBMSs can add their own extensions. SQL is not limited to one vendor, syntax is not unique to each database, and there is no requirement for lowercase keywords.

  16. View Creation

    Which SQL statement would be used to create a view for displaying data from a table?

    1. CREATE VIEW
    2. MAKE DISPLAY
    3. SET VISIBLE
    4. GENERATE WINDOW

    Explanation: CREATE VIEW is used to make a new view, which can present data from tables in a customized format. The other options are not valid SQL commands and would not function for view creation.

mockrounds.com Learn • Practice • Evaluate