Bank clerical exam computer questions SOLVED TEST MCQ Computer Awareness

Bank clerical exam computer questions SOLVED TEST MCQ
Clerical Exam Sample Paper:Computer Awareness test
Computer Awareness
15 solved questions
1.Which of following is not an open source OS?
(A)Red-Hat
(B) Ubuntu
(C) Vista
(D)Knoppix

2 Measuring Unit of Capacity of Hard drive is ?
(A)GHz
(B) GB
(C) Gwatts
(D)G Newton
3. CAD/CAM is ?
(A)Operating System
(B)Type of Virus usually Trojan
(C)Computer Basic parts
(D)Program
4.Overclocking is done to ?
(A)Hard Disk
(B) processor
(C) OS
(D)Programs
5.While Buying PC Check FSB Speed. FSB Speed is word associated with ?
(A)Hard Disk
(B) Motherboard
(C) RAM
(D)Fan Speed
6. Hyper-threading (HT) is related to ?
(A)Processor
(B)RAM
(C) Mother Board
(D)Hard Disk
7. Intel and AMD are Leaders in
(A)Processor
(B)RAM
(C) Mother Board
(D)Hard Disk
8. IDE (ATA) or SATA interface connect Mother Board with ?
(A)Processor
(B)RAM
(C) Monitor
(D)Hard Disk
9. USB is a type of ?
(A)Processor
(B)Port
(C) Monitor
(D)Program

10 What menu is selected for printing?
(A)Edit
(B)Special
(C) File
(D)Tools
11.The name a user assigns to file is called?
(A)File name
(B)program
(C)record
(D)data
12.Two access properties of an object ,we use mouse to
(A)Left Click
(B)Right Click
(C) Drag
(D)Drop
13 To assess a Main Frame Computer Users normally use
(A)Terminal
(B)PC
(C) Laptop
(D)None of these
14.Web address is a unique address to identify ……… on web
(A)Browser
(B)Link
(C) PDA
(D)Website
15.Optical storage unit is used in modern PC and is known as
(A)Floppy
(B)CD
(C) ROM
(D)RAM
Answers

1	C
2	B
3	D
4	B
5	B
6	A
7	A
8	D
9	B
10	C
11	A
12	B
13	A
14	D
15	B

Read more »

Posted in: Bank , computer , Model paper , Practice paper , Question and Answers , Sample Paper , test

Free solved paper Basics of Computer science Number system Binary hexadecimal Flip Flop for Exams

Free solved paper Basics of Computer science Number system Binary hexadecimal Flip Flop for Exams
Free Computer Science Question Papers download
FREE EXAM SOLVED PAPER Computer science
Computer Science Question papers Free .
1.What is the base of octal system
a)      2
b)      8
c)      16
d)      10
Ans:b
2. What is the base of binary system
a)      2
b)      8
c)      16
d)      10
Ans:a
3.What is the base of decimal system
a)      2
b)      8
c)      16
d)      10
Ans:d
4.   What is the base of hexadecimal system
a)      2
b)      8
c)      16
d)      10
Ans:c
5.       Convert 25 (Base 10)  to binary
a)      10010
b)      11001
c)      11110
d)      00111
Ans:b
6.   Convert 5210 to binary
a)      100011
b)      110100
c)      111100
d)      000011
Ans:b
7.   If one of the inputs is low ,then output is also low in
a)      OR
b)      EXOR
c)      NOR
d)      AND
Ans:d
8.  If one of the inputs is high ,then output is also high in
a)      OR
b)      AND
c)      EXOR
d)      NAND
Ans:a
9.  Simplifications of any logic expression by using
a)      Vector analysis
b)      Boolean algebra
c)      matrix analysis
d)      None of these
Ans:b
10 Flip flop has
a)      one state
b)      two states
c)      zero state
d)      none of these
Ans:b
11. If both inputs are same, then output is “0” in
a)      OR
b)      AND
c)      EXOR
d)      NAND
Ans:c
12. RS flip flop is
a)      clocked output
b)      reset/set flip flop
c)      set only
d)      reset only
Ans:b
12.In RS Flip flop,R=0,S=0,then output is
a)      set
b)      reset
c)      last value
d)      illegal
Ans:c
13. In RS Flip flop,R=0,S=1,then output is
a)      set
b)      reset
c)      last value
d)      illegal
Ans:a
14. In RS Flip flop,R=1,S=0,then output is
a)      set
b)      reset
c)      last value
d)      illegal
Ans:b
15.. In RS Flip flop,R=1,S=1,then output is
a)      set
b)      reset
c)      last value
d)      illegal
Ans:d
16. In clocked RS Flip flop, clock=0,R=0,S=0,then output is
a) set
b)reset
c)last value
d)illegal
Ans:c
17. In clocked RS Flip flop, clock=0,R=0,S=1,then output is
a) set
b)reset
c)no change
d)illegal
Ans:c
18 In clocked RS Flip flop, clock=0,R=1,S=0,then output is
a) no change
b)reset
c)set
d)illegal
Ans:a
19. In D Flip flop, clock=1,D=0,then output is
a)0
b)1
c)last value
d)illegal
Ans:a
20. In D Flip flop, clock=1,D=1,then output is
a)0
b)1
c)last value
d)illegal
Ans:b
21.Register is
a)group of transistors
b) group of diodes
c) group of flip flops
d)none of these
Ans:c
22.Counter is activated by
a)      clock
b)      flip flop
c)      register
d)      none of these
Ans:a
23.In asynchronous counter, each filp flop triggered by
a)clock
b)impulse
c)previous flip flop
d)none of these
Ans:c
24. In synchronous counter,each filp flop triggered by
a)clock
b)impulse
c)previous flip flop
d)none of these
Ans:a
25. In asynchronous counter, speed is
a)high
b)very high
c)0
d)limited
Ans:d

