Interview Questions
« Previous | 0 | 1 | 2 | 3 | 4 | Next »

1.What is the difference between SQL and MySQL or SQL Server?

SQL or Structured Query Language is a language; language that communicates with a relational database thus providing ways of manipulating and creating databases. MySQL and Microsoft’s SQL Server both are relational database management systems that use SQL as their standard relational database language.

2.What is the difference between SQL and PL/SQL?

PL/SQL is a dialect of SQL that adds procedural features of programming languages in SQL. It was developed by Oracle Corporation in the early 90's to enhance the capabilities of SQL.
What are various DDL commands in SQL? Give brief description of their purposes.
Following are various DDL or Data Definition Language commands in SQL −

  • CREATE − it creates a new table, a view of a table, or other object in database.
  • ALTER − it modifies an existing database object, such as a table.
  • DROP − it deletes an entire table, a view of a table or other object in the database.

3.What are various DML commands in SQL? Give brief description of their purposes.?

Following are various DML or Data Manipulation Language commands in SQL −

  • SELECT − it retrieves certain records from one or more tables.
  • INSERT − it creates a record.
  • UPDATE − it modifies records.
  • DELETE − it deletes records.

4.What are various DCL commands in SQL? Give brief description of their purposes.?

Following are various DCL or Data Control Language commands in SQL −

  • GRANT − it gives a privilege to user.
  • REVOKE − it takes back privileges granted from user.

5.Can you sort a column using a column alias?

Yes. A column alias could be used in the ORDER BY clause.

6.Is a NULL value same as zero or a blank space? If not then what is the difference?

A NULL value is not same as zero or a blank space. A NULL value is a value which is ‘unavailable, unassigned, unknown or not applicable’. Whereas, zero is a number and blank space is a character.

7.If a table contains duplicate rows, does a query result display the duplicate values by default? How can you eliminate duplicate rows from a query result?

A query result displays all rows including the duplicate rows. To eliminate duplicate rows in the result, the DISTINCT keyword is used in the SELECT clause.

8.What is the purpose of the condition operators BETWEEN and IN?

The BETWEEN operator displays rows based on a range of values. The IN condition operator checks for values contained in a specific set of values.

9.How do you search for a value in a database table when you don’t have the exact value to search for?

In such cases, the LIKE condition operator is used to select rows that match a character pattern. This is also called ‘wildcard’ search.

10.What is the default ordering of data using the ORDER BY clause? How could it be changed?

The default sorting order is ascending. It can be changed using the DESC keyword, after the column name in the ORDER BY clause.

11.What are the specific uses of SQL functions?

SQL functions have the following uses −

  • Performing calculations on data
  • Modifying individual data items
  • Manipulating the output
  • Formatting dates and numbers
  • Converting data types

12.What are the case manipulation functions of SQL?

LOWER, UPPER, INITCAP

13.Which function returns the remainder in a division operation?

The MOD function returns the remainder in a division operation.

14.What is the purpose of the NVL function?

The NVL function converts a NULL value to an actual value.

15.What is the difference between the NVL and the NVL2 functions?

The NVLexp1, exp2 function converts the source expression orvalue exp1 to the target expression orvalue exp2, if exp1 contains NULL. The return value has the same data type as that of exp1.
The NVL2exp1, exp2, exp3 function checks the first expression exp1, if it is not null then, the second expression exp2 is returned. If the first expression exp1 is null, then the third expression exp3 is returned.

16.What is the use of the NULLIF function?

The NULLIF function compares two expressions. If they are equal, the function returns null. If they are not equal, the first expression is returned.

17.Discuss the syntax and use of the COALESCE function?

The COALESCE function has the expression COALESCEexp1, exp2, …. expn It returns the first non-null expression given in the parameter list.

18.Which expressions or functions allow you to implement conditional processing in a SQL statement?

There are two ways to implement conditional processing or IF-THEN-ELSE logic in a SQL statement.

  • Using CASE expression

  • Using the DECODE function

You want to display a result query from joining two tables with 20 and 10 rows respectively.

19.Erroneously you forget to write the WHERE clause. What would be the result?

The result would be the Cartesian product of two tables with 20 x 10 = 200 rows.

20.What is the difference between cross joins and natural joins?

The cross join produces the cross product or Cartesian product of two tables. The natural join is based on all the columns having same name and data types in both the tables.

« Previous | 0 | 1 | 2 | 3 | 4 | Next »


copyright © 2014 - all rights riserved by javatechnologycenter.com