DBMS - SQL MCQ

Database

Title
What is the full form of SQL?
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
Which operator performs pattern matching?
What operator tests column for the absence of data?
Which of the SQL statements is correct?
The FROM SQL clause is used to
Which SQL keyword is used to retrieve only unique values?
Which SQL keyword is used to retrieve a maximum value?
What is a view?
Which of the following SQL commands is used to retrieve data?
Which of the following is a SQL aggregate function?
Which SQL statement is used to update data in a database?
Which SQL statement is used to delete data FROM a database?
Which SQL keyword is used to sort the result-set?
The SQL statement SELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL;
Which of the following group functions ignore NULL values?
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?

Questions

Views

Best Answers

Points