Which SELECT statement will the result 'ello world' from the string 'Hello World'?

SELECT LOWER (TRIM ('H' FROM 'Hello World')) FROM dual;

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;

Which four statements correctly describe functions that are available in SQL?

INSTR returns the numeric position of a named character.

TRIM trims the heading of trailing characters (or both) from a character string.

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.

Which two statements are true regarding the ORDER BY clause?

The sort is in ascending by order by default.

The ORDER BY clause comes last in the SELECT statement.

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.

Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?

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

You need to display the last names of those employees who have the letter "A" as the second character in their names. Which SQL statement displays the required results?

SELECT last_name FROM EMP WHERE last name ='_A%';

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 LIKE '*A%'

Which SELECT statement should you use to extract the year from the system date and display it in the format "1998"?

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;

Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) Which statement produces the number of different departments that have employees with last name Smith?

SELECT COUNT (DISTINCT dept_id) FROM employees WHERE last _name='smith';

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 UNIQE (dept_id) FROM employees WHERE last _name='smith';

Evaluate this SQL statement: SELECT ename, sal, 12* sal+100 FROM emp; The SAL column stores the monthly salary of the employee. Which change must be made to the above syntax to calculate the annual compensation as "monthly salary plus a monthly bonus of $100, multiplied by 12"?

SELECT ename, sal, 12* (sal+100) FROM emp;

No change is required to achieve the desired results.

SELECT ename, sal, (12* sal)+100 FROM emp;

SELECT ename, sal +100,*12 FROM emp;

The EMPLOYEES table contains these columns: EMPLOYEE_ID NUMBER(4) LAST_NAME VARCHAR2 (25) JOB_ID VARCHAR2(10) You want to search for strings that contain 'SA_' in the JOB_ID column. Which SQL statement do you use?

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_';

The CUSTOMERS table has these columns: CUSTOMER_ID NUMBER(4) NOT NULL CUSTOMER_NAME VARCHAR2(100) NOT NULL CUSTOMER_ADDRESS VARCHAR2(150) CUSTOMER_PHONE VARCHAR2(20) You need to produce output that states "Dear Customer customer_name, ". The customer_name data values come from the CUSTOMER_NAME column in the CUSTOMERS table. Which statement produces this output?

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;

The CUSTOMERS table has these columns: CUSTOMER_ID NUMBER(4) NOT NULL CUSTOMER_NAME VARCHAR2(100) NOT NULL STREET_ADDRESS VARCHAR2(150) CITY_ADDRESS VARCHAR2(50) STATE_ADDRESS VARCHAR2(50) PROVINCE_ADDRESS VARCHAR2(50) COUNTRY_ADDRESS VARCHAR2(50) POSTAL_CODE VARCHAR2(12) CUSTOMER_PHONE VARCHAR2(20) A promotional sale is being advertised to the customers in France. Which WHERE clause identifies customers that are located in France?

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%

The PRODUCTS table has these columns: PRODUCT_ID NUMBER(4) PRODUCT_NAME VARCHAR2(45) PRICE NUMBER(8,2) Evaluate this SQL statement: SELECT * FROM PRODUCTS ORDER BY price, product _ name; What is true about the SQL statement?

The results are sorted numerically and then alphabetically.

The results are sorted numerically.

The results are sorted alphabetically.

Oracle_test4

Approved & Edited by ProProfs Editorial Team

The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.

Learn about Our Editorial Process

| By Sudha_test

Sudha_test

Community Contributor

Quizzes Created: 12 | Total Attempts: 36,992

Questions: 15 | Attempts: 1,307 | Updated: Mar 22, 2023

Questions

Settings

Feedback

During the Quiz End of Quiz

Difficulty

Sequential Easy First Hard First

Play as

Quiz Flashcard

Create your own Quiz

This test used to rate your Oracle skills

Questions and Answers

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

Current Version
Mar 22, 2023

Quiz Edited by
ProProfs Editorial Team
Jan 04, 2010

Quiz Created by
Sudha_test