Read more »

Posted in: Basics , computer , Model paper , Practice paper , Question and Answers , Sample Paper , test

Computer & Internet General Awareness Solved Questions March 2011

Technology Questions With Answers March 2011

Here you can download computer Technology  & Internet based  Questions

1 -What is part of a database that holds only one type of information?
A.    Report    B.    Field
C.    Record    D.    File

Answer:  B
2 – ‘OS’ computer abbreviation usually means ?
A.    Order of Significance
B.    Open Software
C.    Operating System
D.    Optical Sensor

Answer-  C
3 – In which decade with the first transatlantic radio broadcast occur?
A.    1850s    B.    1860s
C.    1870s    D.    1900s

Answer: D
4 – Most modern TV’s draw power even if turned off. The circuit the power is used in does what function?
A.    Sound
B.    Remote control
C.    Color balance
D.    High voltage

Answer: B

5 – Which is a type of Electrically-Erasable Programmable Read-Only Memory?
A.    Flash    B.    Flange
C.    Fury    D.    FRAM

Answer:  A

6- ‘.MPG’ extension refers usually to what kind of file?
A.    WordPerfect Document file
B.    MS Office document
C.    Animation/movie file
D.    Image file

Answer: C

7 – Who developed Yahoo?
A.    Dennis Ritchie & Ken Thompson
B.    David Filo & Jerry Yang
C.    Vint Cerf & Robert Kahn
D.    Steve Case & Jeff Bezos

Answer:  B

8 – The most common format for a home video recorder is VHS. VHS stands for…?
A.    Video Home System
B.    Very high speed
C.    Video horizontal standard
D.    Voltage house standard

Answer:  A
9 – What frequency range is the High Frequency band?
A.    100 kHz
B.    1 GHz
C.    30 to 300 MHz
D.    3 to 30 MHz

Answer:  D
10 – In which year was MIDI(dress) introduced?
A.    1987    B.    1983
C.    1973    D.    1977

Answer: B
11 – ‘DB’ computer abbreviation usually means ?
A.    Database
B.    Double Byte
C.    Data Block
D.    Driver Boot

Answer:  A

12 – Who created Pretty Good Privacy (PGP)?
A.    Paul Zimmerman
B.    Tim Berners-Lee
C.    Marc Andreessen
D.    Ken Thompson

Answer:  A

13 – What do we call a network whose elements may be separated by some distance? It usually involves two or more small networks and dedicated high-speed telephone lines.
A.    URL (Universal Resource Locator)
B.    LAN (Local Area Network)
C.    WAN (Wide Area Network)
D.    World Wide Web

