Course on Computer Concepts (CCC) Model Paper with Answer 2013

 

       Course on Computer Concepts (CCC)  TEST PAPERS

1 A client program used to access the Internet services and       resources available through the World Wide Web.

(A)ISP (B)Web Browsers(C) Web Servers (D)None of the above

2"When a computer prints a report, this output is called_____."

hard copy soft copy COM None of the above

3"=ROUND(2.15,1) entered in a cell displays"

 (A)2 (B)2.1 (C)2.2 (D)None of the above

4"=MOD(-3,2) entered in a cell displays"

(A) -1 (B)1(C) -1.5(D) 0

5"To change the size of the chart without changing its proportion, then you have to press _____ as you drag a corner handle"

(B) [Shift] (B) [Alt] (C) [Ctrl] (D) [F11]

6The default page orientation in Excel is

(A)Landscape (B)Horizontal(C) Portrait(D) None of the above

7"In Excel, if you click on the Gridlines and Draft Quality check box on the sheet tab property sheet of page setup dialog box then"

(A)gridlines will be print

(B)gridlines will not be printed

(C)sometimes print

(D) None of the above

8 To create a new blank presentation you could _____.

(A)click on the New button

(B)use the File New command

(C)Both of the above

(D)None of the above

9In which menu Change Case command appears

(A) Insert (B)Slide show (C)Format (D)Edit

10How do you make an inserted sound file play continuously over several slides? (A)"In the Custom Animation task pane, open Effects Options and  set the sound to play for the desired number of slides"

(B)"Using the Record Sound feature, press the Record button and  play your music as you click through the whole slide show"

(C)"Using the Play CD Audio Track feature, set the CD to play  for the desired number of tracks"

(D)All of the above

11 The area on a slide that holds text that will appear in the presentation outline is a _____.

(A)Textbox(B)Placeholder(C)bullet point(D)title box

12 The purpose of AutoFormat command in Excel is to

(A)create a professional and consistent look for your data

(B)"choose between standard table formats that include borders,   shading, font            colours and other formatting options"

(C)easily apply a consistent format throughout a workbook

(D)All of the above

13 Which of the following statements about search engines and directories is true?

(A)A search engine does not discriminate between good and bad  sites.

(B)A search engine displays all Web pages that contain your  keywords and may  list thousands of unordered results.

(C)A directory is someone s attempt to categorize the best  sites available for     a given subject or topic.

(D)All of the above

14 Which one of the following can be entered as a number in a cell? (A)"1,300.00"(B) (5000.00) (C)1.1e+2 (D)All of the above

15 Which of the following a search engine continuously sends out that start on a homepage of a server and pursue all links stepwise?

(A)spiders (B)packets (C)cookies (D)None of the above

16 "What would you use for immediate, real-time communication with a friend?" (A)Instant Messaging(B) E-Mail (C)Usenet (D)Blog

17 The Internet uses

(A)Circuit switching (B)Packet switching

(C) Hybrid switching (D)None of the above

18 The ascending order of a data hierarchy is :

(A)Bit-byte-record-field-file-database(B) Byte-bit-field-record-file-database(A) (D)Byte-bit-record-file-field-database(C) Bit-byte-field-record-file-database

19 Software instruction intended to satisfy a user s specific processing needs are called _____

(A)System software(B)Microcomputer (C)Documentation (D)Application software

20 "In computer terminology, information means"

(A)raw 

(B)data

(C)data in more useful or intelligible form

(D)alphanumeric data program

21 Which of the following is a part of the Central Processing Unit (A)Keyboard(B)Printer (C)Tape(D) Arithmetic Logic Unit

22 What is meant by computer literacy?

(A)Ability to write computer programs

(B)Knowing what a computer can and cannot do

(C)Knowing computer related vocabulary

(D)Ability to assemble computers

23 The software application that is used the most often is _____.

(A)word processing (B)spreadsheet (C)database (D)graphical presentation

24 A floppy disk contains

(A)Circular tracks only (B)Sectors only

(C)Both circular tracks and sectors

