SQL & JDBC Test

Full Name

What does SQL stand for?

• Standard Query Language

• Structured Query Language

• Both

• None

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

• INSERT
• UPDATE
• DELETE
• SELECT

Which of the following is a join that returns only the rows that have matching values in both tables?

• LEFT JOIN
• RIGHT JOIN
• FULL OUTER JOIN
• INNER JOIN

Which of the following is a join that returns all the rows from the left table and matching rows from the right table?

• LEFT JOIN
• RIGHT JOIN
• FULL OUTER JOIN
• INNER JOIN

Which of the following is used to calculate the average value of a numeric column in SQL?

• COUNT
• MAX
• MIN
• AVG

Which of the following is used to add new rows to a SQL table?

• INSERT
• UPDATE
• DELETE
• SELECT

What is JDBC?

• A programming language
• A Java API for connecting and executing SQL statements on a database
• A type of database system
• A type of web browser

Which of the following is used to establish a connection to a database using JDBC?

• Connection.createStatement()
• DriverManager.getConnection()
• Connection.prepareStatement()
• Statement.executeQuery()

Which SQL keyword is used to retrieve only distinct records from a table?

• DISTINCT
• UNIQUE
• SELECT DISTINCT
• DISTINCTROW