Rdbms And SQL Knowledge Test

10 Questions | Total Attempts: 37

SettingsSettingsSettings
Please wait...
Rdbms And SQL Knowledge Test

Welcome to the RDBMS and SQL Knowledge Test. As you might already know, RDMS is the basis for various modern database systems such as SQL, MySQL, MS SQL Server, IBM DB2. Etc. In this quiz, you will be asked questions about the relational database management system and SQL programming. Let's see if you can pass this test or not.


Questions and Answers
  • 1. 
    Which data manipulation command is used to combines the records from one or more tables?
    • A. 

      SELECT

    • B. 

      PROJECT

    • C. 

      JOIN

    • D. 

      PRODUCT

  • 2. 
    Which of the following is not a valid SQL type?
    • A. 

      DECIMAL

    • B. 

      NUMERIC

    • C. 

      FLOAT

    • D. 

      CHARACTER

  • 3. 
    Which operator is used to compare a value to a specified list of values?
    • A. 

      BETWEEN

    • B. 

      ANY

    • C. 

      IN

    • D. 

      ALL

  • 4. 
    Is [ SQL permits attribute names to be repeated in the same relation.  ] true or false?
    • A. 

      True

    • B. 

      False

  • 5. 
    Is [ A SQL query automatically eliminates duplicates  ? ] true or false?
    • A. 

      True

    • B. 

      False

  • 6. 
    Which SQL function is used to count the number of rows in a SQL query?
    • A. 

      COUNT()

    • B. 

      NUMBER()

    • C. 

      SUM()

    • D. 

      COUNT(*)

  • 7. 
    Which SQL keyword is used to retrieve a maximum value?
    • A. 

      MOST

    • B. 

      TOP

    • C. 

      MAX

    • D. 

      UPPER

  • 8. 
    ___________removes all rows from a table without logging the individual row deletions.
    • A. 

      DELETE

    • B. 

      REMOVE

    • C. 

      DROP

    • D. 

      TRUNCATE

  • 9. 
    Which of the following is not a DDL command?
    • A. 

      UPDATE

    • B. 

      TRUNCATE

    • C. 

      ALTER

    • D. 

      None of the Mentioned

  • 10. 
    Which of the following are TCL commands?
    • A. 

       UPDATE and TRUNCATE

    • B. 

      SELECT and INSERT

    • C. 

      GRANT and REVOKE

    • D. 

      ROLLBACK and SAVEPOINT

Related Topics
Back to Top Back to top