Most voted questions under tag oracle

+2 votes

1 answer

what is Truncate is Oracle?

posted Apr 24, 2015 by Kunal Kapoor

+2 votes

1 answer

what is Data Binding in Oracle?

posted Apr 24, 2015 by Kunal Kapoor

+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

Please explain about Forward Declaration in Oracle?

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

2 answers

Oracle: Any three PL/SQL Exceptions?

posted Mar 17, 2015 by Archana

+2 votes

1 answer

Oracle: Which date function returns number value?

posted Mar 17, 2015 by Archana

+2 votes

1 answer

difference between analytic and aggregate function?

posted Mar 17, 2015 by Santosh Kumar Panigrahi

+2 votes

1 answer

Oracle: How to display the number value in Words ?

posted Mar 16, 2015 by Archana

+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

2 answers

Which of the following is not a schema object : Indexes, tables, public synonyms, triggers and packages ?

posted Feb 23, 2015 by Latha

+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

Oracle: What is dev60cgi and f60cgi?

posted Feb 12, 2015 by Amit Kumar Pandey

+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

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

+2 votes

1 answer

What are cascading triggers? What is the maximum no of cascading triggers at a time in Oracle?

posted Dec 11, 2014 by Vidhya Sagar

+2 votes

1 answer

what are the constructs of a procedure, function or a package?

posted Dec 4, 2014 by Suchithra

+2 votes

1 answer

Can 2 functions have same name & input parameters but differ only by Return data type?

posted Dec 4, 2014 by Suchithra

+2 votes

1 answer

Can you call a stored function in the constraint of a table?

posted Dec 1, 2014 by Archana

+2 votes

1 answer

What are the various types of parameter modes in a procedure in PLSQL ?

posted Dec 1, 2014 by Archana