• +91 9971497814
  • info@interviewmaterial.com

Computer Interview Questions Answers

Oracle Interview Questions Answers

Question - 191 : - What is an Index Segment ?

Answer - 191 : - Each Index has an Index segment that stores all of its data.

Question - 192 : - What are the difference between lov & list item?

Answer - 192 : - Lov is a property where as list item is an item. A list item can have only one column, lov can have one or more columns.

Question - 193 : - Can one rename a database user (schema)?

Answer - 193 : - No, this is listed as Enhancement Request 158508. Workaround: Do a user-level export of user A create new user B Import system/manager fromuser=A touser=B Drop user A

Question - 194 : - Do a view contain data?

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

Question - 195 : - What dynamic data replication?

Answer - 195 : - Updating or Inserting records in remote database through database triggers. It may fail if remote database is having any problem.

Question - 196 : - How do I find used/free space in a TEMPORARY tablespace?

Answer - 196 : - Unlike normal tablespaces, true temporary tablespace information is not listed in DBA_FREE_SPACE. Instead use the V$TEMP_SPACE_HEADER view: SELECT tablespace_name, SUM (bytes used), SUM (bytes free) FROM V$temp_space_header GROUP BY tablespace_name;

Question - 197 : - What are the use of Roles ?

Answer - 197 : - REDUCED GRANTING OF PRIVILEGES - Rather than explicitly granting the same set of privileges to many users a database administrator can grant the privileges for a group of related users granted to a role and then grant only the role to each member of the group. DYNAMIC PRIVILEGE MANAGEMENT - When the privileges of a group must change, only the privileges of the role need to be modified. The security domains of all users granted the group's role automatically reflect the changes made to the role. SELECTIVE AVAILABILITY OF PRIVILEGES - The roles granted to a user can be selectively enable (available for use) or disabled (not available for use). This allows specific control of a user's privileges in any given situation. APPLICATION AWARENESS - A database application can be designed to automatically enable and disable selective roles when a user attempts to use the application.

Question - 198 : - Do user parameters appear in the data modal editor in 2.5?

Answer - 198 : - No

Question - 199 : - What is the use of hidden column? What are the various sub events a mouse double click event involves?

Answer - 199 : - A hidden column is used to when a column has to embed into boilerplate text.

Question - 200 : - What is Index Cluster ?

Answer - 200 : - A Cluster with an index on the Cluster Key

Computer Contributors

Rajeev Katiyar
Yes Baroda

Share your email for latest updates


Our partners