10 Important Questions of Operating System

      Click Here For Quiz

IT Officer Quiz with Answer Explanation

IT Officer Important Questions Quiz with Answers Explanation.......

        Click Here For Quiz

Computer Network MCQ

Click Here For Computer Network MCQ

Banking Awareness Quiz

Click Here For Banking Awareness Quiz

10 MCQ of Computer Networks.....

1)In the Ethernet network, What method is used to access the media?
a)Demand priority
b)CSMA/CD
c)Polling
d)CSMA/CA
e)None of these

2)Which of the following Ethernet components is unique for each card created?
a)Frame Type
b)CRC Address
c)IRQ
d)MAC Address
e)None of these

3)ALOHA
a)is used for channel allocation problem
b)is use of data transfer
c)is buffering
d)all of the above
e)None of these

4)Which project 802 standard provides for a collision free protocol?
a)802.2
b)802.3
c)802.5
d)802.4
e)None of these

5)Unnumbering frame in HDLC are used for
a)Unnumbering a frame
b)Deleting a frame
c)System Management
dAdding frame 
e)None of these

6)The store and forward mechanism is used in..................
a)Packet switching
b)Message switching
c)Circuit switching
d)Datagram switching
e)None of these

7)Which one is the least expensive that can support 100Mbps?
a)Coaxial
b)UTP
c)Fibre-optic
d)STP
e)None of these

8)Broadband uses
a)Manchester encoding
b)FSK encoding
c)ASK encoding
d)PSK encoding
e)None of these

9)In CRC Checking, the divisor is ..............the CRC
a)One bit less than
b)One bit more than
c)The same size as
d)These bits more than
e)None of these

10)In the 1-persistent approach when a station finds an idle line, it...............
a)Waits 1s before sending
b)It waits for a random amount of time
c)Its sends immediately
d)Its sends 0.1 sec before sending
e)None of these



Answers:
1)b
2)d
3)a
4)c
5)c
6)b
7)b
8)d
9)b
10)c

10 Previous Year MCQ of DBMS

1)Which privilege is required to create a database?
(A) SYSDBA
(B) DBA
(C) SYSOPER
(D) RESOURCE

2)Which Normal Form(NF) is considered adequate for normal relational database design?
(A) 2NF
(B) 5NF
(C) 4NF
(D) 3NF

3)A Foreign key in one table points to a ________ key in another table.
(A) Alternate
(B) Default
(C) Primary
(D) None of the above

4)In SQL, the spaces at the end of the string are removed by _______ function 
(A) Lower
(B) String
(C) Trim
(D) None of the above

5)The highest level in the hierarchy of data organization is called________
(A) data base
(B) data file
(C) data record
(D) None of the above

6)_______ is the process of organizing data into related tables.
(A) Generalization
(B) Normalization
(C) Specialization
(D) None of the above

7)Which of the following keyword can be used to return different values?
(A) SELECT
(B) GET
(C) OPEN
(D) DISTINCT

8)Which of the following field type is used to store photograph of employees?
(A) Memo
(B) Picture
(C) OLE
(D) Photo

9)Which of the following is standard interactive and programming language for getting information from and updating a database.
(A) SQL
(B) PHP
(C) ASP
(D) None of the above

10)Which TCL command is used to permanently save any transaction into database?
(A) rollback
(B) savepoint
(C) commit
(D) None of the above




Answers:
1)a
2)d
3)c
4)c
5)a
6)b
7)d
8)c
9)a
10)c

10 Important MCQ Of Oracle....

1)The shared pool is also able to support ________ in data warehousing applications.
A. Unshared SQL
B. Stored SQL
C. Unsorted SQL
D. Shared SQL 
E. None of these

2)An important purpose of the shared pool is to cache the executable versions of _________ statements.
A. SQL
B. PL/SQL 
C. Both (A) and (B)
D. MS ACESS
E. None of these

3)___________ Database is the only database specifically designed as an Internet development and deployment platform
A. Oracle 8i 
B. Oracle 9i
C. Oracle 6i
D. Oracle 7i 
E. None of these

4)Oracle 9i Reports is the solution of _______
A. Paper publishing
B. Web publishing
C. Both (A) and (B)
D. Publishing is not possible
E. None of these

5)When a query is submitted to oracle server for execution, oracle checks if same query has been executed previously. If found the same then this event is known as ________
A. Library cache hit
B. Soft parsing
C. Both (A) and (B)
D. Redo log
E. None of these