(D)None of the above

25 The first page that you normally view at a Web site is its:

(A)Home page (B)Master page (C)First page (D)Banner page

26 What is the function of the justification buttons on the toolbar?

(A) To display a drop-down list of justification options

(B)To display the four options for aligning text

(C)To open the justification dialog box

(D)To center the current line

27 The binary number system has a base

(A)2 (B)4 (C)8 (D)16

28 The arithmetic/logic unit performs the following actions:

(A)checks data for accuracy

(B)"does calculations using addition, subtraction,  multiplication, and division"

(C)"does logical comparisons, such as equal to, greater than,  less than"

(D) both calculations and logical comparisons

29 CPU reads the information from secondary memory

(A)Directly

(B)"First, information is transferred to main memory and from   there, the CPU reads"

(C)Through registers

(D)None of these

30 A plotter is 

(A)An input device to produce good quality graphics

(B)An output device to produce drawings and graphics

(C)A fast output device using camera lenses

(D)None of these

31 A _____ is a collection of buttons which represent various operations that can be carried out within an application.

(A)Buttons (B)Menu (C)Toolbar (D)None

32 The topmost bar in any application window is the _____. 

(A)It displays the name of the document or application.

(B)Menu bar

(C)Toolbar

(D)Status bar

33 Supercomputers are primarily useful for

(A)Input-output intensive processing

(B)Mathematical intensive scientific applications

(C)Data retrieval operations

(D)None of these

34 E-mail

(A)Cannot address many users

(B)Does not provide protection given to first class mail

(C)Always uses bridge to send messages in different networks

(D)None of these

35 Which of the following is a graphical package?

(A)CorelDRAW (B)MS-Excel (C)MS-Word (D)None of these

36 The gigantic work of simulating the airflow around an entire aircraft can only be done by using fast

(A)Microcomputers (A)Minicomputers (A)Supercomputers (A)None of these

37 Which of the rule mentioned below for range names is incorrect

(A)names cannot be the same as a cell reference

(B)in a range name you are allowed to use spaces or commas

(C)range names can be directly used in formulas

(D)the only separators allowed are underscore characters  nd/or periods between words

38 What is the first step in MS-Word in changing line spacing?

(A)To open the Format menu

(B)To click the Line Spacing button

(C)To select the paragraphs you want to change

(D)To open the Paragraph menu

39 "A mouse, trackball, and joystick are examples of _____."

(A)pointing devices

(B)pen input devices

(C)data collection devices

(D)multimedia devices

40 The Save As... dialog box can be used

(A)for saving the file for the first time to save 

(B)file by some alternative name

(C)to save file in a format other than Word

(D)All of the above

41 The contents of the Clipboard remain the same until

(A)you cut other text

(B)you shut down your computer

(C)you copy other text

(D)All of the above

42 You will probably use Borders in Word where

(A)you wish to add emphasis to particular paragraphs

(B)you wish to draw lines above and below or to left and right of paragraphs

(C)you wish to surround the paragraphs with different styles  of boxes

(D)All of the above

43 The Formatting Toolbar option are applied

(A)to paragraph selection only

(B)to character selection only

(C)to both character as well as paragraph selections

(D)None of the above

44 A page break is used to do what?

(A)Create a new page at the insertion point

(B)Create a new page at the bottom of the document

(C)Create a new page that cannot be deleted

(D)Create a blank page at the top of the document

45 "In which Word menu, Letter wizard command appears"

(A)Format (B)Tools (C)Insert (D)Table

46 "In Word, split cells command appears in _____ menu."

(A)Table (B)Format (C)Insert (D)Tools

47 Status bar shows different types of keys:

(A)Num lock key (B)Scroll lock key  (C)Caps lock key  (D)All of these

48 In Excel the intersection of a row and column is called

(A)square (B)cubicle (C)cell (D)worksheet

49 "In Excel, once a range has been named, you can go to a range"

(A)by selecting ranges using the name box

(B)by selecting ranges using the [F5] key

(C)both a and b

