1. You query the database with this SQL statement:
SELECT LOWER(SUBSTR(CONCAT(last_name, first_name)), 1, 5) "ID"
FROM employee;
In which order are the functions evaluated?
CONCAT, SUBSTR, LOWER (*)
2. You query the database with this SQL statement:
SELECT CONCAT(last_name, (SUBSTR(LOWER(first_name), 4))) "Default Password"
FROM employees;
Which function will be evaluated first?
LOWER (*)
3. The STYLES table contains this data:
STYLE_IDSTYLE_NAMECATEGORYCOST895840SANDAL8594012.00968950SANDAL8590910.00869506SANDAL8969015.00809090LOAFER8909810.00890890LOAFER8978914.00857689HEEL8594011.00758960SANDAL8697912.00
You query the database and return the value 79. Which script did you use?
SELECT SUBSTR(category, -2,2)
FROM styles
WHERE style_id = 758960;
4. Which query selects the first names of the DJ On Demand clients who have a first name beginning with "A"?
SELECT UPPER(first_name)
FROM d_clients
WHERE LOWER(first_name) LIKE 'a%'
(*)
5. What does the following SQL SELECT statement return?
SELECT UPPER( SUBSTR('Database Programming', INSTR('Database Programming','P'),20))
FROM dual;
PROGRAMMING (*)
6. Which of the following Date Functions will add calendar months to a date?
ADD_MONTHS (*)
7. Which SELECT statement will NOT return a date value?
SELECT (SYSDATE - hire_date) + 10*8
FROM employees;
8. Round and Trunc cannot be used on Date datatypes. True or False?
False(*)
9. Evaluate this SELECT statement:
SELECT SYSDATE + 30
FROM dual;
Which value is returned by the query?
The current date plus 30 days. (*)
10. Which of the following SQL statements will correctly display the last name and the number of weeks employed for all employees in department 90?
SELECT last_name, (SYSDATE-hire_date)/7 AS WEEKS
FROM employees
WHERE department_id = 90;
(*)
11. Which two functions can be used to manipulate number or date column values, but NOT character column values? (Choose two.)
(Choose all correct answers)
ROUND(*)
TRUNC(*)
12. The answer to the following script is 456. True or False?
SELECT TRUNC(ROUND(456.98))
FROM dual;
False (*)
13. Which number function may be used to determine if a value is odd or even?
MOD(*)
14. Which comparison operator retrieves a list of values?
IN(*)
15. Which script displays '01-May-2004' when the HIRE_DATE value is '20-May-2004'?
SELECT TRUNC(hire_date, 'MONTH')
FROM employees;
(*)
Are you looking for SEO? We provide SEO services for small business, start-ups, and big companies too. You will get affordable packages with top 10 results in Google. Need to hire SEO VA, pm
BalasHapus