Round 1 - Online Technical Assessment

You want to send new hire data to a downstream application. You are only interested to send the new records created after the last successful run. Which one of the below is the recommended tool for the same

BIP

OTBI

HCM Extracts

Alerts

Which of the following option correctly represents HCM Extract Components

Extract Definition, Data Groups, Extract Records, Attributes

Extract Definition, Filter Criteria, Data Groups, Extract Records, Attributes

Extract Definition, Filter Criteria, Attributes, Extract Records, Delivery Options

Filter Criteria, Attributes, Extract Records, Delivery Options

A data group connection

Captures association between current data group and parent data group

Connects data group with attributes

Is a mandatory component of every extract. We cannot create a extract without a data group connection.

Forms a hierarchical relationship between data groups

Which of the below are not supported HCM Extract Output Type(s)

TIFF

PDF

EPS

EDI

XML

" I am unable to view some of the Data Models and Reports in Analytics though I have BI Administrator Role, what could be the reason ?"

Need to Check Permissions and Hidden Files Option

Browser Issue

1 and 2

None of the Above

Which of the below output type(s) does not require a BI Publisher template

TEXT

XML

RTF

CSV

Which Is the generic data model used by HCM Extracts

HCMExtractDataModel

GlobalReportsDataModel

IntegrationDataModel

GlobalExtractDataModel

CommonReportDataModel

What are the output types are available for E Text Templates

PDF / TEXT (CSV) / XML

XML / TEXT (CSV) / TEXT (DATA)

TEXT / DATA(XML) / DATA (CSV)

All of the Above

What is the maximum rows of CSV output

2000000

3000000

4000000

5000000

Identify the parameters specific to changes only extract

Baseline Only

Incremental Changes

Changes Only

Delta Changes

Parameter Group

It is mandatory to create an Additional HCM Extract Parameter when you create a Custom HCM Extract

TRUE

FALSE

Is there anyway to Display the Tags based on a condition in E-text Template Output

By using Display condition in E-text Template

By writing Display Condition in Where Clause

By using Where Condition in E-text Template

All of the Above

What are all the destination options available while scheduling a report from BI Analytics and the report is without a bursting query?

HTML/PDF/EMAIL

EMAIL/CONTENT SERVER

CONTENT SERVER/ EXCEL

EXCEL / PDF / EMAIL/ FTP

FTP

How do you run the extract?

My Client Groups->Data Exchange->HCM Extracts->Submit Extracts

Tools->Scheduled Processes->Submit Extract

Payroll Checklists->Submit a Flow or Report

Me->Data Exchange->Submit Extracts

My Client Groups->Payroll->Flow Submission and Results->Submit a Flow

Which ones are the valid options when running a changes-only extract

All Attributes, Changed Attributes, Changed and Marked Attributes, Changed and Marked Attributes with previous values, "Changed, marked attributes, previous data under threading group", Changed and marked attributes under threading group

All Attributes, Changed Attributes, Changed and Marked Attributes, Changed and Marked Attributes with previous values, Changed and marked attributes under threading group

All Attributes, Changed Attributes, Marked Attributes, Changed Attributes with Old Values, Changed and Marked attributes with old values

Changed and Marked Attributes, Changed and marked attributes with old values under threading group

Changed and Marked Attributes, Changed and Marked Attributes with previous values, "Changed, marked attributes, previous data under threading group", Changed and marked attributes under threading group

What are the different options available while defining SQL data group in BI Publisher data model?

SQL / PLSQL / Packages

FSCM / HCM / CRM

Packages / Functions / Procedures

Procedure Call / Non-Standard SQL / Standard SQL

While verifying the data in data model, some XML tags are not visible though the fields are there in the Query. What could be the reason?

Data is Not Available

Joins Issue

Need to be handled in Query

None

Please choose the correct sequence of activities required to be performed in order to create a Custom HCM Extract

"a) Create Extract Definition b) Create Data Groups b) Create Filters c) Create Extract Records d) Create Extract Attributes e) Define Delivery Options f) Validate Extract g) Submit the Extract"

"a) Create Extract Definition b) Create Data Group Connections c) Create Data Group d) Create Data Group Filters e) Create Extract Records f) Create Extract Attributes g) Define Delivery Options "

"a) Create Extract Definition b) Create Data Groups c) Create Data Group Connections d) Create Data Group Filters e) Create Extract Records f) Create Extract Attributes g) Validate Extract h) Define Delivery Options I) Submit the Extract"

"a) Create Data Groups b) Create Data Group Connections c) Create Data Group Filters d) Create Extract Records e) Validate Extract f) Define Delivery Options g) Submit the Extract"

"a) Create Data Groups b) Create Data Group Filters c) Create Extract Records d) Create Extract Attributes e) Validate Extract f) Define Delivery Options "

What are the different types of Extract Records

"Detail Record Header Record Trailer Record"

"Detail Record Header Record Hierarchy Traversal Only"

"Detail Record Group Record Header Record Hierarchy Traversal Only Trailer Record"

