Recent posts under tag sql

+2 votes

1 answer

Difference between SQL(RDBMS) and mongoDB ?

posted Jun 2, 2015 by Alok

+1 vote

1 answer

How you will avoid your query from using indexes in Oracle?

posted Jun 2, 2015 by Vidhya Sagar

+1 vote

1 answer

Which is more faster - IN or EXISTS In Oracle?

posted Jun 2, 2015 by Vidhya Sagar

+1 vote

2 answers

What is a CO-RELATED SUBQUERY?

posted Jun 1, 2015 by Suchithra

+1 vote

0 answers

Is it possible to write a PL/SQL procedure that takes a table name as input and does something with that table?

posted Jun 1, 2015 by Suchithra

+1 vote

1 answer

Find out nth highest salary from emp table in Oracle?

posted May 29, 2015 by Kunal Kapoor

+1 vote

1 answer

How does one code a matrix report in SQL using SUM & DECODE function?

posted May 29, 2015 by Kunal Kapoor

+1 vote

1 answer

How does one select EVERY Nth row from a table In Oracle?

posted May 28, 2015 by Viswas Kumar

+1 vote

1 answer

How does one select the TOP N rows from a table in Oracle?

posted May 28, 2015 by Viswas Kumar

+1 vote

1 answer

why Oracle’s procedural language is used for?

posted May 26, 2015 by Vidhya Sagar

+1 vote

1 answer

what is distributed database network?

posted May 26, 2015 by Vidhya Sagar

+2 votes

1 answer

Will non-procedural language specify what to do? or not how to do?

posted May 25, 2015 by Suchithra

+3 votes

1 answer

what is relations operator in Oracle?

posted May 25, 2015 by Suchithra

+1 vote

1 answer

which are the tools that allows direct and interactive use of the SQL language to access the Oracle server ?

posted May 22, 2015 by Kunal Kapoor

+1 vote

1 answer

SQL & Pl/SQL are used in which of the following products SQL*plus, Oracle Forms and Oracle reports?

posted May 22, 2015 by Kunal Kapoor

+2 votes

1 answer

Is SQL is Procedural language?

posted May 21, 2015 by Viswas Kumar

+2 votes

1 answer

what is the advantages of partitioning in Oracle?

posted May 20, 2015 by Archana

–1 vote

1 answer

what RDBMS stands for?

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

+3 votes

1 answer

how to insert multiple records in a single query?

posted May 15, 2015 by Muskan

+1 vote

1 answer

How the relational database stores the data?

posted May 13, 2015 by Archana

+1 vote

1 answer

what is the minimum CODD rules for any DBMS to be considered as on RDBMS?

posted May 13, 2015 by Archana

+1 vote

1 answer

How to add Comments on table and columns in Oracle?

posted May 11, 2015 by Suchithra

+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

2 answers

how to Alter database archievelog in Oracle?

posted May 5, 2015 by Vidhya Sagar

+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

0 votes

QA Engineer at Real Page

posted Apr 29, 2015 by anonymous

+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