Databases - Upwork

Question: Which of the following statements is a complete transaction?
A
DELETE employees;

B
DESCRIBE employees;

C
ROLLBACK TO SAVEPOINT C;

D
GRANT SELECT ON employees TO SCOTT;

E
ALTER TABLE employees SET UNUSED COLUMN sal;

Note: Not available
1. Report
Question: Which of the following tasks can be performed by using the TO_CHAR function?
A
Convert '10'to 10

B
Convert 10 to '10'

C
Convert 'TEN' to 10

D
Convert a date to a character expression

E
Convert a character expression to a date

Note: Not available
1. Report
Question: What kinds of commands can you enter at the command prompt in 9i Sql Plus?
A
PL/SQL Blocks

B
SQL*Plus commands

C
Security commands

D
SQL commands

Note: Not available
1. Report
Question: Which of the following statements are correct with regard to WHERE and HAVING clauses?
A
A WHERE clause can be used to restrict both rows and groups

B
A WHERE clause can be used to restrict rows only

C
A HAVING clause can be used to restrict both rows and groups

D
A HAVING clause can be used to restrict groups only

E
A HAVING clause CANNOT be used in Subqueries

Note: Not available
1. Report
Question: Examine the description of the STUDENTS table: STD_ID NUMBER (4) COURSE_ID VARCHAR2 (10) START_DATE DATE END_DATE DATE The aggregate functions valid on the START_DATE columns are:
A
SUM(start_date)

B
AVG(start_date)

C
COUNT(start_date)

D
AVG(start_date, end_date)

E
MIN(start_date)

Note: Not available
1. Report
Question: Examine the data in the EMPLOYEES table given below: LAST_NAME �DEPARTMENT_ID SALARY ALLEN 10 3000 MILLER 20 1500 King 20 2200 Davis 30 5000 Which of the following Subqueries work?
A
SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department_id);

B
SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department_id);

C
SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department_id);

D
SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department_id);

E
SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY AVG(SALARY));

Note: Not available
1. Report
Question: You have to calculate the value 12* salary* commission_pct for all the employees in the EMP table. Which of the following statements ensures that a value is displayed in the calculated column for all the employees?
A
SELECT last_name, 12 * salary* commission_pct FROM emp;

B
SELECT last_name, 12 * salary* (commission_pct,0) FROM emp;

C
SELECT last_name, 12 * salary* (nvl(commission_pct,0) )FROM emp;

D
SELECT last_name, 12 * salary* (decode(commission_pct,0)) FROM emp;

Note: Not available
1. Report
Question: Evaluate the following SQL statement: SELECT e.employee_id, (.15* e.salary) + (.5 * e.commission_pct) + (s.sales_amount * (.35 * e.bonus)) AS CALC_VALUE FROM employees e, sales s WHERE e.employee_id = s.emp_id; What will happen if all the parentheses are removed from the calculation?
A
The value displayed in the CALC_VALUE column will be lower

B
The value displayed in the CALC_VALUE column will be higher

C
There will be no difference in the value displayed in the CALC_VALUE column

D
An error will be reported

Note: Not available
1. Report
Question: Which of the following is an iSQL*Plus command?
A
INSERT

B
UPDATE

C
SELECT

D
DESCRIBE

E
DELETE

Note: Not available
1. Report
Question: Examine the code given below: SELECT employee_id FROM employees WHERE commission_pct=.5 OR salary > 23000 Which of the following statement is correct with regard to this code?
A
It returns employees who have 50% of the salary greater than $23,000:

B
It returns employees who have 50% commission rate or salary greater than $23,000:

C
It returns employees who have 50% of salary less than $23,000:

D
None of these above

Note: Not available
1. Report

First Prev 50 51 52 53 54 Next Last

Question: Which of the following statements is a complete transaction?

Question: Which of the following tasks can be performed by using the TO_CHAR function?

Question: What kinds of commands can you enter at the command prompt in 9i Sql Plus?

Question: Which of the following statements are correct with regard to WHERE and HAVING clauses?

Question: Examine the description of the STUDENTS table: STD_ID NUMBER (4) COURSE_ID VARCHAR2 (10) START_DATE DATE END_DATE DATE The aggregate functions valid on the START_DATE columns are:

Question: Examine the data in the EMPLOYEES table given below: LAST_NAME �DEPARTMENT_ID SALARY ALLEN 10 3000 MILLER 20 1500 King 20 2200 Davis 30 5000 Which of the following Subqueries work?

Question: You have to calculate the value 12* salary* commission_pct for all the employees in the EMP table. Which of the following statements ensures that a value is displayed in the calculated column for all the employees?

Question: Evaluate the following SQL statement: SELECT e.employee_id, (.15* e.salary) + (.5 * e.commission_pct) + (s.sales_amount * (.35 * e.bonus)) AS CALC_VALUE FROM employees e, sales s WHERE e.employee_id = s.emp_id; What will happen if all the parentheses are removed from the calculation?

Question: Which of the following is an iSQL*Plus command?

Question: Examine the code given below: SELECT employee_id FROM employees WHERE commission_pct=.5 OR salary > 23000 Which of the following statement is correct with regard to this code?