Explain the use of table functions.
Answer / gogune suresh kumar
Returns multi set data(records) that are subsequently used in
data transformations.
| Is This Answer Correct ? | 2 Yes | 0 No |
how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.
How to start SQL Server in minimal configuration mode?
what is asm?
How can you enable a trace for a session?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
How can you control the amount of free space in your index pages? : sql server DBA
How do you open a cluster administrator? : sql server DBA
What command would you use to encrypt a PL/SQL application?
Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?
11 Answers FA, GE, Wipro,
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
Oracle (3259)
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)