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 |
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
Is it possible to update the multiple field values in a single query? If possible then write the actual query.
What are statistics, under what circumstances they go out of date, how do you update them?
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
Explain about your sql server dba experience? : sql server DBA
What are the commands used in dcl? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
Explain an ORA-01555
How can you gather statistics on a table?
I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
What the different topologies in which replication can be configured? : sql server DBA
Oracle 11g new features?
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)