Search this website:
Main Menu
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
- Article
- September 25, 2009
- 5 comments
Test your SQL query skills with questions and keys (answers).
Question and answers in SQL
- Article
- September 25, 2009
- No comments
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
Data Definition Language (DDL)
2. What operator performs pattern matching?
LIKE operator
FAQ / Interview questions in DBMS
- Article
- August 27, 2009
- 28 comments
Oracle Interview Questions - Part 1
- Article
- May 12, 2009
- 4 comments
SQL Tutorial
- Article
- May 9, 2008
- 5 comments
SQL - Definitions (Notes)
- Article
- June 6, 2007
- 7 comments
SQL Interview Questions (75-95)
- Article
- June 6, 2007
- 6 comments
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)
- Article
- June 6, 2007
- 4 comments
EXPLAIN obtains information (which indexes are used, whether sorting is necessary, which level of locking is
SQL Interview Questions(25-50)
- Article
- June 6, 2007
- 35 comments
An outer join includes rows from tables when there are no matching values in the tables.
SQL Interview Questions
- Article
- June 6, 2007
- 5 comments