6)The ________ performs recovery when a failed instance starts up again.
A. Log Writer(LGWR)
B. Checkpoint(CKPT)
C. Process Monitor(PMON) 
D. System Monitor(SMON)
E. None of these

7) Oracle 9i Reports gives us _______options for building a Web report.
A. two
B. three
C. four
D. five
E. None of these

8)Which of the following is an example for Embedded SQL Statement?
A. ROLLBACK
B. SETROLE
C. ALTER SYSTEM
D. FETCH
E. None of these

9)Oracle Database segregates a small amount of the shared pool for large objects(Over 5KB).The segregated area of the shared pool is called ______
A. Fixed Pool
B. Allocated Pool
C. Reserved Pool
D. All of the above
E. None of the above

10)The ______ process is used for inter-instance locking in Real Application Clusters.
A. Lock Manager Server
B. Back Manager Server
C. Front Manager Server
D. Administration Manager
E. None of these



Answers:
1)a
2)c
3)b
4)c
5)c
6)d
7)a
8)d
9)c
10)a

10 Previous Year Questions of Software Engineering

1)Which of the following is a phase of RAD model?
a)Business modelling
b)Data modelling
c)Application generation
d)All of the above
e)None of these

2)The UML Designation for a public class member is 
a)the symbol @
b)the symbol #
c)the minus symbol(-)
d)the plus symbol(+)
e)the word public

3)A cross life-cycle activity of system development is 
a)Data modelling
b)Fact finding
c)Prototyping
d)Data Flow Diagram modelling
e)Object Modelling

4)The term module in the design phase refers to 
a)Functions 
b)Procedures
c)Sub programs
d)All of the above
e)None of these

5)The objective of testing is 
a)Debugging
b)To uncover errors
c)To gain Modularity
d)To analyze system
e)None of these

6)Software testing techniques are most effective if applied immediately after 
a)Requirement specification
b)Design
c)Coding
d)Integration
e)None of the above

7)If limited user participation is available, which model is to be selected
a)Waterfall Model
b)Spiral Model
c)Iterative Model
d)Any of the above
e)None of these

8)Which of the following is the phase of SDLC in which the identified requirements are incorporated into the new system's design?
a)Maintenance
b)Physical Layout
c)Requirement Design
d)System Design
e) System Blueprint

9)Milestones are used to 
a)know the cost of the project
b)know the status of the project
c)know the user expectations
d)All of the above
e)None of these

10)Software Quality is 
a)Conformance to requirements
b)Fitness for the purpose
c)Level of satisfaction
d)All of the above
e)None of these



Answers:
1)d
2)d
3)b
4)d
5)b
6)b
7)d
8)b
9)a
10)d

10 Previous Year Questions of DBMS

1)Each block of B tress of order 'n' can have
a)n-1 key values, and n pointers
b)n+1 key values, and n pointers
c)n key values, and n+1 pointers
d)Cannot be determined

2)Which normal form is considered adequate for relational database design?
a)2NF
b)3NF
c)4NF
d)BCNF

3)The concept of locking can be used to solve the problems of 
a)Lost Updates
b)Uncommited dependency
c)Inconsistent data
d)All of the above

4)When the number of buckets or the bucket address range changes with file, it is called 
a)Hashing
b)Extendable Hashing
c)Inverted index Hashing
d)None of the above

5)Blocking factor is applicable for .............. organization
a)Spanned
b)Un-spanned
c)Both 
d)None

6)A correlate sub-query always executes in
a)Top-Bottom
b)Bottom-Top
c)Top-Bottom-Top
d)None of these

7)Access time in B+ trees 
a)Varies
b)Constant
c)Cannot say
d)Both a and b

8)The five aggregation operations in SQL is 
a)SUM, AVG, IN ALL, ANY
b)SUM, AVG, MIN, MAX, DISTINCT
c)SUM, AVG, MIN,MAX,COUNT
d)SUM, AVG,IN, DISTINCT,COUNT

9)Deadlock in database system is an example of...
a)User error
b)Consistency error
c)System error
d)None of these

10)Which language is used to define the integrity constraints?
a)DDL
b)DML
c)DCL
d)None of these



Answers:
1)a
2)b
3)d
4)b
5)b
6)c
7)b
8)c
9)c
10)a

10 Previous Year questions of Computer Networks

1)What kind of scheme is the HTTP protocol?
a)get/put
b)store/forward
c)queuing
d)search/return
e)request/response

2)Which of the following is used for integrity?
a)DES
b)Diffie-Hellman
c)SED
d)AES
e)MD5

