how will u see whether the dabase is in archive log mode or not?
Answers were Sorted based on User's Feedback
Answer / kittu
in two ways we can check
1) archive log list
2) select log_mode from v$database;
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / krishna
archive log list
select log_mode from v$database;
| Is This Answer Correct ? | 1 Yes | 0 No |
by issuing "alter tablespace begin backup;" what happens to tablespace?
what are the benefits of flashback feature?
Where would you look for errors from the database engine?
Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
How can we see the database version in os level
What is the importance of a recovery model? : sql server DBA
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.
What are the operating modes in which database mirroring runs? : sql server DBA
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Explain materialized views and how they are used.
You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?
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)