bullet CBSE > > Cbse Class Foundation Information Technology Sample Paper

CBSE Class X Foundation of Information Technology Sample Paper

Foundation of Information Technology

Sample Question Paper (Code : 165)

Class X TERM-I (2010-11)

Time: 3hours                                                                                                                                                     M.M.: 80

SECTION A1.            Fill in the blanks:                                                                                                                                                                  [10]1.1         Internet is a network of_______________________ .1.2         Primary key is used to_____________ identify the records in a table.1.3         In a text type data field, we can put maximum____________ characters.1.4         The address or location of the document on the world wide web is called its__________ .1.5    _____________ allows customers to conduct financial transactions on a secure website.1.6         Web pages on a site are linked together through a system of_________________ .1.7    ____________ is the smallest part of a table in which one data item can be kept.1.8    _____________ is a software used to view web pages.1.9    __________________ is a collection of related information.1.10 _________________ is a field when used as a primary key , numbers each recordsequentially.2.            State True and False:                                                                                                                                                        [10]2.1         A Database can have only one table.2.2         Memo data type allows you to store character type values in the table.2.3         TCP helps in converting the digital signal to analog signal and vice versa.2.4         A Primary Key value can be NULL.2.5         Chat Rooms are actual rooms where chat session takes place.2.6         IP address is given to every computer for its unique identification.2.7         If a piece of data is stored in two places in the database, then storage space is wasted and changing the data in one place will not cause data inconsistency.2.8         Downloading of files means transferring files from host computer to the Internet.2.9         The Datasheet view displays the data in a table in a tabular format.2.10      Altavista is used for searching for available Internet connection.Read the following paragraph. Find six network and communication related abbreviations and give their expanded form along with a single line definition of each of them:                            [10]RBI is planning to expand its connectivity with all major banks of India. The plan includes providing TCP connectivity through HTTP for easy access points and seeks help from some ISPs to join hands in this venture. Also, there is a plan to setup IIS and SMTP servers. Some banks will go for ADSL line while others will use Leased line connectivity to access these services. RBI is also taking help of NT professors in this venture.4.      Answer the following Questions:                                                                                                                   [2X8 = 16]4.1.        Sharvan Joshi is a student of Political Science and is a keen researcher of Political issues related to various countries and states. He wants to share his research and his own opinion on these issues on day -to-day basis with everyone one World Wide Web. He is also interested in collecting views of others to enhance his research and knowledge related to his area of interest. He belongs to a middle class family and can’t afford his own website. Also being a non-technical person he can’t create a dynamic website to deal with day-to-day inputs.a.            Suggest an easy way for Shravan to achieve the same.b.            Also name two popularly used free services that can help Shravan in this regard.4.2.        As life gets busier, it becomes difficult for everyone to keep a track with school & college friends, old colleagues, old neighbours and favourite teachers. It is important to keep in touch with all your near and dear ones. At times, people sitting miles away doing similar kind of activity or solving similar kind of problems can help you to achieve goals faster by sharing their experiences. Similarly people belonging to different socio- economic background can change your perspective and can enhance your understanding of various cultures.a.            Suggest the real time tools that are suitable for the above-mentioned activities.b.            What is the generic name used for such tools?4.3.        Laleema Chakradhar wants a broadband connection for accessing her mails and staying informed about the latest happenings in the field of Biotechnology. Can you suggest two Internet Service Providers of India to be approached for the same?4.4.        Identify domain name(s) and URL(s) from the following list:
a.yoga@yoga.com
b.doYogaEveryday.com
c.www.doYogaEveryday.com/old/index.html
d.www.PerformingArts_schools.org/backlink.htm
e.192.168.0.1
f.http://cbse.nic.in
4.5. Anila works in a Multinational Company and needs to work online from home also. She therefore requires fast Internet connection. Which type of Internet connection in your view would be best suited for her. Apart from browsing on the internet she will berequiring uploading/ downloading of files to/from remote sites. Which protocol will help her to perform this activity?4.6.        Differentiate between container and empty elements of HTML.4.7.        Which of the following is not an example of a database?a.            Cross n Knot Gameb.            Employee Payroll Managementc.            Numeric Calculatord.            Customer Management System4.8.        Identify the errors and write the corrected HTML statements:a.            <BODY BACKGROUND=”Red”>b.            <FONT>Do as directed:                                                                                                                                                                        [12]5.1         Pronita is a programmer in an institution and is asked to handle the records containing personal information of the teachers teaching in the institution. Suggest five fieldnames, which you think must be present in the table called Teacherlnfo.                                                                                                                                     [5]5.2         Look at the table called “Item” given below and answer the question.
ItemldItem NameItemStockItemDOPQuantity Purchased
  1. Suggest the data types of all the fields                                                                                        [5]
  2. Which two fields can act as the Primary Key from the above table?                         [1]
