Tag: packaged enterprise solutions

Questions Related to packaged enterprise solutions

  1. The number of CPUs on the server

  2. The degree of parallelism on the tables

  3. The use of bitmap indexes

  4. The quality of the SQL optimization


Correct Option: D
  1. Indexes are only used in special cases

  2. Indexes are used to make table storage more efficient

  3. Indexes rarely make a difference in SQL performance

  4. Indexes exist solely to improve query speed


Correct Option: D
  1. No data can be updated while it is being read

  2. No data can be read while it is being updated

  3. While SQL statement gets executed automatically DBA locks data called implicit locking

  4. All the Above


Correct Option: D
  1. Column Constraint

  2. Table Constraint

  3. Both A. and B

  4. None of the Above


Correct Option: C