Answer Posted / guest

listener and tnsname

What is the difference between dropping a database and taking a database offline? : sql server DBA

1075

---

Why does Oracle not permit the use of PCTUSED with indexes?

2947

---

how can you create a user-defined lock?

1024

---

How would you extract DDL of a table without using a GUI tool?

2495

---

What is dcl? : sql server DBA

1277

---

How to start SQL Server in minimal configuration mode?

7985

---

Which autogrowth database setting is good? : sql server DBA

1164

---

who owns the operating system files created by the utl_file package?

1082

---

how can you implement fine-grained auditing?

1149

---

how can you get actual data change values from previous transactions in oracle?

1094

---

What are the different types of database compression introduced in sql server 2008? : sql server DBA

1113

---

what is the use of ocr?

1036

---

how can you generate profile of pl/sql applications to identify performance bottlenecks?

1089

---

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

1942

---

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

2309

---