SQL/PLSQL/Oracle

SQL (Structured Query Language) is a standard computer language used to access, retrieve and update date in the databases. In order to use SQL for websites SQL uses RDBMS ( Relational Database Management System) to enhance the process. Most database management systems uses SQL for querying against the databases. SQL can retrieve, modify, update, insert and delete the records in the databases. It is set-based, declarative query language unlike C which is imperative query language. This section provides all the tutorials related to SQL which act as guide to SQL learners.

Test your SQL query skills with answers

Test your SQL query skills with questions and keys (answers).

Question and answers in SQL

1. Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?


Data Definition Language (DDL)

2. What operator performs pattern matching?


LIKE operator

1. Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
Data Definition Language (DDL)

2. What operator performs pattern matching?
LIKE operator

FAQ / Interview questions in DBMS

Interview question and answers in DBMS ( Database Management Systems) and database concepts to better understand fundamentals of DBMS.

FAQ's Oracle SQL

Contains FAQ's on Oracle SQL statement.

Oracle Interview Questions - Part 1

Contains a set of interview questions on Oracle

Oracle Interview Questions- Part 2

Interview Questions on Oracle

Oracle Interview Questions - Part 3

Oracle Interview Questions

MySQL Tutorial

MySQL Tutorial

SQL Tutorial

SQL Tutorial with examples. Very helpful for beginners. Download the tutorial from the attachments section below.

SQL - Definitions (Notes)

Structured Query Language (SQL) provides the ability to create and define relational database objects. After these objects are defined, the language permits one to add data to these objects.

SQL Interview Questions (75-95)

 

What happens when you say OPEN CURSOR?

If there is an ORDER BY clause, rows are fetched, sorted and made available for the FETCH statement. Other wise simply the cursor is placed on the first row.

SQL Interview Questions (50-75)

EXPLAIN obtains information (which indexes are used, whether sorting is necessary, which level of locking is

SQL Interview Questions(25-50)

An outer join includes rows from tables when there are no matching values in the tables.

 

 

SQL Interview Questions

Structured Query Language (SQL) provides the ability to create and define relational database objects.

DBA SET - I

DBA  FAQ

Database Questions

Database Questions