SQL Plus Interview Questions and Answers

Sponsers

Sponsers

Interview Questions

Java Programming Questions
Programming Questions
Oracle Questions
Testing Questions
Accounting Questions
Applications Questions
Clarify CRM Questions
Concepts Questions
Database Questions
Engineering Questions
General Questions
HelpDesk Questions
Mainframe Questions
Management Questions
Networking Questions
Operating System Questions
Data Warehousing Questions
Oracle Apps Questions
Peoplesoft Questions
SAP R/3 Questions
Siebel Questions
Testing Tools Questions
Web Designing Questions

Oracle Interview Questions» SQL Plus

SQL Plus Interview Questions

Answer

what is procedure and function?	Answer
why u want to leave the current job & coming here to work why	Answer
Sponsers
why u want to leave the current job & coming here in our company	Answer
i m installing oracle9i in my system having vista...is no install..what i do..my CD IS NEW...	Answer
what is standard in pharma	Answer
how to store images in oracle database	Answer
How can we delete one column of a table in sql? what is the query?	Answer
establishment of cci&who founder of cotton crop?	Answer
Getting the Next ID in a SQL Server Identity	Answer
Returning XML From SQL Server	Answer
Creating an XML Document with the XMLTextWriter Class	Answer
Which command is used to execute a store procedure?	Answer
What is auto invoice?	Answer
What are the pre-requisites to modify data type	Answer
WWhat are key flexfields and descriptive flexfields in order management?hat are key flexfi...	Answer
What are the error comes when customize a report and how can we eliminate that error?	Answer
How to retrieve data using view?	Answer
What is the difference between Cross Validation and Security Validation?	Answer
What is the maximum sub-tasks we can create for a main task in a Project?	Answer
What are JTF Objects, Why are they required?	Answer
What are the advantages and disadvantages, compared to the standard SQL and SQL*plus ?	Answer
What is the difference between REF Cursor & Normal Cursor?	Answer
Plz specify the sizes occupied by the various data types in Oracle?	Answer
What are the differences between Crystal Report & Oracle Reports?	Answer
Which one is faster DELETE/TRUNCATE? Why?	Answer
. What is the difference between snapshot & mat. view?	Answer
The round(23.59384,-2) is giving output as 0. Can any one explain ,why it was 0?	Answer
How does Oracle 10g(RAC) works?	Answer
Dispaly the employee who gets more salary than the average salary in their depart ment?	Answer
What is Database Trigger ?	Answer
Which section of a PL/SQL block would most likely contain a RAISE statement?	Answer
Which section of a PL/SQL block would most likely contain a RAISE statement?	Answer
what are the contents and components of supplied packages?	Answer
What are the advantages of having a Package ?	Answer
What is difference between Procedures and Functions ?	Answer
What is a Procedure ?	Answer
Write a query to display all the odd numbers from a table?	Answer
what is the difference between CREATE INDEX and CREATE UNIQUE INDEX.?	Answer
Give a brief account on Oracle Engine.?	Answer
how do you know index is invalid?	Answer
How the Bitmap indexes can be useful for Fact tables ?	Answer
What are the date, character, converstion functions in oracle?	Answer
what is SNAPSHOT-TOO-OLD error? How does snapshot-too-old error can be rectified in Oracle...	Answer
How does the index work internally? Provide some examples in different criteria and explai...	Answer
what is isolated Jion ?	Answer
Define tablespace,decode,case,clusters.?	Answer
What are the advantages and disadvantages, compared to the standard SQL and SQL*plus ?	Answer
What is the difference between REF Cursor & Normal Cursor?	Answer
which function is used to trap the error code and error message of an exception?	Answer
Plz specify the sizes occupied by the various data types in Oracle?	Answer
. What is Partition Transparancy?	Answer
What are the differences between Crystal Report & Oracle Reports?	Answer
How many Dispatcher Processes are created ?	Answer
What is the function of Dispatcher (Dnnn) ?	Answer
What is function of RECO ?	Answer
What is function of RECO ?	Answer
What is the function of ARCH ?	Answer
What are functions of PMON ?	Answer
What Does DBWR do ?	Answer
What is a Multi-threaded Server Configuration ?	Answer
What is Dedicated Server Configuration?	Answer
What are the two types of Server Configurations?	Answer
Between EXISTS and In which one is more performance friendly?	Answer
Which one is faster DELETE/TRUNCATE? Why?	Answer
What is the difference between snapshot & mat. view?	Answer
The round(23.59384,-2) is giving output as 0. Can any one explain ,why it was 0?	Answer
How does Oracle 10g(RAC) works?	Answer
what is materialised view?	Answer
What is Non-Schema Object?	Answer
Dispaly the employee who gets more salary than the average salary in their depart ment?	Answer
Which section of a PL/SQL block would most likely contain a RAISE statement?	Answer
What is Server Process ?	Answer
What is User Process ?	Answer
Name the ORACLE Background Process ?	Answer
When Does DBWR write to the database ?	Answer
When does LGWR write to the database ?	Answer
what is SGA? Where it is located? Why the system performance will be slow after loading th...	Answer
What does LGWR do ?	Answer
What is the function of checkpoint(CKPT)?	Answer
What is Shared SQL Area ?	Answer
why oracle is called kernel packagecomponents of oracle tablesql system variables local an...	Answer
What are the components of SGA ?	Answer
What is Cursor ?	Answer
What do Redo Log Buffers contain ?	Answer
What do Database Buffers contain ?	Answer
What is SGA ?	Answer
What constitute an ORACLE Instance ?	Answer
What is PGA ?	Answer
What is Shared Pool ?	Answer
What are the functions of SMON ?	Answer
What are the different types of PL/SQL program units that can be defined and stored in ORA...	Answer
If the entire disk is corrupted how will you and what are the steps to recover the databas...	Answer
How to do the scheduled task/jobs in Unix platform?	Answer
What are the differences you have seen while installing Oracle on NT and Unix platform ?	Answer
What are the differences between database designing and database modeling ?	Answer
If the large table contains thousands of records and the application is accessing 35% of t...	Answer
In which situation whether peak time or off peak time you will execute the ANALYZE TABLE c...	Answer
All the users are complaining that their application is hanging. How you will resolve this...	Answer
If the SQL * Plus hangs for a long time, what is the reason.	Answer
Shall we create procedures to fetch more than one record.	Answer

Question Page : 1

Ask Your Question
Your Name	:
Your Email	:
Your Question	:
Change Image
Enter Security Code Given Above

* Your answer or comment will be approved by web master before posting

SQL Plus Interview Questions and Answers

Ask Your Question