• +91 9971497814
  • info@interviewmaterial.com

Computer Interview Questions Answers

Oracle Interview Questions Answers

Question - 11 : - What are the Coordination Properties in a Master-Detail relationship?

Answer - 11 : - The coordination properties are Deferred Auto-Query These Properties determine when the population phase of block coordination should occur.

Question - 12 : - What are the dictionary tables used to monitor a database spaces ?

Answer - 12 : - DBA_FREE_SPACE DBA_SEGMENTS DBA_DATA_FILES.

Question - 13 : - What are difference between post database commit and post-form commit?

Answer - 13 : - Post-form commit fires once during the post and commit transactions process, after the database commit occurs. The post-form-commit trigger fires after inserts, updates and deletes have been posted to the database but before the transactions have been finalized in the issuing the command. The post-database-commit trigger fires after oracle forms issues the commit to finalized transactions.

Question - 14 : - Can a view based on another view?

Answer - 14 : - Yes.

Question - 15 : - Do View contain Data ?

Answer - 15 : - Views do not contain or store data.

Question - 16 : - What is relation between the window and canvas views?

Answer - 16 : - Canvas views are the back ground objects on which you place the interface items (Text items), check boxes, radio groups etc.,) and boilerplate objects (boxes, lines, images etc.,) that operators interact with us they run your form . Each canvas views displayed in a window.

Question - 17 : - Why are OPS$ accounts a security risk in a client/server environment? (for DBA)

Answer - 17 : - If you allow people to log in with OPS$ accounts from Windows Workstations, you cannot be sure who they really are. With terminals, you can rely on operating system passwords, with Windows, you cannot. If you set REMOTE_OS_AUTHENT=TRUE in your init.ora file, Oracle assumes that the remote OS has authenticated the user. If REMOTE_OS_AUTHENT is set to FALSE (recommended), remote users will be unable to connect without a password. IDENTIFIED EXTERNALLY will only be in effect from the local host. Also, if you are using "OPS$" as your prefix, you will be able to log on locally with or without a password, regardless of whether you have identified your ID with a password or defined it to be IDENTIFIED EXTERNALLY.

Question - 18 : - What is user Account in Oracle database?

Answer - 18 : - An user account is not a physical structure in Database but it is having important relationship to the objects in the database and will be having certain privileges.

Question - 19 : - Where are my TEMPFILES, I don't see them in V$DATAFILE or DBA_DATA_FILE?

Answer - 19 : - Tempfiles, unlike normal datafiles, are not listed in v$datafile or dba_data_files. Instead query v$tempfile or dba_temp_files: SELECT * FROM v$tempfile; SELECT * FROM dba_temp_files;

Question - 20 : - How will you enforce security using stored procedures?

Answer - 20 : - Don't grant user access directly to tables within the application. Instead grant the ability to access the procedures that access the tables. When procedure executed it will execute the privilege of procedures owner. Users cannot access tables except via the procedure.

Computer Contributors

krishan
Rajeev Katiyar
Yes Baroda

Share your email for latest updates

Name:
Email:

Our partners