(D)None of the above

50 One of the statements is not true:

(A)"In its default settings, a word processor does not  hyphenate the text"

(B)Hyphenating helps when you are dealing with thin columnar  text

(C)"By hyphenating, the looks of the justified thin columns  will look greatly      improved"

(D)Microsoft Word hyphenates text in its default settings.

51Animation effects appears in the Standard toolbar.

(A)True (B)False

52 BIOS stands for Basic Integrated Operating System

(A)True (B)False

53 LENGTH() function is used to find the length of the string.

(A)True (B)False

54 The floating text (text not associated with objects in the chart) cannot be moved in the chart area.

(A)True (B)False

55 "Just as you can preview a worksheet before printing, it is not possible to preview a chart."

(A)True (B)False

56 "To insert a header or footer in a worksheet, select Header and Footer option in the File menu."

(A)True (B)False

57 You can add items to the Start menu of windows

(A)True (B)False

58 You can swap over the functionality of the left and right mouse buttons

(A)True (B)False

59 The AutoContent Wizard creates the structure and contents based on the choices you make.

(A)True (B)False

60 PowerPoint has more than twenty four slide layouts.

(A)True (B)False

61 Bullets and numbering appears in the standard toolbar.

(A)True (B)False

62 The Cell/range names are case sensitive.

(A)True (B)False

63 You can apply a color scheme to the current slide or to all slides in your presentation.

(A)True (B)False

64 99 sales is a valid name for a cell or a range.

(A)True (B)False

65 PowerPoint allows you to differentiate your own animation effects.

(A)True (B)False

66 Internet is not a commercial information service.

(A)True (B)False

67 The network NSFnet was later renamed as Internet.

(A)True (B)False

68 The IP address space is divided into classes five in all which are given letters A through E

(A)True (B)False

69 The Request for Comments (RFCs) core topics are Internet and the TCP/IP protocol suites.

(A)True (B)False

70 The Back and Forward buttons can be used to visit only pages from the same website

(A)True (B)False

71 A protocol used for fetching e-mail from a mailbox is POP1

(A)True (B)False

72 All conversations on the IRC are in English

(A)True (B)False

73 The full form of ISP is Information Source Provider

(A)True (B)False

74 "A smiley, is a sequence of ordinary printable characters, or a small image, intended to represent a human facial expression and convey an emotion."

(A)True (B)False

75 You can stop using the spelling checker at any time by clicking the close button.

(A)True (B)False

76 The View menu in Word is used to create header and footer.

(A)True (B)False

77 Check boxes are used to present options requiring individual on/off decisions in Message boxes.

(A)True (B)False

78 Firmware is software that is embedded in a hardware device

(A)True (B)False

79 Primary memory has higher storage capacity than secondary memory.

(A)True (B)False

80 Pressing F1 is a common way to invoke help in Windows?

(A)True (B)False

81 "To select an entire document in Word, move the pointer to the left of any document text until it changes to a right-pointing arrow, and then double-click."

(A)True (B)False

82 [Ctrl]+[U] selects the italics style for the selected text.

(A)True (B)False

83 A blank line is also called as a paragraph. It is called as an empty paragraph.

(A)True (B)False

84 [Del] key deletes the text to the left of the insertion point.

(A)True (B)False

85 Word includes a number of AutoCorrect entries. We can use these entries but cannot modify them.

(A)True (B)False

86 You can create your own dictionaries in Word.

(A)True (B)False

87 "When you create a formula that contains a function, the Insert Function dialog box helps you enter worksheet functions."

(A)True (B)False

88 "In Word, you can change the character spacing from the toolbar."

(A)True (B)False

89 "e-commerce consists primarily of the distributing, buying, selling, marketing, and servicing of products or services over electronic systems such as the Internet"

(A)True (B)False

90 Word template does not include style formatting.

(A)True (B)False

91 The Blank Web page template of Word contains pre-formatted or pre-designed options.

(A)True (B)False

92 The Word organizer does not copy the Auto-Text entries.

(A)True (B)False

