DBA QUESTIONS FOR DRIVERS ED SOFTWARE
DBA QUESTIONS FOR DRIVERS ED PROFESSIONAL
DBA QUESTIONS FOR DRIVERS ED SERIES

Advanced (A 3+ year experienced DBA should have enough knowledge to answer these questions. How would you do it?Дў.6 Q- What is the most important requirement in order to use RMAN to make consistent hot backups?ДЄ- Your database has to be in ARCHIVELOG mode.Дў.7 Q- Can you connect to a local database without a listener?Дў.8 Q- In which view can you find information about every view and table of oracle dictionary?Дў.9 Q- How can you view all the users account in the database?Дў.10 Q- In linux, how can we change which databases are started during a reboot?ДЈ. If you want to modify parameters in PFILE, you have to restart the database.ДЄ SPFILE is a dynamic, binary file that allows you to overwrite parameters while the database is already started (with some exceptions)Дў.3 Q- In which Oracle version was Data Pump introduced?Дў.4 Q- Say two examples of DML, two of DCL and two of DDLДЄ- DML: SELECT, INSERT, UPDATE, DELETE, MERGE, CALL, EXPLAIN PLAN, LOCK TABLEДDL: CREATE, ALTER, DROP, TRUNCATE, COMMENT, RENAMEДў.5 Q- You want to save the output of an Oracle script from sqlplus. He could fail one or two questions, but not more)Дў.1 Q- What should you do if you encounter an ORA-600?Дў.2 Q- Explain the differences between PFILE and SPFILEДЄ- A PFILE is a Static, text file that initialices the database parameter in the moment that itвЂ™s started. Moderate (Standard knoledge for a daily-work of every DBA.

DBA QUESTIONS FOR DRIVERS ED SOFTWARE

This knowledge is just basic for a 3+ year experienced DBA)ДЎ.1 Q- Which are the default passwords of SYSTEM/SYS?ДЎ.2 Q- How can you execute a script file in SQLPLUS?ДЄ- To execute a script file in SQLPlus, type and then the file name.ДЎ.3 Q- Where can you find official Oracle documentation?ДЎ.4 Q- What is the address of the Official Oracle Support?ДЄ- or ДЎ.5 Q- What file will you use to establish Oracle connections from a remote client?ДЎ.6 Q- How can you check if the database is accepting connections?ДЎ.7 Q- Which log would you check if a database has a problem?ДЎ.8 Q- Name three clients to connect with Oracle, for example, SQL Developer:ДЄ- SQL Developer, SQL-Plus, TOAD, dbvisualizer, PL/SQL DeveloperвЂ¦ There are several, but an experienced dba should know at least three clients.ДЎ.9 Q- How can you check the structure of a table from sqlplus?ДЎ.10 Q- What command will you start to run the installation of Oracle software on Linux?Дў. Basic (Every DBA should answer correctly ALL these questions. Either if you are the interviewer, or the interviewer.

DBA QUESTIONS FOR DRIVERS ED SERIES

Look for stories where candidates erred, rectified their error and learned a valuable lesson from it.In response for a reader of this blog who asked me for some interview questions for a 3+Year experienced DBA, I have written this series of questions that you can use in your interviews.

How did you rectify it?Д¬andidates should acknowledge the importance of diligence in their duties and how oversight can lead to being late, causing damage to company reputation. Describe a time when you made a mistake in your duties.

DBA QUESTIONS FOR DRIVERS ED PROFESSIONAL

How do you manage the situation?Д¬andidates should always remain calm and professional when dealing with clients. A client is being difficult to deal with. What, in your opinion, is the most important quality in a driver?Д¬andidates should list good organizational and interpersonal skills as the most important attributes in a Driver. Look for candidates who point out the most optimal route and detail the nuances of different approaches.

This question tests a candidate's knowledge of his operational area. How do I get to the nearest hospital from where we currently are? Look for candidates who display critical thinking when driving to ensure their safety on the road. Have you ever been in a car accident?Д¬andidates should describe how the accident occurred, the steps they have taken to avoid repeating it and the lessons they've learned from it.

Dba questions for drivers ed