The SQL statement - SELECT SUBSTR(\'abcdefghij\', INSTR(\'123321234\', \'2\', 3, 2), 2) FROM DUAL; Prints

SQL (Structured Query Language) MCQ Quiz (Multiple Choice Questions And Answers)

• Which SQL function is used to count the number of rows in a SQL query?
• Which SQL keyword is used to retrieve a maximum value?
• Which of the following SQL clauses is used to DELETE tuples from a database table?
• _____removes all rows from a table without logging the individual row deletions
• Which of the following is not a DDL command?
• Which of the following are TCL commands?
• ___ is not a category of SQL command
• If you don’t specify ASC or DESC after a SQL ORDER BY clause, the following is used by default ____
• Which of the following statement is true?
• What is the purpose of the SQL AS clause?
• Which of the following is a legal expression in SQL?
• DCL provides commands to perform actions like
• The COUNT function in SQL returns the number of _____
• Which data type can store unstructured data in a column?
• A SQL query will not work if there are no indexes on the relations - Is it true?
• Table Employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE
• The SQL statement - SELECT SUBSTR(\'abcdefghij\', INSTR(\'123321234\', \'2\', 3, 2), 2) FROM DUAL; Prints
• The SQL statement - SELECT ROUND(45.926, -1) FROM DUAL;
• Which of the following must be enclosed in double-quotes?
• Which of the following command makes the updates performed by the transaction permanent in the database?
• A subquery in an SQL SELECT statement is enclosed in:
• The result of a SQL SELECT statement is a ______
• In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:
• The HAVING clause does which of the following?
• Which of the following do you need to consider when you make a table in SQL?

This question belongs to these collections

• SQL (Structured Query Language) MCQ Quiz (Multiple Choice Questions And Answers)

Similar questions