93 Different cells with in a row can have different heights.

(A)True (B)False

94 The AutoFit to contents enables Word to widen or narrow columns based on the contents you insert in Insert Table.

(A)True (A)False

95 Print Preview of Word does not allow you to do any editing.

(A)True (A)False

96 "From the Mail Merge Helper dialog box, you can only open an existing data source but cannot create a new one."

(A)True (B)False

97 The name box is at the left end of the formula bar

(A)True (B)False

98 "In Excel, The delete and clear commands perform the same function."

(A)True (B)False

99 You cannot change the Font style of the entire workbook by a single command. It can change only worksheet by worksheet.

(A)True (B)False

100 The spelling and grammar check can only be done once the text is selected. (A)True (B)False

�CCC� TEST PAPERS

answare 

1=    b    2=    a    3=    c    4=    b    5=    c    6=    c    7=    a    8=    c    9=    c    10=    d   

11=    a    12=    d    13=    d    14=    d    15=    c    16=        17=    b    18=    d    19=    d  

  20=    b    21=    d    22=    c    23=    a    24=    c    25=    a    26=    d    27=    a    28=    d 

   29=    b    30=        31=    c    32=    d    33=    b    34=    c    35=    a    36=    c    37=    b

   38=    c    39=    a    40=    d    41=    b    42=    d    43=    c    44=    b    45=    b    46=   a 

  47=    d    48=    c    49=    c    50=    d    51=    t    52=    f    53=    t    54=    f    55=    f    

56=    f    57=    t    58=    t    59=t    60=    t    61=    f    62=    f    63=    t    64=    f    65= f   

66=    f    67=    f    68=    f    69=    t    70=    f    71=    t    72=    t    73=    f    74=t75=    f  

  76=    f    77=    f    78=    t    79=    f    80=    t    81=    t    82=    f    83=    t    84=    f   

 85=    f    86=    t    87=    t    88=    t    89=    t    90=    f    91=    f    92=    f    93=    f   

 94=    t    95=    t    96=    f    97=    t    98=    t    99=    t    100=    f    

Read more ...

THE HISTORY OF JAVA WITH TUTORIAL

 In year 1991, a group of engineers at Sun Microsystems Laboratory
developed the Java language. The Sun Microsystems engineers. Patrick Naughton and james Gosling
wanted to design a programming language for the development of software that could used in different consumer electronic devices such as VCRs, toasters, and cable television switch boxes.The team of sun Microsystems engineer designed a project which they named as Green Project.
The Green Project engineer designed a portable language that was small in nature, as its memory requirement
was less and it could also be used to generate an intermediated code for virtual machines such as the java Virtual Machine code. This Process of generating and interpreting the intermediate code less memory space and, thereby, provided compatibility to a variety of consumer electronic devices.  The newly developed language was named oak wich was based on C++ and followed the object-oriented programming approach . The oak programming language was later renamed Java and was introduced with this new name in year 1995. In year 1993 the first graphical wed browser Mosaic was released in the market. During this time
Internet on their machines which run on variety of OS and hardware configuration.
Due to the increasing popularity of the web, the Sun engineers decided to use Java for Internet by utilizing its feature of platform independence.
Patrick Naughton and Jonathan Payne built the Hot Java web browser written in the Java language . This web browser was made capable of interpreting the intermediate code for Java.

THE FEATURES OF JAVA

Java inherits most of its features from the previous object-oriented programming languages suc as C++.

The various features of Java are:

• Compiled and Interpreted 
• Platform- Independent and Portable
• Object-Oriented Programming Approach
• Robust and Secure
• Simple and Distributed
• Small and Familiar
• Multi-threaded and Interactive
• High Performance 
• Dynamic and Extensible

Compiled and Interpreted : Java is a compiled and interpreted language.The Java Compiler translates the 

program code into a compiled format known as byte code instruction . The byte code instructions can be executed by using the Java Virtual Machine (JVM) on any system irrespective of the hardware configuration and oprating system of the system in use. JVM is abstract computing machine that is used for interpreting 