Answer:  C
14 – In a color television set using a picture tube a high voltage is used to accelerate electron beams to light the screen. That voltage is about…?
A.    500 volts
B.    5 thousand volts
C.    25 thousand volts
D.    100 thousand volts

Answer:  C

15 – What do we call a collection of two or more computers that are located within a limited distance of each other and that are connected to each other directly or indirectly?
A.    Inernet
B.    Interanet
C.    Local Area Network
D.    Wide Area Network

Answer:  C

Read more »

Posted in: computer , Question and Answers , Technology

Servlet Interview Question | Latest Servlet/JSP Interview Question

Q) What is the difference between JSP and Servlets ?

A)JSP is used mainly for presentation only. A JSP can only be HttpServlet that means the only supported protocol in JSP is HTTP. But a servlet can support any protocol like HTTP, FTP, SMTP etc.

Q )What is difference between custom JSP tags and beans?

A)Custom JSP tag is a tag you defined. You define how a tag, its attributes and its body are interpreted, and then group your tags into collections called tag libraries that can be used in any number of JSP files. To use custom JSP tags, you need to define three separate components: the tag handler class that defines the tag’s behavior ,the tag library descriptor file that maps the XML element names to the tag implementations and the JSP file that uses the tag library

JavaBeans are Java utility classes you defined. Beans have a standard format for Java classes. You use tags

Custom tags and beans accomplish the same goals — encapsulating complex behavior into simple and accessible forms. There are several differences:

Custom tags can manipulate JSP content; beans cannot. Complex operations can be reduced to a significantly simpler form with custom tags than with beans. Custom tags require quite a bit more work to set up than do beans. Custom tags usually define relatively self-contained behavior, whereas beans are often defined in one servlet and used in a different servlet or JSP page. Custom tags are available only in JSP 1.1 and later, but beans can be used in all JSP 1.x versions.

Q) What are the different ways for session tracking?

A)Cookies, URL rewriting, HttpSession, Hidden form fields

Q) What mechanisms are used by a Servlet Container to maintain session information?

A)Cookies, URL rewriting, and HTTPS protocol information are used to maintain session information

Q) Difference between GET and POST

A)In GET your entire form submission can be encapsulated in one URL, like a hyperlink. query length is limited to 255 characters, not secure, faster, quick and easy. The data is submitted as part of URL.

In POST data is submitted inside body of the HTTP request. The data is not visible on the URL and it is more secure.

Q) What is session?

A)The session is an object used by a servlet to track a user’s interaction with a Web application across multiple HTTP requests. The session is stored on the server.

Q) What is servlet mapping?

A)The servlet mapping defines an association between a URL pattern and a servlet. The mapping is used to map requests to Servlets.

Q) What is servlet context ?

A)The servlet context is an object that contains a information about the Web application and container. Using the context, a servlet can log events, obtain URL references to resources, and set and store attributes that other servlets in the context can use.

Q) What is a servlet ?

A)servlet is a java program that runs inside a web container.

Q) Can we use the constructor, instead of init(), to initialize servlet?

A)Yes. But you will not get the servlet specific things from constructor. The original reason for init() was that ancient versions of Java couldn’t dynamically invoke constructors with arguments, so there was no way to give the constructor a ServletConfig. That no longer applies, but servlet containers still will only call your no-arg constructor. So you won’t have access to a ServletConfig or ServletContext.

Q) How many JSP scripting elements are there and what are they?

A)There are three scripting language elements: declarations, scriptlets, expressions.

Q) How do I include static files within a JSP page?

A)Static resources should always be included using the JSP include directive. This way, the inclusion is performed just once during the translation phase.

Q) How can I implement a thread-safe JSP page?

A)You can make your JSPs thread-safe adding the directive <%@ page isThreadSafe=”false” % > within your JSP page.

Q) What is the difference in using request.getRequestDispatcher() and context.getRequestDispatcher()?

A)In request.getRequestDispatcher(path) in order to create it we need to give the relative path of the resource. But in resourcecontext.getRequestDispatcher(path) in order to create it we need to give the absolute path of the resource.

Q) What are the lifecycle of JSP?
A)When presented with JSP page the JSP engine does the following 7 phases.

Page translation: -page is parsed, and a java file which is a servlet is created.

Page compilation: page is compiled into a class file

Page loading : This class file is loaded.

Create an instance :- Instance of servlet is created

jspInit() method is called

_jspService is called to handle service calls

_jspDestroy is called to destroy it when the servlet is not required.

Q) What are context initialization parameters?

A)Context initialization parameters are specified by the <context-param> in the web.xml file, these are initialization parameter for the whole application.

Q) What is a Expression?

A)Expressions are act as place holders for language expression, expression is evaluated each time the page is accessed. This will be included in the service method of the generated servlet.

Q) What is a Declaration?

A)It declares one or more variables or methods for use later in the JSP source file. A declaration must contain at least one complete declarative statement. You can declare any number of variables or methods within one declaration tag, as long as semicolons separate them. The declaration must be valid in the scripting language used in the JSP file. This will be included in the declaration section of the generated servlet.

Q) What is a Scriptlet?

A)A scriptlet can contain any number of language statements, variable or expressions that are valid in the page scripting language. Within scriptlet tags, you can declare variables to use later in the file, write expressions valid in the page scripting language, use any of the JSP implicit objects or any object declared with a <jsp:useBean>. Generally a scriptlet can contain any java code that are valid inside a normal java method. This will become the part of generated servlet’s service method.

Read more »

Posted in: Careers , computer , Interview , jobs info , Question and Answers

Latest PHP Interview Question Answers | Basic & Most asked Question of PHP

Q 1)Which function in PHP gives us absolute path of a file on the server?
< ?php $p = getcwd(); echo $p; ?> Ans: getcwd() Here I have stored my files under httdocs (using php5,i haven’t checked under php4) so I get the output as C:\apache2triad\htdocs you may get your path information while runnings the above code.

Q 2)what is the php solution to dynamic caching ?
www.w3answers.com PHP offers an extremely simple solution to dynamic caching in the form of output buffering.

Q 3)What is the difference between strstr() and stristr()?
strstr — Find first occurrence of a string strstr() example < ?php$email = 'user@example.com';$domain = strstr($email, '@');echo $domain; // prints @example.com?> stristr — Case-insensitive strstr() stristr() example < ?php$email = 'USER@EXAMPLE.com';echo stristr($email, 'e');// outputs ER@EXAMPLE. ....!
Is it possible to set a time expire page in PHP.?
Yes it is Using header("Expires: Mon, 26 Jul 2007 05:00:00 GMT"); .

Q 4)What is MIME?
MIME is Multipurpose Internet Mail Extensions is an internet standard for the format of e-mail. Howewer browsers also uses MIME standart to transmit files. MIME has a header wich is added to a begining of the data. When browser sees such header it shows the data as it would be a file (for example image) some mimes:audio/x-ms-wmpimage/pngaplication/x-shockwave-flash .

5)What is the maximum length of a table name, a database name, or a field name in MySQL?
Ans: Database name: 64 characters Table name: 64 characters Column name: 64 characters ….!
php supports following database
a) Solid & oracle b) mysql c) None of the above d) All of the above All of the above ….!
what are the ‘function problems’ you have met in php?
1)Call to undefined function we_w3answers() ***************************************** PHP is trying to call the function we_w3answers(), which has not been because you misspelled the name of a function (built-in or user-defined) simply omitted the function definition. If you use include/require functions, make sure that you are loading the appropriate files. 2)Call to undefined function array() *********************************** This problem has a cause that i….!

Q 6)What is meant by Exceptional Handling?
Exceptions PHP 5 has an exception model similar to that of other programming languages. An exception can be thrown, try and caught within PHP. A Try block must include at least one catch block. Multiple catch blocks can be used to catch different classtypes; execution will continue after that last catch block defined in sequence. Exceptions can be thrown within catch blocks. When an exception is thrown, code following the statement will not be executed and PHP will attempt to find the first matching catch block. ….!

Q 7)what is the output here?
< ?php var_dump(0 == "a"); ?>
a) false
b) true
c) error
d) declaration error ANS : true ….!

