Most answered questions under tag sql

+1 vote

1 answer

Explain Unbalanced Index in Oracle?

posted May 11, 2015 by Suchithra

+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

+1 vote

1 answer

what is Redo Log in Oracle?

posted Apr 30, 2015 by Viswas Kumar

+1 vote

1 answer

what are UTLBSTAT and UTLESTAT in Oracle?

posted Apr 30, 2015 by Viswas Kumar

+1 vote

1 answer

Difference between PRIMARY KEY, UNIQUE KEY, CANDIDATE KEY? Where I have to use this?

posted Apr 30, 2015 by Nagaraj

+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

+1 vote

1 answer

What is ORDBMS in Oracle 8?

posted Apr 17, 2015 by Vidhya Sagar

+1 vote

1 answer

Explain about Oracle 8i?

posted Apr 17, 2015 by Vidhya Sagar

+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

+1 vote

1 answer

Oracle: How can you gather statistics on a table?

posted Apr 9, 2015 by Kunal Kapoor

+3 votes

1 answer

Oracle: You have just compiled a PL/SQL package but got errors, how would you view the errors?

posted Apr 8, 2015 by Kunal Kapoor

+3 votes

1 answer

Oracle: Explain what partitioning is and what its benefit is.

posted Apr 8, 2015 by Kunal Kapoor

+3 votes

1 answer

What is open query in sql server?

posted Apr 8, 2015 by Muskan

+1 vote

1 answer

Oracle: How can you rebuild an index?

posted Apr 7, 2015 by Viswas Kumar

+1 vote

1 answer

Oracle: How would you determine who has added a row to a table?

posted Apr 7, 2015 by Viswas Kumar

+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

+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

+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