INSERT INTO jobs VALUES JAVADEV Java Developer 7000 8000 Add a 500 pesos

Insert into jobs values javadev java developer 7000

This preview shows page 6 - 9 out of 35 pages.

INSERT INTO jobs VALUES ('JAVA_DEV', 'Java Developer', 7000, 8000) Add a 500 pesos increase in salary of all employees who have rendered services 10 years and above. UPDATE employees SET salary = salary + 500 where TO_CHAR(sysdate,'YYYY') - TO_CHAR(hire_date,'YYYY') >= 10 Which of the following DOES NOT describes the state of the data after the COMMIT command None of the choices Which of the following describes the command below? SELECT * FROM employees WHERE department = 60 FOR UPDATE Locks the rows in the EMPLOYEES table with department id is 60. Which of the following will erase all records in the departments table TRUNCATE TABLE departments SQL command to create a marker in the current transaction. SAVEPOINT Nathaniel had accidentally deleted all the records in the newly updated ORACLE database using the DELETE SQL command. What is the best solution that he can do to restore all the deleted records in the database. Run the ROLLBACK command ---------------------------------------- LA8 Which of the following will grant a query privileges on the STUDENT table GRANT select ON student TO mat You want to cancel the privilege of matt to add records from the employees table. REVOKE insert ON employees FROM mat; This has the highest level of privileges for task such as creating new users, removing users and tables and backing up tables.
Image of page 6
DBA ---------------------------------------- SQ8 TRUE OR FALSE. An owner has all the privileges on the object. True Which of the following provide privilege to update the employees table? GRANT update (salary) ON employees TO mat Which of the following will is the correct command to create a role. CREATE ROLE gen_manager Matt wants to change his password from 1234 to abcd. Which of the following will perform the task? ALTER USER mat IDENTIFIED abcd; The DBA will create a new user name sales. Which of the following SQL command will perform the creation? CREATE sales ACCESS 1234 Which of the following SQL command that the DBA will run to provide Matt to create a table in the Oracle Database. GRANT create table TO mat What privileges that manipulates the content of the database objects. Object Privileges ---------------------------------------- 1st Q Exam Evaluate the following SQL command SELECT employee_id, salary, department_id FROM employees WHERE department_id IN (60,70) The SQL command will display employees with department id 60 or 70. True or False. The AND, OR, NOT are comparison operators. False What is the SQL command to count the number of records in the employees table? SELECT COUNT(*) FROM employees
Image of page 7
What will be the SQL command if every employee will be given a productivity bonus which is equivalent to 3% of the monthly salary? Display the employee id, salary and the productivity bonus. SELECT employee_id, salary, salary * .03 FROM employees Display the employee id, salary, number of years and the hiring date of every employee in the company. SELECT employee_id, salary, hire_date, ROUND((SYSDATE - hire_date) /365,0) FROM employees; You what to generate the average salary of all employees whose job function is FI_ACCOUNT.
Image of page 8
Image of page 9

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture