Computer Quiz on Database

Q. : 1   The first step in the transacton processing cycle is ___________

1) database operations 

2) audit

3) data entry 

4) user inquiry

5) None of these 

Q. : 2   In the information systems  concept, the output function involves __________

1) Capturing and assembling elements  that enter the system to be processed

2) Trans formation processes  that convert input into output

3) Transferring elements  that have been produced by a trans formation process  to their ultimate

destination

4) Monitoring and evaluating feedback to determine whether a system is  moving toward the achievement of its  goal

5) None of these 

Q. : 3   What SQL command can be used to delete columns  from a table ?

1) MODIFY TABLE Table Name DROP COLUMN Column Name

2) MODIFY TABLE Table Name DROP Column Name Column Name

3) ALTER TABLE Table Name DROP Column Name

4) 1 and 2

5) None of these 

Q. : 4   Which of the following modifications  may not succeed?

1) Changing a column data type from char to date

2) Changing a column data type from numeric to char

3) Both of the above actions  should succeed 

4) Neither of the above actions  will  succeed

5) None of these 

Q. : 5   Changing cardinalities  in a database is

1) A common database design task 

2) A rare database design task, but does  occur

3) A database design task that never occurs

4) Is  impossible to do, s o a new database must be constructed and the data moved into it

5) None of these 

Q. : 6  A regular subquery can be processed

1) From the top down 

2) From the bottom up

3) By nesting 

4) From the right up

5) None of these 

Q. : 7   How many copies  of the database schema are typically used in the redesign process  ?

1) One 

2) Two

3) Three 

4) Four

5) None of these 

Q. : 8   Which organizational  layer is  responsible for developing the goals  and strategies  as  outlined by the topmost level  of management?

1) Tactical  management 

2) Strategic management

3) Operational  management 

4) Non management employees

5) None of these 

Q. : 9   Which of the following is  collective information about customers , competitors , business  partners , competitive environments , and internal  operations ?

1) Aggregate Data 

2) External  Knowledge

3) Business  Intelligence (BI) 

4) Information Granularity

5) None of these 

Q. : 10   What term is  used to describe information coming into a computer that is  in bad form, or is  incorrect, and will  improperly affect the decision-making process ?

1) GIGO 

2) Tainted data

3) Dirty information 

4) Scrubbed data

5) None of these 

Answer:-

Q. 1 (3)	Q. 2 (1)	Q. 3 (3)	Q. 4 (1)	Q. 5 (1)
Q. 6 (2)	Q. 7 (3)	Q. 8 (2)	Q. 9 (3)	Q. 10 (1)

Read more »

Computer Quiz For SBI PO Exam

Q. : 1   Poor response times  are usually caused by

1) Process  busy 

2) High I/O rates

3) High paging rates 

4) Any of the above

5) None of these 

Q. : 2   Which of the following program is  not a utility?

1) Debugger 

2) Editor

3) Spooler 

4) all  of the above

5) None of these 

Q. : 3   What is  the full  form of CRT?

1) current ray tube 

2) current ray technology

3) cathode ray tube 

4) cathode ray technology

5) None of these 

Q. : 4   What do you call  the rules  of a programming language?

1) Procedures 

2) Login

3) Assembly 

4) Syntax

5) None of these 

Q. : 5   ____ trans forms  one interface into another interface

1) Program 

2) Software

3) Data 

4) compiler

5) None of these 

Q. : 6   A group of related items /section of program oding treated as  a unit is  referred as

1) Block 

2) Duplex

3) Street 1 

4) All  of the above

5) None of these 

Q. : 7   BLOB is

1) Binary Large Object 

2) Along bit string representing complex data

3) Object oriented language 

4) Only 1. and 2. are true

5) None of these 

Q. : 8   Broadband channel  is  the

1) The fastest carriers  where data transfer rates  is of 1 mi l l i on baud (bi ts /second) or more

2) The slower carriers  where data transfer rates  is of 56 k baud

3) Mus i cal  channel 

4) All  of the above

5) None of these 

Q. : 9   The following is  responsible for number of logical  records  in a physical  record

1) Blocking factor 

2) Block

3) Boolean algebra 

4) All  of the above

5) None of these 

Q. : 10   An operation in which data is  moved to a different location is  referred as

1) Block move 

2) Street move

3) Delete 

4) All  of the above

5) None of these 

Answer:-

Q. 1 (4)	Q. 2 (3)	Q. 3 (3)	Q. 4 (4)	Q. 5 (2)
Q. 6 (1)	Q. 7 (4)	Q. 8 (1)	Q. 9 (1)	Q. 10 (1)

Read more »

Computer Quiz For IBPS Exam

Q. : 1   IEEE has  defined the specifications  for a wireless  LAN, called _______, which covers  the physical  and data link layers .

1) IEEE 802.3 

2) IEEE 802.5

3) IEEE 802.11 

4) IEEE 802.2

5) None of these 

Q. : 2   In IEEE 802.11, a ___ is  made of stationary or mobile wireless  stations  and an optional  central  base station, known as  the access  point (AP).

1) ESS 

2) BSS

3) CSS 

