Sql Questions for campus

. how to write a query to unsort while retrieving the data. it should be niether in ascending nor descending
Comments: 1 Read/Add Answers

Last Update: February 17, 2007 By Harsh Athalye

2. How do you delete duplicate row from oracle table that does not have any primary key field?
Comments: 2 Read/Add Answers

Last Update: February 07, 2007 By Jayanth Saimani

3. What is SQL injection? What are the uses of it?
Comments: 3 Read/Add Answers

Last Update: January 24, 2007 By Lakshaman

4. can we delete master records from the parent table ? if yes justify
Comments: 2 Read/Add Answers

Last Update: February 27, 2007 By SHAMIK

5. How to generate 1...N (sequence Numbers) without using the sequence concept in SQL?
Comments: 5 Read/Add Answers

Last Update: February 06, 2007 By kaledhananjay

6. Write a query to find the list of employees whos age is greater than 30 or so given a date of birth colu
Comments: 4 Read/Add Answers

Last Update: February 12, 2007 By ggk.krishna

7. how to hide the code in procedures,packages?
Comments: 3 Read/Add Answers

Last Update: February 13, 2007 By vavasudevan

8. How many null values does a column accept if it is declared as a unique key?
Comments: 14 Read/Add Answers

Last Update: January 17, 2007 By bibhu

9. What is the main use of FOREIGN KEY?
Comments: 14 Read/Add Answers

Last Update: February 14, 2007 By abc

10. What is oracle hint? how do we use hints in SQL for the optimization of the query?
Comments: 1 Read/Add Answers

Last Update: December 05, 2006 By John Thomas Ambadan

11. What is the basic difference in MySQL & Stored SQL?
Comments: 1 Read/Add Answers

Last Update: November 28, 2006 By aa

12. How many trigger we can create on a table? How many column we can create in a table?
Comments: 6 Read/Add Answers

Last Update: February 05, 2007 By Atul Trikha

13. How do you find the number of rows in a table?
Comments: 9 Read/Add Answers

Last Update: February 06, 2007 By manohar

14. Difference between Cluster and Non-cluster index?
Comments: 2 Read/Add Answers

Last Update: December 07, 2006 By Rajesh Varma

15. What is a table called, if it does not have neither Cluster nor Non-cluster Index?
Comments: 1 Read/Add Answers

Last Update: October 19, 2006 By Jerrin

16. What de-normalization and when do you do it?
Comments: 8 Read/Add Answers

Last Update: February 06, 2007 By sivanesh.a

17. How do you know which index a table is using?
Comments: 2 Read/Add Answers

Last Update: November 12, 2006 By Nigam

18. How could i delete the distinct name from the table. the rest record would be available as it is in the
Comments: 2 Read/Add Answers

Last Update: January 09, 2007 By preethi

19. How to tune the following sql in order that the performance improve the query is SELECT DISTINCTA.BUSINESS_UNIT
Comments: 3 Read/Add Answers

Last Update: October 12, 2006 By zskhan

20. How do you subtract two columns in oracle database, two columns are in data format.Example : inserttime
Comments: 2 Read/Add Answers

Last Update: September 26, 2006 By condemnity

21. It is also mentioned that column aliases cannot be used in the WHERE clause, then how did this query
Comments: 3 Read/Add Answers

Last Update: November 02, 2006 By Hitesh

22. 1. Why is it so that the given query worked :"select * from (select rownum rnum,a.* from emp a) where
Comments: 1 Read/Add Answers

Last Update: October 03, 2006 By adarsh_sp

