• +91 9971497814
  • info@interviewmaterial.com

Computer Interview Questions Answers

Oracle Interview Questions Answers

Question - 211 : - What is an Integrity Constrains ?

Answer - 211 : - An integrity constraint is a declarative way to define a business rule for a column of a table.

Question - 212 : - What is a profile ?

Answer - 212 : - Each database user is assigned a Profile that specifies limitations on various system resources available to the user.

Question - 213 : - What is an Oracle sequence?

Answer - 213 : - A sequence generates a serial list of unique numbers for numerical columns of a database's tables.

Question - 214 : - What are the built-in used for getting cell values?

Answer - 214 : - Get_group_char_cell(function) Get_groupcell(function) Get_group_number_cell(function)

Question - 215 : - What is the maximum no of chars the parameter can store?

Answer - 215 : - The maximum no of chars the parameter can store is only valid for char parameters, which can be upto 64K. No parameters default to 23Bytes and Date parameter default to 7Bytes.

Question - 216 : - What are different types of canvas views?

Answer - 216 : - Content canvas views Stacked canvas views Horizontal toolbar vertical toolbar.

Question - 217 : - Can a property clause itself be based on a property clause?

Answer - 217 : - Yes

Question - 218 : - If a break order is set on a column would it affect columns which are under the column?

Answer - 218 : - No

Question - 219 : - What are the different file extensions that are created by oracle reports?

Answer - 219 : - Rep file and Rdf file.

Question - 220 : - What are roles? How can we implement roles ?

Answer - 220 : - Roles are the easiest way to grant and manage common privileges needed by different groups of database users. Creating roles and assigning provides to roles. Assign each role to group of users. This will simplify the job of assigning privileges to individual users.

Computer Contributors

krishan
Rajeev Katiyar
Yes Baroda

Share your email for latest updates

Name:
Email:

Our partners