Oracle Interview Questions – Part

·  Are there any troubleshooting tips for OEM? (for DBA)

·  Can 2 functions have same name & input parameters but differ only by return datatype ?

·  Can functions be overloaded ?

·  Can one export a subset of a table? (for DBA)

·  Can one import tables to a different tablespace? (for DBA)

·  Can one improve the performance of SQL*Loader? (for DBA)

·  Can one load data into multiple tables at once? (for DBA)

·  Can one load variable and fix length data records? (for DBA)

·  Can one modify data as it loads into the database? (for DBA)

·  Can one monitor how fast a table is imported? (for DBA)

·  Can one selectively load only the records that one need? (for DBA)

·  Can one skip certain columns while loading data? (for DBA)

·  Can one write scripts to send alert messages to the console?

·  Can we define exceptions twice in same block ?

·  Can you call a stored function in the constraint of a table ?

·  Can you have two functions with the same name in a PL/SQL block ?

·  Can you have two stored functions with the same name ?

·  Can you pass parameters in packages ? How ?

·  Difference between SUBSTR and INSTR ?

·  ere can one get more information about TCL? (for DBA)

·  Explain UNION,MINUS,UNION ALL, INTERSECT ?

·  How can a cross product be created?

·  How can get SQL*Loader to COMMIT only at the end of the load file? (for DBA)

·  How does one backout events and jobs during maintenance slots? (for DBA)

·  How does one load multi-line records? (for DBA)

·  How does one start the Oracle Intelligent Agent? (for DBA)

·  How does one use SQL*Loader to load images, sound clips and documents? (for DBA)

·  How does one use the import/export utilities? (for DBA)

·  How does one use the SQL*Loader utility? (for DBA)

·  How is possible to restrict the user to a list of values while entering values for parameters?

·  Is there a SQL*Unloader to download data to a flat file? (for DBA)

·  Should the OEM Console be displayed at all times (when there are scheduled jobs)? (for DBA)

·  What are the constructs of a procedure, function or a package ?

·  What are the parts of a database trigger ?

·  What are the pre requisites ?

·  What are the triggers available in the reports?

·  What are the two ways to incorporate images into a oracle forms application?

·  What are the types of SQL Statement ?

·  What are the types of visual attribute settings?

·  What are the various types of database triggers ?

·  What are the various types of Exceptions ?

·  What are the various types of parameter modes in a procedure ?

·  What do you mean by a block in forms4.0?

·  What is a display item?

·  What is import/export and why does one need it? (for DBA)

·  What is Over Loading and what are its restrictions ?

·  What is SQL*Loader and what is it used for? (for DBA)

·  What is the difference between a procedure and a function ?

·  What is the difference between boiler plat images and image items?

·  What is the difference between the conventional and direct path loader? (for DBA)

·  What is the Oracle Intelligent Agent? (for DBA)

·  What kind of jobs can one schedule with OEM? (for DBA)

·  Why Create or Replace and not Drop and recreate procedures ?

·  Why is a Where clause faster than a group filter or a format trigger?

 

 

 

How To Dress For An Interview: Dress For Success

 

 

How to dress for an interview is a question that people often have when preparing for a job interview that they really want to win.

The interview dress code is fairly straight forward especially for "office" or professional-type jobs.

You really can't go wrong with wearing business attire.

For a man, this means a business suit. Not a blazer and different color pants, a two-piece suit. Choose an appropriate and matching tie. You really can't go wrong with a good suit (think neutral or business colors like navy blue, black or dark gray).

For a woman, this can also mean a business suit or perhaps other business attire ie. a tailored business outfit. Think conservative colors and also consider the time of year ie. you probably don't want to wear wool during the summer.

It really depends on the position and company you are applying for but a lot of it is common sense.

Don't forget your shoes either! Make sure your shoes are nicely shined and are clean. Nothing is worse than wearing a nice suit but forgetting what's below your ankles!

That includes your socks, too. No white socks with dress shoes, guys!

Finally, don't forget hygiene. It's best to avoid strong smelling cologne or perfume on the day of an interview. Men, don't forget to shave.

At the end of the day, dress for success and use common sense. If you have trouble figuring out what to wear, ask someone you know who can offer correct advice.

Your dress style is certainly somewhat dependent on your industry and level of position but you really can't go wrong with wearing business attire.

Remember that it's better to overdress than underdress. A business suit whether you're male or female is best for office/professional positions and helps to present a great first impression.

Carl Mueller is an Internet entrepreneur and professional recruiter who wants to help you find your dream career. Free newsletter: Separate yourself from other job searchers by signing up for his free monthly newsletter: [https://www.find-your-dream-career.com/dream-career-finder.html] Free 5-day course: Sign up for The Effective Career Planner, Carl’s free 5-day course: https://www.find-your-dream-career.com/effective-career-planner.html Please feel free to reprint this article in its entirety in your ezine or on your website but please don’t change any of the content and ensure that you include the above bio that shows my website URLs. Article Source: https://EzineArticles.com/?expert=Carl_Mueller