 |
|
|
Verizon papers |
|
Verizon paper :2
---------------
Section I – Unix Programming
1) works as a command interpretor
A) Hardware B) Kernal C) Shell D) CPU
2) The major no for a floppy disk device is
A) 1 B) 3 C) 2 D) 4
3) chown
Changes the mode of operation to kernel mode
Creates a thread
Changes the users and/or group ownership of each given file
Creates a child process
4) lilo
Uninstalls the boot loader
Installs the boot loader
Is a login utility
Invokes a daemon to logoff
5) netdevice
Provides low level access to Linux network devices
Provides low level access to Linux storage devices
Provides an interface to communicate with graphic devices
None of the other option listed for this question
6) The process which terminates before the parent process exits, is called as
Zombie
Orphan
Child
None of the other option listed for this question
7) Context switch means
Kernel switches from executing one process to another.
Process switches from kernel mode to user mode.
Process switches from user mode to kernel mode.
None of the other option listed for this question
8) The following socket provides two way, sequenced,reliable and unduplicated flow of data with no record boundaries.
Sequential packet socket
Datagram socket
Stream socket
Raw socket
9) Identify the point(s) that is not true w.r.t.signals
Signals are software generated interrupts that are sent to a process when an event happens
Signal delivery is analogous to hardware interrupts in that a signal can be blocked from being delivered in the future. ( BUT NOT SURE)
Most signals are synchronous by nature.
Most signal cause termination of the receiving process if no action is taken by the process in response to the signal.
10) Identify the point(s) that is true wrt Semaphore
Only one process at a time can update a semaphore.
All the other options listed for this question
They are often used to monitor and control the availability of system resources such as shared memory segments.
Is a process with exclusive use of a semaphore terminates abnormally and fails to undo the operation or free the semaphore, the semaphore stays locked in
the state the process left it.
RDBMS
1) When a single entity is related to itself then the relationship is termed as
ONE –TO-ONE
ONE-TO-MANY
RECURSIVE
MANY-TO-MANY
2) means allowing objects of different types to be considered as examples of higher level set
AGGREGATION
SPECIALIZATION
GENERALIZATION
DECOMPOSITION
3) The primary characteristic of a key field as that it must be
A NAME
TEXT
UNIQUE BUT NOT SURE)
ALL OF THE OTHER OPTION LISTED FOR THIS QUESTION
4) What kind of relationship exist between customers and salespersons if each customer may have one or more salespersons, and each salesperson may have one or more customers?
one-to-one
one to many
many to many
many to one
5) The following is a valid SET operation.
Join
Insert
Select
Difference
6) means allowing objects of different types to be considered as example of a higher level set.
Aggregation
Specialization
Generalization
Decomposition
7) A relation R is said to be in the , if it is in BCNF and there are non-trivial multi valued dependencies.
1st NF
2nd NF
3rd NF
4th NF
8) A occurs when a weak entity does not have a candidate key and its instances are indistinguishable without a relationship with another entity.
Existence dependency
Identifier dependency
Referential dependency
None of the other option listed for this question
9) is / are sample(s) of data model.
Relational
Rational
Entity- relationship
None of the other option listed for this question
10) In hierarchical database,
There is one to many relationship
A child may have more than one parent
A parent may have more than one child
There is no restriction on the number of parents a child may have or the number of children a parent may have
11) The term “inner join” refers to:
Joins between two tables in the same schema.
An equality join based on one column from each table.
A table joined with itself.
A Cartesian product join.
12) Which type of join is used in this query?
SELECT last_name “Name”, hire_date “Hire Date”, loc
“Location”
FROM employee, department
WHERE employee.deptno = department.deptno.
Outer join
Self join
Equijoin
Non-equijoin
13) A sales database has two table – SALESPERSON and
CUSTOMERS as below:
SALESPEOPLE
--------------------
snum NUMBER
sname VARCHAR2(10)
CUSTOMER
--------------------
snum NUMBER
cname VARCHAR2(10)
The management wants to know the mapping of salespersons to their customers without excluding those salespersons that are not currently assigned.
What would be the most appropriate condition, which can be applied on the Query to accomplish the above task?
salespeople.snum(+) = customers.snum
salespeople.snum = customers.snum(+)
salespeople.snum = customers.snum
salespeople.snum(+) = customers.snum(+)
14) join returns those rows from a table which have no direct match in the other table.
Outer join
inner join
Equijoin
Self join
15) To produce a meaningful result set without any Cartesian products, what is the minimum number of conditions that should appear in the WHERE clause of a four table join?
1
4
2
8
Further there were question from MATHS (in aptitude section), testing the working knowledge of WIN NT (how to change the page file size etc), then general terms related to computers like WORM, Trojan Horse etc.