"Master Record Detail Record Group Record Header Record Trailer Record"

"Detail Record Master Record Header Record Hierarchy Traversal Only Trailer Record"

There is a requirement to select all values from the parameter and value to select from the list is 'All'. Choose the right option to handle parameter values from the query?

X = NVL(:P1,'All')

X IN :P1 or 'All' IN (P1||'All')

X IN NVL(:P1,'All')

All of the Above

How many reports can be assigned to a single data model?

All of the Above

Which all data types are supported by Extract Attributes

"Date String Integer"

"Date String Integer Float"

"Date String Integer Float Double"

"Date Number Text"

"Date String Integer Float Double Varchar "

What are the steps required to migrate an extract?

"a) Export The extract from Source Environment b) Extract Definition file gets downloaded into the local system c) Locate the path of the downloaded file and import into Target Environment"

"a) Choose your Extract as part of FSM Package b) Import the FSM package to Target Environment"

"a) Archive the Extract from Source Environment b) Unarchive the Extract into Target Environment"

It is not possible to migrate an Extract. The extract needs to be created from scratch in the Target Environment

"a) Provide the URL of the Target Environment under Data Exchange->Migrate Extract b) Click on ""Initiate Extract Migration"""

After clicking on View Report option, Report ran without providing the Parameters. How do I prevent this option?

By providing AutoRun Option in Data Model Properties

By unchecking AutoRun Option in Report Properties

By Providing Parameters as soon as open the report

Not listed

I could see some graphs / pie charts in report output, which type of report can be used to show graphs in output?

RTF Template

E-text Template

XSL Template

Interactive Template

Which of the below statements is correct?

You can only migrate custom extracts

You can only migrate seeded extracts

You can migrate both seeded and custom extracts

You can only migrate extracts if their status is VALID

You can migrate all extracts (both seeded and custom) except Changes-Only Extract

I have to develop one report, which contains all GL related information. By mistake, I placed the Data Model and Report in Shared Folders/Custom/Projects folder instead of Shared Folders/Custom/General Ledger Folder, Can I run the report from Project Folder?

We can’t run the report until we can place the report in GL Folder

BI Analytics Limitation Not to run the report

Copy the report from Projects Folder

We can Run Any Report from Anywhere in /Shared Folder/Custom

Can I run the report without Data model?

Yes but template required

No. Data model is required

Template and data model both are required

None of the Above

If the report is having Multiple Bursting Queries where do we select the default Bursting option to select one

In Data Model Bursting Properties

In Data Model Properties

In RTF Template Properties

In Report General Properties

Where do I provide the email message body in bursting query?

Parameter5

Parameter 7

Parameter4

Parameter2

Oracle Transactional Business Intelligence allows end users to:

Store and distribute dashboards

View and edit analysis content

Create analyses

All of the above

Which of these is not a typical consideration when scoping analyses?

Frequency of delivery

Analysis content

Target audience

All of the above are typical considerations.

"Subject areas can be considered as collections of interconnected information with the same business goal."

TRUE

FALSE

Subject areas must be selected as the last step when creating new custom analyses.

TRUE

FALSE

What is the difference between columns and measure columns?

"Columns track data in multidimensional examination and measure columns convey mainly quantitative data by which a column can be measured."

"Columns convey mainly quantitative data and measure columns track data in multidimensional examination."

"Columns cannot track data in multidimensional examination and measure columns rarely convey quantitative data by which a column can be measured."

There are no differences between them.

Filters can only be used with quantitative data.

TRUE

FALSE

Which one of these statements about filters is true?

Filters are conditions that add data to analyses.

The effect of filters on data in the results is gradual.

Filters can affect the size of data aggregates found in the analysis results.

Filters cannot strip out data from analysis results.

Which of the following statements indicates what selection steps can do with members?

Add or remove them

Add, keep only, or remove them

Remove them only

Add them only

Selection steps are established after analyses have run.

TRUE

FALSE

Calculated items involve a mathematical function.

TRUE

FALSE

When HCM Data Loader Scope is set to Full, you can use neither HCM File-Based Loader nor the static spreadsheet templates in HCM Spreadsheet Data Loader.

True

False

Documents can be printed either as PDFs or in HTML format.

TRUE

FALSE

Using HCM Data Loader, you can:

Load business objects belonging to key Oracle HCM Cloud products

Load translated data in multiple languages

Load attachments and pictures

All of the above

Agents can be considered as macros that carry out scheduling and distribution tasks.

TRUE

FALSE

The specialized data loaders are intended for business users, whereas HCM Data Loader is aimed at the integration specialist.

True

False

When you create a translatable object in Oracle HCM Cloud, a translation record is automatically created for every enabled language in your environment.

True

False

What is the best workflow for successfully building and implementing agents?

"Schedule > Run > Delivery Content > Save > Destinations > Actions > Recipients > Condition"

"Schedule > Condition > Delivery Content > Recipients > Destinations > Actions > Save > Run"

"Save > Run > Schedule > Condition > Delivery Content > Recipients > Destinations > Actions"

