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 |
Give the two types of tables involved in producing a star schema and the type of data theyhold.
How would you determine who has added a row to a table?
How do you switch from an init.ora file to a spfile?
how do see how much space is used and free in a tablespace
What type of index should you use on a fact table?
Where would you look for errors from the database engine?
How to determine the service pack currently installed on SQL Server?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
What purpose does the model database server? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
how can you implement fine-grained auditing?
I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........
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)