What is the full form of SQL?
Select an option to see the answer and solution.
SQL · all questionsSQL
SQL
practice.
Practice every MCQ with options. Use Show answers when you want the correct option and solution.
79
Questions
1/4
Page
Pick an option on a question to see the right answer and solution.
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
Select an option to see the answer and solution.
Which operator performs pattern matching?
Select an option to see the answer and solution.
What operator tests column for the absence of data?
Select an option to see the answer and solution.
In SQL, which command(s) is(are) used to change a table's storage characteristics?
Select an option to see the answer and solution.
In SQL, which of the following is not a data definition language commands?
Select an option to see the answer and solution.
In SQL, which command is used to SELECT only one copy of each set of duplicable rows
Select an option to see the answer and solution.
A command that lets you change one or more fields in a record is
Select an option to see the answer and solution.
Which of the SQL statements is correct?
Select an option to see the answer and solution.
The FROM SQL clause is used to...
Select an option to see the answer and solution.
Which SQL keyword is used to retrieve only unique values?
Select an option to see the answer and solution.
Which SQL keyword is used to retrieve a maximum value?
Select an option to see the answer and solution.
What is a view?
Select an option to see the answer and solution.
Which of the following SQL commands is used to retrieve data?
Select an option to see the answer and solution.
Which of the following is a SQL aggregate function?
Select an option to see the answer and solution.
Which SQL statement is used to update data in a database?
Select an option to see the answer and solution.
Which SQL statement is used to delete data FROM a database?
Select an option to see the answer and solution.
Which SQL keyword is used to sort the result-set?
Select an option to see the answer and solution.
The SQL statement
SELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL;
SELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL;
Select an option to see the answer and solution.
Which of the following group functions ignore NULL values?
Select an option to see the answer and solution.