• +91 9971497814
  • info@interviewmaterial.com

Computer Interview Questions Answers

Oracle Interview Questions Answers

Question - 181 : - What is term?

Answer - 181 : - The term is terminal definition file that describes the terminal form which you are using r20run.

Question - 182 : - What are the default parameter that appear at run time in the parameter screen? What are the various sub events a mouse double click event involves?

Answer - 182 : - Destype and Desname.

Question - 183 : - What is snapshots?

Answer - 183 : - Snapshot is an object used to dynamically replicate data between distribute database at specified time intervals. In ver 7.0 they are read only.

Question - 184 : - What is a timer?

Answer - 184 : - Timer is an "internal time clock" that you can programmatically create to perform an action each time the times.

Question - 185 : - What is Rollback Segment ?

Answer - 185 : - A Database contains one or more Rollback Segments to temporarily store "undo" information.

Question - 186 : - What is a shared pool?

Answer - 186 : - The data dictionary cache is stored in an area in SGA called the shared pool. This will allow sharing of parsed SQL statements among concurrent users.

Question - 187 : - What are the different types of Delete details we can establish in Master-Details?

Answer - 187 : - Cascade Isolate Non-isolate

Question - 188 : - Can a tablespace hold objects from different schemes?

Answer - 188 : - Yes.

Question - 189 : - What are the built-ins used for Creating and deleting groups?

Answer - 189 : - CREATE-GROUP (function) CREATE_GROUP_FROM_QUERY(function) DELETE_GROUP(procedure)

Question - 190 : - How does one create a password file?

Answer - 190 : - The Oracle Password File ($ORACLE_HOME/dbs/orapw or orapwSID) stores passwords for users with administrative privileges. One needs to create a password files before remote administrators (like OEM) will be allowed to connect. Follow this procedure to create a new password file: . Log in as the Oracle software owner . Runcommand: orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=mypasswd . Shutdown the database (SQLPLUS> SHUTDOWN IMMEDIATE) . Edit the INIT.ORA file and ensure REMOTE_LOGIN_PASSWORDFILE=exclusive is set. . Startup the database (SQLPLUS> STARTUP) NOTE: The orapwd utility presents a security risk in that it receives a password from the command line. This password is visible in the process table of many systems. Administrators needs to be aware of this!

Computer Contributors

krishan
Rajeev Katiyar
Yes Baroda

Share your email for latest updates

Name:
Email:

Our partners