Section A) Linux Questions:1) What command is used to search a file in a linux server in dynamic conditions as well?

a) locate b) search c) grep d) find

2) Which file consists of Unix users present in a server? a) /etc/users b) /usr/local c) /etc/passwd d) /etc/usr

3) Which command is used to schedule tasks repeatedly? a) crontab b) repeat c) schedule d) at

4) Which command is used to check the disk space?

a) dd l

b) dl l

c) df lh d) ds l

5) Which command is used to display the ip details of a server?

a) ifcfg b) ifconfig c) iplist d) ipconfig

6) Which command is used to search a text sample in a file a.txt from command prompt?

a) Print sample a.txt b) Search sample a.txt c) Grep sample a.txt d) Cat sample a.txt

7) What command is used to find the system summary?

a) system sum b) sum system c) top d) less

8) What default permissi7on does u need to open a directory?

a) rwx

b) w c) r d) x

9) Which of the following command(s) will show a list of the files in your home directory including hidden files and the contents of all subdirectories? Choose one: a. ls -c home b. ls -aR /home/username c. ls -aF /home/username d. ls -l /home/username

10) How do you copy an entire directory structure? Eg from task to tak.backup a) Cp r task task. Backup b) Cp e c) Cp d d) Cp s

11)

Which command is used to check the process running in the system? d) ls a

a) Pd a b) ps a c) process e

12)

Which command is used to show the current working directory?

a) Cwd b) dwd c) pwd d) None of the above

13)

What does this command do chmod go +rw?

a) Gives the file called go, read and execute permission on all files in the current directory. b) Gives Groups others read and execute permission on all files in the current working directory c) Gives read + execute permission on all files were execute access in already set d) Gives file named go read + execute permission on all files in the current working directory only.

14)

How do you add a user in linux?

a) adduser b) addusr c) useradd d) usradd

15)

Which command is used to convert Dos into Linux format?

a) Dos2unix b) unix2dos c) Dos2Linux d) All of the Above

Section B: Database Question:

a) Structured Query Language b) Strong Question Language c) Structured Question Language

d) None of the Above

2) Which SQL statement is used to extract data from a database? a) SELECT Ans) select b) GET c) OPEN d)EXTRACT

3) Which of the following is not a CONSTRAINT? a) CHECK b) IN c) NOT NULL d) UNIQUE

4) Which clause is used to display the records in a table either in ascending or descending values. a) GROUP BY b) ORDER BY c) LIST BY d) LIST ORDER BY Ans) order by

5) Which SQL statement is used to insert new data in the database? a) ADD RECORD b) ADD NEW c) INSERT d) INSERT NEW Ans) insert 6) With SQL, how do you select a column named Firstname from a table named Persons? a) SELECT Persons.Firstname b) EXTRACT Firstname From Persons

c) Select Firstname from Persons d) None of the above Ans) c

7) Write a basic syntax of create table command (with different data types at least one constraint.
Ans) create table employee (first varchar(15), last varchar(20), age number(3), address varchar(30), city varchar(20), state varchar(20));

8) What is the use of COMMIT and ROLLBACK? Ans) To make the changes done in a transaction permanent issue the COMMIT statement.

To rollback the changes done in a transaction give rollback statement. Rollback restore the state of the database to the last commit point. Example : delete from emp; rollback;

9) With SQL, how do you select all records from a table named Persons where the value of the column Firstname starts with an abc? a) SELECT * from Persons WHERE FIRSTNAME LIKE %abc b) SELECT * FROM Persons where Firstname=abc c) SELECT * FROM PERSONS WHERE FIRSTNAME Like %abc% d) SELECT * FROM Persons WHERE FIRSTNAME=abc%

Ans) c

10) The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions are listed are true. a) False b) True Ans) true

11)

Which SQL Statement is used to avoid duplicate records?

a) SELECT DIFFERENT b) SELECT DISTINCT c) SELECT UNIQUE d) SELECT DIFF Ans) b

12)

What is a Primary Key?

Ans) A primary key is used to uniquely identify each row in a table.

13)

What is difference between where clause and a having clause?

Ans) 1. The WHERE clause specifies the criteria which individual records must meet to be selcted by a query. It can be used without the GROUP BY clause. The HAVING clause cannot be used without the GROUP BY clause. 2. The WHERE clause selects rows before grouping. The HAVING clause selects rows after grouping. 3. The WHERE clause cannot contain aggregate functions. The HAVING clause can contain aggregate functions 14) 15) Difference Between Truncate and Delete? What is the use of indexing the tables?

Section C:
Logical and Analytical Questions :

1 ) Fifty Minutes ago if it was four times as many minutes past three o' clock , how many minutes is it to six o' clock ? a ) 26 minutes b ) 30 minutes c ) 25 minutes d ) 28 minutes e ) none of the above

2 ) 1 chocolate cost is Rs.1 & if we return 3 wrapers(covers) of chocolate we get 1 more chocolate. If u have Rs.15 how many chocolates do u get...? a)15 b)20 c)21 d) 22 ans) 20

