Recent posts under tag sql

+1 vote

1 answer

Oracle: How do you add a data file to a tablespace?

posted Apr 3, 2015 by Suchithra

+3 votes

1 answer

What is the difference between Rollup ad cube?

posted Apr 3, 2015 by Santosh Kumar Panigrahi

+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

+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

+6 votes

1 answer

How to change multiple column datatype in SQL Server single query.

posted Apr 1, 2015 by Khusboo

+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

+4 votes

1 answer

How to fetch values from xml into table in sql

posted Mar 27, 2015 by Muskan

+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

+3 votes

1 answer

How do I install the MySQLdb under python programming?

posted Mar 26, 2015 by Amit Kumar Pandey

+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

1 answer

Oracle: Which date function returns number value?

posted Mar 17, 2015 by Archana

+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

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

+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

+3 votes

1 answer

What is mixed mode authentication in sql server???

posted Mar 11, 2015 by Muskan

+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

+4 votes

2 answers

What is the difference between SQL, MySql, Sqlite, Sqlite3

posted Mar 10, 2015 by anonymous

+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

+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