Q 8)What will be the following script output?
< ?php$a = 1;$a = $a— + 1;echo $a;?>
A. 2
B. 1
C. 3
D. 0
E. Null Answer : B is correct. ….!

Q 9)What are the different functions in sorting an array?
Ans: asort() arsort() ksort() krsort() uksort() sort() natsort() rsort() ….!

Q 10)What is the difference between the functions unlink() and unset()?
unlink is a function for file system handling. It will simply delete the file in context unset will set UNSET the variable ….!

Q 11)What will be the following script output?
< ?php$x = 3 - 5 % 3;echo $x;?>
A. 2
B. 1
C. Null
D. True
E. 3 Answer A is correct. Because of operator precedence, the modulus operation isperformed first, yielding a result of 2 (the remainder of the division of 5 by 2).Then, the result of this operation is subtracted from the integer 3. ….!

Q 12)< ?php
$x = 3 - 5 % 3;
echo $x;
?>
A. 2
B. 1
C. Null
D. True
E. 3 Answer A is correct.

Because of operator precedence, the modulus operation is
performed first, yielding a result of 2 (the remainder of the division of 5 by 2).
Then, the result of this operation is subtracted from the integer 3.

….!

Read more »

Posted in: Careers , computer , Interview , jobs info , Question and Answers

Basic MySql Database Questions with Answers | MySql Mostly Asked Question in Interview

Q 1 how to do login in mysql with unix shell

A: By below method if password is pass and user name is root
A# [mysql dir]/bin/mysql -h hostname -u root -p pass

Q 2 how you will Create a database on the mysql server with unix shell

A: mysql> create database databasename;

Q 3 how to list or view all databases from the mysql server.

A: mysql> show databases;

Q4 How Switch (select or use) to a database.

A: mysql> use databasename;

Q 5 How To see all the tables from a database of mysql server.

A: mysql> show tables;

Q 6 How to see table’s field formats or description of table .

A: mysql> describe tablename;

Q7 How to delete a database from mysql server.

A : mysql> drop database databasename;

Q 8 How we get Sum of column

A : mysql> SELECT SUM(*) FROM [table name];

Q9 How to delete a table

A : mysql> drop table tablename;

Q 10 How you will Show all data from a table.

A : mysql> SELECT * FROM tablename;

Q 11 How to returns the columns and column information pertaining to the designated table

A: mysql> show columns from tablename;

Q12 How to Show certain selected rows with the value “pcds”

A : mysql> SELECT * FROM tablename WHERE fieldname = “pcds”;

Q13 How will Show all records containing the name “sonia” AND the phone number ’9876543210′

A: mysql> SELECT * FROM tablename WHERE name = “sonia” AND phone_number = ’9876543210′;

Q 14 How you will Show all records not containing the name “sonia” AND the phone number ’9876543210′ order by the phone_number field.

A: mysql> SELECT * FROM tablename WHERE name != “sonia” AND phone_number = ’9876543210′ order by phone_number;

Q 15 How to Show all records starting with the letters ‘sonia’ AND the phone number ’9876543210′

A : mysql> SELECT * FROM tablename WHERE name like “sonia%” AND phone_number = ’9876543210′;

Q16 How to show all records starting with the letters ‘sonia’ AND the phone number ’9876543210′ limit to records 1 through 5.

A: mysql> SELECT * FROM tablename WHERE name like “sonia%” AND phone_number = ’9876543210′ limit 1,5;

Q 17 Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with r.

A :mysql> SELECT * FROM tablename WHERE rec RLIKE “^r”;

Q 18How you will Show unique records.

A: mysql> SELECT DISTINCT columnname FROM tablename;

Q 19 how we will Show selected records sorted in an ascending (asc) or descending (desc)

A : mysql> SELECT col1,col2 FROM tablename ORDER BY col2 DESC;
mysql> SELECT col1,col2 FROM tablename ORDER BY col2 ASC;

Q20 how to Return total number of rows.

A: mysql> SELECT COUNT(*) FROM tablename;

Q21 How to Join tables on common columns.

A: mysql> select lookup.illustrationid, lookup.personid,person.birthday from lookup left join person on lookup.personid=person.personid=statement to join birthday in person table with primary illustration id

Read more »

Posted in: Careers , computer , Interview , jobs info , Question and Answers