4) all  of the above

5) none of the above 

Q. : 3   In IEEE 802.11, a BSS without an AP is  called an _________.

1) an adhoc architecture 

2) an infrastructure network

3) client server network 

4) either a or b

5) None of these 

Q. : 4   In IEEE 802.11, communication between two stations  in two different BSSs  usually occurs  vi a two ________.

1) BSSs 

2) ESSs

3) APs 

4) all  of the above

5) none of the above 

Q. : 5   In IEEE 802.11, a station with ________ mobility is  either stationary (not moving) or moving only inside a BSS.

1) no-transition 

2) BSS-transition

3) ESS-transition 

4) all  of the above

5) none of the above 

Q. : 6   It converts  accepted instructions  into machine language

1) input unit 

2) output unit

3) processing unit 

4) memory unit

5) None of these 

Q. : 7   By default the bottom margin in the word document is

1) 2 inch 

2) 1 inch

3) 3 inch 

4) 1.5 inch

5) None of these 

Q. : 8   A file name cannot contain in MS-Word database file

1) a letter 

2) number

3) underscore 

4) space

5) None of these 

Q. : 9   Selection of text involves  only

1) single word 

2) line or multiple line

3) paragraph or paragraphs  and complete document

5) None of these 

Q. : 10   ‘ Replace’  option is  available in

1) Edit menu 

2) File menu

4) All  of the above

3) Tools  menu 

4) Insert menu

5) None of these

Answer:-

Q. 1 (3)	Q. 2 (2)	Q. 3 (1)	Q. 4 (3)	Q. 5 (1)
Q. 6 (1)	Q. 7 (2)	Q. 8 (4)	Q. 9 (4)	Q. 10 (1)

Read more »

Computer Quiz For IBPS Exam

Q. : 1   Which of the following high-speed circuits  is  the fastest?

1) T1 

2) T2

3) T3 

4) DS3

5) None of these 

Q. : 2   What type of communication media is  the most widely used cabling for data transfer today?

1) Cat 5 

2) Twisted pair

3) Coaxial 

4) Optical  fiber

5) None of these 

Q. : 3   What type of network device allows  you to share your connection to the Internet with other computers  in your home?

1) Ethernet card 

2) NIC

3) Router 

4) Cat 5

5) None of these 

Q. : 4   A______________ i s  a microprocessor-based computing device.

1) Personal  computer 

2) Mainframe

3) Workstation 

4) Server

5) None of these 

Q. : 5   What type of network is  commonly used in a college lab environment?

1) WAN 

2) MAN

3) LAN 

4) CAN

5) None of these 

Q. : 6   What is  the term used to describe the amount of space you have to transmit to and from the Internet?

1) Internet speed 

2) Network speed

3) Router 

4) Bandwidth

5) None of these 

Q. : 7   The purpose of the primary key in a database is  to

1) Unlock the database 

2) Provide a map of the data

3) Uniquely identify a record 

4) Establish constraints  on database operations

5) None of the above 

Q. : 8   The instructions  that tell  a computer how to carry out the processing tasks  are referred to as  computer

1) Programs 

2) Processors

3) Input devices 

4) Memory modules

5) None of these 

Q. : 9   The ________________ is  the amount of data that a storage device can move from the storage medium to the computer per second.

1) Data migration rate 

2) Data digitizing rate

3) Data transfer rate 

4) Data access  rate

5) None of these 

Q. : 10   C, BASIC, COBOL and Java examples  of _languages .

1) Low-level 

2) Computer

3) System programming 

4) High-level

5) None of the above 

Q. 1 (4)	Q. 2 (1)	Q. 3 (3)	Q. 4 (1)	Q. 5 (3)
Q. 6 (4)	Q. 7 (2)	Q. 8 (1)	Q. 9 (3)	Q. 10 (2)

Read more »

Computer Quiz For IBPS Exam

Q. : 1   The _________ layer enables  the users  to access  the network.

1) transport 

2) application

3) datalink 

4) physical

5) None of these 

Q. : 2   TCP/IP is  a ______ hierarchical  protocol  suite developed ____ the OSI model .

1) seven-layer; before 

2) five-layer; before

3) six-layer; before 

4) five-layer; after

5) None of these 

Q. : 3   The _______ layer ensures  interoperability between communicating devices  through transformation of data into a mutual l y agreed upon format.

1) transport 

2) network

3) datalink 

4) presentation

5) None of these 

Q. : 4   A parabolic dish antenna is  a(n) _______ antenna.

1) omni directional 

2) bi directional

3) uni directional 

4) horn

5) None of these 

Q. : 5   The ________ layer is  responsible for the process -to-process  delivery of the entire message.

1) transport 

2) network

3) datalink 

4) physical

5) None of these 

Q. : 6   The ______ layer establishes , maintains , and synchronizes  the interactions  between communicating

devices .

1) trans port 

2) network

3) session 

4) physical

5) None of these 

Q. : 7   When the angle of incidence is  _______ the critical  angle, the light beam bends  along the interface

1) more than 

2) less  than

3) equal  to 

4) all  of above

5) None of these 