compiled byte code instruction.

Platform- independent and Portable:A Java program has a unique feature of portability. Java programs can be easily transferred form one computer another and code be executed anywhere and any time .Java
provides portability as the Java compiler generates the byte code instruction that you can implement on any machine irrespective of the operating system of the processor.

Object-oriented Approach: Java is an object-oriented language that supports various object-oriented programming (OOPs) features such as polymorphism, data and inheritance. Java enables you to store the program code and data in the form of object and classes. 

Robust and Secure: Java also supports the feature of exception handling,  which detects the errors and exception and reduces the possibility of run-time errors. Java ensures that the downloaded  applet is virus-free.  Applet is a small Java program that executes in a web browser, but can be executed in other applications or devices that support the Applet programming model. Java also supports the feature of garbage collection,

Which solves the memory management problem by deleting unused objects form the memory. 

Simple and Distributed: The syntax for the Java language is similar to that of the C++ and C. The end user, who is familiar with C and C++, requires less effort in learning Java Because Java and C or C++ have a similar syntax. Java is a simpler language than the existing language and dose not implement some of the redundant and complex concepts of C and  C++.

 

Small and familiar:OOPs concept of inheritance allows the programmers and developers to re-use the pre-defined classes and objects in the programming code.

Multi-threaded and Interactive: Java supports the process of multi-threading that allows you to simultaneously perform multiples tasks. Multi-threading allows you to staks, the Java run-time environment supports multi-process synchronisation.

High Performance: Java enables the developer to create high-performance applications as the programs are first converted into byte code and that byte code is easily translated into machine language. Java programs require less memory and are faster to execute also increase their performance

Dynamic and Extensible: Java is more dynamic then C++ or C language because it allows dynamic linking of  classes to libraries and per_defined methods and objects. You can use programs written in other programming language such as C and C++ in Java, by dynamically linking then to the Java run-time environment. Java run time environment makes inter-connections between the modules of a program at run-time. You can also add new methods and temporary variables in the existing libraries.

Read more ...

LOCATING INFORMATION ON THE WEB

  The World Wide Web con be used to locate information on the Web. There are tow basic techniques to locate information on the web:

1. Browsing the Web: 

Browsing the web is the process of following the links on the web pages. Web pages have links that are connected to other pages. have links that are connected to other pages or resources on the some of different server. If you find a website that has the content you want to access then you can easily  follow the links to other sites and get the required information. Browsing can be time-consuming because in thecourse of following the links you can get to site to sites that may not contain the relevant information.

2 Searching the Web: 

In searching the web, a live list of search items is generated which are links to others websites. These links can be clicked and the information that you want to search can be accessed. There are a number of search 

websites on this Internet links:

• Google
• Excite
• MSN.com
• Go.com
• Lycos
• All The Web

 You can just type in the world or phrase in the text box, describing the subject on which you can view a list of hyperlinks. You can click any of these hyperlinkes and go to the corresponding website and find the desired information by browsing those sites.

Read more ...

WHAT IS THE INTERNET

Internet is a system of computer networks that are spread all over the word the world and use a number of protocol to communicate withe one another such as
Transmission Control Protocol (TCP) and Internet Protocol (IP). Internet is still uncharted and there is no central authority controlling the content of the internet and user connectivity. Any computer with a modem
(a computer interface to standard telephone lines) can be connected to the Internet. Following are two common of Internet connection:

Dial-UP Connections 

Individual subscribers in order to access the internet make use of dial-up connections.

To access the Internet through a dial-up connection you need a personal computer, a modem and an appropriate communication software like the Internet Explorer. In this mode, there is a host which services the client requests for the information . The host is called using a local or toll-free number. 

There are a number of dial-up connection providers is the market, so the user can decide which one to choose depending upon their needs and the services offered by he connection providers.

Direct Connection

Direct connection are those use wireless medium for information transfer. Commonly direct connection

