Free Oracle 1Z1-591 Practice Test & Real Exam Questions

Exam Code/Number: 1Z1-591
Exam Name/Title: Oracle Business Intelligence Foundation Suite 11g Essentials
Certification Provider: Oracle
Corresponding Certification: Java and Middleware

Exam Questions: 122
Updated On: Aug 03, 2026

Question #1

The WebLogic Console will allow you to perform which of the following functions in the BI Managed Server?

A. Manage user logins

B. Create Summary Tables

C. Start and Stop BI Services

D. Build Aggregate Queries

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #2

One of the most common uses of Dynamic Repository Variables is to setup filters for use in reporting. Which variable below is a valid example of a Dynamic Repository Variable?

A. Quarter

B. CurrentMonth

C. Year

D. Month

Discussion 0

Correct Answer: B Vote an answer

Question #3

An organization would like to see a Time folder with subfolders for its Fiscal and Julian calendars. How would you accomplish this?

A. By creating Presentation Folder called Time and then two subsequent folders called -> Fiscal Calendar and -> Julian Calendar

B. By creating a Presentation Folder called ->Time called then two subsequent folders called Fiscal Calendar and Julian Calendar

C. By creating a Presentation Folder called -Time and then two subsequent folders called + Fiscal Calendar and + Julian Calendar

D. By creating a Presentation Folder called Time<parent> and then two subsequent folders called Fiscal Calendar<child> and Julian Calendar<child>

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #4

Oracle BI Server at a company is connected to Data Warehouse that is refreshed on a daily basis, the majority of users at the company log in to Oracle BI every Monday to generate the previous week's sales report. The BI Administrator schedules cache purge and cache seeding to improve report response times. How is this accomplished?

A. Every Monday early morning

B. Every day after Data Warehouse refresh

C. Every day before Data Warehouse refresh

D. Every Monday late night

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #5

What would you use to customize the text elements that appear on BI Analysis, Delivers and Dashboard pages?

A. XML Message Files

B. DHML Message files

C. Cascading Style Sheets

D. BI Presentation services web template

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #6

The administration tool is the developer's interface to the repository file. It allows the development of and changes to the metadata repository file. Which statement is true?

A. Opening the rpd.file in online mode results in performance Issues for the application user.

B. Changes to the repository can only be carried out in offline mode.

C. Multiple developers can work on one repository at the same time. Results can be merged later on.

D. All aspects of security are being held in the repository file.

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #7

Which component is responsible for determining the device that receives the alerts for a given user account?

A. Dashboard

B. Delivery Profiles

C. iBot

D. Alerts

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #8

Which two Oracle BI Components contain security information regarding permissions and privileges?

A. The Repository

B. The Web Catalog

C. NQServer.ini File

D. InstanceConfig.xml File

E. NQSConfig.ini File

Discussion 0

Correct Answer: A,B Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #9

When adding a new dimension to an existing logical table, what is the significance of the Logical Level setting in the Logical Table Source properties?

A. It creates a foreign key relationship.

B. It defines the granularity of the dimension.

C. It determines the actual value of the dimension.

D. It creates a new session variable.

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #10

The WebLogic Repository Schema generated via RCU can be deployed to which three DBMS?

A. Microsoft SQL Server

B. Teradata

C. Oracle RDBMS

D. IBM DB2

Discussion 0

Correct Answer: A,C,D Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Download Free Oracle 1Z1-591 Demo

Simply submit your e-mail address below to get started with our free demo of your Oracle 1Z1-591 exam.