Answer / guest

o A full database backup is a full copy of the database.
o A transaction log backup copies only the transaction log.
o A differential backup copies only the database pages
modified after the last full database backup.
o A file or filegroup restore allows the recovery of just
the portion of a database that was on the failed disk.

What is fill factor? : sql server DBA

0 Answers  

---

From the database level, how can you tell under which time zone a database is operating?

1 Answers  

---

Where do you find the default index fill factor and how to change it? : sql server DBA

0 Answers  

---

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?

0 Answers  

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

0 Answers  

---

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1 Answers  

---

how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.

4 Answers   DELL, TCS,

---

what is logical system in sap basis

0 Answers  

---

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

0 Answers  

---

Name two files used for network connection to a database.

5 Answers  

---

In oracle 10g export, import if we declare rows=y/n what would be the output?

0 Answers   Value Labs,

---

What are the different types of indexes available in sql server? : sql server DBA

0 Answers  

---