What type of index should you use on a fact table?
Answer / monal
IN SQL SERVER 2005 USING NON CLUSTERED INDEX WOULD BE BETTER.
| Is This Answer Correct ? | 3 Yes | 0 No |
Which environment variables are absolutely critical in order to run the OUI?
What is the difference between LMT & DLT?
Datapump backup steps?
Explain how you would restore a database using RMAN to Point in Time?
Name two files used for network connection to a database.
What does coalescing a tablespace do?
Query processing is slow(eg select query)how will u solve that
What command would you use to encrypt a PL/SQL application?
When a user process fails, what background process cleans up after it?
what is ora 600?
Give the reasoning behind using an index.
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
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)