What is the maximum number of triggers,can apply to a single
table?
Answers were Sorted based on User's Feedback
Answer / gaurav
With oracle 10g and above:- unlimited
9 or below :- 12
| Is This Answer Correct ? | 2 Yes | 0 No |
Types of joins?
Why is normalization important?
What is implicit cursor in pl sql?
Explain the difference between 'between' & 'and' operators in sql
what are the security recommendations while using mysql? : Sql dba
how to insert the data through views? The view is depending upon more than two tables? how to update materalized views?
What is the difference between CHAR and VARCHAR2? If VARCHAR2 serves the uses of CHAR why CHAR is still used and not been discarded yet?
What are Lexical Parameters.How They are used in Reports 6i
how to create object in plsql
What is Histogram?
how to increment dates by 1 in mysql? : Sql dba
In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join.
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)