top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Questions answered by gowda

1 vote
What are the values of :new and :old in Insert/Delete/Update Triggers in Oracle ?
answer Dec 12, 2014
2 votes
What are cascading triggers? What is the maximum no of cascading triggers at a time in Oracle?
answer Dec 12, 2014
1 vote
Oracle: Can views be specified in a trigger statement?
answer Dec 11, 2014
0 votes
Oracle: What is the maximum no. of statements that can be specified in a trigger statement?
answer Dec 11, 2014
1 vote
What is the advantage of a stored procedure over a database trigger?
answer Dec 10, 2014
1 vote
What are the parts of a database trigger?
answer Dec 10, 2014
1 vote
Oracle: Can you pass parameters in packages? If yes then how?
answer Dec 8, 2014
1 vote
Why "create or Replace" but not the "drop and recreate" while creating procedures?
answer Dec 8, 2014
2 votes
select data from multiple rows in a single columnsql
answer Dec 5, 2014
1 vote
Can 2 functions have same name & input parameters but differ only by Return data type?
answer Dec 5, 2014
1 vote
what are the constructs of a procedure, function or a package?
answer Dec 5, 2014
1 vote
What is Cursor ? Explain With Example?
answer Dec 5, 2014
1 vote
Can functions be over loaded?
answer Dec 4, 2014
1 vote
What is Over Loading and what are its restrictions?
answer Dec 4, 2014
0 votes
Can some body give me some example of INSTEAD OF trigger?
answer Dec 3, 2014
1 vote
How can I get the source code for a function or a procedure or a package from the database?
answer Dec 3, 2014
1 vote
What are the various types of parameter modes in a procedure in PLSQL ?
answer Dec 2, 2014
1 vote
Can you call a stored function in the constraint of a table?
answer Dec 2, 2014
1 vote
How does one get the value of a sequence into a PL/SQL variable?
answer Nov 26, 2014
1 vote
What DBMS package should I use to manipulate the long column in Oracle 7
answer Nov 26, 2014
1 vote
How can I view the dependencies of a PL/SQL block?
answer Nov 24, 2014
1 vote
What are the two ways to specify a column alias?
answer Nov 24, 2014
0 votes
What is a Result Set? when is it created?
answer Nov 19, 2014
0 votes
Can one only retreive rows X to Y from a table?
answer Nov 19, 2014
0 votes
What are constraints? Explain different types of constraints?
answer Nov 18, 2014
0 votes
How many types of triggers are there?
answer Nov 18, 2014
1 vote
Explain Implicit and Explicit cursors.
answer Nov 13, 2014
0 votes
What is Commit, Rollback and Savepoint in context of SQL/Oracle?
answer Nov 12, 2014
0 votes
How does a syntax error differ from a runtime error in Oracle SQL?
answer Nov 12, 2014
0 votes
What special operators does Oracle provide for dealing with NULLs?
answer Nov 12, 2014
0 votes
Explain three different rules that apply to NULLs when doing comparisons?
answer Nov 12, 2014
0 votes
can anyone tell me about SQL tuning tips?
answer Nov 7, 2014
0 votes
unable to connect to the DB using Taod ORA-12571 TNS packet writer failure
answer Nov 7, 2014
0 votes
can any one explain about SQL Unions Clause in detail ?
answer Nov 7, 2014
1 vote
What is a transaction and what are ACID properties in Oracle?
answer Nov 3, 2014
1 vote
Explain different isolation levels in Oracle?
answer Nov 3, 2014
1 vote
What's the maximum size of a row in Oracle?
answer Nov 3, 2014
1 vote
Explain Active/Active and Active/Passive cluster configurations ?
answer Nov 3, 2014
1 vote
Explain the architecture of SQL Server?
answer Nov 3, 2014
2 votes
What is lock escalation?
answer Nov 3, 2014
0 votes
Explain the storage models of OLAP?
answer Nov 3, 2014
1 vote
What are the new features introduced in SQL Server 2000 ?
answer Nov 3, 2014
0 votes
What changed between the previous version of SQL Server and the current version?
answer Nov 3, 2014
1 vote
What are the steps you will take to improve performance of a poor performing query?
answer Nov 3, 2014
1 vote
What are the steps you will take, if you are tasked with securing an SQL Server?
answer Nov 3, 2014
1 vote
Is space acquired in blocks or extents in Oracle?
answer Nov 3, 2014
1 vote
How many columns can table have in Oracle?
answer Oct 22, 2014
1 vote
What is pseudo columns in Oracle and what are their names?
answer Oct 22, 2014
0 votes
What is the Difference between a post query and a pre query?
answer Oct 21, 2014
1 vote
What is Normalization in Oracle?
answer Oct 20, 2014
Page:
...