hello =) best question in my interview was: when selects without any
funtions can do redo ?
On 03/08/2016 02:56 PM, rob@xxxxxxxxxxxxxxxx wrote:
I've put togehter some questions for Oracle DBA's; however one of my co-workers say the questions are a bit tough. Said "we don't want to scare a potential employee." Can y'all comment, are these questions too hard? Should I include more Backup and Recovery? What are your thoughts? -Rob
1.
Make a column not null, but you have null values in the column.
How would you approach the problem?
2.
How would you change the encryption algorithm on a tablespace.
3.
Can you rekey (rotate keys) for encrypted tablespaces?
4.
What process would you use to encrypt data in an existing tablespace?
5.
How to you rekey change the encryption algorithm on an encrypted
column?
1.
Alter table <table name> rekey using ‘<encryption algorithm>’;
6.
A junior DBA deleted some archive logs prior to them being applied
to the standby database. How do you get the standby database resynced?
7.
You have encrypted a set of columns, there are existing indexes on
those columns. When you encrypted the columns, did the index get
encrypted?
8.
You ran an datapump backup of encrypted data, you did not specify
encryption in the datapump command line, is the datapump file
encrypted?
9.
In rman, you have executed CONFIGURE ENCRYPTION FOR DATABASE ON;
What encryption algorithm will Oracle use?
1.
select algoritm_name, is_default from
V$RMAN_ENCRYPTION_ALGORITHMS;
10.
How do you find out what users still have the default password?
1.
dba_users_with_defpwd
===================================
Robert P. Lockard Oracle ACE
President Oraclewizard.com, Inc.
"When given the choice between two evils, I always take the one I have not tried." Mae West
(cell) 571.276.4790
(office) 410.766.6960
(fax) 410.766.0332
twitter @navonpilot
youtube https://www.youtube.com/user/n4281k
blog: http://www.oraclewizard.com
