Oracle SQL Exam Trivia Quiz!
30 Questions
| Total Attempts: 53
Questions and Answers
- 1.Group functions cannot be nested
- A.
True
- B.
False
- 2.Only two tables can be JOINed in each SELECT statement
- A.
True
- B.
False
- 3.NONEQUIJOINS are JOINs used to SELECT data between ranges of values.
- A.
True
- B.
False
- 4.The main query executes before the subquery.
- A.
True
- B.
False
- 5.The expression in SELECT list may not match in number when doing operations involving SET operators.
- A.
True
- B.
False
- 6.Duplicate rows are eliminated in UNIONALL
- A.
True
- B.
False
- 7.In SET operations, the ORDER BY clause can appear only once at the end of compound query.
- A.
True
- B.
False
- 8.You can remove existing rows by using DELETE statement.
- A.
True
- B.
False
- 9.TRUNCATE statement removes all rows from a table, leaving the table empty and the table structure intact.
- A.
True
- B.
False
- 10.An automatic rollback occurs when there is abnormal termination of SQL Developer or System failure.
- A.
True
- B.
False
- 11.A SEQUENCE logically represents subsets of data from one or more tables
- A.
False
- B.
True
- 12.Table and Column names must begin with a letter.
- A.
True
- B.
False
- 13.You cannot remove a view without losing data because a view is based on underlying tables in the database.
- A.
False
- B.
True
- 14.A unique index is created automatically when you define a PRIMARY KEY or UNIQUE KEY constraints in a table definition.
- A.
True
- B.
False
- 15.Contraints can still be added even if the table is already created.
- A.
True
- B.
False
- 16.Remove INDEX by using DROP INDEX command.
- A.
True
- B.
False
- 17.A table cannot be created from the result of a subquery.
- A.
False
- B.
True
- 18.A column can be added even the table is already created.
- A.
True
- B.
False
- 19.Regular Expressions cannot be used on CHECK Constraints.
- A.
False
- B.
True
- 20.SQL statements are case sensitive
- A.
False
- B.
True
- 21.Date and character literal values should be enclose within single quotation marks
- A.
True
- B.
False
- 22.A SELECT statement always requires the presence of WHERE clause
- A.
False
- B.
True
- 23.The default order provided by the ORDER BY clause is descending order
- A.
False
- B.
True
- 24.You cannot use case-conversion function on the WHERE clause
- A.
False
- B.
True
- 25.The MOD function returns the remainder of division
- A.
True
- B.
False
PL/SQL is a procedural language extension to Structured Query Language. You can take this Oracle PL/SQL quiz questions and answers and check your knowledge. The purpose of PL/SQL is to combine database language and procedural...
Questions: 30 | Attempts: 13291 | Last updated: Nov 18, 2021
-
Sample QuestionSelect incorrect variable declarations
Are you able to pass this Oracle PL/SQL test? This free procedural language is designed to run alongside the SQL within the same server process, bringing optimal efficiency. The Oracle PL, although not portable and doesn't...
Questions: 45 | Attempts: 3460 | Last updated: Sep 23, 2020
-
Sample QuestionSelect incorrect variable declarations
Hey, check out this amazing 'Oracle Final Test' quiz. We've designed this quiz to test your knowledge about the Oracle subject. If you are planning to give the Oracle Certification Exam, then this quiz will prove...
Questions: 40 | Attempts: 3396 | Last updated: Jan 10, 2022
-
Sample QuestionYou attempt to query the database with this command: SELECT name, salary FROM employee WHERE salary= (SELECT salary FROM employee WHERE last_name= ‘Wagner’ OR dept_no=233) Why could this statement cause an error?
Back to top