The encryption questions are tough for someone that has not used the
encryption.
As encryption is not required by everyone, many DBA's will have little
knowledge of these details.
It seems to me it would be fair to let interviewees know ahead of time that
encryption will be a topic during the interview.
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Principal Consultant at Pythian
Pythian Blog http://www.pythian.com/blog/author/still/
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com
On Tue, Mar 8, 2016 at 3:56 AM, <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 ACEPresident 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
