(AKS 11) │-4+2│ ____ 5. Find the sum 46 + (–15). (AKS 8) ____ 6. Evaluate for -18 and -27. (AKS 8) ____ 7.
What is the result of adding 2.5 [pic] 10[pic] and 3.5 [pic] 10[pic]? |a. |2.9 [pic] 10[pic] |c. |2.9 [pic] 10[pic] | |b. |6.0 [pic] 10[pic] |d.
(Points : 7) Question 5. 5. (TCO 3) What is standard deviation? (Points : 7) Question 6. 6.
Based upon your skills developed and practice of SQL develop 5 challenging scripts, execute, capture output and post the following into the conference: a. SQL Script b. Output c. Explain what the script does. Note: There will be extensive coverage for SQL for the final exam. This exercise is intended to prepare you for the final exam, hence your script should be able to demonstrate your understanding of reading material illustrated in Oracle SQL by Example book in addition to readings from the text book. Avoid writing simple SQL, focus on complex joins, sub queries and nested joins.
Each table consists of columns and rows. The database engine is responsible for building or structuring the data in the database. It is also responsible for storing and retrieving data. It can accept SQL requests from application programs written by users, known as the DBMS (Database Management System) components. The components of a typical DBMS consist of forms facility, report writer, interactive query tool, application program and database front-end.