3) Look at this series: 70, 71, 76, __, 81, 86, 70, 91, . . . What number should fill the blank? a. 70 b. 71 c. 80 d. 96 ans) 70 In this series, 5 is added to the previous number; the number 70 is inserted as every third number. 4) 4+5=41 5+6=61 6+7=? a) 71 b) 81 c)85 d) 95 Ans)71 5 ) Dakota: It is true that people have been allowed to receive a drivers license at sixteen for generations. However, in recent years, the increase in traffic means drivers face more dangers than ever and must be ready to respond to a variety of situations. The fact that schools can no longer afford to teach drivers education results in too many young drivers who are not prepared to face the traffic conditions of today.

On what does Dakota rely in making her argument? Ans: a. statistics b. emotion c. fairness d. anecdotes e. actualities

6) An employee has been assigned the task of allotting offices to six of the staff members. The offices are numbered 1 - 6. The offices are arranged in a row and they are separated from each other by six foot high dividers. Hence voices, sounds and cigarette smoke flow easily from one office to another. Miss Robert's needs to use the telephone quite often throughout the day. Mr. Mike and Mr.Brown need adjacent offices as they need to consult each other often while working. Miss.Hardy, is a senior employee and has to be allotted the office number 5, having the biggest window. Mr. Donald requires silence in the offices next to his. Mr. Tim, Mr. Mike and Mr. Donald are all smokers. Miss Hardy finds tobacco smoke allergic and consecutively the offices next to hers to be occupied by non-smokers. Unless specifically stated all the employees maintain an atmosphere of silence during office hours. i) The ideal candidate to occupy the office furthest from Mr. Brown would be (a) Miss Hardy (b) Mr. Mike (c) Mr. Tim (d) Mr. Donald (e) Mr. Robert ii) The three employees who are smokers should be seated in the offices. (a) 1, 2 and 4 (b) 2, 3 and 6 (c) 1, 2 and 3 (d) 1, 2 and 3 (e) 1, 2 and 6 7) JAUNDICE: LIVER a. rash : skin b. dialysis : kidney c. smog : lung d. valentine : heart e. imagination : brain 8) Make 69 using 1, 9, 9, 3 operators +,-,x,/ are allowed numbers are not to be repeated .

9) Frank is 15 years younger then John. In 5 years John will be twice as old as Frank. How old will Frank be in four years? a) 8 b) 10 c) 12 d) 14 e) 16 10) In a four-day period Monday through Thursday each of the following temporary office workers worked only one day, each a different day. Ms. Johnson was scheduled to work on Monday, but she traded with Mr. Carter, who was originally scheduled to work on Wednesday. Ms. Falk traded with Mr. Kirk, who was originally scheduled to work on Thursday. After all the switching was done, who worked on Tuesday? a) Carter b)Falk c) Johnson d) Kirk 1) Differentiate between a Port and Socket. 2) Explain in brief about DHCP and DNS 3) What are the different topologies present in networking? 4) Differentiate between a Router, a Bridge,a Switch, a Repeater and a Hub. 5) Explain the need and importance of Ipv6? 6) What is meant by a Frame Relay? 7) Briefly explain about RIP, OSPF and BGP. 8) What are the different types of switching present in networks? 9) Differentiate between Bit rate and Baud rate. 10) What are the different layers of OSI and give few examples of each layer . 11 12 13 What is IP datagram fragmentation and MTU? Larger the IP datagram less the overhead, is it true or false? Can you explain the concept of static and dynamic routing?

14) How can we interrelate IP and MAC addresses? 15) Differentiate between TCP and UDP 16) What are the different classes of IP addressing present in Ipv4. Explain in brief the use of Private and Public IP addresses. 17) Mention different types of acknowledgment techniques used in TCP?

18) Explain about ARP and RARP 19) What are the functionalities of bottom three layers of OSI model? 20) How can we change the MAC address of a system? SQL 1.What are the roles of SQL ?

2.Define candidate key, alternate key, composite key. 3.What is database replication? What replication you can set up in SQL Server? are the different types of

Ans) Database replication can be used on many database management systems,

4.Explain about BREAK and COMPUTE in SQL. Ans) BREAK and COMPUTE commands create subset of records and add space
and/or summary lines after each subset. The column you specify in a BREAK command is called a break column which suppresses duplicate values. By including the break column in your ORDER BY clause, you create meaningful subsets of records in your output. You can then add formatting to the subsets within the same BREAK command and add a summary (containing total, averages, and so on) by specifying the break column in a COMPUTE command.

5.How to select a last n records from a table ? Ans) From Oracle 9i onwards, the RANK() and DENSE_RANK() functions can be used to determine the TOP N rows. Examples:

Get the top 10 employees based on their salary

6.How to add new column in the existing table at our desired location? 7.Whats the output of the below query select * from emp where rowid in(select decode(rownum,2,rowid) from emp); 8. Table : Software
PNAME (VARCHAR), TITLE (VARCHAR), DEVIN (VARCHAR), SCOST (NUMBER), DCOST (NUMBER), SOLD (NUMBER)

Whats the output of the below query SELECT MAX(SOLD) FROM SOFTWARE; 9. Table: Programmer
PNAME (VARCHAR), DOB (DATE), DOJ (DATE), SEX (CHAR), PROF1 (VARCHAR), PROF2 (VARCHAR), SAL (NUMBER)

SELECT * FROM PROGRAMMER WHERE PROF1 IN (C',PASCAL) OR PROF2 IN (C',PASCAL); 10. NOTE: Use above table Write a query to update the salary of an employee whose service time is more than 6 months.