Page 1 :
. Se, , Write a PL/SQL program to print the series from 1 to 50., , Sol: BEGIN, FORNUMIN 1..50, LOOP, DBMS_OUTPUT.PUT_LINE (NUM | |* ):, END LOOP:, . DBMS_OUTPUT.PUT_LINE ("):, END:, /, WriteaPL/SQL program to print the following series from 1,4,7,10...40., , Sel: DECLARE, I NUMBER (2):, BEGIN, Ess 15, DBMS_OUTPUT.ENABLE, WHILE (1 <= 40), LOOP, DMBS_OUTPUT.PUT (I | |*7):, I:=1+3:, END LOOP:, DBMS OUTPUT.PUT_LINE(C )):, pe, , EXERCISE, Ql. What is PL/SQL ?, Q@2. What are advantages and disadvantages of PL/SQL ?, Q3. What is difference between the SQL and PL/SQL., @4. Explain the PL/SQL blockstructure., Q@5. What is variable? Explain it., Q@6. What do you mean by control structure ? Explain it., Q@7. What do you mean by IF Statement? Explain its types with, example., @8s. What do you mean by loop statements/ Iterative control ?, Q@8. Explain the FOR Loop and While Loop with an example., Q10. What do you mean by Trigger?Write its advantages., Q11. Explain the types of Trigger., Q12. What do you mean by cursor? What are different types of cursor?, Q13. Define the Implicit cursor and Explicit Cursor., 914. Differentiate the Trigger and Cursor., Q15. Explain the following cursor attributes :, 1) %Found 2) %NOTFOUND- 3) %ISOPEN 4) %ROWCOUNT, , —End—, , , , , , (250) Computer Science-XI, , , , , , Scanned with CamScanner
Page 2 :
INTERNET BUSINESS APPLICATIONS, , 7.1 Online Services, , An online service refers to any information and services provided, over the Internet. These services not only allow subscribers to, communicate with each other, but they also provide unlimited access to, information. Online services can range from simple to complex. Online, services may be free or paid.An online service provider may be a local,, international, or global company who specializes in online services or, allows you to connect to online services through their network.An, organization that provides an information service over the Internet. One, aspect of online services is electronic commerce.companies can create an, interface online to allow customers to order products and services at any, time. Schools, Colleges and universities use online services for their, students to cut down on paperwork. Students might be able to register, for classes online.Government agencies also use online services to reach, citizens., , 7.2 Different Online Services, , , , , , , , , , , , , , , , , , , , , , , , , , , , Online Services Examples ., , Communication Email, Instant messaging, Online conferencing,, social networking e.g Facebook, chat, Twitter etc.,., , Real Time Information Train Timetables, news services. traffic reports,, weather, , Commerce Shopping, banking. auctions, , Government Online tax returns, applications for various, governments, Revenue collection, Health services, , Education Online learning, School/college/hpbose websites., Online counseling., , Business Video conferencing, online share trading, , Entertainment Multi user games, radio players, sports, books, , Download services Softwares, upgrades, music, film, , Web storage Google docs, Drop Box, , Online mapping and Google maps, navigation, , route planning oe, , , , , , , , (251) |(Computer Science-XNID, , , , , , , , , , Scanned with CamScanner
Page 3 :
7.3 ADVANTAGES AND DISADVANTAGES OF ONLINE SERVICES, , The advantages of online services are as follows :, , 1. Convenience : You shop whenever you want to Online shops are, never closed. You can use any of the service at whatever time you, desire., , 2. Saves time : Much quicker and less hassle., , 3. Greater choice : A large number of options are available. So you, can choose the best one., , 4. Better prices : You can compare prices between suppliers. Internet, offers bargain prices not available elsewhere., , 5. No travel costs, traffic jams or car parking space needed. No, queuing at checkouts. Weather doesn’t matter., , 6. Convenient delivery., 7. Reduced long-term costs : Businesses do not need to pay for, , expensive shop premises, running costs (bills, insurance) and sales, , staff., 8. Wider customer base : Products can be sold to customers all-over, the country/world and not just in the area where the shop is based., , 9. Added Items : Customers often impulse buy when online and buy, , extra items., 10. Online learning reduces travel time and travel costs for off-campus, , students., 11.Students may have the option to select learning materials that, , meets their level of knowledge and interest., 12. Students can study anywhere they have access to computer and, , Internet connection, 13. Freedom of choice : Freedom of choice is very high in online than, Shoping from a nearby store. In online you can choose the product, , you are looking, from a vast range of products., 14. High satisfaction percentage : Now a days shopping online is very, reliable., , , , , , (252) Computer Science-XII, , , , , , Scanned with CamScanner
Page 4 :
——_™_: ar, , 15. Privacy : There are some products which you don’t want to buy, publicly You can buy any kind of product from online web store, , anonymously to maintain your desired privacy., , 16. Data storage saving : By storing your data online you are reducing, the burden of your hard disk, which means you are eventually, saving disk space., , 17. Online account is simple to open and easy to operate., , 18. It is quite convenient as you can easily pay your bills, can transfer, funds between accounts, etc., , 19. With Internet banking, you can keep an eye on your transactions, and account balance all thetime., , The disadvantages of online Services are as follows :, , 1. Cost : Businesses will normally need to pay out a lot of money to, have their websites professionally designed and developed., , 2. Staff with expertise : The staff required to run the online business, will need to have the expertise to manage the website and keep it, , maintained., , 3. Website downtime : If the website goes down, no one will be able to, purchase anything meaning the company are making no money., , 4. Online Fraud : A lot of online fraud, means there is a risk of losing, money on sales., , 5. Delay : The main disadvantage of online shopping is, you cannot, receive the product immediately., , 6. Inferior product ; You don’t know about the actual quality of the, product. Sometimes the description of the product might be, different than the actual product., , 7. Shipping Charge : Shipping charge and shipping delays are one of, the main disadvantage of Shopping online., , 8. Students may-feel isolated from the instructor and classmates., , 9. Slow Internet connections or older computers may make accessing, , course materials frustrating., , , , , , (253) | (Computer Science-XII), , , , , , Scanned with CamScanner, , , , , , j, |, ki
Page 5 :
7.4 E- Commerce, , Electronic commerce (EC) The process of buying, — selling,, transferring. or exchanging products, services, or information via, computer networks. E-business is a broader definition of EC that, includes not just the buying and selling of goods and services, but also, servicing customers, collaborating with business partners, and, conducting electronic transactions within an organization.E-Commerce or, Electronics Commerce is a methodology of modern business which, addresses the need of business organizations, vendors and customers to, reduce cost and improve the quality of goods and services while, increasing the speed of delivery. E-commerce refers to paperless exchange, of business information using following ways., , e Electronic Data Exchange (EDI), e Electronic Mail (E-mail), , e Electronic Bulletin Boards, , e Electronic Fund Transfer (EFT), , e@ Other Network-based technologies, Features, , , , E-Commerce provides following features, , @ Non-Cash Payment ~ E-Commerce enables use of credit cards, |, debit cards, smart cards, electronic fund transfer via bank’s website, and other modes of electronics payment., , @ 24x7 Service availability ~“ E-commerce automates business of, enterprises and services provided by them to customers are, available anytime, anywhere. Here 24x7 refers to 24 hours of each, seven days of a week., , e Advertising / Marketing “~ E-commerce increases the reach of, advertising of products and services of businesses., , e@ Improved Sales “ Using E-Commerce, orders for the products can, be generated any time. any where without any human intervention., , By this way, dependencies to buy a product reduce at large and, sales increases., , , , , , (254) Computer Science-XII, , , , , , Scanned with CamScanner