Look at the table structures shown below and do as directed:                                                                       [6]6.1    Identify the column (s) out of the given three, which should not be present in each of the following tables:                                                                                                                                       [1x3 = 3]
1.Table 1: Stock
Item No.Date Of BirthItem Quantity
2.Table 2: Book
AdmnoPriceAccssn No
3.Table 4: Student
FNoDesign CatPhone Number
6.2Sanchita is working for a nationalized bank and is in the process of creation a table to store the details of customers of the bank. Find out, which of the following Fields of table Bank can be selected as Primary Key, Candidate Key and Alternate Key.    [3]
SECTION B7       Multiple Choice Questions (Choose most appropriate option)                                                                         [16]7.1         IP stands fora)             Internet Protocolb)             Intranet Protocolc)             Internet Providerd)             Internet Package7.2         Which of these services will not be provided by a typical Internet service provider (ISP)?a)            An email addressb)            Modemc)            A connection to the Internet d.)     Technical help7.3         HTML is aa)             Packageb)             Softwarec)             Languaged)             None of these7.4         An IP address is a string of____________ numbers separated by periodsa)            3b)            4c)            2d)            57.5         Which of the following statements about search engine is true ?a)            Search engines discriminate between good and bad sitesb)            Search engines have fixed hours when we can use themc)            Search engines are waste of time as they do not provide relevant informationd)            Search engine is a program designed to search for information on the web using keywords7.6         Digital information is converted into analog information by the modem ata)             destination computerb)             source computerc)             both source and destination computerd)             neither source nor destination computer7.7         Google Chrome is aa)            Web Browerb)            News Websitec)            Graphing Packaged)            Word Processor7.8         A domain name ending with org. belongs toa)            An educational institutionb)            An organizationc)            A site that is highly organizedd)            A commercial website7.9         What can you do with the Internet?a)            Exchange information with friends and colleaguesb)            Access pictures, sounds, video clips and other media elementsc)            Find diverse perspective on issues from a global audienced)            All of the above7.10      Which of the following sites would you most probably buy books from?a)            www.yahoomail.comb)            www.sun.comc)            www.msn.comd)            www.amazon.com7.11      Which of these is not a part of URL ?a)            IP addressb)            Port Numberc)            Domain Named)            None of these7.12      Out of the following which one is most appropriate data field in context of employee table if only one of these is required?a)            Age in yearsb)            Date of Birthc)            Age in daysd)            Age in months7.13      Which is not true for a database filea)            Each record may contain several fieldsb)            Fields are organized in columnsc)            Data types have to be declared in advanced)            Each field may contain several records7.14      What datatype should you choose for a zip code field in a table?a)            Textb)            Numberc)            Memod)            All of above7.15      Which of the following fields would not make a suitable primary keya)            A customers account numberb)            A date fieldc)            An AutoNumber fieldd)            A students admission number7.16      What is the purpose of the description column in Table Design View?a)            To describe the data that should be entered in each fieldb)            To define the data type applied to each field within the tablec)            To enter lookup data that the field should refer to.d)            None of the above

Answers:

