SQL set 3

Which of the following must be enclosed in double-quotes?

• Dates

• Column Alias

• String

• All of the mentioned

A subquery in an SQL SELECT statement is enclosed in:

• parenthesis -- (...)

• brackets -- [...].

• CAPITAL LETTERS

• braces -- {...}

What is returned by SUBSTR(‘TUTORIALS POINT’, -1, 1)?

• T

• NULL

• 0

• N

Consider the following schema −

STUDENTS(student_code, first_name, last_name, email,phone_no, date_of_birth, honours_subject, percentage_of_marks);

Which query will display the names and honours subjects of all students and if a student has not yet been given a honours subject yet, then it should display ‘No Honours Yet’?

• select first_name, last name, nvl(honours_subject, ‘No Honours Yet’) from students;

• select first_name, last name, nvl2(honours_subject, ‘No Honours Yet’) from students;

• select first_name, last name, honours_subject, from students;

• select first_name, last name, nullif(honours_subject, ‘No Honours Yet’) from students;

Which of the following is not true about single-row subqueries?

• Single row subqueries return one row from the inner SELECT statement.

• Single row subqueries return one row from the outer SELECT statement.

• Single row subqueries use single-row comparison operators.

• All of the above.

Which of the following is not a developer’s privilege?

• CREATE USER

• CREATE TABLE

• CREATE VIEW

• CREATE SEQUENCE

Which of the following is not true about use of a database view?

• It restricts data access.

• It makes queries easy.

• It provides data independence.

• It prevents different views of same data.

What is returned by INSTR ('JAVAT POINT', 'P')?

• 6

• 7

• POINT

• JAVAT

The SQL statement: SELECT ROUND (65.726, -1) FROM DUAL;

Prints:

• is illegal

• garbage

• 726

• 70

A CASE SQL statement is ________?

• A way to establish a loop in SQL.

• A way to establish an IF-THEN-ELSE in SQL

• A way to establish a data definition in SQL

• All of the above.