WordPress.com



Half Yearly examination (2018-19)Informatics PracticesTime : 3 hr Class – XI Max.Marks:70General Instructions :This question paper has 3 sections A, B and CAll the question are compulsoryMarks carried by each question are mentioned against each.SECTION A : Computer HardwareWhich one is not antivirus software? 1AVGMcAffeeCreeperWrite the full forms for the following: 3OCRALUMUWhat are input devices? Give examples2Give examples of any two secondary storage devices.1Differentiate between RAM and ROM: 2Out of the following devices, classify them as input & output devices. 1Barcode Reader PlotterSECTION B :MYSQLExpand the following: 2DDLRDBMS Differentiate between primary key and alternate key with suitable examples.2Explain the purpose of DISTINCT keyword. 1Write the output for the following statements. 10Select Round(3452.654,2);Select Truncate(6734.23,0);Select pow(20,2); Select upper(“computer”); Select right(“Database”,4);Select INSTR(‘computer’,’put’);Select left(‘Object Oriented’,3);Select concat(‘DAV‘, ‘United’);Select DayofMonth(‘2015-06-08’);Select substring(“morning”, 3); 11. Answer the following questions based on SQL briefly:a) What is the difference between the following?2Curdate( ) and Sysdate( ).LTrim() and RTrim()b) Shipra created a table Sports in MySQL.Table : SportsS_IdNameSW01NULLSB02FootBallSB03HockeySW04SwimmingWhat will be the output of the following queries: 2SELECT Name FROM Sports WHERE Name like ‘_o%’;SELECT * FROM Sports WHERE Name IS NULL;Consider the following table: 1Table :TV_ShowShowIdNameTRPT001Comedy Nights10S001Online Shopping7Siddhant wants to change the Name of the TV_Show “Comedy Nights” with “Comedy Nights with Kapil”. He is confused which command to use.Help him in finding the correct command from the given set of commands:i) Update table TV_ShowShowId = “T001” where Name = “Comedy Nights with Kapil”;ii) Update TV_Show set Name = “Comedy Nights with Kapil” where Name = “Comedy Nights”;iii) Alter table TV_Show set Name = “Comedy Nights with Kapil” where Name = “Comedy Nights”;iv) Alter table TV_Show Name = “Comedy Nights with Kapil” where TRP = 10;Consider the following table and write the queries for the following statements:10Table : ItemItemIDItem_NameUnit_RateQtyCategoryDatePurchased101T-Shirts350.005Clothing2016-07-02102Face cream150.001Cosmetics2016-07-03103Cup-saucer set175.002Crockery 2016-07-03104Soup Bowl set345.001Crockery2016-07-04105Talcum powder100.002Cosmetics2016-07-04106Trousers400.002Clothing2016-07-05107Shirts525.003Clothing2016-07-07108Dinner Set4500.001Crockery2016-07-07Display name and category of all the items.Display details of all items having quantity greater than 2.Display itemname and category of all items in descending order of their unit rate.To display details of all items starting with “T”Display name of the items in ascending order.Delete the items of cosmetic category.Change the unit rate of trousers from 400 to 600.Displaythe names of item having “ou” in the middle.Add a new row in the tableDelete the date purchased column from the table. Consider the following table and write the queries for the following:10IDMED_NAMEPRICEPHARMACY_NAMEPHARMACY LOCATIONDATE_SUPPLIED101PARACETAMOL15.00RAJ MEDICOSVIVEK VIHAR2017-05-07102AMLODIPINE100.50RAGHAV PHARMACYPITAMPURA2017-03-02103NEBISTAR70.77RAM MEDICOSMALVIYA NAGAR2017-03-01104ZINTAC50.65MY CHEMISTRAJOURI GARDEN2017-05-04Display ID along with first 3 characters of medicine name.Display pharmacy name concatenated with pharmacy location of all the medicines. Display day name of the week on which zintac was supplied.Display names and prices of the medicine rounded to the nearest rupee.Display ID along with month(in number) when the medicines were supplied.Display medicine name and pharmacy name along with the year in which it was supplied.Display the length of addressalong with medicine name.Display all the medicine names in lower case.Display the current date.Display the medicine name in lowercase and pharmacy location in uppercase.SECTION C : JAVA NET BEANS Design a GUI application that inputs length and breadth of a rectangle and displays the area. 5Design a GUI application to add two numbers on a click of a button.5Accept two numbers from users using labels and text field.Display the result in another text field.Consider the following form and write the code for the buttons as directed :5When we click on the Football button it displays a message in message box When we click on the Basketball button it displays a message in message box Write the program to create a personalized Diwali greeting card to wish HAPPY DIWALI on a click of a button.5Accept the name from user.The personalized message”Happy Diwali Sahil” is displayed by clicking the button “Wishes for DIWALI” taking input from textfield. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download