DBA Questions

1 Whats your daily activities?

2 How to exprot full database?

3 Difference b/w exp/imp and expdp/impdp?

4 What is meant by content=ALL in data pump

5 How to take meta data of your user?

    select dbms_metadata.get_ddl('USER','JAI') from dual;

6 How to schema refresh?

7 What is ignore=y

8 What is dertroy=y

9 How to take full backing RMAN?

10 What is your backup strategy in your company?

11 What is diff b/w cumulative and full and incremental?

12 What is diff b/w hot backup, cold backup and RMAN backup?

13 How to recover full database?

14 What is meant by point in time recovery?

15 How to check validate backup set?

16 How to recover single datafile?

17 How to increase the performance of rman?

18 What retention window or policy?

19 Diff b/w absolute and expire backup?

20 How to create a user ? Create unlock and reset password of the uer?

21 How to allocate user quota for perticular uer?

22 How to check object or table level privillage of user?

23 What is diff b/w admin option and grant option ?

24 How to create table space add datafile and resize?

25 How to check free space of tablespace and used space of tablespace ?

26 How to check temporary tablespace ussage?

    v$temp_header_file

27 Diff b/w dictionary managed tablespace locally managed table space?

28 What  is colesec and rebuild in index?

29 What are all sga components?

30 What is default background process and explain?

31 Explain check point?

32 How to switch over redo log file?

33 What is pct used pct free ?

34 What is row migration and row changing?

35 How to cloning and explain the steps?

36 How to configure dataguard and explain pre and post request?

37 How to find the gab and how to resolve?

38 How to check whether its is standby or not?

39 How to switch over primary to standby and standby (db drill)?

40 How to take snapshot for AWR report?

41 What is the default table space for AWR report?

42 How analyze AWR report, if user he facing performance issue in the query what will do

43 What you fell difficult task in your project?

44 Diff b/w RFS and MRP?

45 How kill session?