Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

2220

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

2502

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

1964

What is a system database and what is a user database? : sql server DBA

1318

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

1137

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

1095

What purpose does the model database server? : sql server DBA

1273

how can you implement fine-grained auditing?

1206

how can you connect from 10g user to 11g user??

2169

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2090

how can you create a user-defined lock?

1058

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

1079

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?

2746

What is the default port no on which sql server listens? : sql server DBA

1224

What is replication? : sql server DBA

1239