what is query and types of query

Answers were Sorted based on User's Feedback



what is query and types of query ..

Answer / manohar

to retrieve data from the database tables is called query

Is This Answer Correct ?    9 Yes 2 No

what is query and types of query ..

Answer / gangadhar mahabubabad

query is a language
by using query, we can write SQL statements

Is This Answer Correct ?    0 Yes 0 No

what is query and types of query ..

Answer / bhupali

Query is a sql statement which helps to retrieve data from
multiple table

Is This Answer Correct ?    0 Yes 1 No

what is query and types of query ..

Answer / vaibhav tiwari

The SQL statement returns a result set of records from one
or more tables.Query is not only used for data retrieval
but it can also be used for updation of data.

Is This Answer Correct ?    0 Yes 1 No

what is query and types of query ..

Answer / vipin kumar ( m.c.a)

Query is a PL/SQL statement using to perform an action.

Is This Answer Correct ?    1 Yes 5 No

what is query and types of query ..

Answer / reddibasha

A Query is a SELECT statement, which is always successful.

Is This Answer Correct ?    1 Yes 9 No

Post New Answer

More Oracle General Interview Questions

How to run create database statement again?

0 Answers  


We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.

0 Answers  


What view(s) do you use to associate a users SQLPLUS session with his o/s process?

0 Answers  


What is oracle datasource?

0 Answers  


How to end the current transaction in oracle?

0 Answers  






I have query like this. select dept_id, max_mark from stude_dept where min_mark= (select min(mini_mark) from stud_dept); How can i optimize this query. Can anyone help me with it

2 Answers  


Difference between primary key and unique key ?

77 Answers   Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions,


can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ?

2 Answers   Allfon,


What is a Redo Log ?

3 Answers  


What is oracle analytical function?

0 Answers  


Please explain compound trigger in oracle?

0 Answers  


How to define an explicit cursor in oracle?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)