السلام عليكم انا عايز امتحانات اوريكال الخاصه ب sql @pl/sql ياريت الي عندو اي امتحانات اويعرف حاجه يدلنا لله تعالي والسلام عليكم

وعليكم السلام اخي هذه مجموعه من الاسئله في شكل دروس ارجو ان تفيدك

lesson one

Q: What is PL/SQL

Q: Where can you store a PL/SQL procedure

Q: What is the PL/SQL body section

Q: What is the PL/SQL declaration section

Q: What does the SET SERVEROUTPUT command

Q: What does the DBMS_OUTPUT.PUT_LINE procedure

Q: How do you define a variable or variables in the PL/SQL declaration section

Q: How do you save a PL/SQL block in the client environment

Q: How do you use the %TYPE keyword

Q: How do you open a saved PL/SQL block

Q: How do you run a saved PL/SQL block

Q: What does the %ROWTYPE keyword in the PL/SQL language

Q: What is an implicit cursor in the PL/SQL language

Q: An implicit cursor must have _________ on its SELECT SQL statement

Q: What does the SQL%NOTFOUND reserved PL/SQL word

Q: What does the “SET SERVEROUTPUT ON”

Q: Write a PL/SQL block , to output the "Hello iSelfSchooling" message

Q: Use the %TYPE keyword, to declare a variable as the same datatype and size of the department name column of the dept table.

Q: Use the implicit cursor to query the department table information where deptno is 30. Check, if no record was found then print “Record was not found.” Else print the department name only.

lesson tow

Q: Describe that why do we need to use a solid naming convention in our PL/SQL program

Q: What is the explicit cursor in the PL/SQL language

Q: What are the differences between the explicit and implicit cursors

Q: Where do you declare an explicit cursor in the PL/SQL language

Q: Where do you declare an implicit cursor in the PL/SQL language

Q: What is a simple loop in the PL/SQL language

Q: How do you open an explicit cursor in the PL/SQL language

Q: What does the FETCH statement in the Oracle PL/SQL language

Q: How do you terminate from a simple loop in the PL/SQL language

Q: How do you OPEN or CLOSE a cursor in the PL/SQL language

Q: Declare a cursor to list the department name (dname), total number of employees (ttemp), total salary (ttsal), and average salary (avsal) for each department from the department table and employee table order by the department name.

Write all department names with their total number of employees for each department using the notepad editor.

lesson 3

Q: What does the FOR LOOP statement in the PL/SQL language

Q: What are the differences between a SIMPLE LOOP and FOR LOOP

Q: What are the advantages of using the FOR LOOP statement

Q: What does the SHOW ERRORS statement in the PL/SQL language

Q: What is the IF-THEN-ELSE statement

Q: Modify the previous PL/SQL block and use the “FOR LOOP ” statement vs the simple “LOOP” statement. Also, list only the department name that their total number of employees is more than 4

واذا احتجت الى المزيد فلا باس

والله المستعان .

تم تعديل 17 نوفمبر 201114 سنة بواسطة shrara

lesson 3

Q: What does the FOR LOOP statement in the PL/SQL language

Q: What are the differences between a SIMPLE LOOP and FOR LOOP

Q: What are the advantages of using the FOR LOOP statement

Q: What does the SHOW ERRORS statement in the PL/SQL language

Q: What is the IF-THEN-ELSE statement

Q: Modify the previous PL/SQL block and use the “FOR LOOP ” statement vs the simple “LOOP” statement. Also, list only the department name that their total number of employees is more than 4

واذا احتجت الى المزيد فلا باس

والله المستعان .

السلام عليكم شكرا اولا علي مجهود حضرتك ولاكن انا كنت عاوز الاسئله والاجوبه عشان انفذ عملي لاني مبتدا والسلام عليكم ورحمة الله وبركاته

وعليكم السلام اخي ان شاء الله في القريب العاجل سوف اقوم بكتابه الاجوبه لكل الدروس
حسب ظروف عملي الان
والله الموفق.........