Interested to Buy Any Domain ? << Click Here >> for more details...
Where do you find the default index fill factor and how to change it? : sql server DBA
- 0 Answers
- 1121 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Query processing is slow(eg select query)how will u solve that
what are the benefits of flashback feature?
What background process refreshes materialized views?
2 Answers Accenture, FLSmidth,
1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace?????
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
Explain materialized views and how they are used.
Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?
You have just compiled a PL/SQL package but got errors, how would you view the errors?
how can you enable flashback feature?
how can you get actual data change values from previous transactions in oracle?
What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?
-
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)