3)Which tool is used to test serial and parallel ports?
a)high volt probe
b)cable scanner
c)loop backs(wrap plugs)
d)sniffer
e)None of these

4)TCP is
a)reliable connection oriented protocol 
b)unreliable connection oriented protocol
c)reliable connection less protocol
d)unreliable connectionless protocol
e)None of these

5)What is the name of protocol used in eliminate loops?
a) Switching                            
b) ISL
c) Frame tagging                   
d) Spanning Tree Protocol
e) None of these


6)Print server uses ........which is a buffer that holds before it is send to the printer
a)Queue
b)Spool
c)Node
d)Stack
e)None of these

7)If you want to locate the hardware address of a local device, which protocol would you use?
a)ARP
b)RARP
c)ICMP
d)PING
e)PONG

8)Which of the following function is not performed by TCP?
a)Flow Control
b)Sequencing
c)Error Checking
d)Subnetting
e)None of these

9)A communication medium where data are transformed into light pulses is
a)Coaxial Cable
b)Optical Fibre
c)Satellite
d)Twisted-pair Cable
e)Copper Cable

10)FDDI is 
a)Ring Network
b)Star Network
c)Mesh Network
d)Bus Based Network
e)None of these




Answers:
1)e
2)e
3)c
4)a
5)d
6)b
7)a
8)d
9)b
10)a

10 Previous Year Questions of Computer Networks..

1)Frame Relay

a)does not use error correction routine

b)is used by facsimile machines

c)uses error correction routines

d)does not work weel on the internet

e)is an outdated technology

2)At......... layer,TCP/IP defines two protocols: Transmission Control Protocol and User Datagram Protocol(UDP)

a)Transport Layer

b)Network Layer

c)Physical Layer

d)Application Layer

e)None of these

3)The ........layer is the layer closest to transmission medium.

a)Transport

b)Network

c)Data Link

d)Physical

e)None of these

4)Which protocol does ping use?

a)TCP

b)ARP

c)ICMP

d)BootP

e)None of these

5)How many collision domains are created when you segment a network with a 12 port switch?

a)1

b)2

c)5

d)12

e)None of these

6)Synchronous optical network(SONET)

a)It provides away to multiplex digital channels together

b)It consists of switches, multiplexes and repeaters all connected by fiber

c)Sonet can be meshed but is often dual ring

d)All of the above

e)None of these

7)Packages are used

a)to avoid name collision

b)to determine the accessibility of variables

c)to fast retrieving

d)All of the above

e)None of these

8)What is main reason for OSI model creation

a)To create a layered model larger than the DoD model

b)Application developers can change only one layers protocol at a time

c)So different networks could communicate

d)Cisco could use the model

e)None of these

9)Which of the following forms does not describe parallel ATA devices

a)SCSI

b)IOE and DOE

c)IOE

d)DOE

e) ATA

10)Which of the following could be a legitimate Media Access Control Address

a)192.168.254.3

b)3FA2.4756.F9A3

c)A5514

d)C1.3A.77.5B

e)None of these

Answers:

1)a

2)a

3)d

4)c

5)d

6)d

7)a

8)c

9)a

10)d

10 Previous Year Questions of DBMS...

1)Locking may cause which of the following problems?
a)Deadlock
b)Versioning
c)Versioning & deadlock
d)Erroneous updates
e)Erroneous updates and deadlock

2)Which of the following are placeholders for literal values in a SQL query being sent to the database?
a)reduction and resolution variables
b)resolution variables
c)reduction variables
d)assimilation variables
e)bind variables

3)What is meant by type in RDBMS?
a)Domain
b)Range
c)Named set of value
d)Both a and c
e)None of these

4)What are the function of DCL?
a)handling the authorization aspects of data
b)permitting the user to control who has access to see or manipulate data within the database  
c)both a and b
d)a only
e)None of these

5)Which database level is closest to the users?
a)External
b)Internal
c)Physical
d)Conceptual
e)None of these

6)Fifth Normal Form is concerned with
a)Functional dependency
b)Multi-valued Dependency
c)Join Dependency
d)Domain Key
e)None of these

7)In E-R diagram, the term cardinality is a synonym for the term.........
a)Attributes
b)Degree
c)Entities
d)Cartesian
e)None of these

8)Rows of a relation are called:
a)Relation
b)Tuples
c)Data Structures
d)An entity
e)None of these

9)An Oracle server index---------
a)Is a schema object
b)Is used to speed up the retrieval of rows by using a pointer
c)Is independent of the table its indexes
d)All of the above
e)None of these

