• +91 9971497814
  • info@interviewmaterial.com

Computer Interview Questions Answers

Oracle Interview Questions Answers

Question - 51 : - What are the master-detail triggers?

Answer - 51 : - On-Check_delete_masterOn_clear_detailsOn_populate_details

Question - 52 : - Does a Before form trigger fire when the parameter form is suppressed?

Answer - 52 : - Yes.

Question - 53 : - What is Table ?

Answer - 53 : - A table is the basic unit of data storage in an ORACLE database. The tables of a database hold all of the user accessible data. Table data is stored in rows and columns.

Question - 54 : - To execute row from being displayed that still use column in the row which property can be used?

Answer - 54 : - Format trigger.

Question - 55 : - What is an Extent ?

Answer - 55 : - An Extent is a specific number of contiguous data blocks, obtained in a single allocation, and used to store a specific type of information.

Question - 56 : - What is Oracle table?

Answer - 56 : - A table is the basic unit of data storage in an Oracle database. The tables of a database hold all of the user accessible data. Table data is stored in rows and columns.

Question - 57 : - What are the different type of Segments ?

Answer - 57 : - Data Segment, Index Segment, Rollback Segment and Temporary Segment.

Question - 58 : - What are the built-ins used for Getting cell values?

Answer - 58 : - GET_GROUP_CHAR_CELL (function) GET_GROUPCELL(function) GET_GROUP_NUMBET_CELL(function)

Question - 59 : - What is Parallel Server ?

Answer - 59 : - Multiple instances accessing the same database (Only In Multi-CPU environments)

Question - 60 : - How does one add users to a password file?

Answer - 60 : - One can select from the SYS.V_$PWFILE_USERS view to see which users are listed in the password file. New users can be added to the password file by granting them SYSDBA or SYSOPER privileges, or by using the orapwd utility. GRANT SYSDBA TO scott;

Computer Contributors

krishan
Rajeev Katiyar
Yes Baroda

Share your email for latest updates

Name:
Email:

Our partners