• +91 9971497814
  • info@interviewmaterial.com

Computer Interview Questions Answers

Oracle Interview Questions Answers

Question - 221 : - What are the benefits of distributed options in databases?

Answer - 221 : - Database on other servers can be updated and those transactions can be grouped together with others in a logical unit. Database uses a two phase commit.

Question - 222 : - What is a text list?

Answer - 222 : - The text list style list item appears as a rectangular box which displays the fixed number of values. When the text list contains values that can not be displayed, a vertical scroll bar appears, allowing the operator to view and select undisplayed values.

Question - 223 : - Can a Tablespace hold objects from different Schemes ?

Answer - 223 : - Yes.

Question - 224 : - How is it possible to select generate a select set for the query in the query property sheet?

Answer - 224 : - By using the tables/columns button and then specifying the table and the column names.

Question - 225 : - Name of the functions used to get/set canvas properties?

Answer - 225 : - Get_view_property, Set_view_property

Question - 226 : - What are the various type of snapshots?

Answer - 226 : - Simple and Complex.

Question - 227 : - What is strip sources generate options?

Answer - 227 : - Removes the source code from the library file and generates a library files that contains only pcode. The resulting file can be used for final deployment, but can not be subsequently edited in the designer.ex. f45gen module=old_lib.pll userid=scott/tiger strip_source YES output_file

Question - 228 : - What is Partial Backup ?

Answer - 228 : - A Partial Backup is any operating system backup short of a full backup, taken while the database is open or shut down.

Question - 229 : - What are the database administrators utilities available ?

Answer - 229 : - SQL * DBA - This allows DBA to monitor and control an ORACLE database. SQL * Loader - It loads data from standard operating system files (Flat files) into ORACLE database tables. Export (EXP) and Import (imp) utilities allow you to move existing data in ORACLE format to and from ORACLE database.

Question - 230 : - What are the advantages of views?

Answer - 230 : - - Provide an additional level of table security, by restricting access to a predetermined set of rows and columns of a table. - Hide data complexity. - Simplify commands for the user. - Present the data in a different perspective from that of the base table. - Store complex queries.

Computer Contributors

krishan
Rajeev Katiyar
Yes Baroda

Share your email for latest updates

Name:
Email:

Our partners