Question 2. 2. (TCO A) You issue this command: Grant update on employee to Sally

Question

Question 2.2. (TCO A) You issue this command:
Grant update on employee to Sally with grant option;
Which task could Sally perform on the employee table? (Points : 5)

       View data.
       Delete data.
       Modify constraints.
       Give update access to other users.

Question 4.4. (TCO A) The EMPLOYEE table contains these columns.
FIRST_NAME   VARCHAR(25)
LAST_NAME    VARCHAR(25)
JOB                 VARCHAR(25)
SALARY          DECIMAL(7,2)
DEPT_ID          INT(3)

You need to display the first name and last name for employees whose

last name is Brown, Chan, or Lindsey;

job is manager, technician, or clerk; and

salary is greater than $30,000.

You issue this SQL statement.
SELECT first_name, last_name
SELECT first_name, last_name
FROM employee
WHERE UPPER(last_name) in ('BROWN','CHAN','LINDSEY')
AND UPPER(job) IN ('MANAGER','TECHNICIAN','CLERK')
AND salary > 30,000 (Points : 5)

       Those who meet only two requirements.
       Those who meet all three requirements.

Question 5.5. (TCO A) You are proposing to management that all employees receive a 10% salary increase and receive a commission that is 20% of this newly increased salary. You are writing a report that will display the proposed salary, commission, and total compensation. Evaluate these SQL statements.
SELECT sal * 1.1 "Salary", sal * 1.1 * .2 "Commission", sal * 1.1 + sal * 1.1 * .2 "Compensation"
FROM emp;
SELECT sal * 1.1 "Salary", sal * 1.1 * .2 "Commission", (sal * 1.1) + (sal * .2) "Compensation"
FROM emp;
SELECT sal * 1.1 "Salary", sal * .2 "Commission", sal * 1.1 + sal * 1.1 * .2 "Compensation"
FROM emp;
What are the results of these statements? (Points : 5)

       Two statements return the desired result.
       Only Statement 1 returns the desired result.
       Only Statement 2 returns the desired result.
       Only Statement 3 returns the desired result.
       None of the statements return the desired result.

Question 11.11. (TCO F) Under which circumstance would you create an index for a column of a table? (Points : 5)

       The table is small.
       The table is updated frequently.
       The column's values are static and contain a narrow range of values.
       Two columns are consistently used in the Where clause join condition of SELECT statements.

Question 2.2. (TCO A) You issue this command:
Grant update on employee to Sally with grant option;
Which task could Sally perform on the employee table? (Points : 5)

       View data.
       Delete data.
       Modify constraints.
       Give update access to other users.

Explanation / Answer

2.2

Command :

Grant update on employee to Sally with grant option;

Correct statement :

Sally perform Modify constraints on the employee table.

Reason :

Grant update means giving the permission to perform the update or modify constraints of database.

Option 3 is correct choice.

4.4

1.UPPER(last_name) in ('BROWN','CHAN','LINDSEY') AND

2.UPPER(job) IN ('MANAGER','TECHNICIAN','CLERK') AND

3.salary > 30,000

Those who meet all three requirements is correct choice.

5.5

Question :

You are proposing to management that all employees receive a 10% salary increase and receive a commission that is 20% of this newly increased salary.

commission = sal * 1.1 * .2

Total Compensation = salary + commission

Total Compensation = sal * 1.1 + sal * 1.1 * .2

Correct Query :

SELECT sal * 1.1 "Salary", sal * 1.1 * .2 "Commission", sal * 1.1 + sal * 1.1 * .2 "Compensation"
FROM emp;

It is correct.

Option 1 is correct choice.

11.11

Option 4 is correct choice.

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.