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 one requirement.
       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 12.12. (TCO H) Examine the table instance chart for the MANUFACTURER table. Which command would you use to create an index for the manufacturer_name column? (Points : 5)

       CREATE INDEX manufacturer(manufacturer_name);
       CREATE INDEX manufacturer_manufacturer_name_idx ON Manufacturer;
       CREATE INDEX manufacturer(manufacturer_name) manufacturer_manufacturer_name_idx;
       CREATE INDEX manufacturer_manufacturer_name_idx ON manufacturer(manufacturer_name);

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

12.Examine the table instance chart for the MANUFACTURER table. Which command would you use to create an index for the manufacturer_name column ?

       CREATE INDEX manufacturer(manufacturer_name);
       CREATE INDEX manufacturer_manufacturer_name_idx ON Manufacturer;
       CREATE INDEX manufacturer(manufacturer_name) manufacturer_manufacturer_name_idx;
       CREATE INDEX manufacturer_manufacturer_name_idx ON manufacturer(manufacturer_name);

Answer :-

CREATE INDEX manufacturer_manufacturer_name_idx ON manufacturer(manufacturer_name);

Explanation :-

Syntax :-

CREATE INDEX INDEX_NAME ON TABLE_NAME (COLUMN_NAME) ;

12.Examine the table instance chart for the MANUFACTURER table. Which command would you use to create an index for the manufacturer_name column ?

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

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