WordPress.com



HALF YEARLY EXAM (2017-18)Informatics Practices (SET-A)Class XITime Allowed: 3 hours _____M.Marks:70All questions are compulsory1.a)Differentiate between the following: 2 i) ASCII and UNICODEii)Address Bus and Control Busb). From the following statements identify the Input/Output devices: 2i) It is used to convert images of text into machine editable text.ii)It is used to input audio data into the computer and mainly used for sound recording. c). Which of the following is a security measure? 1 i)Scan your computer regularly with antivirus software.ii)Sharing your pen drive iii)Download any email attachment from an unknown sender. d). Write full forms of the following: 1 i) IDE ii) GUIe).Which one is not antivirus software? 1i)AVGii)McAffeeiii)Creeper2.a)i.What is RDBMS?Explain .2ii)Name the command used to display table structure.1b)What is the difference between Tuple and Attribute of a table? 2c ).What is the difference between the following:2i. Curdate( ) and Sysdate( )ii.LTrim() and RTrim()?b)A student created a table Sports in MySQL.Table : SportsS_IdNameSW01NULLSB02FootBallSB03HockeySW04SwimmingWhat will be the output of the following queries: 2i. SELECT Name FROM Sports WHERE Name like ‘_o%’;ii. SELECT * FROM Sports WHERE Name IS NULL;c. Consider the following table:1Table : TV_ShowShowIdNameTRPT001Comedy Nights10S001Online Shopping7Raman 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_Show ShowId = “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;d. Raman wants to view records of TV_Show having TRP as 10. He has written the following command which is giving error(s). Help him re-write the correct query:1 Select * from TV_Show Where TRP is 10;3. a).Answer the following questions based on MySQL:i. Create a table ‘Library’ with the following structure:2Field NameData TypeSizeAccnoIntegerTitleVarchar20AuthorVarchar20PriceDecimal7,2ii. Write the MySQL command to add a field No_of_copies of data type integer.1iii.Write the MySQL command to physically remove the table ‘Library’.1b).Consider the table “E_Shop” with the following data and give command in MySQL 4Table: E_Shop i. To display records of all electronic items offered by ‘Samsung’. ii. To display records of items within price range 15000 to 25000. iii. To insert the following record into the table-(E13,Microwave,LG,19000.00,1200.00,3) iv. To display the different items available in E-Shop.c).Choose the correct output for the following query:-1select Upper(mid( ‘Information Technology’, -5,2) );a. OLb. rmc. old. RMd. Write command to extract month from date – ‘2010-09-29’.14. a).Consider the table Emp having four columns(Eno,Ename,Desig,Salary)1Mr. Sahil wants to enter values for columns Eno,Ename. He wrote a command Insert into Emp values(101, ‘rohit’);Help him to run the Query by removing the error and write the correct statement. b).Write the output of the following MySQL statements 15(i) Select Round(43.567,2);(ii) Select left(‘Object Oriented’,3);(iii) Select concat(‘DAV‘, ‘United’);(iv) Select DayofMonth(‘2015-06-08’);(v) select substring(“Informatics”, 2,6);(vi) select substring(“welcome”, 2);(vii)select substring(“morning”, -3);(viii)select trunc(450.568, -2);(ix) select round(589.365, -1);(x)select pow(4,2);(xi) select dayofmonth(“1997/05/30”);(xii) select dayname(curdate());(xiii) select year(curdate());(xiv) select right(substring(“Independence Day”, 3,6), 2);(xv) select pow(instr(“Happiness”, “pin”), 2);c).Write SQL commands for the following statements. 10 Table : StudentAdmnoDOASnamemarksStream1012009-04-01Amit408Non Medical1022008-04-02Suhani360Commerce1032010-04-01Rahul401Medical1042010-04-02Sunny410Medical1052008-04-02Tanvi379Commerce(i) To display the name of student in uppercase whose admno is 104.(ii) To display the position of character ‘d’ in column stream.(iii) To display last three characters of the column sname where stream is Medical or Non Medical. (iv) To display the year of admission of medical students.(v) To increase the marks by 10% of commerce stream students.(vi) To display the first two letter of name of those students whose DOA has year as 2010.(vii) To add a new column activity of type char(20).(viii) To delete all the records of the students scoring less than 300.(ix) To display the report of students in the following form:e.g.Amit is a student of Non Medical stream(x) To delete the column DOA.d). Identify DML commands from the following.2INSERT, SELECT,ALTER,DROPe) What is the difference between sysdate() and now(). 2f) Name a string function in SQL that returns a number 1HALF YEARLY EXAM (2017-18)Informatics Practices (SET-B)Class XITime Allowed: 3 hours _____M.Marks:70All questions are compulsorya.i)Name the application software for each of the following:2It is used to keep the record of stock of the physical resources. A software used to calculate salary and generate pay ?cheques for employees.ii)Give two objectives for using Trojan by a hacker. 2b. Identify the communication port: 2i) It is in the form of 25 pin female connector used to connect printer or scanner.ii) It is used for ethernet connections. ?It is an 8 wire connection.c. Which is not a System Software? 1??????i) BIOS?????ii) Device Driver????iii) Language Processor?????iv) MySQL d. What are the characteristics of a strong password? 2e. Expand the term ISCII. 12.a)i.What is SQL? .2ii)Name the command used to display the contents of a table in alphabetical order.1b)What is the difference between Alter Table and Update command of SQL? 2c ).What is the difference between the following: 2i. trunc( ) and round( )ii.Lcase() and ucase()?b)A student created a table Sports in MySQL.Table : SportsS_IdNameSW01NULLSB02FootBallSB03HockeySW04SwimmingWhat will be the output of the following queries:4i. SELECT Name FROM Sports WHERE Name like ‘_w%’;ii. SELECT * FROM Sports WHERE Name IS NOTNULL;c. Consider the following table:1Table : TV_ShowShowIdNameTRPT001Comedy NightsWith Kapil10S001Online Shopping7Raman wants to change the increase the TRP of theTV_Show “Comedy Nights With Kapil” by 4%. He is confused which command to use.Help him in finding the correct command from the given set of commands:i) Update table TV_Show ShowId = “T001” where Name = “Comedy Nights with Kapil”;ii) Update TV_Show set TRP =”4%” where “Comedy Nights with Kapil” ;iii) Update table TV_Show set TRP = TRP + 0.04*TRP where name= “Comedy Nights with Kapil”;iv) Update TV_Show set TRP = TRP + 0.04*TRP where name= “Comedy Nights with Kapil”;d. Raman wants to view name of TV_Show having TRP more than 6. He has written the following command which is giving error(s). Help him re-write the correct query:1 Select * from TV_Show Where TRP > 6;3. Answer the following :a)Create a table ‘Hotel’ with the following structure: ? 2???????????????????Field NameData TypeSizeRoomnoIntegerRoomtypeVarchar10 ???CheckindateDateCheckoutdateDateRentDecimal(7,2)i. Write the MySQL command to add a field ‘No_of_days’ of data type integer . 2ii.Write the MySQL command to modify the data type of field ‘Rent’ to integer . 2b Consider the table “Stream” with the following data and give command in MySQL. 4????????????Table: Streami. ?To display all the records in descending order of strength.ii. To display stream names with optional as ??‘Mathematics’.iii. To change the strength of SIdS07 to 55.iv. ?To display the different names of stream in the above table.c). Choose the correct option as output for the following query:- 1select length( “-10.68”) ;???a. ?????6 ???b. ?????7???c. ?????5 ???d. ?? -10.7d). Give the command to join two strings “Sample” and “Paper”. 1e)Consider the table voter and write the output of the following queries:4Table : VoterVnoVnameAgeAddressGender201Sidhi22RohiniM202Rajiv35VikasPuriM203Anupama34JanakPuriF204Sumit65RohiniM205Anandi25Dev NagarF(i) ?select ?ASCII (gender) from voter where ?age IN(22,34); (ii) select mid(vname,2,2) from voter where age >34;(iii) Select concat(vname, address) from voterwhere gender = ‘F’;(iv) select left(address,5) from voter where vname like’%i’;4. a). Identify the pair of SQL statements which give the same output.1(i)Select ?* from ?shop ?where ?pcost ?IN( ?1000 , 2000);(ii)Select ?* from ?shop ?where ?pcost>1000 ??and pcost< 2000;(iii)Select ?* from ?shop ?where ?pcost =1000 ?OR pcost = 2000;b).Write the output of the following MySQL statements 15(i) Select Round(94.262,2);(ii) Select left(‘Oriental town’,4);(iii) Select concat(‘DAV‘, ‘United’);(iv) Select Instr(‘Database Management’,’bat’);(v) select substring(“Sustainable”, 2,6);(vi) select substring(“Goals are”, 2);(vii)select substring(“Development”, -3);(viii)select trunc(452.568, -2);(ix) select round(578.365, -1);(x)select pow(2,4);(xi) select dayofmonth(“1997/05/30”);(xii) select dayname(curdate());(xiii) select year(curdate());(xiv) select right(substring(“Diwali Celebration”, 3,6), 2);(xv) select pow(instr(“Mountains”, “nt”), 2);c).Write SQL commands for the following statements. 10 Table : StudentAdmnoDOASnamemarksStream1012009-04-01Amit408Non Medical1022008-04-02Suhani360Commerce1032010-04-01Rahul401Medical1042010-04-02Sunny410Medical1052008-04-02Tanvi379Commerce(i) To display the name of student in lowercase whose admno is 104.(ii) To display the position of character ‘a’ in column stream.(iii) To display first fourcharacters of the column sname where stream is Medical or Non Medical. (iv) To display the year of admission of commerce students.(v) To increase the marks by 20% of Non Medical stream students.(vi) To display the first two letters of name of those students whose DOA has year as 2009.(vii) To add a new column activity of type char(20).(viii) To delete all the records of the students scoring less than 300.(ix) To display the report of students in the following form:e.g.Amit has scored 408 marks(x) To delete the column DOA.d). Identify DML commands from the following.2INSERT, SELECT,ALTER,DROPe) What is the difference between DDL and DML commands of SQL. 2f) Name a date function in SQL that returns a number 1 ................
................

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

Google Online Preview   Download