Global Web Forum

AgentVinod12

Agent Vinod

From: India

Registered: 2012-03-23

Posts: 1,149

Website

SQL and PL/SQL Interview Questions And Answers

Basic and Advance databases programming :: SQL and PL/SQL Job Interview Questions and Answers

Explore the Structure Query Language (SQL) and PLSQL Interview Questions and Answers

1 What is the SQL?
2 What is SQL*Plus?
3 What is NVL?
4 What is Date Functions?
5 What is Character Functions?
6 What is TTITLE and BTITLE?
7 What is COLUMN?
8 What is BREAK?
9 What is COMPUTE?
10 What is SET?
11 What is SPOOL?
12 What is a JOIN?
13 What is Union?
14 What is Intersect?
15 What is Minus?
16 What is Correlated Subquery?
17 What is Multiple columns?
18 What is Sequences?
19 What is Synonyms?
20 What is Indexes?
21 What is Data types?
22 Order of SQL statement execution?
23 What is Transaction?
24 What is Commit?
25 What is Posting?
26 What is Rollback?
27 What is Savepoint?
28 What is Set Transaction?
29 What is Locking?
30 What is Consistency?
31 What is SQL Integrity?
32 What is SQL Deadlock?
33 What is Mutating SQL Table?
34 What is SQL*Loader?
35 The most important DDL statements in SQL are?
36 Operators used in SELECT statements are?
37 SELECT statements in SQL?
38 The SELECT INTO Statement is most often used to create backup copies of tables or for archiving records?
39 The INSERT INTO Statements in SQL?
40 The Update Statement in SQL.
41 The Delete Statements in SQL.
42 Sort the Rows in SQL.
43 The IN operator may be used if you know the exact value you want to return for at least one of the columns.
44 BETWEEN ... AND operators in SQL.
45 What is the use of CASCADE CONSTRAINTS?