Re: Oracle DBA Interview Questions

From: Anton <djeday84_at_gmail.com>
Date: Mon, 14 Mar 2016 12:54:18 +0300
Message-ID: <56E68A4A.9030206_at_gmail.com>

hello =) best question in my interview was: when selects without any funtions can do redo ?

On 03/08/2016 02:56 PM, rob_at_oraclewizard.com 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 _at_navonpilot
> youtube https://www.youtube.com/user/n4281k
> blog: http://www.oraclewizard.com
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Mar 14 2016 - 10:54:18 CET