10)In Oracle, what is the default number of transactions that MAXTRANS is set to if not specified?
a)512
b)10
c)40
d)1
e)255



Answers:
1)a
2)e
3)d
4)c
5)a
6)c
7)b
8)b
9)d
10)e

10 Previous Year Questions of Computer Networks.....

1)Common Gateway Interface(CGI) is which of the following?
a)An interface that accepts and returns a data that may be written in SQL
b)A small program that executes within other application and is stored on the server
c)A small program that executes within other application and is stored on the client.
d)A small program that executes within other application 
e)An Interface that accepts and returns data that may be written in any language that produce executable file

2)...........is a standard for security that is inclined at the network or packet processing layer of network communications, as opposed to the application layer
a)Passive FTP
b)TCP
c)IPSec
d)S-HTTP
e)SSL

3)In addition to an internet connection, which of the following is needed to ?
a)Telnet client
b)Scanner
c)Mail Client
d)HP Client
e)Web Browser

4)Which amongst the following is not an advantage of distributed system?
a)Reliability
b)Incremental Growth
c)Resource Sharing
d)Low Cost
e)None of these

5)Link Encryption
a)is more secure than end to end encryption
b)is less secure than end to end encryption
c)cannot be used in public network
d)is used only to debug
e)None of these

6)Which of the following OSI level is more closely related to the physical communications facilities?
a)Application
b)Session
c)Network
d)Data link
e)None of these

7)Handshaking is 
a)Synchronous type
b)asynchronous
c)Sequential
d)All of the above
e)None of these

8)Which of the following is a variation of Frequency Division Multiplexing(FDM)?
a)Time Division Multiplexing(TDM)
b)Pulse Code Multiplexing(PCM)
c)Wavelength Division Multiplexing
d)All of above 
e)None of these

9)What is ISL used for?
a)To allow an Ethernet interface to understand frame tags
b)To make two Ethernet interfaces appear as one
c)To connect an Ethernet switch with a high-speed core switch such as ATM
d)To allow simultaneous routing and switching
e)None of these

10)Which uses a Pre Shared Key that is more than 7 and less than 64 characters in length?
a)WPA-PSK
b)TKIP
c)AES
d)All of the above
e)None of these



Answers:
1)e
2)e
3)e
4)a
5)b
6)d
7)a
8)c
9)a
10)d

10 Previous Year Questions Of DBMS

1)A set of programs that handle firm's database responsibilities is called a
a)Database Management System(DBMS)
b)Database Processing System(DBPS)
c)Data Management System(DMS)
d)All of the above
e)None of these

2)Which of the following is used with database?
a)EDI
b)Credit card
c)ATM
d)Payment Gateway
e)Data mining

3)In Oracle, who owns the data dictionary?
a)Oracle
b)SYS
c)The DBA
d)System
e)None of these

4)The language used in application programs to request data from the DBMS is referred to as the
a)DML
b)DDL
c)Query Language
d)DCL
e)None of these

5)An indexing operation 
a)Sorts a file using a single key
b)Sorts file using two keys 
c)Establishes an index for a file
d)Both a and c
e)None of these

6)In SQL, which command is used to changes data in a data table?
a)Update
b)Insert
c)Browse
d)Append
e)None of these

7)An Oracle server index........
a)Is a schema object
b)Is used to speed up the retrieval of rows by using a pointer
c)Is independent of the table it indexes
d)All of the above
e)None of these

8)Aggregation is special form of ........
a)Object
b)Specialization
c)Generalization
d)Association
e)None of these

9)Which command is used to redefine a column of the table in SQL?
a)Alter Table
b)Modify Table
c)All of the Above
d)Define Table
e)None of these

10)Data mining evolve as a mechanism to cater the limitations of ..........system to deal massive data sets with high dimensionality, new data type, multiple heterogenous data resources etc.
a)OLTP
b)OLAP
c)DSS
d)DWH
e)None of these



Answers:
1)d
2)e
3)b
4)a
5)c
6)a
7)d
8)d
9)a
10)a

MCQ Of Editorial Vocabulary

1)Deficit
a)Success
b)Satisfaction
c)Shortage
d)Excess

2)Conceive
a)loss
b)Understand
c)Fail
d)Avoid

3)Intervene
a)Ignore
b)Leave
c)Connect
d)Interfere

4)Hasty
a)Careful
b)Speedy
c)Thoughtful
d)Lingering

5)Distress
a)Agony
b)Cheer
c)Miracle
d)Benefit


Answers:
1)c
2)b
3)d
4)b
5)a

Click Here For Detail Answers