Oracle Basics Interview Questions

Questions: 47

Comments: 244

Oracle Basics Tags

—

Backup

Showing Questions 21-30 of 47 Questions

<< Previous 1 2 [3] 4 5 Next >>

Sponsored Links

Oracle Basics Interview Questions

Sorting Options :

Create a query that will display the total no.of employees and, of that total, the no.of employees hired

Create a query that will display the total no.of employees and, of that total, the no.of employees hired in 1995,1996,1997, and 1998. create appropriate column headings.

Read Answers (4)

Answer Question Subscribe

Write a query that displays the difference between the highest and lowest salaries. Label the column

Write a query that displays the difference between the highest and lowest salaries. Label the column DIFFERENCE.

Read Answers (2) | Asked by : zecar

Answer Question Subscribe

Write a query to display the no.of people with the same job

Latest Answer: SELECT job, count(*) AS no.ofemployee FROM emp GROUP BY job; ...

Read Answers (6) | Asked by : zecar

Answer Question Subscribe

Create a query that display the last name,hire date and the day of the week on which the employee started.

Create a query that display the last name,hire date and the day of the week on which the employee started. Label the column DAY. Order the results by the day of the week starting with Monday.LAST_NAME HIRE_DATE DAYGrant 24-MAY-99 MONDAYErnst 21-MAY-99 TUESDAYMourgos 16-NOV-99 TUESDAY------- ----- SUNDAY

Read Answers (7) | Asked by : zecar

Answer Question Subscribe

I want to try create the database from my script which i made.can help me how to run a script. can explain

I want to try create the database from my script which i made.can help me how to run a script. can explain me step by step because i am a starter.thank's

Read Answers (3) | Asked by : agusprg

Answer Question Subscribe

What is synapshot?

Latest Answer: A snapshot is a read-only copy of a master table / output of a query based on multiple tables located on a remote location.Once these are read only so can not have DML statments. Yes they can be refeshed periodically based ...

Read Answers (3) | Asked by : senthil

Answer Question Subscribe

What is the difference between rownum,rowid

Latest Answer: rownum is generated for the data retrieved and stored in an implicit cursor so depending on the outcum it may varry where as rowid is generated automatically for creation of every row,hence forth if we want retrive a particular row in a table we ...

Read Answers (4) | Asked by : senthil

Answer Question Subscribe

What is variable size when showing SGA?

Variable portionThe variable portion is called variable because its size (measured in bytes) can be changed. The variable portion consists of: • large pool (optional)Provides working space for rman

View Question | Asked by : Ravi Prakash Pichika

Answer Question Subscribe

Can we create sequence to a View??

Latest Answer: Sequence is used to generate numbers which can be stored in tables. View does not have data of its own and is generally used to query data. So sequence can not be created to a view. ...

Read Answers (3) | Asked by : rajanipriya

Answer Question Subscribe

Is Oracle is a Multidimensional database? If yes How?

Latest Answer: this statement is supported by the prescence of cube and rollup operators in oracle 9i which indicates that it is a multidimensional dbs ...

Read Answers (2) | Asked by : Srinu

Answer Question Subscribe

View page << Previous 1 2 [3] 4 5 Next >>

Go Top

#	User Name	Count
1	lanka_satya	6
2	saginandkishore	5
3	rampratap409	5
4	zecar	5
5	prasads_delight1	4
6	Beena	3
7	amikat	3
8	shamkohli	3
9	rahultripathi	3
10	rajanipriya	3

Get Latest Updates Via RSS Reader or by Email
Forum Discussion
Knowledge Base
Learning Series
Freelance Jobs
GeekInterview Blog
Testing Interview Questions
Oracle Interview Questions
Java Interview Questions
Latest Placement Papers
Free Training
Learn AJAX