What command would you use to encrypt a PL/SQL application?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
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.
Explain materialized views and how they are used.
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
What is checkpoint?
What is the difference between clustered and non-clustered index? : sql server DBA
What view would you use to determine free space in a tablespace?
When a user process fails, what background process cleans up after it?
Where in the Oracle directory tree structure are audit traces placed?
Give two methods you could use to determine what DDL changes have been made.
what is a user-defined lock?
What is the recommended interval at which to run statspack snapshots, and why?