InterviewSolution
Saved Bookmarks
InterviewSolution
This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your ORACLE knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
While the database instance is up and running, you receive an out-of-memory error due to the under-sizing of the shared pool. You checked the trace file and observed that the following error was always recorded during peak hours:ORA-04031: unable to allocate 4000 bytes of shared memory On investigation, you found that SGA_MAX_SIZE was larger than the sum of the sizes of all System Global Area (SGA) components and you do not have the scope to increase it further. Identify a solution to reduce the probability of getting this error in future.(a) Set the PRE_PAGE_SGA parameter to TRUE(b) Set the LOCK_SGA initialization parameter to TRUE(c) Implement Automatic Shared Memory Management(d) Set the SGA_TARGET initialization parameter to zeroThe question was posed to me in exam.Asked question is from Installing Oracle Database 11g and Creating a Database topic in chapter Oracle Database 11g Architecture Options of Oracle |
| Answer» <html><body><a href="https://interviewquestions.tuteehub.com/tag/correct-409949" style="font-weight:bold;" target="_blank" title="Click to know more about CORRECT">CORRECT</a> choice is (<a href="https://interviewquestions.tuteehub.com/tag/c-7168" style="font-weight:bold;" target="_blank" title="Click to know more about C">C</a>) Implement Automatic Shared Memory Management<br/><br/>For explanation: Cause: More shared memory is needed than was allocated in the shared pool.Action : If the shared pool is out of memory, either use the DBMS_shared_pool package to pin large packages, reduce your use of shared memory, or increase the <a href="https://interviewquestions.tuteehub.com/tag/amount-374803" style="font-weight:bold;" target="_blank" title="Click to know more about AMOUNT">AMOUNT</a> of available shared memory by increasing the <a href="https://interviewquestions.tuteehub.com/tag/value-1442530" style="font-weight:bold;" target="_blank" title="Click to know more about VALUE">VALUE</a> of the INIT.ORA <a href="https://interviewquestions.tuteehub.com/tag/parameters-11881" style="font-weight:bold;" target="_blank" title="Click to know more about PARAMETERS">PARAMETERS</a></body></html> | |
| 2. |
You want to be warned automatically when more than 100 sessions are opened with your database instance.Identify the action that would help you achieve this.(a) Set the TRACE_ENABLED parameter to TRUE(b) Set the threshold for the Current Logons Count metric(c) Set the LOG_CHECKPOINT_TO_ALERT parameter to TRUE(d) Set the SESSIONS_PER_USER limit in the profiles used by usersThis question was addressed to me in quiz.My query is from Installing Oracle Database 11g and Creating a Database topic in portion Oracle Database 11g Architecture Options of Oracle |
| Answer» <html><body><p>Right choice is (b) <a href="https://interviewquestions.tuteehub.com/tag/set-11758" style="font-weight:bold;" target="_blank" title="Click to know more about SET">SET</a> the threshold for the Current Logons Count metric<br/><br/>Explanation: A metric is defined as the rate of <a href="https://interviewquestions.tuteehub.com/tag/change-913808" style="font-weight:bold;" target="_blank" title="Click to know more about CHANGE">CHANGE</a> in some cumulative statistic. This rate can be measured against a variety of <a href="https://interviewquestions.tuteehub.com/tag/units-1438468" style="font-weight:bold;" target="_blank" title="Click to know more about UNITS">UNITS</a>, including <a href="https://interviewquestions.tuteehub.com/tag/time-19467" style="font-weight:bold;" target="_blank" title="Click to know more about TIME">TIME</a>, transactions, or database calls. For example, the number database calls <a href="https://interviewquestions.tuteehub.com/tag/per-590802" style="font-weight:bold;" target="_blank" title="Click to know more about PER">PER</a> second is a metric.</p></body></html> | |
| 3. |
You notice that the database instance takes a long time to start up after the instance crash. How will you resolve the problem?(a) Increase the size of the redo log files(b) Decrease the number of redo log members(c) Set LOG_CHECKPOINT_TO_ALERT to TRUE(d) Decrease the value for the FAST_START_MTTR_TARGET initialization parameterThe question was asked by my school teacher while I was bunking the class.This key question is from Installing Oracle Database 11g and Creating a Database in section Oracle Database 11g Architecture Options of Oracle |
| Answer» <html><body><a href="https://interviewquestions.tuteehub.com/tag/right-1188951" style="font-weight:bold;" target="_blank" title="Click to know more about RIGHT">RIGHT</a> <a href="https://interviewquestions.tuteehub.com/tag/option-25810" style="font-weight:bold;" target="_blank" title="Click to know more about OPTION">OPTION</a> is (d) Decrease the value for the FAST_START_MTTR_TARGET <a href="https://interviewquestions.tuteehub.com/tag/initialization-1044675" style="font-weight:bold;" target="_blank" title="Click to know more about INITIALIZATION">INITIALIZATION</a> parameter<br/><br/>The best I can explain: FAST_START_MTTR_TARGET enables you to specify the number of seconds the database takes to <a href="https://interviewquestions.tuteehub.com/tag/perform-1150848" style="font-weight:bold;" target="_blank" title="Click to know more about PERFORM">PERFORM</a> crash recovery of a single instance.<br/><br/>FAST_START_MTTR_TARGET contains below <a href="https://interviewquestions.tuteehub.com/tag/information-1043838" style="font-weight:bold;" target="_blank" title="Click to know more about INFORMATION">INFORMATION</a>.</body></html> | |
| 4. |
Which operations can be performed using the Data Recovery Ad-visor?(a) Diagnosing data failure(b) It is a percentage of rows in which the statistics are collected incrementally for partitions(c) Presenting appropriate repair options(d) Generating reports for possible causes of failureThe question was asked during an interview.Question is from Installing Oracle Database 11g and Creating a Database in portion Oracle Database 11g Architecture Options of Oracle |
| Answer» <html><body><p>The correct <a href="https://interviewquestions.tuteehub.com/tag/option-25810" style="font-weight:bold;" target="_blank" title="Click to know more about OPTION">OPTION</a> is (a) Diagnosing data failure<br/><br/>Explanation: The Data Recovery Ad-visor <a href="https://interviewquestions.tuteehub.com/tag/automatically-7262700" style="font-weight:bold;" target="_blank" title="Click to know more about AUTOMATICALLY">AUTOMATICALLY</a> diagnoses corruption or <a href="https://interviewquestions.tuteehub.com/tag/loss-1079380" style="font-weight:bold;" target="_blank" title="Click to know more about LOSS">LOSS</a> of persistent data on disk, determines the appropriate repair options, and executes repairs at the user’s request. This <a href="https://interviewquestions.tuteehub.com/tag/reduces-621012" style="font-weight:bold;" target="_blank" title="Click to know more about REDUCES">REDUCES</a> the complexity of recovery process, thereby <a href="https://interviewquestions.tuteehub.com/tag/reducing-2981618" style="font-weight:bold;" target="_blank" title="Click to know more about REDUCING">REDUCING</a> the Mean Time To Recover (MTTR).</p></body></html> | |
| 5. |
Which statement is correct regarding undo management?(a) The database can have more than one undo tablespaces(b) The undo data must be purged manually when the transaction is over(c) The UNDO_TABLESPACE parameter is valid only if the UNDO_MANAGEMENT parameter is set AUTO OFF(d) Undo management is automatic by default even if the UNDO_MANAGEMENT initialization parameter is set to NULLI had been asked this question at a job interview.Asked question is from Installing Oracle Database 11g and Creating a Database in section Oracle Database 11g Architecture Options of Oracle |
| Answer» <html><body><p>Right <a href="https://interviewquestions.tuteehub.com/tag/answer-15557" style="font-weight:bold;" target="_blank" title="Click to know more about ANSWER">ANSWER</a> is (a) The database can have more than one <a href="https://interviewquestions.tuteehub.com/tag/undo-1436983" style="font-weight:bold;" target="_blank" title="Click to know more about UNDO">UNDO</a> tablespaces<br/><br/>Explanation: <a href="https://interviewquestions.tuteehub.com/tag/oracle-12831" style="font-weight:bold;" target="_blank" title="Click to know more about ORACLE">ORACLE</a> provides an automatic undo <a href="https://interviewquestions.tuteehub.com/tag/management-1085657" style="font-weight:bold;" target="_blank" title="Click to know more about MANAGEMENT">MANAGEMENT</a>, for managing undo information and space. With automatic undo management, the database <a href="https://interviewquestions.tuteehub.com/tag/manages-1085880" style="font-weight:bold;" target="_blank" title="Click to know more about MANAGES">MANAGES</a> undo segments in an undo table-space.</p></body></html> | |
| 6. |
What SYSTEM VARIABLE is used to refer DATABASE TIME ?(a) $$dbtime$$(b) $$time$$(c) $$datetime$$(d) None of the MentionedThis question was posed to me in an interview.The origin of the question is Installing Oracle Database 11g and Creating a Database in chapter Oracle Database 11g Architecture Options of Oracle |
| Answer» <html><body><p>Right choice is (a) $$dbtime$$<br/><br/>The <a href="https://interviewquestions.tuteehub.com/tag/explanation-455162" style="font-weight:bold;" target="_blank" title="Click to know more about EXPLANATION">EXPLANATION</a> is: The <a href="https://interviewquestions.tuteehub.com/tag/db-430813" style="font-weight:bold;" target="_blank" title="Click to know more about DB">DB</a> time Oracle <a href="https://interviewquestions.tuteehub.com/tag/metric-1095342" style="font-weight:bold;" target="_blank" title="Click to know more about METRIC">METRIC</a> is the amount of elapsed time (in microseconds) <a href="https://interviewquestions.tuteehub.com/tag/spent-1222060" style="font-weight:bold;" target="_blank" title="Click to know more about SPENT">SPENT</a> performing Database user-level <a href="https://interviewquestions.tuteehub.com/tag/calls-907980" style="font-weight:bold;" target="_blank" title="Click to know more about CALLS">CALLS</a>.</p></body></html> | |
| 7. |
Oracle server configuration is dedicated for(a) One server process – Many user processes(b) Many server processes – One user process(c) One server process – One user process(d) Many server processes – Many user processesThis question was addressed to me in an interview.This interesting question is from Installing Oracle Database 11g and Creating a Database topic in portion Oracle Database 11g Architecture Options of Oracle |
| Answer» <html><body><p>Right <a href="https://interviewquestions.tuteehub.com/tag/option-25810" style="font-weight:bold;" target="_blank" title="Click to know more about OPTION">OPTION</a> is (c) One <a href="https://interviewquestions.tuteehub.com/tag/server-11236" style="font-weight:bold;" target="_blank" title="Click to know more about SERVER">SERVER</a> process – One user process<br/><br/>The best explanation: Single-process Oracle is a database system in which all Oracle code is <a href="https://interviewquestions.tuteehub.com/tag/executed-7257022" style="font-weight:bold;" target="_blank" title="Click to know more about EXECUTED">EXECUTED</a> by one process. Different processes are not used to separate execution of the parts of Oracle and the client <a href="https://interviewquestions.tuteehub.com/tag/application-25616" style="font-weight:bold;" target="_blank" title="Click to know more about APPLICATION">APPLICATION</a> program. Instead, all code of Oracle and the single user’s database application is executed by a single process.</p></body></html> | |
| 8. |
What is the result of the following‘PAN’NULL’KAJ’?(a) Error(b) PAN KAJ(c) PANKAJ(d) NULLThe question was asked in exam.My question is from Programmatic Oracle Structures in division Oracle Database 11g Architecture Options of Oracle |
| Answer» <html><body><a href="https://interviewquestions.tuteehub.com/tag/correct-409949" style="font-weight:bold;" target="_blank" title="Click to know more about CORRECT">CORRECT</a> <a href="https://interviewquestions.tuteehub.com/tag/choice-915996" style="font-weight:bold;" target="_blank" title="Click to know more about CHOICE">CHOICE</a> is (c) PANKAJ<br/><br/>For explanation I would say: In Oracle <a href="https://interviewquestions.tuteehub.com/tag/null-17167" style="font-weight:bold;" target="_blank" title="Click to know more about NULL">NULL</a> values represent missing <a href="https://interviewquestions.tuteehub.com/tag/unknown-1438723" style="font-weight:bold;" target="_blank" title="Click to know more about UNKNOWN">UNKNOWN</a> data.</body></html> | |
| 9. |
Which of the following statement is false ?(a) Any procedure can raise a error and return an user message and error number(b) Error number is ranging from 20000 to 20999 are reserved for user defined messages(c) Oracle checks Uniqueness of User defined errors(d) Raise_Application_error is used for raising an user defined errorThis question was posed to me in final exam.The doubt is from Programmatic Oracle Structures in section Oracle Database 11g Architecture Options of Oracle |
| Answer» <html><body><p>The correct choice is (c) Oracle checks Uniqueness of User defined errors<br/><br/>To <a href="https://interviewquestions.tuteehub.com/tag/elaborate-967511" style="font-weight:bold;" target="_blank" title="Click to know more about ELABORATE">ELABORATE</a>: The <a href="https://interviewquestions.tuteehub.com/tag/unique-720618" style="font-weight:bold;" target="_blank" title="Click to know more about UNIQUE">UNIQUE</a> <a href="https://interviewquestions.tuteehub.com/tag/constraint-930945" style="font-weight:bold;" target="_blank" title="Click to know more about CONSTRAINT">CONSTRAINT</a> <a href="https://interviewquestions.tuteehub.com/tag/uniquely-7384545" style="font-weight:bold;" target="_blank" title="Click to know more about UNIQUELY">UNIQUELY</a> identifies each record in a database table.The UNIQUE and PRIMARY KEY constraints both provide a guarantee for uniqueness for a <a href="https://interviewquestions.tuteehub.com/tag/column-922494" style="font-weight:bold;" target="_blank" title="Click to know more about COLUMN">COLUMN</a> or set of columns.</p></body></html> | |
| 10. |
What is SQL * FORMS ?(a) SQL * FORMS is a 4GL tool for developing and executing Oracle based interactive based application(b) SQL * FORMS is a 3GL tool for connecting to a Database(c) SQL * FORMS is a reporting tool(d) None of the MentionedThis question was addressed to me during an internship interview.My doubt stems from Programmatic Oracle Structures in division Oracle Database 11g Architecture Options of Oracle |
| Answer» <html><body><p>The correct <a href="https://interviewquestions.tuteehub.com/tag/choice-915996" style="font-weight:bold;" target="_blank" title="Click to know more about CHOICE">CHOICE</a> is (a) SQL * FORMS is a <a href="https://interviewquestions.tuteehub.com/tag/4gl-318759" style="font-weight:bold;" target="_blank" title="Click to know more about 4GL">4GL</a> tool for developing and executing Oracle based interactive based <a href="https://interviewquestions.tuteehub.com/tag/application-25616" style="font-weight:bold;" target="_blank" title="Click to know more about APPLICATION">APPLICATION</a><br/><br/>For <a href="https://interviewquestions.tuteehub.com/tag/explanation-455162" style="font-weight:bold;" target="_blank" title="Click to know more about EXPLANATION">EXPLANATION</a> I would say: SQL*Forms is a general-purpose tool for developing and executing forms-based interactive applications. The design component of this tool is specially designed for application developers and <a href="https://interviewquestions.tuteehub.com/tag/programmers-25552" style="font-weight:bold;" target="_blank" title="Click to know more about PROGRAMMERS">PROGRAMMERS</a>.</p></body></html> | |
| 11. |
In Oracle, which of the following package procedure is UNRESTRICTED ?(a) CALL_INPUT(b) CLEAR_BLOCK(c) EXECUTE_QUERY(d) USER_EXITThis question was addressed to me during an interview.Question is taken from Programmatic Oracle Structures in chapter Oracle Database 11g Architecture Options of Oracle |
| Answer» <html><body><p>The correct choice is (d) USER_EXIT<br/><br/>To explain I would say: A user exit is a C subroutine and called by <a href="https://interviewquestions.tuteehub.com/tag/oracle-12831" style="font-weight:bold;" target="_blank" title="Click to know more about ORACLE">ORACLE</a> Forms to do special-purpose processing.It can <a href="https://interviewquestions.tuteehub.com/tag/display-25607" style="font-weight:bold;" target="_blank" title="Click to know more about DISPLAY">DISPLAY</a> messages on the Oracle Forms status line, <a href="https://interviewquestions.tuteehub.com/tag/get-11812" style="font-weight:bold;" target="_blank" title="Click to know more about GET">GET</a> and set field <a href="https://interviewquestions.tuteehub.com/tag/values-25920" style="font-weight:bold;" target="_blank" title="Click to know more about VALUES">VALUES</a>, do high-speed computations and table look-ups, and manipulate Oracle <a href="https://interviewquestions.tuteehub.com/tag/data-25577" style="font-weight:bold;" target="_blank" title="Click to know more about DATA">DATA</a>.</p></body></html> | |
| 12. |
The system variable that records the select statement that SQL * FORMS most recently used to populate a block is __________(a) SYSTEM.LAST_RECORD(b) SYSTEM.CURSOR_RECORD(c) SYSTEM.CURSOR_FIELD(d) SYSTEM.LAST_QUERYThis question was posed to me in an internship interview.My query is from Programmatic Oracle Structures topic in division Oracle Database 11g Architecture Options of Oracle |
| Answer» <html><body><a href="https://interviewquestions.tuteehub.com/tag/right-1188951" style="font-weight:bold;" target="_blank" title="Click to know more about RIGHT">RIGHT</a> choice is (d) SYSTEM.LAST_QUERY<br/><br/>To elaborate: SYSTEM.LAST_QUERY system variable represents the <a href="https://interviewquestions.tuteehub.com/tag/query-611355" style="font-weight:bold;" target="_blank" title="Click to know more about QUERY">QUERY</a> statement <a href="https://interviewquestions.tuteehub.com/tag/used-2318798" style="font-weight:bold;" target="_blank" title="Click to know more about USED">USED</a> by <a href="https://interviewquestions.tuteehub.com/tag/forms-11384" style="font-weight:bold;" target="_blank" title="Click to know more about FORMS">FORMS</a> to populate a data block during run-time.</body></html> | |
| 13. |
POST-BLOCK trigger is also a ?(a) Navigational Trigger(b) Key Trigger(c) Transaction Trigger(d) All of the MentionedI had been asked this question at a job interview.My query is from Programmatic Oracle Structures topic in portion Oracle Database 11g Architecture Options of Oracle |
| Answer» <html><body><p>The correct answer is (a) Navigational Trigger<br/><br/>The best I can explain: Pre- and <a href="https://interviewquestions.tuteehub.com/tag/post-2638" style="font-weight:bold;" target="_blank" title="Click to know more about POST">POST</a>- triggers <a href="https://interviewquestions.tuteehub.com/tag/fire-989497" style="font-weight:bold;" target="_blank" title="Click to know more about FIRE">FIRE</a> as Form Builder navigates <a href="https://interviewquestions.tuteehub.com/tag/internally-2132312" style="font-weight:bold;" target="_blank" title="Click to know more about INTERNALLY">INTERNALLY</a> through <a href="https://interviewquestions.tuteehub.com/tag/different-951434" style="font-weight:bold;" target="_blank" title="Click to know more about DIFFERENT">DIFFERENT</a> levels of the object hierarchy.When-New-Instance triggers fire at the end of a navigational sequence that places the input focus in a different item.</p></body></html> | |
| 14. |
What does DLL stand for ?(a) Dynamic Link Library(b) Dynamic Language Library(c) Dynamic Load Library(d) None of the MentionedI have been asked this question during a job interview.I need to ask this question from Programmatic Oracle Structures in division Oracle Database 11g Architecture Options of Oracle |
| Answer» <html><body><p>Right <a href="https://interviewquestions.tuteehub.com/tag/choice-915996" style="font-weight:bold;" target="_blank" title="Click to know more about CHOICE">CHOICE</a> is (a) Dynamic Link Library<br/><br/>To elaborate: DLL, linking occurs at <a href="https://interviewquestions.tuteehub.com/tag/run-1192138" style="font-weight:bold;" target="_blank" title="Click to know more about RUN">RUN</a> <a href="https://interviewquestions.tuteehub.com/tag/time-19467" style="font-weight:bold;" target="_blank" title="Click to know more about TIME">TIME</a> when the routine is actually used. This <a href="https://interviewquestions.tuteehub.com/tag/results-2643" style="font-weight:bold;" target="_blank" title="Click to know more about RESULTS">RESULTS</a> in much smaller executable because routines are pulled in only as needed.</p></body></html> | |
| 15. |
When a transaction modifies the database, Oracle copies the original data before modifying it. The original copy of the modified data is called(a) Undone Data(b) Archive Data(c) Redo Data(d) Undo DataThis question was posed to me in quiz.This is a very interesting question from Storing and Guarding the Data in division Oracle Database 11g Architecture Options of Oracle |
| Answer» <html><body><p>Right choice is (d) <a href="https://interviewquestions.tuteehub.com/tag/undo-1436983" style="font-weight:bold;" target="_blank" title="Click to know more about UNDO">UNDO</a> <a href="https://interviewquestions.tuteehub.com/tag/data-25577" style="font-weight:bold;" target="_blank" title="Click to know more about DATA">DATA</a><br/><br/>The best I can explain: Before transaction happen the <a href="https://interviewquestions.tuteehub.com/tag/oracle-12831" style="font-weight:bold;" target="_blank" title="Click to know more about ORACLE">ORACLE</a> kept the files in Undo Data to overcome form any <a href="https://interviewquestions.tuteehub.com/tag/failure-983002" style="font-weight:bold;" target="_blank" title="Click to know more about FAILURE">FAILURE</a>.</p></body></html> | |
| 16. |
Recycle bin can be turned on or off this. This parameter is stored in which of the below file?(a) PARAMETER FILE(b) PARFILE(c) DATAFILES(d) PFILEThis question was posed to me by my college professor while I was bunking the class.The question is from Storing and Guarding the Data in portion Oracle Database 11g Architecture Options of Oracle |
| Answer» <html><body><p>Right answer is (a) <a href="https://interviewquestions.tuteehub.com/tag/parameter-1146745" style="font-weight:bold;" target="_blank" title="Click to know more about PARAMETER">PARAMETER</a> <a href="https://interviewquestions.tuteehub.com/tag/file-11330" style="font-weight:bold;" target="_blank" title="Click to know more about FILE">FILE</a><br/><br/>To <a href="https://interviewquestions.tuteehub.com/tag/elaborate-967511" style="font-weight:bold;" target="_blank" title="Click to know more about ELABORATE">ELABORATE</a>: A parameter file is a file that contains a list of initialization parameters and a <a href="https://interviewquestions.tuteehub.com/tag/value-1442530" style="font-weight:bold;" target="_blank" title="Click to know more about VALUE">VALUE</a> for each parameter.</p></body></html> | |
| 17. |
The ORDER BY clause can only be used in ___________(a) SELECT queries(b) INSERT queries(c) GROUP BY queries(d) HAVING queriesI got this question in an interview.My query is from Storing and Guarding the Data topic in chapter Oracle Database 11g Architecture Options of Oracle |
| Answer» <html><body><p>Right <a href="https://interviewquestions.tuteehub.com/tag/option-25810" style="font-weight:bold;" target="_blank" title="Click to know more about OPTION">OPTION</a> is (a) <a href="https://interviewquestions.tuteehub.com/tag/select-630282" style="font-weight:bold;" target="_blank" title="Click to know more about SELECT">SELECT</a> queries<br/><br/>The explanation is: An ORDER BY clause <a href="https://interviewquestions.tuteehub.com/tag/allows-857958" style="font-weight:bold;" target="_blank" title="Click to know more about ALLOWS">ALLOWS</a> you to <a href="https://interviewquestions.tuteehub.com/tag/specify-1221718" style="font-weight:bold;" target="_blank" title="Click to know more about SPECIFY">SPECIFY</a> the order in which rows appear in the <a href="https://interviewquestions.tuteehub.com/tag/result-1187343" style="font-weight:bold;" target="_blank" title="Click to know more about RESULT">RESULT</a> set.</p></body></html> | |
| 18. |
What is the purpose of SMON (System Monitor Process) background process?(a) Performs crash recovery when a failed instance starts up again(b) Performs recovery when a user process fails(c) Writes redo log entries to disk(d) All of the MentionedI got this question by my school principal while I was bunking the class.Origin of the question is Storing and Guarding the Data topic in portion Oracle Database 11g Architecture Options of Oracle |
| Answer» <html><body><p>Correct <a href="https://interviewquestions.tuteehub.com/tag/option-25810" style="font-weight:bold;" target="_blank" title="Click to know more about OPTION">OPTION</a> is (a) Performs crash recovery when a <a href="https://interviewquestions.tuteehub.com/tag/failed-2080748" style="font-weight:bold;" target="_blank" title="Click to know more about FAILED">FAILED</a> <a href="https://interviewquestions.tuteehub.com/tag/instance-25561" style="font-weight:bold;" target="_blank" title="Click to know more about INSTANCE">INSTANCE</a> starts up again<br/><br/>The best explanation: <a href="https://interviewquestions.tuteehub.com/tag/smon-2256740" style="font-weight:bold;" target="_blank" title="Click to know more about SMON">SMON</a> process of one instance can perform instance recovery for a failed CPU or instance.</p></body></html> | |
| 19. |
Which of the following rule below are categories of index?(a) Column and Functional(b) Multiple Column and Functional(c) To create an index in another schema(d) None of the MentionedI got this question in an internship interview.My query is from Storing and Guarding the Data in section Oracle Database 11g Architecture Options of Oracle |
| Answer» <html><body><a href="https://interviewquestions.tuteehub.com/tag/right-1188951" style="font-weight:bold;" target="_blank" title="Click to know more about RIGHT">RIGHT</a> <a href="https://interviewquestions.tuteehub.com/tag/option-25810" style="font-weight:bold;" target="_blank" title="Click to know more about OPTION">OPTION</a> is (a) Column and Functional<br/><br/>The best <a href="https://interviewquestions.tuteehub.com/tag/explanation-455162" style="font-weight:bold;" target="_blank" title="Click to know more about EXPLANATION">EXPLANATION</a>: An index is an optional structure, <a href="https://interviewquestions.tuteehub.com/tag/associated-886051" style="font-weight:bold;" target="_blank" title="Click to know more about ASSOCIATED">ASSOCIATED</a> with a table or table cluster, that can sometimes speed data <a href="https://interviewquestions.tuteehub.com/tag/access-846773" style="font-weight:bold;" target="_blank" title="Click to know more about ACCESS">ACCESS</a>.</body></html> | |
| 20. |
How we can force a log switch?(a) By using ALTER SYSTEM LOG(b) By using ALTER SYSTEM SWITCH LOGFILE(c) By using ALTER SYSTEM SWITCH LOGS(d) By using ALTER SYS LOGFILESI had been asked this question during an interview.My question is taken from Storing and Guarding the Data in chapter Oracle Database 11g Architecture Options of Oracle |
| Answer» <html><body><p>Right <a href="https://interviewquestions.tuteehub.com/tag/answer-15557" style="font-weight:bold;" target="_blank" title="Click to know more about ANSWER">ANSWER</a> is (<a href="https://interviewquestions.tuteehub.com/tag/b-387190" style="font-weight:bold;" target="_blank" title="Click to know more about B">B</a>) By using ALTER SYSTEM SWITCH <a href="https://interviewquestions.tuteehub.com/tag/logfile-1077632" style="font-weight:bold;" target="_blank" title="Click to know more about LOGFILE">LOGFILE</a><br/><br/>Explanation: To force a <a href="https://interviewquestions.tuteehub.com/tag/log-543719" style="font-weight:bold;" target="_blank" title="Click to know more about LOG">LOG</a> switch, you must have the ALTER SYSTEM privilege. Use the ALTER SYSTEM statement with the SWITCH LOGFILE <a href="https://interviewquestions.tuteehub.com/tag/clause-918411" style="font-weight:bold;" target="_blank" title="Click to know more about CLAUSE">CLAUSE</a>.</p></body></html> | |
| 21. |
Which of the following object types below cannot be replicated?(a) Data(b) Trigger(c) View(d) SequenceI had been asked this question at a job interview.This interesting question is from Storing and Guarding the Data in chapter Oracle Database 11g Architecture Options of Oracle |
| Answer» <html><body><p>Correct option is (d) <a href="https://interviewquestions.tuteehub.com/tag/sequence-1201556" style="font-weight:bold;" target="_blank" title="Click to know more about SEQUENCE">SEQUENCE</a><br/><br/>To elaborate: Use the <a href="https://interviewquestions.tuteehub.com/tag/create-427332" style="font-weight:bold;" target="_blank" title="Click to know more about CREATE">CREATE</a> SEQUENCE <a href="https://interviewquestions.tuteehub.com/tag/statement-16478" style="font-weight:bold;" target="_blank" title="Click to know more about STATEMENT">STATEMENT</a> to create a sequence, which is a database object from which multiple users <a href="https://interviewquestions.tuteehub.com/tag/may-557248" style="font-weight:bold;" target="_blank" title="Click to know more about MAY">MAY</a> generate unique integers. You can use sequences to automatically generate primary key values.</p></body></html> | |
| 22. |
Which schema object instructs Oracle to connect to remotely access an object of a database?(a) Sequence(b) Remote Link(c) Database Link(d) Data LinkI have been asked this question in an interview.This intriguing question comes from Storing and Guarding the Data in chapter Oracle Database 11g Architecture Options of Oracle |
| Answer» <html><body><a href="https://interviewquestions.tuteehub.com/tag/right-1188951" style="font-weight:bold;" target="_blank" title="Click to know more about RIGHT">RIGHT</a> <a href="https://interviewquestions.tuteehub.com/tag/answer-15557" style="font-weight:bold;" target="_blank" title="Click to know more about ANSWER">ANSWER</a> is (d) Data Link<br/><br/>Best <a href="https://interviewquestions.tuteehub.com/tag/explanation-455162" style="font-weight:bold;" target="_blank" title="Click to know more about EXPLANATION">EXPLANATION</a>: A DATABASE LINK value references a resource outside the underlying data source through a <a href="https://interviewquestions.tuteehub.com/tag/url-11678" style="font-weight:bold;" target="_blank" title="Click to know more about URL">URL</a>.</body></html> | |
| 23. |
Where is data dictionary kept?(a) SYSTEM Tablespace(b) Stack Space(c) Data File(d) None of the MentionedI got this question in an online interview.My question is taken from Storing and Guarding the Data topic in portion Oracle Database 11g Architecture Options of Oracle |
| Answer» <html><body><a href="https://interviewquestions.tuteehub.com/tag/right-1188951" style="font-weight:bold;" target="_blank" title="Click to know more about RIGHT">RIGHT</a> choice is (a) SYSTEM Tablespace<br/><br/>The <a href="https://interviewquestions.tuteehub.com/tag/best-390038" style="font-weight:bold;" target="_blank" title="Click to know more about BEST">BEST</a> I can explain: The Oracle <a href="https://interviewquestions.tuteehub.com/tag/database-11539" style="font-weight:bold;" target="_blank" title="Click to know more about DATABASE">DATABASE</a> user SYS owns all base tables and user-accessible <a href="https://interviewquestions.tuteehub.com/tag/views-13678" style="font-weight:bold;" target="_blank" title="Click to know more about VIEWS">VIEWS</a> of the <a href="https://interviewquestions.tuteehub.com/tag/data-25577" style="font-weight:bold;" target="_blank" title="Click to know more about DATA">DATA</a> dictionary.</body></html> | |
| 24. |
A _____________ is a set of tables physically stored together as one table that shares a common column(a) Index(b) Object(c) Datafiles(d) ClusterI had been asked this question in examination.My enquiry is from Databases and Instances in section Oracle Database 11g Architecture Options of Oracle |
| Answer» <html><body><p>Right <a href="https://interviewquestions.tuteehub.com/tag/option-25810" style="font-weight:bold;" target="_blank" title="Click to know more about OPTION">OPTION</a> is (d) Cluster<br/><br/>The explanation is: Cluster is a schema object that <a href="https://interviewquestions.tuteehub.com/tag/contains-11473" style="font-weight:bold;" target="_blank" title="Click to know more about CONTAINS">CONTAINS</a> <a href="https://interviewquestions.tuteehub.com/tag/data-25577" style="font-weight:bold;" target="_blank" title="Click to know more about DATA">DATA</a> from one or more tables, all of which have one or more <a href="https://interviewquestions.tuteehub.com/tag/columns-922590" style="font-weight:bold;" target="_blank" title="Click to know more about COLUMNS">COLUMNS</a> in <a href="https://interviewquestions.tuteehub.com/tag/common-923599" style="font-weight:bold;" target="_blank" title="Click to know more about COMMON">COMMON</a>.</p></body></html> | |
| 25. |
A _______________ is used to logically group data together(a) Database(b) Tablespace(c) Datafiles(d) ObjectThis question was posed to me in class test.This key question is from Databases and Instances topic in portion Oracle Database 11g Architecture Options of Oracle |
| Answer» <html><body><p>Correct option is (b) Tablespace<br/><br/>Easy <a href="https://interviewquestions.tuteehub.com/tag/explanation-455162" style="font-weight:bold;" target="_blank" title="Click to know more about EXPLANATION">EXPLANATION</a>: Oracle database consists of <a href="https://interviewquestions.tuteehub.com/tag/one-585732" style="font-weight:bold;" target="_blank" title="Click to know more about ONE">ONE</a> or more logical <a href="https://interviewquestions.tuteehub.com/tag/storage-11586" style="font-weight:bold;" target="_blank" title="Click to know more about STORAGE">STORAGE</a> <a href="https://interviewquestions.tuteehub.com/tag/units-1438468" style="font-weight:bold;" target="_blank" title="Click to know more about UNITS">UNITS</a> <a href="https://interviewquestions.tuteehub.com/tag/called-907796" style="font-weight:bold;" target="_blank" title="Click to know more about CALLED">CALLED</a> tablespaces.</p></body></html> | |
| 26. |
Modification schema of oracle database in one level without affecting the schema in high level is called as _______(a) Data Migration(b) Data Isolation(c) Data Independence(d) Data AbstractionThe question was asked in an internship interview.Question is taken from Databases and Instances in chapter Oracle Database 11g Architecture Options of Oracle |
| Answer» <html><body><p>Correct <a href="https://interviewquestions.tuteehub.com/tag/choice-915996" style="font-weight:bold;" target="_blank" title="Click to know more about CHOICE">CHOICE</a> is (c) Data Independence<br/><br/>Easiest explanation: Data Independence <a href="https://interviewquestions.tuteehub.com/tag/means-1091780" style="font-weight:bold;" target="_blank" title="Click to know more about MEANS">MEANS</a> changing internal <a href="https://interviewquestions.tuteehub.com/tag/level-1072714" style="font-weight:bold;" target="_blank" title="Click to know more about LEVEL">LEVEL</a> does not <a href="https://interviewquestions.tuteehub.com/tag/affect-851195" style="font-weight:bold;" target="_blank" title="Click to know more about AFFECT">AFFECT</a> <a href="https://interviewquestions.tuteehub.com/tag/conceptual-928163" style="font-weight:bold;" target="_blank" title="Click to know more about CONCEPTUAL">CONCEPTUAL</a> level.</p></body></html> | |
| 27. |
Map entities, attributes and relations in Oracle is represented by___________(a) Conceptual Schema(b) Logical Schema(c) Physical Schema(d) All of the MentionedThe question was asked in homework.Origin of the question is Databases and Instances in section Oracle Database 11g Architecture Options of Oracle |
| Answer» <html><body><p>The correct <a href="https://interviewquestions.tuteehub.com/tag/option-25810" style="font-weight:bold;" target="_blank" title="Click to know more about OPTION">OPTION</a> is (b) Logical <a href="https://interviewquestions.tuteehub.com/tag/schema-11583" style="font-weight:bold;" target="_blank" title="Click to know more about SCHEMA">SCHEMA</a><br/><br/>To explain I <a href="https://interviewquestions.tuteehub.com/tag/would-3285927" style="font-weight:bold;" target="_blank" title="Click to know more about WOULD">WOULD</a> say: Logical schema model may have many-to-many relationships and also have <a href="https://interviewquestions.tuteehub.com/tag/objects-20533" style="font-weight:bold;" target="_blank" title="Click to know more about OBJECTS">OBJECTS</a> like table, view, procedure etc.</p></body></html> | |
| 28. |
What do the schema objects comprise of?(a) Table(b) Index(c) Cluster(d) All of the MentionedThis question was posed to me in examination.My query is from Databases and Instances in section Oracle Database 11g Architecture Options of Oracle |
| Answer» <html><body><a href="https://interviewquestions.tuteehub.com/tag/right-1188951" style="font-weight:bold;" target="_blank" title="Click to know more about RIGHT">RIGHT</a> option is (d) All of the Mentioned<br/><br/>Explanation: Oracle database <a href="https://interviewquestions.tuteehub.com/tag/schema-11583" style="font-weight:bold;" target="_blank" title="Click to know more about SCHEMA">SCHEMA</a> <a href="https://interviewquestions.tuteehub.com/tag/consists-930075" style="font-weight:bold;" target="_blank" title="Click to know more about CONSISTS">CONSISTS</a> of Table, Index, <a href="https://interviewquestions.tuteehub.com/tag/cluster-919934" style="font-weight:bold;" target="_blank" title="Click to know more about CLUSTER">CLUSTER</a>.</body></html> | |
| 29. |
What are the valid Oracle database schemas?(a) Logical Schema(b) Physical Schema(c) Logical and Physical Schema(d) None of the MentionedI had been asked this question in unit test.The query is from Databases and Instances topic in chapter Oracle Database 11g Architecture Options of Oracle |
| Answer» <html><body><p>Right answer is (c) Logical and <a href="https://interviewquestions.tuteehub.com/tag/physical-600035" style="font-weight:bold;" target="_blank" title="Click to know more about PHYSICAL">PHYSICAL</a> <a href="https://interviewquestions.tuteehub.com/tag/schema-11583" style="font-weight:bold;" target="_blank" title="Click to know more about SCHEMA">SCHEMA</a><br/><br/>The <a href="https://interviewquestions.tuteehub.com/tag/best-390038" style="font-weight:bold;" target="_blank" title="Click to know more about BEST">BEST</a> explanation: <a href="https://interviewquestions.tuteehub.com/tag/oracle-12831" style="font-weight:bold;" target="_blank" title="Click to know more about ORACLE">ORACLE</a> <a href="https://interviewquestions.tuteehub.com/tag/databases-10329" style="font-weight:bold;" target="_blank" title="Click to know more about DATABASES">DATABASES</a> has two schema level logical and physical.</p></body></html> | |
| 30. |
Collection of information stored in database at particular instance of time is called as ____________(a) Instance of Database(b) Objects in Databases(c) Data structure(d) Database SchemaI have been asked this question during an online interview.Query is from Databases and Instances topic in portion Oracle Database 11g Architecture Options of Oracle |
| Answer» <html><body><p>The correct option is (a) Instance of Database<br/><br/>The <a href="https://interviewquestions.tuteehub.com/tag/best-390038" style="font-weight:bold;" target="_blank" title="Click to know more about BEST">BEST</a> I can explain: Oracle work on the instance <a href="https://interviewquestions.tuteehub.com/tag/basis-893664" style="font-weight:bold;" target="_blank" title="Click to know more about BASIS">BASIS</a>, whatever the operation related to Oracle is only on instance <a href="https://interviewquestions.tuteehub.com/tag/level-1072714" style="font-weight:bold;" target="_blank" title="Click to know more about LEVEL">LEVEL</a>.</p></body></html> | |
| 31. |
Oracle database’s design is also called as_____________(a) Database Abstraction(b) Database Instance(c) Database Schema(d) None of the MentionedThis question was posed to me during an internship interview.I'm obligated to ask this question of Databases and Instances topic in chapter Oracle Database 11g Architecture Options of Oracle |
| Answer» <html><body><p>The <a href="https://interviewquestions.tuteehub.com/tag/correct-409949" style="font-weight:bold;" target="_blank" title="Click to know more about CORRECT">CORRECT</a> <a href="https://interviewquestions.tuteehub.com/tag/answer-15557" style="font-weight:bold;" target="_blank" title="Click to know more about ANSWER">ANSWER</a> is (c) Database Schema<br/><br/>Easiest explanation: Oracle database’s design is <a href="https://interviewquestions.tuteehub.com/tag/done-2591742" style="font-weight:bold;" target="_blank" title="Click to know more about DONE">DONE</a> on the schema <a href="https://interviewquestions.tuteehub.com/tag/level-1072714" style="font-weight:bold;" target="_blank" title="Click to know more about LEVEL">LEVEL</a>.</p></body></html> | |
| 32. |
Which is the smallest unit of storage in an Oracle database?(a) Data Block(b) Segment(c) Extent(d) Data FileI have been asked this question during an online interview.My enquiry is from Databases and Instances in portion Oracle Database 11g Architecture Options of Oracle |
| Answer» <html><body><a href="https://interviewquestions.tuteehub.com/tag/correct-409949" style="font-weight:bold;" target="_blank" title="Click to know more about CORRECT">CORRECT</a> <a href="https://interviewquestions.tuteehub.com/tag/choice-915996" style="font-weight:bold;" target="_blank" title="Click to know more about CHOICE">CHOICE</a> is (a) Data Block<br/><br/>To <a href="https://interviewquestions.tuteehub.com/tag/explain-447165" style="font-weight:bold;" target="_blank" title="Click to know more about EXPLAIN">EXPLAIN</a>: The <a href="https://interviewquestions.tuteehub.com/tag/logical-543774" style="font-weight:bold;" target="_blank" title="Click to know more about LOGICAL">LOGICAL</a> units of database space <a href="https://interviewquestions.tuteehub.com/tag/allocation-373131" style="font-weight:bold;" target="_blank" title="Click to know more about ALLOCATION">ALLOCATION</a> are data blocks.</body></html> | |
| 33. |
The Oracle environment of database is called as ___________(a) Database Schema(b) Database Instances(c) Data Structure(d) All of the MentionedI got this question in unit test.I want to ask this question from Databases and Instances in chapter Oracle Database 11g Architecture Options of Oracle |
| Answer» <html><body><a href="https://interviewquestions.tuteehub.com/tag/right-1188951" style="font-weight:bold;" target="_blank" title="Click to know more about RIGHT">RIGHT</a> <a href="https://interviewquestions.tuteehub.com/tag/choice-915996" style="font-weight:bold;" target="_blank" title="Click to know more about CHOICE">CHOICE</a> is (b) <a href="https://interviewquestions.tuteehub.com/tag/database-11539" style="font-weight:bold;" target="_blank" title="Click to know more about DATABASE">DATABASE</a> Instances<br/><br/>The <a href="https://interviewquestions.tuteehub.com/tag/explanation-455162" style="font-weight:bold;" target="_blank" title="Click to know more about EXPLANATION">EXPLANATION</a>: A database instance is a <a href="https://interviewquestions.tuteehub.com/tag/set-11758" style="font-weight:bold;" target="_blank" title="Click to know more about SET">SET</a> of memory structures that manage database files.</body></html> | |
| 34. |
The redo log buffer and Shared pool are elements of?(a) PGA(b) Buffer cache(c) PGA and Buffer cache(d) SGAI have been asked this question in an online quiz.My enquiry is from Oracle Database 11g Architecture topic in division Oracle Database 11g Architecture Options of Oracle |
| Answer» <html><body><a href="https://interviewquestions.tuteehub.com/tag/right-1188951" style="font-weight:bold;" target="_blank" title="Click to know more about RIGHT">RIGHT</a> answer is (d) SGA<br/><br/>For explanation I would say: SGA (System Global <a href="https://interviewquestions.tuteehub.com/tag/area-13372" style="font-weight:bold;" target="_blank" title="Click to know more about AREA">AREA</a>) <a href="https://interviewquestions.tuteehub.com/tag/contains-11473" style="font-weight:bold;" target="_blank" title="Click to know more about CONTAINS">CONTAINS</a> Shared Pool, Database Buffer <a href="https://interviewquestions.tuteehub.com/tag/cache-411959" style="font-weight:bold;" target="_blank" title="Click to know more about CACHE">CACHE</a>, <a href="https://interviewquestions.tuteehub.com/tag/java-1034" style="font-weight:bold;" target="_blank" title="Click to know more about JAVA">JAVA</a> Pool, redo Log Buffer.</body></html> | |
| 35. |
In Oracle, which of below are types of segments?(a) Permanent Segment(b) Object Segment(c) Data Segment(d) All of the MentionedThis question was addressed to me in unit test.My question is taken from Oracle Database 11g Architecture in division Oracle Database 11g Architecture Options of Oracle |
| Answer» <html><body><p>Right <a href="https://interviewquestions.tuteehub.com/tag/choice-915996" style="font-weight:bold;" target="_blank" title="Click to know more about CHOICE">CHOICE</a> is (c) <a href="https://interviewquestions.tuteehub.com/tag/data-25577" style="font-weight:bold;" target="_blank" title="Click to know more about DATA">DATA</a> <a href="https://interviewquestions.tuteehub.com/tag/segment-1199331" style="font-weight:bold;" target="_blank" title="Click to know more about SEGMENT">SEGMENT</a><br/><br/>For explanation I would say: Oracle has 4 type of data segment :1)data segments 2)index segments 3)<a href="https://interviewquestions.tuteehub.com/tag/rollback-625038" style="font-weight:bold;" target="_blank" title="Click to know more about ROLLBACK">ROLLBACK</a> segments 4)temporary segments.</p></body></html> | |
| 36. |
The ____________ contains a set of tables and views that Oracle uses as a reference to the database.(a) PGA(b) Library cache(c) Data dictionary(d) SGAI have been asked this question in a job interview.My question is taken from Oracle Database 11g Architecture in division Oracle Database 11g Architecture Options of Oracle |
| Answer» <html><body><p>Correct answer is (c) Data <a href="https://interviewquestions.tuteehub.com/tag/dictionary-11752" style="font-weight:bold;" target="_blank" title="Click to know more about DICTIONARY">DICTIONARY</a><br/><br/>To explain I would say: The data dictionary is structured in tables and <a href="https://interviewquestions.tuteehub.com/tag/views-13678" style="font-weight:bold;" target="_blank" title="Click to know more about VIEWS">VIEWS</a>, just <a href="https://interviewquestions.tuteehub.com/tag/like-1073845" style="font-weight:bold;" target="_blank" title="Click to know more about LIKE">LIKE</a> other <a href="https://interviewquestions.tuteehub.com/tag/database-11539" style="font-weight:bold;" target="_blank" title="Click to know more about DATABASE">DATABASE</a> data. All the data dictionary tables and views for a given database are stored in that database’s SYSTEM tablespace.</p></body></html> | |
| 37. |
Which area of PGA stores binding variables and run-time buffers information?(a) SQL area(b) Private SQL area(c) Stack space(d) Session areaThe question was asked in a job interview.The origin of the question is Oracle Database 11g Architecture in section Oracle Database 11g Architecture Options of Oracle |
| Answer» <html><body><a href="https://interviewquestions.tuteehub.com/tag/correct-409949" style="font-weight:bold;" target="_blank" title="Click to know more about CORRECT">CORRECT</a> option is (b) Private SQL area<br/><br/>To explain I would <a href="https://interviewquestions.tuteehub.com/tag/say-1195451" style="font-weight:bold;" target="_blank" title="Click to know more about SAY">SAY</a>: PGA (Program Global Area) is a non-shared <a href="https://interviewquestions.tuteehub.com/tag/memory-11894" style="font-weight:bold;" target="_blank" title="Click to know more about MEMORY">MEMORY</a> <a href="https://interviewquestions.tuteehub.com/tag/region-1182095" style="font-weight:bold;" target="_blank" title="Click to know more about REGION">REGION</a> that contains data and control information exclusively for use by an Oracle process.The PGA is created by Oracle Database when an Oracle process is started.</body></html> | |
| 38. |
What is the use of extent in Oracle?(a) Stores user data within the database(b) Stores rollback information used when data must be rolled back(c) Minimize the amount of wasted (empty) storage(d) None of the MentionedI had been asked this question during an online exam.Asked question is from Oracle Database 11g Architecture topic in chapter Oracle Database 11g Architecture Options of Oracle |
| Answer» <html><body><a href="https://interviewquestions.tuteehub.com/tag/correct-409949" style="font-weight:bold;" target="_blank" title="Click to know more about CORRECT">CORRECT</a> option is (c) Minimize the amount of wasted (empty) storage<br/><br/>The explanation is: An extent is a logical <a href="https://interviewquestions.tuteehub.com/tag/unit-1438166" style="font-weight:bold;" target="_blank" title="Click to know more about UNIT">UNIT</a> of database storage space <a href="https://interviewquestions.tuteehub.com/tag/allocation-373131" style="font-weight:bold;" target="_blank" title="Click to know more about ALLOCATION">ALLOCATION</a> made up of a number of contiguous <a href="https://interviewquestions.tuteehub.com/tag/data-25577" style="font-weight:bold;" target="_blank" title="Click to know more about DATA">DATA</a> blocks.</body></html> | |
| 39. |
Which of the following components comprise an Oracle architecture?(a) Database related background processes(b) Tablespaces(c) Datafiles(d) All of the MentionedThis question was addressed to me during an online exam.This interesting question is from Oracle Database 11g Architecture in division Oracle Database 11g Architecture Options of Oracle |
| Answer» <html><body><p>The <a href="https://interviewquestions.tuteehub.com/tag/correct-409949" style="font-weight:bold;" target="_blank" title="Click to know more about CORRECT">CORRECT</a> answer is (d) All of the Mentioned<br/><br/>For <a href="https://interviewquestions.tuteehub.com/tag/explanation-455162" style="font-weight:bold;" target="_blank" title="Click to know more about EXPLANATION">EXPLANATION</a>: Oracle <a href="https://interviewquestions.tuteehub.com/tag/architecture-68" style="font-weight:bold;" target="_blank" title="Click to know more about ARCHITECTURE">ARCHITECTURE</a> consists of DB process, Table space, Datafiles.</p></body></html> | |
| 40. |
What is the use of an index?(a) Retrieve data more quickly and efficiently(b) Related data requires much less I/O overhead if accessed simultaneously(c) Simplify the user’s perception of data access(d) All of the MentionedI got this question in unit test.This intriguing question comes from Oracle Database 11g Architecture topic in chapter Oracle Database 11g Architecture Options of Oracle |
| Answer» <html><body><p>The correct answer is (a) <a href="https://interviewquestions.tuteehub.com/tag/retrieve-613988" style="font-weight:bold;" target="_blank" title="Click to know more about RETRIEVE">RETRIEVE</a> data more quickly and efficiently<br/><br/>To <a href="https://interviewquestions.tuteehub.com/tag/explain-447165" style="font-weight:bold;" target="_blank" title="Click to know more about EXPLAIN">EXPLAIN</a> I would say: Index is <a href="https://interviewquestions.tuteehub.com/tag/used-2318798" style="font-weight:bold;" target="_blank" title="Click to know more about USED">USED</a> for to perform the <a href="https://interviewquestions.tuteehub.com/tag/quick-1174961" style="font-weight:bold;" target="_blank" title="Click to know more about QUICK">QUICK</a> operation on the data.</p></body></html> | |
| 41. |
Which of the following segment is destroyed when the SQL statement is finished?(a) Data Segment(b) Object Segment(c) Temporary Segment(d) All of the MentionedI have been asked this question in semester exam.My question is taken from Oracle Database 11g Architecture topic in portion Oracle Database 11g Architecture Options of Oracle |
| Answer» <html><body><p>Right <a href="https://interviewquestions.tuteehub.com/tag/choice-915996" style="font-weight:bold;" target="_blank" title="Click to know more about CHOICE">CHOICE</a> is (c) <a href="https://interviewquestions.tuteehub.com/tag/temporary-659719" style="font-weight:bold;" target="_blank" title="Click to know more about TEMPORARY">TEMPORARY</a> Segment<br/><br/>The explanation is: After each block is formatted/finished, the <a href="https://interviewquestions.tuteehub.com/tag/new-1114486" style="font-weight:bold;" target="_blank" title="Click to know more about NEW">NEW</a> <a href="https://interviewquestions.tuteehub.com/tag/index-505893" style="font-weight:bold;" target="_blank" title="Click to know more about INDEX">INDEX</a> keys are <a href="https://interviewquestions.tuteehub.com/tag/put-11868" style="font-weight:bold;" target="_blank" title="Click to know more about PUT">PUT</a> in a sort (temporary) segment.</p></body></html> | |
| 42. |
Which processes is an instance made of Oracle?(a) Oracle background processes(b) Memory processes(c) Data processes(d) All of the MentionedI had been asked this question during an online exam.The doubt is from Oracle Database 11g Architecture in chapter Oracle Database 11g Architecture Options of Oracle |
| Answer» <html><body><p>The <a href="https://interviewquestions.tuteehub.com/tag/correct-409949" style="font-weight:bold;" target="_blank" title="Click to know more about CORRECT">CORRECT</a> option is (a) Oracle background <a href="https://interviewquestions.tuteehub.com/tag/processes-21463" style="font-weight:bold;" target="_blank" title="Click to know more about PROCESSES">PROCESSES</a><br/><br/>To elaborate: Oracle creates a set of background processes for an instance to manage <a href="https://interviewquestions.tuteehub.com/tag/memory-11894" style="font-weight:bold;" target="_blank" title="Click to know more about MEMORY">MEMORY</a> structure, asynchronously <a href="https://interviewquestions.tuteehub.com/tag/perform-1150848" style="font-weight:bold;" target="_blank" title="Click to know more about PERFORM">PERFORM</a> I/O to write data to <a href="https://interviewquestions.tuteehub.com/tag/disk-955870" style="font-weight:bold;" target="_blank" title="Click to know more about DISK">DISK</a>, and do general maintenance tasks.</p></body></html> | |
| 43. |
What is the use of Library cache?(a) Contains User information, such as user privileges(b) Used to store shared SQL(c) Log of changes made to the database(d) All of the MentionedThe question was posed to me by my school principal while I was bunking the class.Origin of the question is Oracle Database 11g Architecture in portion Oracle Database 11g Architecture Options of Oracle |
| Answer» <html><body><p>Correct choice is (b) <a href="https://interviewquestions.tuteehub.com/tag/used-2318798" style="font-weight:bold;" target="_blank" title="Click to know more about USED">USED</a> to store shared SQL<br/><br/>Best <a href="https://interviewquestions.tuteehub.com/tag/explanation-455162" style="font-weight:bold;" target="_blank" title="Click to know more about EXPLANATION">EXPLANATION</a>: Oracle Library cache is like a <a href="https://interviewquestions.tuteehub.com/tag/data-25577" style="font-weight:bold;" target="_blank" title="Click to know more about DATA">DATA</a> buffer cache, except that it is not for data, but a cache for SQL PL/SQL <a href="https://interviewquestions.tuteehub.com/tag/programs-1169026" style="font-weight:bold;" target="_blank" title="Click to know more about PROGRAMS">PROGRAMS</a> and Java classes.</p></body></html> | |