"Schedule > Condition > Delivery Content > Recipients > Destinations > Save > Actions > Run"

Which answer describes an actual set operator?

Accumulate

Union none

Union all

Bisect

You cannot edit attribute values in the Error Management page.

True

False

All business object components need a key that can be used to locate the record, either to maintain it or to reference it from another object.

True

False

Which workflow describes dashboard design most accurately?

Create > Run &Test > Add Content & Save > Publish

Run &Test > Create > Publish > Add Content & Save

Create > Add Content & Save > Run & Test > Publish

Add Content & Save > Create > Publish > Run & Test

HCM Data Loader does not allow you to supply data for child components independently.

True

False

You can supply DELETE and MERGE instructions in the same file, but you cannot MERGE and DELETE the same record in the same file.

TRUE

FALSE

During data migration, it is recommended that you run HCM Data Loader in the:

Retain mode

Replace mode

None of the above

Both option 1 and 2

Users keys are:

Used to uniquely identify the record being maintained or referenced

Defined as one or more attributes that have user readable values

Visible on the user interface

All of the above

Image and attachment files are placed in data-type-specific folders called BlobFiles and ClobFiles within the zip file.

True

False

Extensible flexfields and Descriptive flexfields have the same FLEX attribute to define the flexfield code.

True

False

The enterprise option User Account Creation controls whether user accounts are created automatically for workers loaded in bulk.

True

False

The __________ button on the Import and Load Data page allows you to select a file from the Oracle WebCenter Content server.

Import File

Import Local File

It is recommended that supervisor records not be provided with the new worker data but loaded separately in a different zip file.

True

False

You can save data periodically from a spreadsheet to the stage tables.

True

False

To delete object components using a spreadsheet, you enter attribute values to identify the components and upload the spreadsheet.

True

False

You cannot copy a spreadsheet template in the Active status.

True

False

The source key is the recommended key type to use for all implementations.

True

False

When you delete spreadsheet data sets from the HCM Data Loader stage tables they’re deleted from the HCM Spreadsheet Data Loader stage tables.

True

False

Which table contains Date Of Birth column

PER_DATE_OF_BIRTH

PER_PERSONS

PER_PERSON

PER_PERSON_PERSONAL_INFO

What is the output for NVL(A,B)

It will display Column A and Column B data

It will display Column A data only

It will display Column B data only

It will display Column B data if Column A is null

It will display Column A data if Column B is null

What is the use of PRIMARY_FLAG in per_all_assignments_m table

Represents primary assignment

Represents the primary assignment associated to the primary Work Relationship

Represents primary work relationship

Difference between per_all_assignments_f and per_all_people_m

The first one is a view, and the second one is a table

The first one is a table, and the second one is a view

Both are tables

Both are Views

Corrections and updations will be stored in

Tables

Views

Audit Tables

Cursors

How do you eliminate duplicate rows from a query result

Distinct

Common

Unique

All of the above

Which table contains entitlements related information

ABS_ABSENCE_ENTITLEMENTS

PER_ABS_ABSENCE_ENTITLEMENT

PER_ABSENCE_ENTITLEMENTS

ANC_ABSENCE_ENTITLEMENTS

Identify the table name for legal employer

HR_ALL_ORGNIZATIONUNITS_F_VL

PER_LEGAL_EMPLOYERS

HR_LEGAL_ENTITIES

All of the above

We can't display element entries row wise

TRUE

FALSE

Which table contains gender related information for an employee

PER_PEOPLE_LEGISLATIVE_F

PER_PERSONS

PER_PERSON_PERSONAL_INFO

All of the above

Which table contains email related information

PER_EMAIL_ADDRESSES

PER_EMAIL_ADDRESS

HR_EMAIL_ADDRESS

PER_EMP_EMAIL_ADDRESS

Please select the appropriate output for the below query SELECT SUBSTR('HELLO WORLD', 1, INSTR('HELLO WORLD', ' ') - 1) FROM DUAL

HELLO

WORLD

HELLO W

HELL

HELLO WORLD

Please select the appropriate output for the below query SELECT DISTINCT COUNT('MPC CLOUD CONSULTING PVT. LTD.') FROM DUAL

Please select the appropriate output for the below query SELECT Replace('SQL/PLSQL/MYSQL','L', 'M') FROM DUAL

SQM/PLSQL/LYSQM

SQM/PMSQL/LYSQM

SQM/PMSQM/LYSQM

SQM/PMSQM/MYSQM

SQL/PLSQL/LYSQL

Please select the appropriate output for the below query SELECT SYSDATE+3 FROM DUAL

It will add 3Years to the current date

It will add 3Months to the current date

It will add 3weeks to the current date

It will add 3days to the current date

{"name":"Round 1 - Online Technical Assessment", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"You want to send new hire data to a downstream application. You are only interested to send the new records created after the last successful run. Which one of the below is the recommended tool for the same, Which of the following option correctly represents HCM Extract Components, A data group connection","img":"https://www.quiz-maker.com/3012/images/ogquiz.png"}