Are sql views compiled?
Answer / kiran r
NO SQL VIEWS ARE NOT GONNA COMPILED AS APROCEDURE
| Is This Answer Correct ? | 0 Yes | 0 No |
How do you exit in sql?
Mention what problem one might face while writing log information to a data-base table in pl/sql?
What are wait events. Describe the wait event tables.
Is sql a dbms?
Whate is use of MOD function in pl/sql.
What are functions in sql?
Explain autonomous transaction.
Initially question was asked to mention the types of indexes. Then asked about BITMAP INDEX and B-Tree Index
What is a trigger word?
can use the following like overloading concept in a single package: procedure p1(a varchar), procedure p1(a varchar2), procedure p1(a char)
Give the structure of the procedure ?
What is a schema sql?
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)