Sterliate Educations
673-A, Second Floor, Gali No.-7, Govindpuri, Kalkaji,, New Delhi 110019 Bharat
TTE-35-DCA-APRIL-2023
|
| Question : 100 |
Duration : 60 Minutes |
|
| 1 |
A database management system
|
| A: is a collection of programs for managing data in a single file |
| B: can do more than a record management system |
| C: allows simultaneous access to multiple file |
| D: is a collection of programs for managing data in a single file |
| Answer: D |
|
| 2 |
A table consists of
|
| A: Rows and cells |
| B: Rows and columns |
| C: Fields and columns |
| D: Rows and cells |
| Answer: B |
|
| 3 |
Which of the following is at the highest level in the hierarchy of data organization?
|
| A: Database |
| B: Data bank |
| C: Data file |
| D: Database |
| Answer: A |
|
| 4 |
An entry in the telephone book can be compared to a
|
| A: Field |
| B: Record |
| C: File |
| D: Field |
| Answer: B |
|
| 5 |
A file consists of
|
| A: Fields and records |
| B: Records and sorts |
| C: Fields and sorts |
| D: Fields and records |
| Answer: A |
|
| 6 |
Open the Save As dialog box
|
| A: F1 |
| B: F2 |
| C: F10 |
| D: F1 |
| Answer: D |
|
| 7 |
In Access, ____ are used to store the data.
|
| A: Report |
| B: Form |
| C: Table |
| D: Report |
| Answer: C |
|
| 8 |
A _____ is an area reserved for a specific piece of data.
|
| A: Report |
| B: Key |
| C: Record |
| D: Report |
| Answer: D |
|
| 9 |
Press _____ to quit MS Access. |
| A: Tab +F4 |
| B: Esc+ W |
| C: Ctrl +F4 |
| D: Tab +F4 |
| Answer: D |
|
| 10 |
Microsoft Access is a _____
|
| A: Network Database Model |
| B: RDBMS |
| C: ORDBMS |
| D: Network Database Model |
| Answer: B |
|
| 11 |
Which of the following option creates a Drop Down List of values ? |
| A: Ole Object |
| B: Hyperlink |
| C: Memo |
| D: Ole Object |
| Answer: D |
|
| 12 |
Each box in a spreadsheet is called a
|
| A: Field |
| B: Record |
| C: Cell |
| D: Field |
| Answer: C |
|
| 13 |
Which of the following programs enables you to calculate numbers related to rows and columns?
|
| A: Window program |
| B: Spreadsheet program |
| C: Graphics program |
| D: Window program |
| Answer: B |
|
| 14 |
A typical worksheet has ________ Number of columns in excel 2003
|
| A: 128 |
| B: 256 |
| C: 512 |
| D: 128 |
| Answer: B |
|
| 15 |
How many characters can be typed in a single cell in Excel?
|
| A: 256 |
| B: 1024 |
| C: 32000 |
| D: 256 |
| Answer: D |
|
| 16 |
What term refers to a specific set of values saved with the workbook? |
| A: Range |
| B: Scenario |
| C: Trend line |
| D: Range |
| Answer: B |
|
| 17 |
Statistical calculations and preparation of tables and graphs can be done using |
| A: Adobe Photoshop |
| B: Excel |
| C: Notepad |
| D: Adobe Photoshop |
| Answer: B |
|
| 18 |
A cell may be used in a mathematical formula if it contains
|
| A: A label |
| B: Numerical data |
| C: Both (a) and (b) |
| D: A label |
| Answer: B |
|
| 19 |
The bar used to display the current cell and its contents is
|
| A: Menu bar |
| B: Function bar |
| C: Formula bar |
| D: Menu bar |
| Answer: C |
|
| 20 |
Which one of the following is not a Spreadsheet program?
|
| A: Quattro Pro |
| B: MS-DOS |
| C: Lotus 1-2-3 |
| D: Quattro Pro |
| Answer: B |
|
| 21 |
What type of chart will you use to compare performance of sales of two products ? |
| A: Column Chart |
| B: Line Chart |
| C: Pie Chart |
| D: Column Chart |
| Answer: A |
|
| 22 |
How many sheets are there, by default, when we create a new Excel file ? |
| A: 1 |
| B: 3 |
| C: 5 |
| D: 1 |
| Answer: B |
|
| 23 |
It is a collection of data that is stored electronically as a series of records in a table. |
| A: spreadsheet |
| B: presentation |
| C: database |
| D: spreadsheet |
| Answer: C |
|
| 24 |
Functions in MS Excel must begin with ___ |
| A: An () sign |
| B: An Equal Sign |
| C: A Plus Sign |
| D: An () sign |
| Answer: B |
|
| 25 |
In Excel, which one denoted a range from B1 through E5 |
| A: B1 - E5 |
| B: B1:E5 |
| C: B1 to E5 |
| D: B1 - E5 |
| Answer: B |
|
| 26 |
A features that displays only the data in column (s) according to specified criteria |
| A: Formula |
| B: Sorting |
| C: Filtering |
| D: Formula |
| Answer: C |
|
| 27 |
Which functionin Excel tells how many numeric entries are there ? |
| A: NUM |
| B: COUNT |
| C: SUM |
| D: NUM |
| Answer: B |
|
| 28 |
Turn on the computer for first time on a day is called a
|
| A: Hot boot |
| B: Cold boot |
| C: Cool boot |
| D: Hot boot |
| Answer: B |
|
| 29 |
In MICR, C stands for
|
| A: Character |
| B: Computer |
| C: colour |
| D: Character |
| Answer: A |
|
| 30 |
Which of the following is the first neural network computer?
|
| A: AN |
| B: AM |
| C: RFD |
| D: AN |
| Answer: D |
|
| 31 |
Which of the following numbers is a binary number?
|
| A: 1 and 2 |
| B: 0 and 0.1 |
| C: 2 and 0 |
| D: 1 and 2 |
| Answer: D |
|
| 32 |
What is five main components of a computer system?
|
| A: CPU, CD-ROM, Mouse, Keyboard, Sound card |
| B: Memory, Video card, Monitor, Software, Hardware |
| C: Modem, Keyboard, Word Processor, Printer, Screen |
| D: CPU, CD-ROM, Mouse, Keyboard, Sound card |
| Answer: D |
|
| 33 |
What is the full form of USB?
|
| A: Unshielded Serial Board |
| B: Universal System Board |
| C: Unidentified serial Bus |
| D: Unshielded Serial Board |
| Answer: D |
|
| 34 |
What is the full form of SRAM?
|
| A: Static Random-Access Memory |
| B: Static Remote-Access Memory |
| C: Setup Random-Access Memory |
| D: Static Random-Access Memory |
| Answer: A |
|
| 35 |
What is the full form of DRAM?
|
| A: Dynamic Remote Access Memory |
| B: Dynamic Random-Access Memory |
| C: Dependent Remote Access Memory |
| D: Dynamic Remote Access Memory |
| Answer: B |
|
| 36 |
Which device uses a handheld operation system?
|
| A: A mainframe |
| B: A laptop |
| C: A personal computer |
| D: A mainframe |
| Answer: D |
|
| 37 |
The main memory of a computer can also be called
|
| A: Primary memory |
| B: Primary storage |
| C: Internal memory |
| D: Primary memory |
| Answer: D |
|
| 38 |
Where is data saved permanently?
|
| A: Printer |
| B: CPU |
| C: Storage |
| D: Printer |
| Answer: C |
|
| 39 |
A set of rules that computer on a network use to communicate with each other are called
|
| A: Bus |
| B: Regulation |
| C: Rules |
| D: Bus |
| Answer: D |
|
| 40 |
Microsoft Office is an example of a
|
| A: Horizontal market software |
| B: Vertical market software |
| C: Open source software |
| D: Horizontal market software |
| Answer: A |
|
| 41 |
The process of carrying out commands is called
|
| A: Executing |
| B: Decoding |
| C: Storing |
| D: Executing |
| Answer: A |
|
| 42 |
The technology that is used to establish wireless networking is
|
| A: Bluetooth |
| B: MATLAB |
| C: J2ME |
| D: Bluetooth |
| Answer: A |
|
| 43 |
What is the full form of RAM?
|
| A: Remote Access Memory |
| B: Random Access Memory |
| C: Read Access Memory |
| D: Remote Access Memory |
| Answer: B |
|
| 44 |
What is the speed of computer measured in?
|
| A: Nanoseconds |
| B: Kilo-seconds |
| C: Gigahertz |
| D: Nanoseconds |
| Answer: C |
|
| 45 |
Which of the following values is the correct value of this binary code 1011 and 1111?
|
| A: 11 and 14 |
| B: 12 and 15 |
| C: 11 and 15 |
| D: 11 and 14 |
| Answer: C |
|
| 46 |
What kind of language can computer understand?
|
| A: Normal language |
| B: Computer language |
| C: Assembly language |
| D: Normal language |
| Answer: C |
|
| 47 |
Which type of program acts as an intermediary between a user of a computer and the computer hardware?
|
| A: Operating system |
| B: User thread |
| C: Superuser thread |
| D: Operating system |
| Answer: A |
|
| 48 |
Which of the following is equal to a gigabyte?
|
| A: 1024 bytes |
| B: 512 GB |
| C: 1024 megabytes |
| D: 1024 bytes |
| Answer: C |
|
| 49 |
Which one of the following groups contains graphical file extensions?
|
| A: JPG, CPX, GCM |
| B: GIF, TCE, WMF |
| C: TCP, JPG, BMP |
| D: JPG, CPX, GCM |
| Answer: D |
|
| 50 |
The central processing unit is located in the _____.
|
| A: Hard disk |
| B: System unit |
| C: Memory unit |
| D: Hard disk |
| Answer: B |
|
| 51 |
A computer is accurate, but if the result of a computation is false, what is the main reason for it?
|
| A: Power failure |
| B: The computer circuits |
| C: Incorrect data entry |
| D: Power failure |
| Answer: C |
|
| 52 |
BIOS is used?
|
| A: By operating system |
| B: By compiler |
| C: By interpreter |
| D: By operating system |
| Answer: A |
|
| 53 |
Which of the following natural element is the primary element in computer chips?
|
| A: Silicon |
| B: Carbon |
| C: Iron |
| D: Silicon |
| Answer: A |
|
| 54 |
Which of the following is the smallest visual element on a video monitor?
|
| A: Character |
| B: Pixel |
| C: Byte |
| D: Character |
| Answer: B |
|
| 55 |
How is the data stored on the diskette?
|
| A: Ink |
| B: Laser bubbles |
| C: Magnetism |
| D: Ink |
| Answer: C |
|
| 56 |
How many color dots make up one color pixel on a screen?
|
| A: 265 |
| B: 16 |
| C: 8 |
| D: 265 |
| Answer: D |
|
| 57 |
What is the term for a temporary storage area that compensates for differences in data rate and data flow between devices?
|
| A: Buffer |
| B: Bus |
| C: Channel |
| D: Buffer |
| Answer: A |
|
| 58 |
What is the decimal equivalent of the binary number 10111?
|
| A: 21 |
| B: 25 |
| C: 23 |
| D: 21 |
| Answer: C |
|
| 59 |
A process is a _______.
|
| A: single thread of execution. |
| B: program in the execution |
| C: program in the memory |
| D: single thread of execution. |
| Answer: B |
|
| 60 |
Computers use the ____ system to process data
|
| A: Representational |
| B: Binary |
| C: Kilobyte |
| D: Representational |
| Answer: B |
|
| 61 |
All the deleted files go to
|
| A: My computer |
| B: Tool bar |
| C: Task bar |
| D: My computer |
| Answer: D |
|
| 62 |
Output which is made up of pictures, sounds, and video is called
|
| A: Multimedia |
| B: Graphics |
| C: Hard Copy |
| D: Multimedia |
| Answer: A |
|
| 63 |
CDs are of which shape? |
| A: Information |
| B: Round |
| C: Rectangular |
| D: Information |
| Answer: C |
|
| 64 |
Cache and main memory will lose their contents when the power is off. They are |
| A: Non-volatile |
| B: Volatile |
| C: Static |
| D: Non-volatile |
| Answer: B |
|
| 65 |
Which of these keys is not on the number keypad?
|
| A: Num Lock |
| B: Enter |
| C: Del |
| D: Num Lock |
| Answer: D |
|
| 66 |
A computer communicates with other computers on the internet through
|
| A: IP |
| B: TCP/IP |
| C: HTTPS |
| D: IP |
| Answer: B |
|
| 67 |
Each computer on a network is recognized by a unique
|
| A: IP address |
| B: HTTP |
| C: HTTPS |
| D: IP address |
| Answer: A |
|
| 68 |
What is the major use of internet?
|
| A: Sharing data and information |
| B: Browsing webpages |
| C: Sending and receiving emails |
| D: Sharing data and information |
| Answer: D |
|
| 69 |
|
| A: |
| B: |
| C: |
| D: |
| Answer: |
|
| 70 |
The process of removing unwanted part of an image is called |
| A: Hiding |
| B: Bordering |
| C: Cropping |
| D: Hiding |
| Answer: C |
|
| 71 |
The generation based on VLSI microprocessor
|
| A: 1ST |
| B: 2nd |
| C: 3rd |
| D: 1ST |
| Answer: D |
|
| 72 |
Which of the following is the root tag of the HTML document?
|
| A: |
| B: |
| C: |
| D: |
| Answer: D |
|
| 73 |
The tags in HTML are -
|
| A: case-sensitive |
| B: in upper case |
| C: not case sensitive |
| D: case-sensitive |
| Answer: C |
|
| 74 |
A program in HTML can be rendered and read by -
|
| A: Web browser |
| B: Server |
| C: Interpreter |
| D: Web browser |
| Answer: A |
|
| 75 |
What are the types of unordered or bulleted list in HTML? |
| A: disc, square, triangle |
| B: polygon, triangle, circle |
| C: disc, circle, square |
| D: disc, square, triangle |
| Answer: C |
|
| 76 |
Which of the following is the container for data?
|
| A: data |
| B: table |
| C: group |
| D: data |
| Answer: B |
|
| 77 |
How to add a background color in HTML?
|
| A: |
| B: |
| C: |
| D: |
| Answer: C |
|
| 78 |
How to insert an image in HTML?
|
A: ![]() |
B: ![]() |
C: ![]() |
D: ![]() |
| Answer: D |
|
| 79 |
How to create a hyperlink in HTML?
|
| A: sterliate.com |
| B: |
| C: sterliate.com |
| D: sterliate.com |
| Answer: A |
|
| 80 |
The correct sequence of HTML tags for starting a webpage is - |
| A: Head, Title, HTML, body |
| B: HTML, Body, Title, Head |
| C: HTML, Head, Title, Body |
| D: Head, Title, HTML, body |
| Answer: D |
|
| 81 |
|
| A: HyperText Markup Language. |
| B: HighText Markup Language. |
| C: HyperText Markdown Language. |
| D: HyperText Markup Language. |
| Answer: A |
|
| 82 |
A major step before taking print of the document is
|
| A: To save the document |
| B: To set paper setting |
| C: To see print preview of the document |
| D: To save the document |
| Answer: D |
|
| 83 |
To view paragraph marks, clicks on the _____ tab, in the paragraph group, click Show/Hide.
|
| A: View |
| B: Home |
| C: Page layout |
| D: View |
| Answer: B |
|
| 84 |
The center the selected text, the shortcut key is
|
| A: Ctrl + C |
| B: Ctrl + E |
| C: Ctrl + U |
| D: Ctrl + C |
| Answer: B |
|
| 85 |
In the _____ we can change the view of the document and set the zoom option.
|
| A: Home panel |
| B: View option toolbar |
| C: Ribbon |
| D: Home panel |
| Answer: B |
|
| 86 |
_____ is the change the way text warps around the selected object.
|
| A: Text wrapping |
| B: Indent |
| C: Clipart |
| D: Text wrapping |
| Answer: A |
|
| 87 |
Which option is not available in Microsoft office button?
|
| A: Bold |
| B: New |
| C: Save |
| D: Bold |
| Answer: A |
|
| 88 |
A _____ identifies a location or a selection of text that you name and identify for future reference.
|
| A: Footer |
| B: Bookmark |
| C: Header |
| D: Footer |
| Answer: B |
|
| 89 |
A word gets selected by clicking it
|
| A: Once |
| B: Twice |
| C: Three times |
| D: Once |
| Answer: B |
|
| 90 |
To show the font dialog box press ____
|
| A: Ctrl+ P |
| B: Ctrl+ D |
| C: Ctrl+ B |
| D: Ctrl+ P |
| Answer: B |
|
| 91 |
Word pad not contain this item of the group: |
| A: clipboard |
| B: Font |
| C: Paragraph |
| D: clipboard |
| Answer: D |
|
| 92 |
In Wordpad .rtf stands for ____ |
| A: Rich text file |
| B: rich text format |
| C: Real text file |
| D: Rich text file |
| Answer: B |
|
| 93 |
How many types of alignment available in word pad?
|
| A: 3 |
| B: 4 |
| C: 2 |
| D: 3 |
| Answer: B |
|
| 94 |
How many maximum slides can be added to a PowerPoint presentation?
|
| A: 50 |
| B: 500 |
| C: No fixed number |
| D: 50 |
| Answer: C |
|
| 95 |
A PowerPoint 2003 design template is stored in any file with __________ extensions.
|
| A: .pot |
| B: ptt |
| C: dtp |
| D: .pot |
| Answer: D |
|
| 96 |
Which of the following is the extension of Notepad?
|
| A: .txt |
| B: .xls |
| C: .ppt |
| D: .txt |
| Answer: A |
|
| 97 |
When was the first operating system developed?
|
| A: 1948 |
| B: 1949 |
| C: 1950 |
| D: 1948 |
| Answer: C |
|
| 98 |
What is the shortcut key to increase the font size of selected text in MS-Word? |
| A: Ctrl + Shift + G |
| B: Ctrl + Shift+ > |
| C: Ctrl + Shift + < |
| D: Ctrl + Shift + G |
| Answer: B |
|
| 99 |
Which of the following are physical devices of a computer?
|
| A: Hardware |
| B: Software |
| C: System Software |
| D: Hardware |
| Answer: A |
|
| 100 |
Which of the following is the brain of the computer?
|
| A: Central Processing Unit |
| B: Memory |
| C: Arithmetic and Logic unit |
| D: Central Processing Unit |
| Answer: A |
|