Logo F2FInterview

SQL Plus Interview Questions

Q   |   QA

There are 5 types

1.data definition type

2.data manipulation

3.data control

4.transaction control

5.data query

SQL is Structured Query Language is a database computer language designed for managing data in relational database management systems (RDBMS).

PostgreSQL is an object-relational database management system (ORDBMS).It is released under a BSD-style license and is thus free software. As with many other open-source programs, PostgreSQL is not controlled by any single company, but has a global community of developers and companies to develop it.

SQLite is an ACID-compliant embedded relational database management system contained in a relatively small (~225 KB) C programming library. The source code for SQLite is in the public domain.

MySQL is a relational database management system (RDBMS) which has more than 6 million installations. MySQL stands for "My Structured Query Language". The program runs as a server providing multi-user access to a number of databases. 

TOO_MANY_ROWS

NO_DATA_FOUND

INVALID_CURSORS

CURSOR_ALREADY_OPEN

DUP_VAL_ON_INDEX 

A Cartesian product is the result of an unrestricted join of two or more tables. The result set of a three table Cartesian product will have x * y * z number of rows where x, y, z correspond to the number of rows in each table involved in the join. 

Integrity constraint is a rule that restricts values to a column in a table. 

Use the DISTINCT keyword right after SELECT...

i.e. SELECT DISTINCT customername FROM customer

select * from emp e where rownum=
(select max(rownum) from emp ee
where e.empno=ee.empno) 

In order to link this F2FInterview's page as Reference on your website or Blog, click on below text area and pres (CTRL-C) to copy the code in clipboard or right click then copy the following lines after that paste into your website or Blog.

Get Reference Link To This Page: (copy below code by (CTRL-C) and paste into your website or Blog)
HTML Rendering of above code: