PLACEMENT INTERVIEW QUESTIONS WITH SOLUTION

A piece of message: prepare for every basic and conceptual questions . Interviewer mostly asking easy but tricky and conceptual questions so try to have a good command over all such questios..like. defintion of datastructure, abstraction ,algorithm,cmplexity,dbms,pointer,function recursion,window OS,kernel, normalisation.

Q.What is the difference between MS-DOS and Window-95 operating system?

Ans: - MS-DOS: - It is a 16-bit, single-user, command-line oriented operating system. MS-DOS is developed by Microsoft in 1981.At that time it was only useful for IBM 8088 based personal computer.It supports total only 11 character file name, 8 characters for file name and 3 characters for extension.

Windows-95:- This is developed by Microsoft in 1995.It transfers all the features of MS-DOS into GUI.Window-95 consisting of all most all the best features likes virtual memory, process management and multiprogramming.It can support long filenames.

Q. What is the difference between oracle 9i and oracle 10g?

Ans: - Oracle 9i is the database which supports internet computing (as in 9i, i stands for internet) developed by Oracle workgroup. It is based on relational database management system.

Oracle 10g is an advanced or extended version of oracle 9i which adds the unique feature of GUI interface that allow us to manage our database without having the knowledge of command line syntax(in the name 10g,g stands for GUI). Oracle 10g also supports Automatic storage management, memory management and transparent data encryption.

Q. What do you mean by instances and schema?

Ans:  Instances: - The collection of information stored in the database at a particular moment is called an instance of the database.

Schema: - The detailed description of the database is called the schema.

Description means table name, field, column name, data type etc.

There are three types of schema: -

                             Physical or internal Schema.

                             Conceptual schema.

                             External schema

 

Q. What is the difference between DBMS and RDBMS?

Ans: - - DBMS is a collection of programs that allows us to create and maintain a database for various applications. It provides an efficient data access, data independence and data integrity. In DBMS tables are not related. In DBMS only one user can access the same database, at the same time. - Ex: - FoxPro data files and earlier Ms Access.

 In RDBMS many users simultaneously access the same database and  tables are related. This approach is developed by E.F.codd. In this approach data are stored in tabular format by the means of rows and columns where the columns name should be unique. The main advantage of an RDBMS is that it supports referential integrity i.e. relationship between related record and table using Foreign Keys.

Ex: - oracle, SQL, My SQL, DB 2.

 

Q. What is kernel? ////very important

Ans: - Kernel connects the application software to the hardware of the computer. This is central component of computer operating system.

The primary purpose of kernel is to mange the computer resources and allows other program to run and use these resources. Typically, the resources consist of –CPU, computer memory, I/O device, maintain the file system.

Program interacts with the kernel through nearly 100 system calls. System calls tell the kernel to carry out various tasks for the program such as opening a file, writing to a file, closing the file, execute the program, terminating a process.

Q. What is the difference between GROUP BY and HAVING sql clause?

Ans: - Both the clause is used for the retrieval of selective rows.

 GROUP BY clause groups the rows based on the distinct values that exits for specified column. It creates a data set, containing several set of records grouped together based on a condition.

e.g.: select name, roll _no from student group by roll_no;

          Above queries displays the name and roll_no of students based on the increasing order of  roll_no.

HAVING clause is used in conjunction with GROUP BY clause. HAVING adds some extra condition on the GROUP BY clause, it further filtrates the data set created by GROUP BY CLAUSE.

 e.g.: select name, roll _no from student group by roll_no HAVING marks > 100;

          Above queries displays the name and roll_no of students based on the increasing order of  roll_no whose marks is greater than 100.

 

 

  Q. What is dual?

Ans: Dual is a dummy table provided by oracle which supports arithmetic calculation and date retrieval and it’s formatting.

It is a small worktable consists of only one row and one column.

e.g.: select 3*3 from dual;

       Output = 9;

Select sysdate from dual;

Here sysdate is a pseudo column in the dual table that contain current date and time.

 

 Q. What is abstraction?

Ans:  An abstraction is an act of representing essential features of something without including much background and implementation details.

Q. What is the difference between function and procedure?

Ans: - A procedure or function is a logically set of SQL and PL/SQL statement that perform a specific task. A function must return a value back to the caller. A function can return only one variable to the calling PL/SQL code block whereas in case of procedure multiple values can be return to the caller by defining multiple OUT parameters.

 But in normal way a function is a portion of code within a larger program which serves a single purpose. For example, we could write a function to find the factorial of a number. Then, any time in our code when we want to calculate the factorial of a number we could use that function instead of writing that code over again each time.

A procedure is some finite steps to perform a task in some specific order.

 

Q. What is query and query language?

Ans: - A query is a statement requesting retrieval, insertion, updatation or deletion of information from some table or database and the language which enables the user to access or manipulate data as organized by the appropriate data model is called query language. SQL (structured query language) is the most widely used query language. 

 

Q. What is the database and database system?

Ans: - Database is a tool to store the interrelated data in tabular format for efficient retrieval and maintenance whereas database and DBMS together is called database system.

 

Q. What is shell?

Ans: - Shell is the part of the operating system that acts as the intermediate between Kernel and user. It works as the command interpreter as it reads the command given by the user and interprets them and sends request to execute the program.

Q. What do you mean by Inode table?

Ans: - Inode table contains the information related to all the files (not content) that are stored on the disk. It keeps the information like –file owner, identifier, file type, file access permission, number of links and file size.

Q. What is GRUB?

Ans: - GRUB stands for grant unified boot loader. It is the command line interface available at boot prompt to write a temporary boot command, view the contents of the file on the file system.

Q. What is template?

Ans: -Template is mechanism to implement the concept of generic programming. It allows us to generate a family of functions or family of functions to handle different data type.

E.g.: - template .

Q. What do you mean by namespace?

Ans:-Namespace defines a scope for identifiers that are used in a program.

E.g.:- namespace std

This will bring all the identifiers defined in std to the current global scope.

difference between Window 95, windows 98indows2000 and window xp operating system?

Q. What is the difference between Window-95 and Window-98 operating system?

Ans: Window 95 was not a full 32-bit operating system, it uses MS-DOS file system with all its limitations. To overcome the problem associated with Window95, Window98 was released in 1998 by Microsoft. There are not many differences between both but window 98 supports internet functionalities and   user interface. 

 

Q. What is the difference between windows98 and windows 2000 operating system?

Ans: - Windows 2000 was released in 2000 by Microsoft to incorporate significant changes over the other windows operating system. The main advantage of windows 2000 over window98 is in terms of distributed file system, increased memory capacity, increased speed, better networking support, laptop support and support for more processor.

 

Q. What is the difference between windows 2000 and windows XP operating system?

 Ans:-Windows XP was released in October 2001 by Microsoft to provide more security, reliability, application compatibility, extensibility and international support. It updates the graphical user interface (GUI) with a visual design that takes advantages of more recent hardware and many new ease-of-use features.

Windows XP is a multi-user operating system, supporting simultaneous access through distributed services.