Basics
Queries & Operations
Joins & Functions
Data Constraints & Aggregate Functions
Advanced SQL Topics
Database Design & Security
Courses
  • Placement 360 CourseExplore

    • SQL Joins & Functions Quiz

    Last Updated :
    Discuss
    Comments

    Question 1

    Which SQL JOIN type returns all rows from both tables, joining records where available?

    • A

      INNER JOIN

    • B

      LEFT JOIN

    • C

      RIGHT JOIN

    • D

      FULL JOIN

    Question 2

    What does the SQL function "CONCAT()" do?

    • A

      Adds two numbers together

    • B

      Concatenates two or more strings

    • C

      Converts a string to uppercase

    • D

      Returns the length of a string

    Question 3

    Which SQL JOIN type returns only the rows that have matching values in both tables?

    • A

      INNER JOIN

    • B

      LEFT JOIN

    • C

      RIGHT JOIN

    • D

      FULL JOIN

    Question 4

    What does the SQL function "LOWER()" do?

    • A

      Adds two numbers together

    • B

      Concatenates two or more strings

    • C

      Converts a string to lowercase

    • D

      Returns the length of a string

    Question 5

    Which SQL JOIN type returns all rows from the left table and matching rows from the right table?

    • A

      INNER JOIN

    • B

      LEFT JOIN

    • C

      RIGHT JOIN

    • D

      FULL JOIN

    Question 6

    What does the function "UPPER()" do?

    • A

      Adds two numbers together

    • B

      Concatenates two or more strings

    • C

      Converts a string to uppercase

    • D

      Returns the length of a string

    Question 7

    Which SQL JOIN type returns all rows from the right table and matching rows from the left table?

    • A

      INNER JOIN

    • B

      LEFT JOIN

    • C

      RIGHT JOIN

    • D

      FULL JOIN

    Question 8

    What does the SQL function "LENGTH()" do?

    • A

      Adds two numbers together

    • B

      Concatenates two or more strings

    • C

      Converts a string to lowercase

    • D

      Returns the length of a string

    Question 9

    Which SQL JOIN type returns all rows when there is a match in either the left or right table?

    • A

      INNER JOIN

    • B

      LEFT JOIN

    • C

      RIGHT JOIN

    • D

      FULL JOIN

    Question 10

    What does the SQL function "ROUND()" do?

    • A

      Rounds a number to the nearest integer


    • B

      Concatenates two or more strings


    • C

      Converts a string to lowercase


    • D

      Returns the length of a string

    There are 10 questions to complete.

    Take a part in the ongoing discussion