Most voted questions under tag sql

+2 votes

1 answer

what is the advantages of partitioning in Oracle?

posted May 20, 2015 by Archana

+2 votes

1 answer

who found the principles of the relational model of database?

posted May 15, 2015 by Kunal Kapoor

+2 votes

1 answer

How to Kill a session in Oracle?

posted May 5, 2015 by Kunal Kapoor

+2 votes

1 answer

how to determine who is logged into Oracle?

posted May 5, 2015 by Kunal Kapoor

+2 votes

1 answer

What is SQL Language Extension?

posted Apr 29, 2015 by Archana

+2 votes

1 answer

what is Positional and Named Notation in Oracle?

posted Apr 29, 2015 by Archana

+2 votes

1 answer

What is Table space in Oracle?

posted Apr 23, 2015 by Viswas Kumar

+2 votes

1 answer

what is PL/SQL Record?

posted Apr 22, 2015 by Archana

+2 votes

1 answer

what do you mean by Data Integrity in Oracle?

posted Apr 14, 2015 by Suchithra

+2 votes

1 answer

Oracle: Name two files used for network connection to a database.

posted Apr 13, 2015 by Viswas Kumar

+2 votes

1 answer

Oracle: What is the difference between the SQL*Loader and IMPORT utilities?

posted Apr 13, 2015 by Viswas Kumar

+2 votes

1 answer

Oracle: How can you enable a trace for a session?

posted Apr 9, 2015 by Kunal Kapoor

+2 votes

1 answer

Oracle: What view would you use to determine free space in a tablespace?

posted Apr 6, 2015 by Vidhya Sagar

+2 votes

1 answer

Oracle: What view would you use to look at the size of a data file?

posted Apr 6, 2015 by Vidhya Sagar

+2 votes

1 answer

Oracle: How do you resize a data file?

posted Apr 3, 2015 by Suchithra

+2 votes

1 answer

Oracle: When creating a user, what permissions must you grant to allow them to connect to the database?

posted Apr 2, 2015 by Vidhya Sagar

+2 votes

1 answer

oracle: Name a tablespace automatically created when you create a database

posted Apr 2, 2015 by Vidhya Sagar

+2 votes

1 answer

Oracle: What background process refreshes materialized views?

posted Mar 27, 2015 by Suchithra

+2 votes

1 answer

Oracle: When a user process fails, what background process cleans up after it?

posted Mar 27, 2015 by Suchithra

+2 votes

1 answer

Oracle: Name three advisory statistics you can collect.

posted Mar 25, 2015 by Suchithra

+2 votes

1 answer

How would you determine the time zone under which a database was operating In Oracle?

posted Mar 20, 2015 by Archana

+2 votes

1 answer

What is the maximum number of triggers, can apply to a single table in Oracle?

posted Mar 20, 2015 by Archana

+2 votes

1 answer

Oracle: What is the output of SIGN function?

posted Mar 19, 2015 by Archana

+2 votes

1 answer

What are the more common pseudo-columns in Oracle?

posted Mar 19, 2015 by Archana

+2 votes

1 answer

Oracle: Which date function returns number value?

posted Mar 17, 2015 by Archana

+2 votes

1 answer

Oracle: How to display the number value in Words ?

posted Mar 16, 2015 by Archana

+2 votes

1 answer

How can we change the data type of a column of a table in SQL?

posted Mar 13, 2015 by Amit Kumar Pandey

+2 votes

1 answer

Orcale: How to view installed Oracle version information?

posted Mar 13, 2015 by Suchithra

+2 votes

1 answer

Oracle: what is the command switch to DOS prompt from sql ?

posted Mar 12, 2015 by Suchithra

+2 votes

1 answer

Oracle: explain NVL function?

posted Mar 12, 2015 by Suchithra

+2 votes

1 answer

How to create composite primary key in oracle/SQL?

posted Mar 7, 2015 by Varun Kumar

+2 votes

1 answer

Oracle: How can I use a large rollback segment ( rblarge )to avoid the snapshot too old error ?

posted Mar 4, 2015 by Vidhya Sagar

+2 votes

1 answer

Oracle: How can I see what tables I have access to and what tables I own?

posted Mar 4, 2015 by Vidhya Sagar

+2 votes

1 answer

Oracle: What are these v$, x$ tables and views?

posted Mar 3, 2015 by Vidhya Sagar

+2 votes

1 answer

Oracle: What is nls_date_format?

posted Mar 3, 2015 by Vidhya Sagar

+2 votes

1 answer

Please help me to know if I can use WHERE and HAVING both in same query?

posted Mar 2, 2015 by Anamika

+2 votes

1 answer

Explain the difference between a hot backup and a cold backup and the benefits associated with each.

posted Feb 18, 2015 by Sathyasree

+2 votes

1 answer

Oracle: What do locks actually do?

posted Feb 13, 2015 by Archana

+2 votes

1 answer

If you insert a row in a table, then create another table and then say Rollback. In this case will the row be inserted ?

posted Feb 11, 2015 by Jayshree

+2 votes

1 answer

Can one use dynamic SQL within PL/SQL? OR Can you use a DDL in a procedure ? How ?

posted Feb 11, 2015 by Jayshree

+2 votes

2 answers

Oracle: How can I retrieve a specified number of highest- or lowest-value columns with a single query?

posted Feb 10, 2015 by Archana

+2 votes

1 answer

Oracle: How can i change the password for my username?

posted Feb 10, 2015 by Archana

+2 votes

1 answer

how we can retrieve the unique values for the in a table without using the DISTINCT keyword

posted Feb 1, 2015 by Garima Gupta

+2 votes

0 answers

JSP: What does mean of SQLWarning objects How to Retrieve Warnings?

posted Jan 31, 2015 by Amit Kumar Pandey

+2 votes

1 answer

Interview question: Which of the following is not a schema object Oracle?

posted Jan 30, 2015 by Archana

+2 votes

1 answer

What are various types of joins in Oracle?

posted Jan 27, 2015 by Archana

+2 votes

1 answer

Oracle: Below were the interview questions which was held by IBM.

posted Jan 2, 2015 by Suchithra

+2 votes

1 answer

Oracle:If a transaction is very large..will the transaction span across different rollback segments

posted Dec 30, 2014 by Arun Gowda

+2 votes

2 answers

Oracle: What is the significance of the &, and && operators in PL SQL?

posted Dec 24, 2014 by Archana

+2 votes

1 answer

Oracle: Is it possible to pass a parameter to a cursor?

posted Dec 24, 2014 by Archana