Answer Posted / prashe

select OWNER,OBJECT_NAME,CREATED,LAST_DDL_TIME,from
dba_objects where OBJECT_NAME='&object_name';
for DDL command.

Where would you look for errors from the database engine?

2833

---

what is a user-defined lock?

1038

---

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

2422

---

Why would you use sql agent? : sql server DBA

1063

---

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

1082

---

How to start SQL Server in minimal configuration mode?

7929

---

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

1243

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1893

---

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

1167

---

What is transparent data encryption? : sql server DBA

1171

---

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

1081

---

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?

2656

---

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

1920

---

. 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?

2432

---

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

2527

---