Tag: databases

Questions Related to databases

  1. Groups and roles can be createdin the Cognos namespace when specifying access to objects.

  2. Even when object security is applied, if anonymous access is configured, every objectin a Framework Manager project is visible toeveryone.

  3. A user belongs to two groups. One of the groups isdenied access to an object. The other group is grantedaccess to the object.The result is that user has access to the object.

  4. Grantingaccess toan object for one user, group orrole(except theEveryone and All Authenticated Users groups), implicitlydenies access to that object for all other users, groups or roles.


Correct Option: D
  1. Toadd a page set to a report.

  2. To set the number of rows on a page.

  3. To create a report title that changes according to a locale.

  4. Tonavigate between report pages and prompt pages.


Correct Option: C
  1. Quantity and Revenue are peers.

  2. Order method is a peer of Retailer type.

  3. Sales territory is a peer of Order method.

  4. Sales territory is a peer of Quantity and Revenue.


Correct Option: A
  1. Oracle Advanced Queuing

  2. DBMS_JOB

  3. DBMS_SQL

  4. Pipelined Functions


Correct Option: C
  1. control structures such as if-then-else statements and loop.

  2. object types and methods.

  3. procedures and functions.

  4. none of these.


Correct Option: A,B,C
  1. procedure

  2. trigger

  3. function

  4. all


Correct Option: C
  1. consists of procedures and functions stored in database as standalone.

  2. block that is associated with an event that occurs in database

  3. constructed dynamically and executed once.

  4. none if these


Correct Option: C
  1. both are same

  2. both are different

  3. none of these

  4. the subtypes VARCHAR and STRING are equivalent to VARCHAR2


Correct Option: D
  1. Higher level 7

  2. Health level 7

  3. health literacy 7

  4. health logo 7


Correct Option: B