• +91 9971497814
  • info@interviewmaterial.com

Computer Interview Questions Answers

Oracle Interview Questions Answers

Question - 41 : - Can you pass data parameters to forms?

Answer - 41 : - No

Question - 42 : - When does a Transaction end ?

Answer - 42 : - When it is committed or Rollbacked.

Question - 43 : - Which parameter can be used to set read level consistency across multiple queries?

Answer - 43 : - Read only

Question - 44 : - Which of the above methods is the faster method?

Answer - 44 : - performing the calculation in the query is faster.

Question - 45 : - What are the various sub events a mouse double click event involves? What are the various sub events a mouse double click event involves?

Answer - 45 : - Double clicking the mouse consists of the mouse down, mouse up, mouse click, mouse down & mouse up events.

Question - 46 : - What are the built-ins used for finding object ID functions?

Answer - 46 : - Find_group(function) Find_column(function)

Question - 47 : - Is the After report trigger fired if the report execution fails?

Answer - 47 : - Yes.

Question - 48 : - What is schema?

Answer - 48 : - A schema is collection of database objects of a user.

Question - 49 : - What are the different windows events activated at runtimes?

Answer - 49 : - When_window_activated When_window_closed When_window_deactivated When_window_resized Within this triggers, you can examine the built in system variable system. event_window to determine the name of the window for which the trigger fired.

Question - 50 : - Where can one find the high water mark for a table? (for DBA)

Answer - 50 : - There is no single system table, which contains the high water mark (HWM) for a table. A table's HWM can be calculated using the results from the following SQL statements: SELECT BLOCKS FROM DBA_SEGMENTS WHERE OWNER=UPPER(owner) AND SEGMENT_NAME = UPPER(table); ANALYZE TABLE owner.table ESTIMATE STATISTICS; SELECT EMPTY_BLOCKS FROM DBA_TABLES WHERE OWNER=UPPER(owner) AND SEGMENT_NAME = UPPER(table); Thus, the tables' HWM = (query result 1) - (query result 2) - 1 NOTE: You can also use the DBMS_SPACE package and calculate the HWM = TOTAL_BLOCKS - UNUSED_BLOCKS - 1.

Computer Contributors

krishan
Rajeev Katiyar
Yes Baroda

Share your email for latest updates

Name:
Email:

Our partners