Recent posts under tag oracle

+2 votes

1 answer

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

posted Apr 2, 2015 by Vidhya Sagar

+4 votes

2 answers

Oracle: What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

posted Apr 1, 2015 by Suchithra

+3 votes

1 answer

oracle: What does coalescing a tablespace do?

posted Apr 1, 2015 by Suchithra

+3 votes

1 answer

Oracle: Give two methods you could use to determine what DDL changes have been made

posted Mar 31, 2015 by Archana

+3 votes

1 answer

Oracle: How would you force a log switch?

posted Mar 31, 2015 by Archana

+4 votes

1 answer

Oracle: Describe what redo logs are?

posted Mar 30, 2015 by Archana

+4 votes

1 answer

Oracle: How would you determine what sessions are connected and what resources they are waiting for?

posted Mar 30, 2015 by Archana

+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

+1 vote

1 answer

Explain materialized views and how they are used in Oracle?

posted Mar 26, 2015 by Archana

+1 vote

1 answer

Where in the Oracle directory tree structure are audit traces placed?

posted Mar 26, 2015 by Archana

+2 votes

1 answer

Oracle: Name three advisory statistics you can collect.

posted Mar 25, 2015 by Suchithra

+1 vote

1 answer

Oracle: Explain the use of table functions.

posted Mar 25, 2015 by Suchithra

+1 vote

1 answer

What command would you use to encrypt a PL/SQL application?

posted Mar 24, 2015 by Vidhya Sagar

+1 vote

1 answer

Oracle: Explain the use of setting GLOBAL_NAMES equal to TRUE.

posted Mar 24, 2015 by Vidhya Sagar

+1 vote

1 answer

oracle: Explain the use of setting GLOBAL_NAMES equal to TRUE.

posted Mar 23, 2015 by Suchithra

+1 vote

1 answer

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

posted Mar 23, 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

+1 vote

1 answer

is any other way to replace query result null value with a text

posted Mar 18, 2015 by Vidhya Sagar

+1 vote

1 answer

What are PL/SQL Cursor Exceptions?

posted Mar 18, 2015 by Vidhya Sagar

+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

+3 votes

1 answer

Oracle: how to display Odd/ Even number of records?

posted Mar 16, 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

Orcale: How to view installed Oracle version information?

posted Mar 13, 2015 by Suchithra

+1 vote

1 answer

Oracle: how to find out 9th highest salary from emp table?

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

+1 vote

1 answer

How to display the records between two range of rownum in Oracle?

posted Mar 11, 2015 by Archana

+1 vote

1 answer

How do I display row number with records in Oracle?

posted Mar 11, 2015 by Archana

+1 vote

1 answer

How do I eliminate the duplicate rows in Oracle?

posted Mar 10, 2015 by Archana

+1 vote

1 answer

How to see current user name and to Change SQL prompt name in Oracle?

posted Mar 10, 2015 by Archana

+1 vote

2 answers

Oracle: What is a Cartesian product?

posted Mar 9, 2015 by Suchithra

+1 vote

2 answers

Oracle: which of the following is better to find the number of rows in a table?

posted Mar 9, 2015 by Suchithra

+1 vote

Senior Software Engineer at Turaco Mobile

posted Mar 9, 2015 by Turaco Mobile Pvt Ltd.

+2 votes

1 answer

How to create composite primary key in oracle/SQL?

posted Mar 7, 2015 by Varun Kumar

+1 vote

1 answer

Oracle: What is a ROWID and Why do we need that?

posted Mar 6, 2015 by Suchithra

+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

0 votes

Programmer Analyst at Oracle Corporation

posted Mar 2, 2015 by anonymous

+1 vote

1 answer

Oracle: Give the reasoning behind using an index?

posted Feb 23, 2015 by Latha

+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

+1 vote

1 answer

Oracle: Is it possible to split the print reviewer into more than one region?

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