are available to institutions, which lease high-speed connection to regional networks and service providers, An Internet connection using phone lines and modems dose not give users a speedy access to the internet . An Internet connection using ordinary telephone lines has a data transfer rate using a direct connection is of the order of mega characters per second.

Read more ...

BASIC CONCEPT OF MEMORY

A computer use tow types of storage : man memory memory and secondary memory. The main memory temporarily stores the instructions to be executed by the computer. The CPU of a computer retrieves instructions from main memory for execution.On the
other hand, secondary memory is constituted of various secondary storage devices such as magnetic disks and magnetic tapes, which stores the information permanently in the form of files.
Main memory, RAM. is the temporary read/write memory of a computer and fasted the secondary storages
devices. Main memory is a set of location defined by sequentially numbered addresses for storing programs for execution, and each location contains a binary number. You can access each byte of RAM directly without reading the previous bytes sequentially.
Each byte in a RAM has an addresses . The addresses are mostly sequential hexadecimal numbers. Usually ,
the addresses of RAM start from 00000.
The memory address that is referred to an instruction can be mentioned in two ways.
 When the exact location of a byte in RAM is mentioned, the addressing scheme is called absolute addressing . The address itself is called on absolute address. For example , the address 5508 indicates a specific location in the RAM, and 5508 is the absolute address of the location.

Similarly , a counter can also be used for location an address. For example, the starting address of a program in memory is 54EE. This address is the root or base address. All the addresses  in this program are relative to the address 54EE such as 8 bytes from the address 54EE The instruction in the program is add the content of the address 3 to the content at address 4. The address, 3 and 4 here are relative and refer to the third and fourth location in the main memory  starting form the root address 54EE. This is called relative addressing and the address itself is called relative address.

Read more ...

WINDOWS NT SERVER ARCHITECTURE

Windows NT Server contain various components among which some of the components run in user mode and other run in kernel mode. Kernel Mode is a
special type of mode in which all the hardware and system data can be accessed by  the running code,
whereas in user mode, there in only restricted access to the system data and hardware by the running code. The user mode is also referred to as non-privileged mode. The architecture of Windows NT Server contains the following components :

• Hardware Abstraction Layer (HAL)
• Kernel
• NT Executive
• Protected Environment Subsystems

Hardware Abstraction Layer (HAL)

HAL is a software interface located between the hardware and the operating system and it is the lowest level

component of the Windows NT operating system. HAL is platform-specific and carries cods for communication and controlling the hardware on which Windows NT operates. HAL gives the interface for

Symmetric MultiProcessing (SMP) and enable Windows NT Server more application-friendly.

HAL is executed as a Dynamic Link Library (DLL) and, is responsible for protecting Windows NT server based on HAL is that it is not compatible with the older version of DOS and Windows program : 

Read more ...

CLASSIFICATION OF OPERATING SYSTEMS

All operating systems consist of  similar components and perform  almost similar functions but the methods and procedures for performing these functions are different. Operating systems are classified into following different categories based on their distinguishing features: 

• Single -user Operating system
• Multi-user Operating system
• Batch processing Operating system
• Multiprogramming Operating system
• Multitasking Operating system 
• Parallel Operating system
• Distributed Operating system
• Real.time operating system

Single-User Operating System 

It allows a single user to access a computer at a time . These computer have single processor and execute 

single program . The resources such as CPU and I/O device are constantly available to the user in a single 

user operating system for operating the system. As a result, the CPU site idle for most of the time and is not utilised to it maximum. A single -user OS is divided into categories :

• Single-user, single-tasking operating system
• single-user , multi-tasking operating system

The single-user, single-tasking operating system allows a single-user to execute on

program at a time. MS-DOS and palm OS for palm hand-held computer at

examples of single-user single-tasking operating system .

Single-user multitasking operating system allows a single-user to operate multiple programs at the same time. For example, you can perform calculation in Excel sheet print a Word document and download a file from the internet concurrently .

Mac OS Windows 95, Windows 98, Windows NT Workstation and Windows 2000 Professional, operating system for desktop and laptop computer are the examples of single-user, multi-tasking operating system. 

Read more ...