Please confirm this assignment if you're amiable in SQL!
On replys which embody SQL embody your SQL and 5-10 lines of the output.
1. What is SQL?
2. What are principal, matchless and outlandish key constraints? What is referential uncompounded-mindedness and how does it detail to these constraints?
3. Provide the DDL to compel the PEOPLE_TEST consideration described adown.
Name Null? Type
------------------------------- -------- ----
SSN NOT NULL VARCHAR2(9)
LAST_NAME NOT NULL VARCHAR2(20)
FIRST_NAME NOT NULL VARCHAR2(15)
SALARY NOT NULL NUMBER(9,2)
Create the consideration in your schema.
4. Provide the DML to suggest this postulates into the PEOPLE_TEST consideration.
303785523, BROWN, JOHN, JAY, MALE, GREENFIELD,10-JAN-68,35000
313507927, SMITH, LINDA, SUE, FEMALE, INDIANAPOLIS,24-MAR-85,50000
312667717, EDWARDS, NORMAN, HENRY, MALE, GREENFIELD,20-APR-92,85000
420001690, GARCIA, STEVEN, LEE, MALE, INDIANAPOLIS, 17-AUG-65,55000
313456233, MEANS, LEONARD, ROBERT, MALE, GREENFIELD,17-AUG-85,75000
490552223, OSBORNE, MARGARET,NULL , FEMALE, INDIANAPOLIS,23-MAR-87,150000
5. Chosen primary_name, definite_indicate order from PEOPLE_TEST in sqlplus. Use post order to format your output. Cut and paste the primary 10 lines of the upshot – including your question and the col orders into your reply.
6. What is frustrate? Illustrate the provisions rollback and execute. Does DDL demand a execute? Does DML? Why is executeting future and frequently considerable?
7. Generate a consideration SORTA_RICH_PEOPLE_TEST behind a while the corresponding building as PEOPLE_TEST using CTAS. Populate your new consideration singly behind a while nation who compel past than $65000 in remuneration from PEOPLE_TEST. Run the SQL and then expose the SQL and a chosen * from SORTA_RICH_PEOPLE_TEST in your reply. Cut and paste the upshot – including your question into your reply.
8. You possess stored contrariant SQL orders in an ASCII/text finish on a floppy (A:\MY_COMMANDS.SQL). You are logged into SQLPLUS. Give the order to run this SQL script finish. How would you do this in builder?
9. What is a apprehension? Give two reasons you would generate a apprehension.
10. What is the arrangement catalog or postulates vocabulary? Why do you pains? What are the user_*, all_* and dba_* apprehensions?
11. You lack to recognize the indicates of all the considerations you own. Give the SQL order. Say one of the considerations was PEOPLE_TEST. Now you lack to see the consideration PEOPLE_TEST’s building. Give the SQL order. Now you lack to see all of the consideration PEOPLE_TEST’s postulates. Give the SQL order.
12. You craving to generate a user designated George behind a while a password of thejungle whose omission considerationspace is users and whose transient considerationspace is users. Give the SQL.
13. What is a role? Why do we compel roles? Give the SQL to cede the roles cohere and expedients to George.
14. What class of postulates is stored in char and varchar2 posts? How are the two posts contrariant from each other?
15. How is determination postulates stored in the postulatesbase? What is the omission determination expose format? How can you transmute the omission determination expose format?
16. What is a consideration? What is a considerationspace?
17. Altering a consideration’s building can be difficult. Provide the DDL to vary the PEOPLE_TEST consideration as follows if it can be performed in a uncompounded order or upright illustrate why it can’t be performed in a uncompounded order.
a. Increase LAST_NAME to 30.
b. Decrease MIDDLE_NAME to 12.
c. Place a new post, TITLE, in the consideration positioned behind MIDDLE_NAME. Compel it VARCHAR2(15).
d. Remove the SALARY post.
18. Give the SQL to updetermination PEOPLE_TEST so that remuneration is increased by 15% for everyone born anteriorly Jan 1, 1980. Compel the transmute burning.
19. Give the SQL to updetermination PEOPLE_TEST so that females who compel past than $80000 are deleted from the consideration. Don’t execute, in deed frustrate the transmute. Give me the orders you used.
20. Give the SQL to chosen sex and the sum of remuneration from PEOPLE_TEST for nation from Indianapolis grouped by sex.
21. Give the SQL to chosen sex and the sum of remuneration from PEOPLE_TEST grouped by city and sex but singly if the sum of remuneration for a sex is main than $150,000.
22. Give the SQL to chosen all posts from PEOPLE_TEST if the remuneration is main than 55000 or the sex is virile.
23. Give the SQL to chosen all posts from PEOPLE_TEST if the definite indicate begins behind a while G or O.
24. You lack to recognize what 345 times 98 plus 97 is. How could SQLPLUS judge you? (Give SQL.)
25. Give the SQL to chosen the definite indicate, remuneration, remuneration behind a while a 15% educate and remuneration behind a while a 25% educate from PEOPLE_TEST. Reindicate the definite two output posts to educate_15 and educate_25.