Oracle Apps Interview Questions

Oracle Apps Interview Questions › Category: SQL
Filter:AllOpenResolvedClosedUnanswered
queary
Openanirudh asked 6 years ago • 
1702 views0 answers0 votes
How to display a number in words?
AnsweredQuestions Master asked 11 years ago • 
4096 views0 answers0 votes
How to select odd number records from a table?
AnsweredQuestions Master asked 11 years ago • 
4006 views0 answers0 votes
When to use EXISTS over IN?
AnsweredQuestions Master asked 11 years ago • 
4076 views0 answers0 votes
To optimize the performance of an SQL statement what should be the order of join conditions in WHERE clause?
AnsweredQuestions Master asked 11 years ago • 
2981 views0 answers0 votes
To optimize the performance of an SQL statement what should be the order of tables in FROM clause?
AnsweredQuestions Master asked 11 years ago • 
3285 views0 answers0 votes
What is the standard execution sequence of an SQL Statement followed by Oracle Database engine?
AnsweredQuestions Master asked 11 years ago • 
3529 views0 answers0 votes
How to find record count of a table without using count(*) ?
AnsweredQuestions Master asked 11 years ago • 
4383 views0 answers0 votes
What is the structure of DUAL table?
AnsweredQuestions Master asked 11 years ago • 
4020 views0 answers0 votes
what is the diffrence between EXISTS and IN? when to use EXISTS and when to use IN?
AnsweredAnonymous asked 11 years ago • 
3565 views0 answers0 votes
Lets say there is a table with 500 rows. Write a query to display rows from 101 to 500.
ResolvedAnonymous asked 11 years ago • 
3434 views0 answers0 votes
Query to find records inserted in last 2 hours
ResolvedAnonymous asked 11 years ago • 
15263 views0 answers0 votes
What is the different between Analytic and Group function in SQL?
ResolvedQuestions Master asked 11 years ago • 
5674 views0 answers0 votes
How to find SQL statements which takes more time to run on Database?
ResolvedQuestions Master asked 11 years ago • 
4138 views0 answers0 votes
What is Referential Integrity?
ResolvedQuestions Master asked 11 years ago • ,
5856 views0 answers0 votes
What is Global Temporary Tables and What is it Purpose?
ResolvedQuestions Master asked 11 years ago • ,
6413 views0 answers0 votes
How to sort a VARCHAR2 field as a Numeric field in SQL?
ResolvedQuestions Master asked 11 years ago • 
3013 views0 answers0 votes
What is the Difference between an Empty String and a NULL value?
ResolvedQuestions Master asked 11 years ago • 
3806 views0 answers0 votes
How would you convert date into Julian date format in Oracle SQL?
ResolvedQuestions Master asked 11 years ago • 
3902 views0 answers0 votes
Can we use a WHERE clause in TRUNCATE statement?
ResolvedQuestions Master asked 12 years ago • 
6528 views1 answers0 votes
How to display the employee number and name for employee working as clerk and earning highest salary among clerks?
ResolvedQuestions Master asked 12 years ago • 
6205 views1 answers0 votes
How to display all employees name,job,salary,grade and depart name for every one in the company except ‘CLERK’.Sort on salary display the highest salary?
ResolvedQuestions Master asked 12 years ago • 
3749 views1 answers0 votes
How to find out the top 5 earners of company based on emp dept table?
ResolvedQuestions Master asked 12 years ago • 
6300 views1 answers0 votes
How to display dname where at least 3 are working and display only department name?
ResolvedQuestions Master asked 12 years ago • 
5959 views1 answers0 votes
How to display those managers name whose salary is more than average salary of his employee?
ResolvedQuestions Master asked 12 years ago • 
7983 views1 answers0 votes
How to display employee name, sal, comm and net pay for those employee whose net pay is greater than or equal to any other employee salary of the company?
ResolvedQuestions Master asked 12 years ago • 
6595 views1 answers0 votes
How to find out last 5 (least) earners of the company.?
ResolvedQuestions Master asked 12 years ago • 
8371 views1 answers0 votes
How to display those employee whose salary is ODD value?
ResolvedQuestions Master asked 12 years ago • 
10589 views1 answers0 votes
How to display those employee who joined in the company in the month of Dec?
ResolvedQuestions Master asked 12 years ago • 
12584 views1 answers0 votes
How to display those employee whose 10% of salary is equal to the year of joining?
ResolvedQuestions Master asked 12 years ago • 
7462 views1 answers0 votes
How to display those employees who joined the company before 15 of the month?
ResolvedQuestions Master asked 12 years ago • 
12679 views1 answers0 votes
How to display employee name and his salary whose salary is greater than highest average of department number?
ResolvedQuestions Master asked 12 years ago • 
10439 views1 answers0 votes
How to display those employee whose joining of month and grade is equal?
ResolvedQuestions Master asked 12 years ago • 
7195 views1 answers0 votes
How to display the 10th record of emp table(without using rowid) ?
ResolvedQuestions Master asked 12 years ago • 
10962 views1 answers0 votes
How to display all enames in reverse order? (SMITH:HTIMS)
ResolvedQuestions Master asked 12 years ago • 
7543 views1 answers0 votes
How to display those employee whose joining DATE is available in deptno?
ResolvedQuestions Master asked 12 years ago • 
9508 views1 answers0 votes
How to impose a validation saying that salary cannot be greater 10,000 (note give a name to this constraint)
ResolvedQuestions Master asked 12 years ago • 
7773 views1 answers0 votes
How to Delete the rows of employees who are working in the company for more ?
ResolvedQuestions Master asked 12 years ago • 
7422 views1 answers0 votes
Write a Query to Delete The Repeated Rows from emp table?
ResolvedQuestions Master asked 12 years ago • 
9178 views1 answers0 votes
HOW TO DISPLAY 5 TO 7 ROWS FROM A TABLE?
ResolvedQuestions Master asked 12 years ago • 
14970 views1 answers0 votes
12