Interested to Buy Any Domain ? << Click Here >> for more details...
how will u see whether the dabase is in archive log mode or not?
- 2 Answers
- 4378 Views
- CSC, I also Faced
- E-Mail Answers
Answer Posted / krishna
archive log list
select log_mode from v$database;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
Why would you call update statistics? : sql server DBA
What are the different types of database compression introduced in sql server 2008? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
. 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
what is a crs resource?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
Query processing is slow(eg select query)how will u solve that
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
what is a user-defined lock?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
How do you trace the traffic hitting a sql server? : sql server DBA
