Recent posts under tag sql

0 votes

1 answer

Oracle: What is the difference between a view and a synonym?

posted Jan 13, 2015 by Archana

0 votes

1 answer

Oracle: Can you create index on view?

posted Jan 13, 2015 by Suchithra

0 votes

1 answer

Oracle: can you alter synonym of view or view?

posted Jan 12, 2015 by Suchithra

0 votes

1 answer

Oracle:Can database trigger written on synonym of a table?

posted Jan 12, 2015 by Suchithra

+1 vote

1 answer

What is the result of the following SQL?

posted Jan 12, 2015 by Suchithra

+1 vote

2 answers

Oracle: When to create indexes?

posted Jan 9, 2015 by Archana

+1 vote

2 answers

Oracle: How can you avoid indexes?

posted Jan 9, 2015 by Archana

0 votes

1 answer

What are the disadvantages of SQL?

posted Jan 8, 2015 by Archana

0 votes

1 answer

Oracle: While designing in client/server what are the 2 imp. Things to be considered?

posted Jan 8, 2015 by Archana

0 votes

1 answer

Oracle: What is Auditing?

posted Jan 7, 2015 by Suchithra

+1 vote

1 answer

Oracle: Definition of relational Database by Dr. Codd (IBM)?

posted Jan 6, 2015 by Archana

0 votes

1 answer

Oracle: sequence, currval and nextval ?

posted Jan 5, 2015 by Archana

+1 vote

1 answer

Oracle: Is Sysdate a system variable or a system function?

posted Jan 5, 2015 by Archana

+3 votes

0 answers

Is there a way to make the Sql Server FullText engine to stop recognizing numbers as numbers?

posted Jan 2, 2015 by Vrije Mani Upadhyay

+1 vote

1 answer

Oracle: A table has the following data : [5, Null, 10]. What will the average function return?

posted Jan 2, 2015 by Suchithra

+2 votes

1 answer

Oracle: Below were the interview questions which was held by IBM.

posted Jan 2, 2015 by Suchithra

+1 vote

1 answer

Oracle: How many rows will the following SQL return?

posted Dec 31, 2014 by Archana

+1 vote

1 answer

Oracle: How many rows will the following SQL return?

posted Dec 31, 2014 by Archana

+1 vote

1 answer

oracle: Is the assignment given below allowed ?

posted Dec 30, 2014 by Suchithra

+1 vote

1 answer

Oracle: Is the query below allowed?

posted Dec 30, 2014 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

+1 vote

1 answer

Is there a way to create a SQL Server function to “join” multiple rows from a subquery into a single delimited field?

posted Dec 29, 2014 by Amit Kumar Pandey

+1 vote

2 answers

Oracle: What are the various types of RollBack Segments?

posted Dec 29, 2014 by Archana

+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

+1 vote

2 answers

What is the maximum no. of columns a table can have in Oracle ?

posted Dec 23, 2014 by Suchithra

+1 vote

1 answer

Can we define multiple save points and Rollback to any save points? in Oracle

posted Dec 23, 2014 by Suchithra

+1 vote

1 answer

When we use insert statement followd by a create table statement followed by rollback?

posted Dec 22, 2014 by Archana

+1 vote

1 answer

What are the states of a rollback segment? What is the difference between partly available and needs recovery in Oracle?

posted Dec 22, 2014 by Archana

+1 vote

2 answers

how to truncate a whole database(tables with too many referential keys) in sqlserver?

posted Dec 19, 2014 by Muthumani

+1 vote

1 answer

What are the min. extents allocated to a rollback extent in Oracle?

posted Dec 19, 2014 by Suchithra

0 votes

1 answer

Can Check constraint be used for self referential integrity? if Yes, How? In Oracle

posted Dec 19, 2014 by Suchithra

0 votes

1 answer

Can null keys be entered in cluster index, normal index in Oracle?

posted Dec 18, 2014 by Archana

0 votes

1 answer

Can Long/Long RAW be clustered in Oracle?

posted Dec 18, 2014 by Archana

+1 vote

2 answers

What are the disadvantages of clusters in Oracle?

posted Dec 17, 2014 by Vidhya Sagar

+1 vote

2 answers

What are the advantages of clusters in Oracle?

posted Dec 17, 2014 by Vidhya Sagar

+1 vote

1 answer

What is the use of Data Dictionary in Oracle?

posted Dec 16, 2014 by Vidhya Sagar

+1 vote

1 answer

What is the use of Control files in Oracle?

posted Dec 16, 2014 by Vidhya Sagar

0 votes

1 answer

Can you increase the size of a table space in Oracle? If yes then How?

posted Dec 15, 2014 by Suchithra

0 votes

1 answer

Describe Oracle database's physical and logical structure In Oracle?

posted Dec 15, 2014 by Suchithra

+1 vote

1 answer

In Oracle, how to enabled triggers performs the following actions?

posted Dec 12, 2014 by Kali Mishra

+1 vote

1 answer

What are constraining triggers in Oracle?

posted Dec 12, 2014 by Archana

+1 vote

1 answer

What are mutating triggers?

posted Dec 12, 2014 by Archana

+1 vote

1 answer

What are the values of :new and :old in Insert/Delete/Update Triggers in Oracle ?

posted Dec 11, 2014 by Vidhya Sagar

0 votes

1 answer

Oracle: Can views be specified in a trigger statement?

posted Dec 10, 2014 by Suchithra

+1 vote

1 answer

Oracle: What is the maximum no. of statements that can be specified in a trigger statement?

posted Dec 10, 2014 by Suchithra

+1 vote

1 answer

What is the advantage of a stored procedure over a database trigger?

posted Dec 8, 2014 by Suchithra

+1 vote

1 answer

What are the parts of a database trigger?

posted Dec 8, 2014 by Suchithra

+1 vote

1 answer

Oracle: Can you pass parameters in packages? If yes then how?

posted Dec 5, 2014 by Archana

+1 vote

1 answer

Why "create or Replace" but not the "drop and recreate" while creating procedures?

posted Dec 5, 2014 by Archana