23. Which is more efficient('WHERE" or "HAVING") in SQL ?
Comments: 6 Read/Add Answers

Last Update: December 22, 2006 By rajneeshbajwa

24. What is the queary for Non equal joints ,self joints?
Comments: 2 Read/Add Answers

Last Update: September 06, 2006 By shivkumarojha

25. How to retrieve record number 70 from a table of 100 records?
Comments: 4 Read/Add Answers

Last Update: September 26, 2006 By krishna

26. 1. How to delete a duplicate records in a table without using rowid?2. What is the use of Connect by
Comments: 8 Read/Add Answers

Last Update: December 08, 2006 By appu

27. Using corelated subquery: Inner query results in more than one row/value, then can this values be concatenated
Comments: 1 Read/Add Answers

Last Update: August 17, 2006 By Bilkis

28. How to display duplicate rows in a table?
Comments: 7 Read/Add Answers

Last Update: February 22, 2007 By Nandu

29. What are the advantages and disadvantages of primary key and foreign key in SQL?
Comments: 2 Read/Add Answers

Last Update: September 06, 2006 By shivkumarojha

30. How to find second maximum value from a table?
Comments: 12 Read/Add Answers

Last Update: September 21, 2006 By chanti4u123

31. How to find out the 10th highest salary in SQL query?
Comments: 12 Read/Add Answers

Last Update: September 09, 2006 By Ram Pratap Singh

32. What the difference between UNION and UNIONALL?
Comments: 4 Read/Add Answers

Last Update: October 06, 2006 By Vasanth Kumar

33. What is materialized View?
Comments: 2 Read/Add Answers

Last Update: October 23, 2006 By thumatinagaraju

34. What is the advantage to use trigger in your PL?
Comments: 2 Read/Add Answers

Last Update: August 03, 2006 By chennoju

35. Given an employee and manager table, write a SQL syntax that could be used to find out an employee's
Comments: 4 Read/Add Answers

Last Update: July 11, 2006 By biswa

36. When using a count(distinct) is it better to use a self-join or temp table to find redundant data, and
Comments: 1 Read/Add Answers

Last Update: August 01, 2006 By Sujatha

37. How to test the complex view using manually testing?
Comments: 0 Read/Add Answers


38. What is difference between DBMS and RDBMS?
Comments: 10 Read/Add Answers

Last Update: March 01, 2007 By Meena

39. In subqueries, which is efficient ,the IN clause or EXISTS clause? Does they produce the same result?
Comments: 3 Read/Add Answers

Last Update: May 23, 2006 By Lokesh Bhat

40. What is the main difference between the IN and EXISTS clause in subqueries??
Comments: 1 Read/Add Answers

Last Update: June 03, 2006 By Rajeshwaran

41. How can i hide a particular table name of our schema.
Comments: 1 Read/Add Answers

Last Update: May 21, 2006 By rajaram

42. If Delete Any Table In Back-End Then. What Are The Triggers will Fire Automatically(Those Triggers Are
Comments: 1 Read/Add Answers

Last Update: May 04, 2006 By Alex T

43. What is cluster.cluster index and non cluster index?
Comments: 2 Read/Add Answers

Last Update: July 04, 2006 By vvijaychandra

44. How write a SQL statement to query the result set and display row as columns and columns as row?
Comments: 4 Read/Add Answers

Last Update: October 06, 2006 By Vasanth Kumar

45. Given an unnormalized table with columns:Name,Phone number,Address You notice that some records in Name
Comments: 3 Read/Add Answers

Last Update: May 05, 2006 By smrati saxena

46. How to write a sql statement to find the first occurrence of a non zero value?
Comments: 8 Read/Add Answers

Last Update: January 15, 2007 By SQL Devotee

47. Why do i get "Invalid Cursor State" errors when I insert/update/delete data with execute Query()?
Comments: 1 Read/Add Answers

Last Update: February 28, 2006 By D.V.Narasimha Rao

48. Difference between VARCHAR and VARCHAR2?
Comments: 14 Read/Add Answers

Last Update: July 26, 2006 By shyamprasad

49. How to store directory structure in a database?
Comments: 1 Read/Add Answers

Last Update: March 28, 2006 By Mainak Aich

50. What is database?
Comments: 10 Read/Add Answers

Last Update: August 14, 2006 By Yugma

51. Difference between a equijoin and a union?
Comments: 2 Read/Add Answers

Last Update: April 03, 2006 By aruna

52. What is normalazation,types with examples. with queries of all types?
Comments: 5 Read/Add Answers

Last Update: April 26, 2006 By Ranjeev

53. Can we call user defined packages in SQL statements?
Comments: 5 Read/Add Answers

Last Update: April 25, 2006 By falak narang

54. What is difference between Oracle and MS Access? What are disadvantages in Oracle and MS Access? What
Comments: 6 Read/Add Answers

Last Update: December 21, 2006 By Vijay Taneja

55. There are 2 tables, Employee and Department. There are few records in employee table, for which, the
Comments: 7 Read/Add Answers

Last Update: January 19, 2007 By Evghenii

56. What operator performs pattern matching?
Comments: 10 Read/Add Answers

Last Update: February 14, 2007 By srihari

57. What is reference cursor?
Comments: 9 Read/Add Answers

Last Update: March 31, 2006 By nandish

58. When we give SELECT * FROM EMP; How does oracle respond?
Comments: 18 Read/Add Answers

Last Update: January 11, 2007 By sim

59. There is a Eno & gender in a table. Eno has primary key and gender has a check constraints for the values
Comments: 2 Read/Add Answers

Last Update: February 27, 2007 By marutalksin

60. What is difference between Co-related sub query and nested sub query?
Comments: 1 Read/Add Answers

Last Update: January 19, 2006 By Sameeksha
61. What is table space?
Comments: 8 Read/Add Answers

Last Update: April 12, 2006 By shivkumar

62. What is the difference between SQL and SQL Server?
Comments: 6 Read/Add Answers

Last Update: November 12, 2005 By jj

63. Whats the back end processes when we type "Select * from Table"?
Comments: 1 Read/Add Answers

Last Update: October 25, 2005 By shashi

64. How can we backup the sql files & what is SAP?
Comments: 1 Read/Add Answers

Last Update: November 11, 2005 By shuaib

65. How to find out the database name from SQL*PLUS command prompt?
Comments: 3 Read/Add Answers

Last Update: January 09, 2006 By Nagarjuna Reddy

66. Explain normalization with examples?
Comments: 2 Read/Add Answers

Last Update: October 27, 2005 By sarala

67. Cursor Syntax brief history?
Comments: 3 Read/Add Answers

Last Update: September 17, 2005 By prabakaran

68. Difference between Store Procedure and Trigger?
Comments: 4 Read/Add Answers

Last Update: August 03, 2006 By chennoju

69. How to copy SQL table?
Comments: 5 Read/Add Answers

Last Update: June 12, 2006 By ravi

70. I have a table with duplicate names in it. Write me a query which returns only duplicate rows with number
Comments: 9 Read/Add Answers

Last Update: September 12, 2006 By Nitin Sharanagate
71. Is there any query which is use to find the case sensitivity in each records in database through visual
Comments: 1 Read/Add Answers

Last Update: January 19, 2006 By Sameeksha

72. How do I write a cron which will run a SQL query and mail the results to a group?
Comments: 1 Read/Add Answers

Last Update: October 18, 2005 By Kalyan

73. What is the difference between Single row sub-Query and Scalar sub-Query?
Comments: 2 Read/Add Answers

Last Update: September 01, 2005 By B.Vijay Karthik

74. What operator performs pattern matching?
Comments: 3 Read/Add Answers

Last Update: September 30, 2005 By sankar

75. Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
Comments: 9 Read/Add Answers

Last Update: December 12, 2006 By Mahesh

76. TRUNCATE TABLE EMP;,DELETE FROM EMP;, Will the outputs of the above two commands?
Comments: 13 Read/Add Answers

Last Update: June 24, 2006 By Manish

77. What is the use of the DROP option in the ALTER TABLE command?
Comments: 3 Read/Add Answers

Last Update: November 14, 2005 By chitra

78. Why does the following command give a compilation error?
Comments: 3 Read/Add Answers

Last Update: November 23, 2005 By Poonam Sachdeva

79. What will be the output of the following query?
Comments: 1 Read/Add Answers

Last Update: January 28, 2006 By sisira

80. What does the following query do?
Comments: 1 Read/Add Answers

Last Update: December 26, 2005 By prasath
81. Which date function is used to find the difference between two dates?
Comments: 1 Read/Add Answers

Last Update: November 14, 2005 By keerthy

82. What is the advantage of specifying WITH GRANT OPTION in the GRANT command?
Comments: 1 Read/Add Answers

Last Update: January 27, 2006 By sisira

83. What is the value of comm and sal after executing the following query if the initial value of ‘sal’
Comments: 1 Read/Add Answers

Last Update: September 20, 2005 By rahul tripathi

84. What is the use of DESC in SQL?
Comments: 2 Read/Add Answers

Last Update: November 08, 2005 By Jayakumar M

85. What is the use of CASCADE CONSTRAINTS?
Comments: 1 Read/Add Answers

Last Update: October 13, 2005 By Anuradha

86. Which function is used to find the largest integer less than or equal to a specific value?
Comments: 1 Read/Add Answers

Last Update: January 27, 2006 By sisira

87. What is the output of the following query?
Comments: 4 Read/Add Answers

Last Update: November 17, 2006 By thumati_nagaraju@yahoo.co.in

88. What operator tests column for the absence of data?
Comments: 3 Read/Add Answers

Last Update: February 06, 2007 By burelamanohar

89. Which command executes the contents of a specified file?
Comments: 2 Read/Add Answers

Last Update: October 17, 2005 By Anshul

90. What is the parameter substitution symbol used with INSERT INTO command?
Comments: 2 Read/Add Answers

Last Update: October 13, 2005 By Anuradha
91. Which command displays the SQL command in the SQL buffer, and then executes it?
Comments: 4 Read/Add Answers

Last Update: July 26, 2006 By Bala

92. What are the wildcards used for pattern matching?
Comments: 1 Read/Add Answers

Last Update: November 18, 2005 By prasuna

93. State true or false. EXISTS, SOME, ANY are operators in SQL.
Comments: 5 Read/Add Answers

Last Update: May 08, 2006 By Rajani

94. State true or false. !=, <>, ^= all denote the same operation.
Comments: 10 Read/Add Answers

Last Update: October 12, 2006 By vinnu

95. What are the privileges that can be granted on a table by a user to others?
Comments: 2 Read/Add Answers

Last Update: May 08, 2006 By Rajani

96. What command is used to get back the privileges offered by the GRANT command?
Comments: 1 Read/Add Answers

Last Update: October 15, 2005 By Hemangi

97. Which system tables contain information on privileges granted and privileges obtained?
Comments: 1 Read/Add Answers

Last Update: January 27, 2006 By sisira

98. Which system table contains information on constraints on all the tables created?
Comments: 1 Read/Add Answers

Last Update: January 27, 2006 By sisira

99. What is the difference between TRUNCATE and DELETE commands?
Comments: 3 Read/Add Answers

Last Update: December 05, 2006 By saravanan p

100. What command is used to create a table by copying the structure of another table?
Comments: 7 Read/Add Answers

Last Update: July 04, 2006 By vijay