0

databases Online Quiz - 1

Description: databases Online Quiz - 1
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

Which of the following statements is correct regarding the implementation of object security in Framework Manager?

  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

In Report Studio, whenwould an author use the Condition Explorer?

  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

AI Explanation

To answer this question, we need to understand the purpose of the Condition Explorer in Report Studio.

Option A) To add a page set to a report - This option is incorrect because the Condition Explorer is not used to add a page set to a report. A page set is used to display different subsets of data on different pages within a report.

Option B) To set the number of rows on a page - This option is incorrect because the Condition Explorer is not used to set the number of rows on a page. This can be done through the properties of the table or list object in Report Studio.

Option C) To create a report title that changes according to a locale - This option is correct. The Condition Explorer in Report Studio can be used to create dynamic report titles that change based on different conditions, such as the locale. This allows authors to create localized reports that automatically display the appropriate title based on the user's language or region.

Option D) To navigate between report pages and prompt pages - This option is incorrect. The Condition Explorer is not used for navigation between report pages and prompt pages. Navigation between report pages and prompt pages can be achieved through the use of hyperlinks or navigation buttons in the report.

The correct answer is C) To create a report title that changes according to a locale. This option is correct because the Condition Explorer in Report Studio can be used to create dynamic report titles that change based on different conditions, such as the locale.

In Report Studio, based on the above crosstab, which relationship is true?

  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

Which of the following do not help you execute multiple PL/SQL programs simultaneously?

  1. Oracle Advanced Queuing

  2. DBMS_JOB

  3. DBMS_SQL

  4. Pipelined Functions


Correct Option: C

AI Explanation

To answer this question, you need to understand the features and capabilities of different PL/SQL execution methods. Let's go through each option to understand why it does or does not help in executing multiple PL/SQL programs simultaneously.

Option A) Oracle Advanced Queuing - This option is incorrect because Oracle Advanced Queuing allows you to enqueue and dequeue messages, which can be used to execute PL/SQL programs asynchronously and in parallel. This feature enables multiple PL/SQL programs to be executed simultaneously.

Option B) DBMS_JOB - This option is incorrect because the DBMS_JOB package allows you to schedule and run PL/SQL programs as jobs. These jobs can be run concurrently, allowing for the execution of multiple PL/SQL programs simultaneously.

Option C) DBMS_SQL - This option is correct because the DBMS_SQL package is used for dynamic SQL execution. While it provides a way to execute SQL statements dynamically, it does not provide a direct mechanism for executing multiple PL/SQL programs simultaneously.

Option D) Pipelined Functions - This option is incorrect because pipelined functions allow you to process data in a streaming manner, which can be beneficial for executing multiple PL/SQL programs simultaneously. Pipelined functions enable the processing of data in parallel and can be used to execute multiple PL/SQL programs concurrently.

The correct answer is Option C) DBMS_SQL. This option does not help in executing multiple PL/SQL programs simultaneously because it is primarily used for dynamic SQL execution and does not provide a direct mechanism for concurrent execution of PL/SQL programs.

what are the extra features of pl/sql over sql?

  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

which of the following objects returns value?

  1. procedure

  2. trigger

  3. function

  4. all


Correct Option: C

what is anonymous block in pl/sql?

  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

what is the difference between varchar n varchar2?

  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

AI Explanation

To answer this question, we need to understand the differences between VARCHAR, VARCHAR2, and STRING data types.

Option A) Both are the same - This option is incorrect because VARCHAR and VARCHAR2 are not the same. They have slight differences in their behavior and storage capacity.

Option B) Both are different - This option is partially correct. VARCHAR and VARCHAR2 are indeed different data types, but they have similar functionalities.

Option C) None of these - This option is incorrect because there are differences between VARCHAR and VARCHAR2.

Option D) The subtypes VARCHAR and STRING are equivalent to VARCHAR2 - This option is correct. In Oracle databases, the subtypes VARCHAR and STRING are equivalent to VARCHAR2. Both VARCHAR and STRING can be used interchangeably with VARCHAR2 without any differences in functionality.

The correct answer is D) The subtypes VARCHAR and STRING are equivalent to VARCHAR2.

what is full form of HL7

  1. Higher level 7

  2. Health level 7

  3. health literacy 7

  4. health logo 7


Correct Option: B

which one of these is not a segment

  1. PV1

  2. PID

  3. ST

  4. NK1


Correct Option: C

which one shows the correct sequence of delimiters

  1. #^*&

  2. /&^~

  3. ^~/&

  4. ^~&


Correct Option: D

.vmd is used as an extension for

  1. vision market and distribution

  2. visual message definition

  3. virus multiple destinations

  4. visual molecular dynamics


Correct Option: B

.vmd is used as an extension for

  1. vision market and distribution

  2. visual message definition

  3. virus multiple destinations

  4. visual molecular dynamics


Correct Option: B
  1. ASCII

  2. binary

  3. unicode

  4. special characters


Correct Option: A

HL7 version 2.3 was released on

  1. 1 march 1997

  2. 1 june 1987

  3. 1 august 1994

  4. 7 june 1997


Correct Option: A

which OSI layer does HL7 belong to

  1. data link

  2. session

  3. network

  4. application


Correct Option: D

HL7 was founded in which year

  1. 1988

  2. 1987

  3. 1997

  4. 1994


Correct Option: B

which one is not a coading standerd in health care

  1. CPT

  2. SNOMED

  3. LOINC

  4. HL7


Correct Option: D
  1. Authorization impacted

  2. Authentication impacted

  3. Billing period data unavailable

  4. alert info unavailable


Correct Option: B
- Hide questions