Oracle_test4 is designed to assess skills in SQL, focusing on functions, query syntax, and data manipulation. The quiz evaluates understanding of SELECT statements, ORDER BY clause, and string manipulation in SQL, essential for database management proficiency.
No change is required to achieve the desired results.
SELECT ename, sal, 12* (sal+100) FROM emp;
SELECT ename, sal, (12* sal)+100 FROM emp;
SELECT ename, sal +100,*12 FROM emp;
Rate this question:
The results are not sorted.
The results are sorted numerically.
The results are sorted alphabetically.
The results are sorted numerically and then alphabetically.
Rate this question:
SELECT SUBSTR ('Hello',) FROM dual;
SELECT INITCAP (TRIM ('Hello World',1,1) FROM dual;
SELECT LOWER (SUBSTR ('Hello World',1,1) FROM dual;
SELECT LOWER (SUBSTR ('Hello World',2,1) FROM dual;
SELECT LOWER (TRIM ('H' FROM 'Hello World')) FROM dual;
Rate this question:
SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA\_%'ESCAPE'\';
SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_';
SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_'ESCAPE'\';
SELECT employee_id, last_name, job_id FROM employees WHERE job_id '%SA_';
Rate this question:
SELECT COUNT (*) FROM employees WHERE last _name='smith';
SELECT COUNT (dept_id) FROM employees WHERE last _name='smith';
SELECT DISTINCT (COUNT (dept_id) FROM employees WHERE last _name='smith';
SELECT COUNT (DISTINCT dept_id) FROM employees WHERE last _name='smith';
SELECT UNIQE (dept_id) FROM employees WHERE last _name='smith';
Rate this question:
SELECT ename, salary*12 'Annual Salary' FROM employees;
SELECT ename, salary*12 "Annual Salary" FROM employees;
SELECT ename, salary*12 AS Annual Salary FROM employees;
SELECT ename, salary*12 AS INITCAP("ANNUAL SALARY") FROM employees
Rate this question:
The sort is in ascending by order by default.
The sort is in descending order by default.
The ORDER BY clause must precede the WHERE clause.
The ORDER BY clause is executed on the client side.
The ORDER BY clause comes last in the SELECT statement.
Rate this question:
SELECT TO_CHAR(SYSDATE,'yyyy') FROM dual;
SELECT TO_DATE(SYSDATE,'yyyy') FROM dual;
SELECT DECODE(SUBSTR(SYSDATE, 8), 'YYYY') FROM dual;
SELECT DECODE(SUBSTR(SYSDATE, 8), 'year') FROM dual;
SELECT TO_CHAR(SUBSTR(SYSDATE, 8,2),'yyyy') FROM dual;
Rate this question:
WHERE lower(country_address) = "france"
WHERE lower(country_address) = 'france'
WHERE lower(country_address) IS 'france'
WHERE lower(country_address) = '%france%'
WHERE lower(country_address) LIKE %france%
Rate this question:
SELECT dear customer, customer_name, FROM customer;
SELECT "Dear Customer", customer_name, ||',' FROM customer;
SELECT 'Dear Customer' || customer_name ',' FROM customer;
SELECT 'Dear Customer' || customer_name || ',' FROM customer;
SELECT "Dear Customer" || customer_name || "," FROM customer;
Rate this question:
INSTR returns the numeric position of a named character.
NVL2 returns the first non-null expression in the expression list.
TRUNCATE rounds the column, expression, or value to n decimal places
DECODE translates an expression after comparing it to each search value.
TRIM trims the heading of trailing characters (or both) from a character string.
Rate this question:
17000.00
17000*****
****17000
**17000.00
An error statement
Rate this question:
25
5
2
1
None of the above
Rate this question:
SELECT last_name FROM EMP WHERE last_ name LIKE '_A%';
SELECT last_name FROM EMP WHERE last name ='*A%'
SELECT last_name FROM EMP WHERE last name ='_A%';
SELECT last_name FROM EMP WHERE last name LIKE '*A%'
Rate this question:
Quiz Review Timeline (Updated): Mar 22, 2023 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
RDBMS And SQL Knowledge Test
Welcome to the RDBMS and SQL Knowledge Test. As you might already know, RDMS is the basis for various modern database systems such as SQL, MySQL, MS SQL Server, IBM DB2. etc. In...
Questions:
10 |
Attempts:
2762 |
Last updated:
Nov 12, 2023
|
The Ultimate SQL Syntax And Functionality Knowledge Test
Since its creation in 1974, SQL has become the most popular programming language for relational database management. With its fine set of functions and easy to learn syntax, it...
Questions:
40 |
Attempts:
429 |
Last updated:
Mar 21, 2023
|
SQL Basic! Ultimate Trivia Quiz
Dive into the basics of SQL with this Ultimate Trivia! Assess your understanding of key SQL functions like COUNT(*), MAX, and DELETE. Perfect for beginners, this quiz enhances...
Questions:
10 |
Attempts:
688 |
Last updated:
Mar 21, 2023
|
SQL Multiple Choice Questions With Answers
Are you looking for some SQL multiple-choice questions with answers to make your preparation level better for the upcoming exam? Try our quiz below and see if you know the basics...
Questions:
20 |
Attempts:
12469 |
Last updated:
Jun 17, 2024
|
Fill In The Blanks On SQL
This SQL quiz assesses key database management skills, focusing on table structure modifications, understanding of relational model constraints, and data manipulation. It's ideal...
Questions:
10 |
Attempts:
1191 |
Last updated:
Mar 21, 2023
|
Introduction To SQL True Or False Quiz
What is SQL? Have you ever used SQL programming language? Here, we have this "Introduction to SQL quiz" in the true or false format to check your knowledge regarding...
Questions:
12 |
Attempts:
2643 |
Last updated:
Aug 24, 2023
|
Wait!
Here's an interesting quiz for you.