Verizone

Pattern: 7 papers test for more than 2 hrs 1.analytical 2.quantitative ability 3.verbal 4.c++ 5.windows NT 6.RDBMS 7.UNIX next shortlisted candidates undergo technical and HR interviews PAPER: Verizon 2003 paper.
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 supported by a PC is _______A) 1 B) 3 C) 2 D) 4
3) chown A) Changes the mode of operation to kernel modeB) Creates a threadC) Changes the users and/or group ownership of each given fileD) Creates a child process
4) liloA) Uninstalls the boot loaderB) Installs the boot loaderC) Is a login utilityD) Invokes a daemon to logoff
5) The process which terminates before the parent process exits, is called as A) ZombieB) OrphanC) ChildD) None of the other option listed for this question
6) Context switch means A) Kernel switches from executing one process to another.B) Process switches from kernel mode to user mode.C) Process switches from user mode to kernel mode.D) None of the other option listed for this question
7) The following socket provides two way, sequenced, reliable andunduplicated flow of data with no record boundaries.A) Sequential packet socketB) Datagram socketC) Stream socketD) Raw socket
8) Identify the point(s) that is not true w.r.t. signalsA) Signals are software generated interrupts that are sent to a process whenan event happensB) Signal delivery is analogous to hardware interrupts in that a signal canbe blocked from being delivered in the future.C) Most signals are synchronous by nature.D) Most signal cause termination of the receiving process if no action istaken by the process in response to the signal.
9) Identify the point(s) that is true wrt SemaphoreA) Only one process at a time can update a semaphore.B) All the other options listed for this questionC) They are often used to monitor and control the availability of systemresources such as shared memory segments.D) Is a process with exclusive use of a semaphore terminates abnormally andfails to undo the operation or free the semaphore, the semaphore stayslocked in the state the process left it.
*********************************************************************These were the questions received from other colleges but our question paper includedmore shell programming commands and output of some procedures involving those commands.If you are strong in SHELL PROGRAMMING you can easily pass this paper. *********************************************************************RDBMS
1) When a single entity is related to itself then the relationship is termedas A) ONE -TO-ONEB) ONE-TO-MANYC) RECURSIVED) MANY-TO-MANY
2) means allowing objects of different types to be consideredas examples of higher level setA) AGGREGATIONB) SPECIALIZATIONC) GENERALIZATIOND) DECOMPOSITION
3) The primary characteristic of a key field as that it must beA) A NAMEB) TEXTC) UNIQUED) ALL OF THE OTHER OPTION LISTED FOR THIS QUESTION
4) What kind of relationship exist between customers and salespersons ifeach customer may have one or more salespersons, and each salesperson mayhave one or more customers?A) one-to-oneB) one to manyC) many to manyD) many to one
5) The following is a valid SET operation.
A) JoinB) InsertC) SelectD) Difference
6) means allowing objects of different types to be consideredas example of a higher level set.A) AggregationB) SpecializationC) GeneralizationD) Decomposition
7) A relation R is said to be in the , if it is in BCNF andthere are non-trivial multi valued dependencies.A) 1st NFB) 2nd NFC) 3rd NFD) 4th NF
8) A occurs when a weak entity does not have acandidate key and its instances are indistinguishable without a relationshipwith another entity.A) Existence dependencyB) Identifier dependencyC) Referential dependencyD) None of the other option listed for this question
9) is / are sample(s) of data model.A) RelationalB) RationalC) Entity- relationshipD) None of the other option listed for this question
10) In hierarchical database,A) There is one to many relationshipB) A child may have more than one parentC) A parent may have more than one childD) There is no restriction on the number of parents a child may have or thenumber of children a parent may have
11) The term "inner join" refers to:A) Joins between two tables in the same schema.B) An equality join based on one column from each table.C) A table joined with itself.D) 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, departmentWHERE employee.deptno = department.deptno.A) Outer joinB) Self joinC) EquijoinD) Non-equijoin
13) A sales database has two table - SALESPERSON and CUSTOMERS as below:
SALESPEOPLE------------------------------------------------------snum NUMBERsname VARCHAR2(10)
CUSTOMER------------------------------------------------------snum NUMBERcname VARCHAR2(10)
The management wants to know the mapping of salespersons to their customerswithout excluding those salespersons that are not currently assigned. Whatwould be the most appropriate condition, which can be applied on the Queryto accomplish the above task?
A) salespeople.snum(+) = customers.snumB) salespeople.snum = customers.snum(+)C) salespeople.snum = customers.snumD) salespeople.snum(+) = customers.snum(+)
14) join returns those rows from a table which have nodirect match in the other table.
A) Outer joinB) inner joinC) EquijoinD) Self join
15) To produce a meaningful result set without any Cartesian products, whatis the minimum number of conditions that should appear in the WHERE clauseof a four table join?
A) 1B) 4C) 2D) 8
16)Output of 'select Instr(Decode(str1,str2,-1)) from dual'A) B) C) D) were single digit numbers
*****************************************************MATHEMATICS
Quantitative -- Problems involoving Venn Diagrams , Completion of series etc. (30 MIN)Analytical -- Alligation or mixture problems, Problem on Ages(10 MIN)Verbal -- Two Comprehension passages, Antonym , Sentence completion(10 MIN)
Example for sentence completionI got ___________ in the traffica. stuck upb. struckc. Both a and bd. None of these***************************************************** WINNT(10 MIN)
1. Which tag will you select for changing the page size?(below will be displayed a screen shot of CONTROL PANEL SETTINGS for changing the page size)Ans:Performance
NOTE: The questions in this section might contain multiple answers and you aresupposed to shade all the correct answers.*****************************************************C++(30 MIN)
TOPICS COVERED1. Input-output stream2.Templates3.Abstract classes4.Virtual Functions
*****************************************************Further there were question testing general terms related to computers like WORM, Trojan Horse etc.