• +91 9971497814
  • info@interviewmaterial.com

Computer Interview Questions Answers

Oracle Interview Questions Answers

Question - 171 : - What is the difference between SHOW_EDITOR and EDIT_TEXTITEM?

Answer - 171 : - Show editor is the generic built-in which accepts any editor name and takes some input string and returns modified output string. Whereas the edit_textitem built-in needs the input focus to be in the text item before the built-in is executed.

Question - 172 : - What is the basic data structure that is required for creating an LOV?

Answer - 172 : - Record Group.

Question - 173 : - Use the Add_group_row procedure to add a row to a static record group 1. true or false?

Answer - 173 : - False

Question - 174 : - Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

Answer - 174 : - False

Question - 175 : - What is use of term?

Answer - 175 : - The term file which key is correspond to which oracle report functions.

Question - 176 : - What is a tablespace?

Answer - 176 : - A database is divided into Logical Storage Unit called tablespaces. A tablespace is used to grouped related logical structures together.

Question - 177 : - What does ROLLBACK do ?

Answer - 177 : - ROLLBACK retracts any of the changes resulting from the SQL statements in the transaction.

Question - 178 : - What are synonyms used for?

Answer - 178 : - - Mask the real name and owner of an object. - Provide public access to an object - Provide location transparency for tables, views or program units of a remote database. - Simplify the SQL statements for database users.

Question - 179 : - What is Mirrored on-line Redo Log ?

Answer - 179 : - A mirrored on-line redo log consists of copies of on-line redo log files physically located on separate disks, changes made to one member of the group are made to all members.

Question - 180 : - What are the built-ins used for processing rows?

Answer - 180 : - Get_group_row_count(function) Get_group_selection_count(function) Get_group_selection(function) Reset_group_selection(procedure) Set_group_selection(procedure) Unset_group_selection(procedure)

Computer Contributors

krishan
Rajeev Katiyar
Yes Baroda

Share your email for latest updates

Name:
Email:

Our partners