SECTION A1             Fill in the blanks:1.1         Networks1.2         Uniquely1.3         2551.4         URL1.5         e-banking1.6         Hyperlinks1.7         field1.8         Web Browsers1.9         Database1.10      AutoN umber2             State True and False:2.1         False2.2         True2.3         False2.4         False2.5         False2.6         True2.7         False2.8         False2.9         True2.10       False(1 Mark for correctly mentioning whether each statement is true or false)The six network related abbreviations are:10
  1. TCP (Transmission Control Protocol): a protocol developed for the internet to get data from one network device to another
  2. HTTP (Hypertext Transfer Protocol): a protocol (utilizing TCP) to transfer hypertext requests and information between servers and browsers
  3. ISP (Internet Service Provider): also sometimes referred to as an Internet access provider (SAP), is an organization that provides access to the Internet through various connectivity mechanisms (dial modem, cable services, etc.)
  4. IIS (Internet Information Server): IIS is Microsofta€™s proprietary web server software, and is included with their Windows NT-based operating systems. It is free, and is required for the use of ASP code in a website. It also provides FTP functionality, and an easy-to-use management console for administrators.
  5. SMTP (Simple Mail Transfer Protocol): is an Internet standard for electronic mail (e-mail) transmission across Internet Protocol (IP) networks.
  6. ADSL (Asymmetric Digital Subscribers Line): is one form of the Digital Subscriber Line technology, a data communications technology that enables faster data transmission over copper telephone lines than a conventional voiceband modem can provide.
(1 Mark for each of the six correct expanded forms) + (1 Mark for each of the six correct definitions)4.1         a. Shravan should develop a blog.                                                                                              2X8 = 16 (1 Mark for naming the correct tool)b.      Twitter and Google Blogger(V2 Mark each for correctly naming any two free services)4.2         a.      Facebook and Twitter(1 Mark for correctly naming any two tools)b.      Social Networking(1 Mark for the correct generic name)4.3.        VSNL.Airtel(1 Mark each for correctly naming any two ISPs)4.4.        b and fare domain names C and d are URLs(1 Mark for correctly identifying the two domains) + (1 Mark for correctly identifying the two URLs)4.5.        For faster Internet connection, the Broad Band or Cable connections are preferred. So Anila should go for either the Cable Connection or for ADSL connection.The FTP will help her in uploading and downloading of files.(1 Mark for correctly naming anyone connection type) + (1 Mark for correctly naming the protocol)4.6.        Container elements are those which require both opening and closing tag like <HTML> <BODY> and <FONT> whereas the empty elements are those that do not require a closing tag like <HR> and <BR>.(2 Marks for any one correct differentiation point between the two types of elements)4.7.        Numeric Calculator(2 Marks for the correct identification)4.8.        a.      <BODY BGCOLOR = “Red”>(1 Mark for writing the correct HTML statement)b.      <FONT FACE= “Arial”>(1 Mark for writing the correct HTML statement)125.1         Table Name: Teacherlnfo                                                                                                                                      5 Column Names:TNo TName DOB Address B Salary(1 Mark each for naming any five valid fieldnames)5.2         1.
Itmeld                   :Text
Item Name              :Text
Item Stock               :Number
Item DOP                :Date
Quantity PurchasedNumber
(1 Mark each for naming the correct data types of each of the five fields)2..      Itemld and ItemName can act as the primary key. (1 Mark each for naming the two correct fields)Look at the table structures shown below and do as directed: 6.1     a.      Table 1 : Items                                                                                                                                 1×3 = 3Ans   Date of Birthb.            Table 2 : Library Ans   Admnoc.             Table 3 : Firmotire Ans   Phone Number(1 Mark each for correctly naming the column in each of the three tabels6. 2    Primary Key : AccountNo                                                                                                                                        3Candidate Key : AccountNo and PANNumberAlternate Key: PANNumber (1 Mark each for correctly naming the primary key, candidate key and alternate key)SECTION BMultiple Choice Questions (Choose most appropriate option)                                                           167.1         a)      Internet Protocol7.2         a)      An email address7.3         c)      Language7.4         b)      47.5         d)      Search engine is a program designed to search for information on the webusing keywords7.6         b)      Source Computer7.7         a)      Web Browser7.8         b)      An organizatoin7.9         d)      All of the above7.10      d)      www.amazon.com7.11      b)      IP address7.12      b)      Dateof Birth7.13      c)      Each field may contain several records7.14      d)      All of above7.15      c)      Adatefield7.16      a)      To describe the data that should be entered in each field (1 Mark for choosing the correct option in each of the MCQ)