Skip to main content

Questions from Qspiders


(1) How do I list all of my tables?

(2) Create one table from another table without copying the data from the first table.

(3) How do I select from different user’s tables?

(4) What is SQL?

(5) What is a function in oracle?

(6) What is the default format of date in Oracle? How can I change my default date format?

(7) Difference between
a)     ROLLBACK & SAVEPOINT
b)     ROLLBACK & COMMIT
c)      Truncate & Delete
d)     Truncate & Drop
e)     Delete & Drop
f)      PK and (UNIQUE + Not Null)
g)     ROUND & TRUNC
h)     ROWID & ROWNUM
i)        Alternate Key & Candidate Key
j)       Simple Key & Composite Key
k)     Stored Procedure and Function
l)        Stored Procedure and Trigger
m)   Equi-Join and Outer Join
n)     CHAR & VARCHAR2
o)     CASE Statements & DECODE
p)     UNION and UNION ALL

8) What is a view? What are its advantages?

9) What is a synonym?

10) What is PL/SQL?

11) What is an Index? Why it is useful?

12) What is PL/SQL?

13) Mention some features of Oracle 9i database.

14) Mention some features of Oracle 10g database.

15) What is the meaning of “i” and “g” in 9i & 10g respectively?

16) What is the purpose of joining the tables? Explain different types of Joins.

17) What are the data types available in Oracle? Explain.

(18) What is Database Link?

(19) What is Tuning? Explain.

(20) What is DDL? Give examples.

(21) What is DML? Give examples.

(23) What is the difference between DBMS & RDBMS?

(24) State some of the Codd Rules.

(25) What is normalization? Explain.

(26) Few differences between Oracle and SQL Server databases.

(27) What is a Sequence?

(28) Write a query to eliminate duplicates rows from a table?

(29) How does one implement IF-THEN-ELSE in a select statement?

(30) How we can send the query output to a file?

(31) Display the Department Names that are having more than 4 employees in it?

(31) What is SQL* Loader?

(32) What is Export & Import?

(33) Increase the salaries of all the employees by 10% for the departments that are common in both of these tables.

Table1



Deptno
Empno
Sal
10
1
1000
10
2
3000
20
3
2000
30
4
6000
20
5
1000
60
6
9000
10
7
1000


Table2



Deptno

10
40

(34) Write the syntax to add Foreign Key?

(35) Write the syntax to create Composite Primary Key?

(36) How to run the SQL statements from a file?

(37) What is a schema?

(38) What are DCLs?

(39) What are roles & privileges?

(40) What are sub query statements and co-related sub query statements?

Labels:

Comments

sam said…
Sir,I want all the answers for questions from qspider -----sam
February 12, 2013 at 2:06 AM
Unknown said…
Hello Sir,
Plz post the answers for Qspider questions based on queries.
September 22, 2013 at 6:33 PM
Unknown said…
sir pls provide answers for question 1 and 3.
This also not given in your class
April 1, 2016 at 7:25 PM
Sona Naidu said…
This comment has been removed by the author.
April 13, 2016 at 8:28 PM
rohit said…
OK thanks for this post it's quite informative and I have learned new things.

kissanime alternatives
January 7, 2019 at 4:09 PM
Post a Comment

Popular posts from this blog

SQL Interview Questions on Subqueries

SUB Queries:
1. List the employees working in research department 2. List employees who are located in New York and Chicago
3. Display the department name in which ANALYSTS are working
4. Display employees who are reporting to JONES
5. Display all the employees who are reporting to Jones Manager
6. Display all the managers in SALES and ACCOUNTING department
7. Display all the employee names in Research and Sales Department who are having at least 1 person reporting to them
8. Display all employees who do not have any reportees
9. List employees who are having at least 2 reporting
10. List the department names which are having more than 5 employees
11. List department name having at-least 3 salesman
12. List employees from research and accounting having at-least 2 reporting
13. Display second max salary
14. Display 4th max salary
15. Display 5th max salary  -- Answer for nth Max Salary
Co-Related Subqueries:
16. Write a query to get 4th max salary from EMP table
17. Write a query to get 2nd…
21 comments
Read more

Basics of RDBMS

Data
Small set of information becomes data, this set of information helps make decision. Data is always some useful information.


Database
Place where you store the data. Database represents some aspect of the real world called "miniworld". A database is designed, built and populated with data for a specific purpose. It has intended group of users and some preconceived applications in which these users are interested.

In other words, a database has some source from which data is derived, some degree of interaction with events in the real world and an audience that is actively interested in the contents of the database.

Database can also be defined as collection of one or more tables.

Ex: Mobile, human brain etc



DBMS (Database Management System)
Is a program that stores retrieves and modifies data in the database on request.

Study of different techniques of design, development and maintenance of the database

Types of DBMS
These types are based upon their management of database s…
101 comments
Read more

Answers for SQL Functions

1. SQL> SELECT empno, ename FROM emp WHERE Length(ename) = 4;

2. SQL> SELECT empno, ename, job FROM emp where Length(job)=7;

3. SQL> SELECT Length('qspiders') - Length(replace('qspiders','s','')) FROM dual;

4. SQL>  SELECT empno, ename, job FROM emp WHERE Instr(job,'MAN') >0;

5. SQL> SELECT empno, ename, job FROM emp WHERE Instr(job, 'MAN') =1;

6. SQL> SELECT empno, ename, job FROM emp WHERE (Length(ename) - Length(Replace(ename, 'L',''))) = 1;

7. SQL> SELECT * FROM dept WHERE Instr(dname,'O') > 0;

8. SQL> SELECT Concat(ename,' working as a ') || Concat(job, ' earns ') || Concat(sal, '  in ') || Conc
at('dept ',deptno) AS text from emp;

OR

SQL> SELECT Concat(Concat(Concat(Concat(Concat(Concat(Concat(ename,' working as a '), job),' earns '), sal),'  in '),'dept '), deptno) AS text FROM emp;

9. SQL> SELECT empno, ename…
40 comments
Read more