SQL quiz cse 35

Which of the following operators is used to compare two values in SQL?

• +

• =

• &

• <>

Which of the following tasks CANNOT be accomplished using SQL?

• Creating and modifying database structures

• Retrieving specific data from a database

• Adding new data to a database

• Writing complex algorithms for data analysis

What is the purpose of the SQL keyword “DISTINCT” in a SELECT statement?

• To filter NULL values

• To delete duplicate records

• To sort the result set

• To retrieve unique values from a column

Which of the following is the basis for SQL?

• SQL Server

• DBMS

• Oracle

• RDBMS

Which character is used to separate SQL statements in database systems?

• :

• %

• _

• ;

Which statement(s) are mandatory in a simple SQL SELECT statement?

• Select, OrderBy

• Select, Where

• Select, GroupBy

• Select, From

Which of the following is a default join type?

• Right join

• Left join

• Outer join

• Inner join

Which of the following commands is used to create a database in SQL?

• MAKE

• INSERT

• DEVELOP

• CREATE

Which of the following statements is true about views in SQL?

• We can delete but not insert rows in a view

• We cannot insert and delete rows in a view

• We can insert but not delete rows in a view

• We can insert and delete rows in a view

What is the full form of PL in PL/SQL?

• Programming Language

• Programming Logic

• Procedural Logic

• Procedural Language