Which number function may be used to determine if a value is odd or even?
TRUNC
BINARY
MOD (*)
ROUND
2. You issue this SQL statement:
SELECT ROUND (1282.248, -2) FROM dual;
What value does this statement produce?
1282
1300 (*)
1200
1282.25
3. What is the result of the following SQL Statement:
SELECT ROUND(45.923,-1)
FROM DUAL;
46
45.9
50 (*)
None of the above
4. Evaluate this function: MOD (25, 2) Which value is returned?
2
25
0
1 (*)
5. Which comparison operator retrieves a list of values?
LIKE
BETWEEN IN
IN (*)
IS NULL
6. What function would you use to return the highest date in a month? END_DAY LAST_DAY (*) HIGHEST_DAY FINAL_DAY 7. The EMPLOYEES table contains these columns: LAST_NAME VARCHAR2(20) FIRST_NAME VARCHAR2(20) HIRE_DATE DATE EVAL_MONTHS NUMBER(3) Evaluate this SELECT statement: SELECT hire_date + eval_months FROM employees; The values returned by this SELECT statement will be of which data type? NUMBER DATETIME DATE (*) INTEGER 8. Which function would you use to return the current database server date and time? SYSDATE (*) CURRENTDATE DATETIME DATE 9. You need to display the number of months between today's date and each employee's hiredate. Which function should you use? ROUND MONTHS_BETWEEN (*) ADD_MONTHS BETWEEN 10. What is the result of the following query? SELECT ADD_YEARS ('11-Jan-1994',6) FROM dual; 11-Jan-2000 This in not a valid SQL statement. (*) 11-Jul-2000 11-Jul-1995
11. Character functions accept character arguments and only return character values. True or False? Doğru Yanlış (*) 12. Which SQL function can be used to remove heading or trailing characters (or both) from a character string? CUT NVL2 TRIM (*) LPAD 13. You need to display the number of characters in each customer's last name. Which function should you use? LPAD SUBSTR COUNT LENGTH (*) 14. Which SQL function is used to return the position where a specific character string begins within a larger character string? LENGTH SUBSTR CONCAT INSTR (*) 15. Evaluate this SELECT statement: SELECT LENGTH(email) FROM employee; What will this SELECT statement display? The longest e-mail address in the EMPLOYEE table The maximum number of characters allowed in the EMAIL column The number of characters for each value in the EMAIL column in the employees table (*) The email address of each employee in the EMPLOYEE table
TRUNC
BINARY
MOD (*)
ROUND
2. You issue this SQL statement:
SELECT ROUND (1282.248, -2) FROM dual;
What value does this statement produce?
1282
1300 (*)
1200
1282.25
3. What is the result of the following SQL Statement:
SELECT ROUND(45.923,-1)
FROM DUAL;
46
45.9
50 (*)
None of the above
4. Evaluate this function: MOD (25, 2) Which value is returned?
2
25
0
1 (*)
5. Which comparison operator retrieves a list of values?
LIKE
BETWEEN IN
IN (*)
IS NULL
6. What function would you use to return the highest date in a month? END_DAY LAST_DAY (*) HIGHEST_DAY FINAL_DAY 7. The EMPLOYEES table contains these columns: LAST_NAME VARCHAR2(20) FIRST_NAME VARCHAR2(20) HIRE_DATE DATE EVAL_MONTHS NUMBER(3) Evaluate this SELECT statement: SELECT hire_date + eval_months FROM employees; The values returned by this SELECT statement will be of which data type? NUMBER DATETIME DATE (*) INTEGER 8. Which function would you use to return the current database server date and time? SYSDATE (*) CURRENTDATE DATETIME DATE 9. You need to display the number of months between today's date and each employee's hiredate. Which function should you use? ROUND MONTHS_BETWEEN (*) ADD_MONTHS BETWEEN 10. What is the result of the following query? SELECT ADD_YEARS ('11-Jan-1994',6) FROM dual; 11-Jan-2000 This in not a valid SQL statement. (*) 11-Jul-2000 11-Jul-1995
11. Character functions accept character arguments and only return character values. True or False? Doğru Yanlış (*) 12. Which SQL function can be used to remove heading or trailing characters (or both) from a character string? CUT NVL2 TRIM (*) LPAD 13. You need to display the number of characters in each customer's last name. Which function should you use? LPAD SUBSTR COUNT LENGTH (*) 14. Which SQL function is used to return the position where a specific character string begins within a larger character string? LENGTH SUBSTR CONCAT INSTR (*) 15. Evaluate this SELECT statement: SELECT LENGTH(email) FROM employee; What will this SELECT statement display? The longest e-mail address in the EMPLOYEE table The maximum number of characters allowed in the EMAIL column The number of characters for each value in the EMAIL column in the employees table (*) The email address of each employee in the EMPLOYEE table
Yorumlar
Yorum Gönder