RDBMS - Day 2

What are the two types of SQL functions? (Select all the right answers)

• Single-row functions

• Double-row functions

• Multiple-row functions

• None of the above

Which SQL function is used to count the number of rows in a SQL query?

• COUNT()

• NUMBER()

• SUM()

• COUNT(*)

Which Command is used to remove all rows from a table?

• Delete

• Remove

• Truncate

• Both A and B

What is the function used to find the numeric position of a named character?

• LPAD

• INSTR

• SUBSTR

• None of the above

Which of the following is used before the group functions?

• TABLE

• FROM

• SELECT

• DISTINCT

What can MIN and MAX functions be used on?

• Numeric

• Character

• Date data types

• All of the above

Which keyword is used to suppress the counting of duplicate values?

• DISTINCT

• COUNT

• REAL

• DUPLICATE

What is used to view the information from multiple tables?

• CONCAT

• JOIN

• ADD

• GROUP

Which command is used to add a column to an existing table?

• Create

• Update

• Alter

• None of the above

Which one of the following results in a Inner join type? (Select all the correct answers)

• Natural join

• Full Join

• on

• using