What are statistics, under what circumstances they go out
of date, how do you update them?
No Answer is Posted For this Question
Be the First to Post Answer
How would you force a log switch?
What column differentiates the V$ views to the GV$ views and how?
why do we give pctfree and pctused in create table statement?
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?
How would you go about generating an EXPLAIN plan?
Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
Where do you find the default index fill factor and how to change it? : sql server DBA
if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
orra 1555 what is this error,why it is occur?
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)