Troy Technologies USA Study Guide: Introduction to Oracle

Read or Download Troy Technologies USA Study Guide: Introduction to Oracle SQL and PLSQL PDF

Best databases books

Teradata RDBMS SQL/Data Dictionary Quick Reference

This e-book is a short reference for the SQL dialect supported by way of the Teradata Relational Database administration procedure. The booklet is additionally a short connection with the supported info description words for the Teradata RDBMS and the information Dictionary. The viewers for this fast reference is all clients of Teradata SQL who desire quickly, non-detailed information regarding easy methods to constitution a SQL assertion.

Access Forms & Reports For Dummies

Create queries that make types and experiences beneficial strengthen kinds to entry the information you wish and make studies that make experience! for those who suggestion you needed to use a spreadsheet application to supply reviews and varieties, wager what! entry can end up great-looking varieties and studies that really express what is going on together with your information -- in the event you know the way to invite it well.

Additional info for Troy Technologies USA Study Guide: Introduction to Oracle SQL and PLSQL

Example text

Which alter command would you use to reinstate a disabled primary re constraint? A: ALTER TABLE CARS ENABLE CONSTRAINT cars_id_pk. 116. You need to perform a major update on the employee table. You have decided to disable the primary key constraint on the empid column and the check constraint on the job column. What happens when you try to enable the constraint after the update is completed? A: All the existing columns values are verified to conform with the constraints and an error message is generated if any existing values do not conformed.

Com BEGIN UPDATE employee SET bonus=bonus+v_bonus WHERE dept_id IN (10,20,30); COMMIT; END; What will be the result? A: A subset of employees will be given a $300 increase in bonus. 114. You have been granted update privileges on the last_name column of the employee table. Which data dictionary view would you query to display the column. The privilege was granted on the schema that owns the employee table? A: ALL_COL_PRIVS_RECD 115. Which alter command would you use to reinstate a disabled primary re constraint?

A: An error is generated. 104. You need to retrieve the employee names and salaries from emp tables assorted by the salary in descending order. If two names match for a salary then two names must be displayed in alphabetical order. Which statement produces the required results? A: SELECT ename,sal FROM emp ORDER BY sal,DESC,ename; 105. Examine the structure of the department and employee table. com DEPARTMENT id PK Name EMPLOYEE id PK Last_ name First_name Dept_id Evaluate this SQL statement: CREATE INDEX ON emp_dept_id_idx employee(dept_id); Which result will this statement provide?

Download PDF sample

Rated 4.46 of 5 – based on 32 votes