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 |
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
From the database level, how can you tell under which time zone a database is operating?
SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.
now one user in online.now i want drop him..how do u drop him?
What are the recovery models for a database? : sql server DBA
What is a system database and what is a user database? : sql server DBA
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
what are the benefits of flashback feature?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
What is the recommended interval at which to run statspack snapshots, and why?
What would you do with an "in-doubt" distributed transaction?
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)