Q. : 8   Signals  with a frequency below 2 MHz us e _______ propagation

1) ground 

2) sky

3) line-of-sight 

4) all  of above

5) None of these 

Q. : 9   Signals  with a frequency between 2 MHz and 30 MHz us e ______ propagation

1) ground 

2) sky

3) line-of-sight 

4) all  of above

5) none of the above 

Q. : 10   Signals  with a frequency above 30 MHz us e _______propagation

1) ground 

2) sky

3) line-of-sight 

4) all  of above

5) None of these 

Answer:-

Q. 1 (2)	Q. 2 (2)	Q. 3 (4)	Q. 4 (3)	Q. 5 (1)
Q. 6 (3)	Q. 7 (3)	Q. 8 (1)	Q. 9 (2)	Q. 10 (3)

Read more »

Computer Quiz

Q. : 1   If a process  is  under statistical  control , then it is

1) Maintainable 

2) Measurable

3) Predictable 

4) Verifiable

5) none of these 

Q. : 2   In which circuit switching, delivery of data is  delayed because data must be stored and retrieved from RAM ?

1) Space division 

2) Time division

3) Virtual 

4) Packet

5) none of these 

Q. : 3   Which command is  the fastest among the following ?

1) COPY TO 

2) COPY STRUCTURE TO

3) COPY FILE 

4) COPY TO MFILE-DA T DELIMITED

5) none of these 

Q. : 4   Leaves  of which of the following trees  are at the same level  ?

1) Bi nary tree 

2) B-tree

3) A VL-tree 

4) Expression tree

5) none of these 

Q. : 5   The baud rate is

1) always  equal  to the bit transfer rate

2) equal  to twice the bandwidth of an ideal channel

3) not equal  to the signal ling rate

4) equal  to half of the bandwidth of an ideal channel

5) none of these 

Q. : 6   Which of the following file transfer protocols  use TCP and establishes  two virtual  circuits  between the local and remote server ?

1) FTP 

2) TFTP

3) TELNET 

4) NFS

5) none of these 

Q. : 7   Networks  that use different technologies  can be connected by using

1) Packets 

2) Switches

3) Bridges 

4) Routers

5) none of these 

Q. : 8   What deletes  the entire file except the file structure ?

1) ERASE 

2) DELETE

3) ZAP 

4) PACK

5) none of these 

Q. : 9   Which of the following is  the process  by which a user’ s  access  to physical  data in the application is  limited, based on his  privileges  ?

1) Authorization 

2) Authentication

3) Access  Control 

4) All  of these

5) none of these 

Q. : 10   If the executing program size is  greater than the existing RAM of a computer, it is  still  possible to execute the program if the OS supports :

1) Multi tasking 

2) virtual  memory

3) paging system 

4) all  of the above

5) none of the above 

Q. 1 (3)	Q. 2 (2)	Q. 3 (2)	Q. 4 (2)	Q. 5 (2)
Q. 6 (1)	Q. 7 (4)	Q. 8 (3)	Q. 9 (3)	Q. 10 (2)

Read more »

Computer Quiz For Upcoming Exam

Q. : 1   If the executing program size is  greater than the existing RAM of a computer, it is  still  possible to execute the program if the OS supports :

1) Multitasking 

2) virtual  memory

3) paging system 

4) all of the above

5) none of the above 

Q. : 2   An example of a universal  building block is  :

1) EX-OR Gate 

2) AND Gate

3) OR gate 

4) NOR Gate

5) None of these 

Q. : 3   An example of a layer that is  absent in broadcast networks  is

1) Physical  layer 

2) Presentation layer

3) Network layer 

4) application layer

5) None of these 

Q. : 4   The ATM cell  is  :

1) 48 bytes  long 

2) 53 bytes  long

3) 64 bytes  long 

4) 69 bytes  long

5) None of these 

Q. : 5   Congestion control  is  done by

1) Network layer 

2) Physical  layer

3) Presentation layer 

4) Application layer

5) None of these 

Q. : 6   IP address  in B class  is  given by:

1) 125.123.123.2 

2) 191.023.21.54

3) 192.128.32.56 

4) 10.14.12.34

5) None of these 

Q. : 7   Black box testing is  done

1) To show that s /w is  operational  at its  interfaces i .e. input and output.

2) To examine internal  details  of code

3) At client side 

4) all  of the above

5) None of the above 

Q. : 8   The unix command used to find out the number of characters  in a file is

1) nc 

2) wc

3) chcnt 

4) lc

5) None of these 

Q. : 9   A program is  located in the smallest available hole in the memory is  ______________

1) best-fit 

2) first-bit

3) worst-fit 

4) buddy

5) None of these 

Q. : 10   A page fault

1) is  an error specific page

2) is  an access  to the page not currently in memory

3) occur when a page program occur in a page memory

4) page used in the previous  page reference

5) None of these 

Answer:-

Q. 1 (2)	Q. 2 (4)	Q. 3 (3)	Q. 4 (2)	Q. 5 (1)
Q. 6 (2)	Q. 7 (1)	Q. 8 (2)	Q. 9 (1)	Q. 10 (2)

Read more »