Partner Sites
Concor India Model Question Paper For The Post Of Assistant Supervisor (MIS)
Professional Knowledge (Objective Questions):
Q1.RAID is used for providing fault tolerence by
a)using multiple hard disk
b)using separate SERVERS
c)using multiple Tape drives
d)None of the above
Q2.The following file actually creates the database
a)cr_ccl.sql
b)initcclo.ora
c)initccl.ora
d)configccl.ora
e)None of these
Q3.The following function is used to trap the error in the exception section
a)SQLERRM
b)LPAD
c)TRAP
d)None of the above
Q4.The maximum limit for identifiers in Oracle is
a)20
b)60
c)30
d)35
Q5.Port 80 is used for
a)HTTP webserver connection
b)FTP connection
c)Telnet connection
d)All of the above
Q6.Reserved loopback IP address is
a)128.0.0.1
b)255.255.255.0
c)127.0.0.1
d)255.0.0.1
Q7.In UNIX the following command is used to list all the files in director as well as all the files in its sub-directories:
a)Is âX
b)Is ât
c)Is âr
d)Is âI
Q8.Which of the following is considered a broadband communications channel?
a)coaxial cable
b)fiber optic cable
c)microwave circuits
d)satellite systems
e)all of the above
Q9.Which of the following can perform protocol conversion?
a)Router
b)Gateway
c)Repeater
d)Bridge
Q10.SQL is used for which of the following
a)Querying data
b)Inserting and updating projects
c)Modifying database objects
d)All of the above
Professional Knowledge (Descriptive Questions)
Q1.What is the difference between application layer and presentation layer?
Q2.Explain NVL2 Function in Oracle ?
Q3.Give five functions of Firewall ?
Q4.What is the difference between TCP and UDP ?
Q5.Give an example for open_form with parameter passing from one form to another form in D2K?
Q6.What is the main difference between schema in RDBMS and schemas in DataWarehouse?
Q7.What is the difference between view and materialized view?
Q8.What is ER Diagram ?
Q9.What is the Difference between Intel Core 2 duo & Dual Core & which one is better for processing?
Q10.What is the difference between the Physical drive and the Logical Drive.How do we Identify? How do to configure the logical drive ?
Q11.What is an interrupt? Explain with examples ?
Q12.What is the difference among deadlock avoidance, detection and prevention?
Q13.What are the different types of schedulers in Operating System?
Q14.Explain Key Flex Fields in Oracle Apps ?
Q15.What are context sensitive segments in descriptive flexfields?
