Tag: technology

Quizzes (307) Questions (36705)

Questions Related to technology

Multiple choice technology databases

What is the restriction on using UNION in embedded SQL ?

It has to be in a CURSOR
cannot be used in Embedded SQL
No restrictions
None of the above

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Which of the following is a NOT a valid reason for defining a view on a table?

Restrict users' access to a subset of table data
Ensure that rows inserted remain within the scope of a definition
Produce an action as a result of a change to a table
Provide users with an alternate view of table data

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Which of the following isolation levels will lock all rows scanned to build a result data set?

Uncommitted Read
Cursor Stability
Read Stability
Repeatable Read

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

A declared temporary table is used for which of the following purposes?

Backup purposes
Storing intermediate results
Staging area for load operations
Sharing result data sets between applications

Reveal answer Fill a bubble to check yourself

Multiple choice technology platforms and products

Which of the following is a reserved word for Workflow Expressions only?

WORKFLOWSTARTTIME
PROC_RESULT
SYSDATE
STARTED

Reveal answer Fill a bubble to check yourself

Multiple choice technology platforms and products

A database field requires the hour that an order is shipped. The date is stored in 24 Hr format. Which of the following examples will return the value 22 for an order shipped on Aug 15 2009, at 10.15 PM?

GET_DATE_PART (DATE_SHIPPED,'HH')
GET_DATE_PART (DATE_SHIPPED,'HH12')
GET_DATE_PART (DATE_SHIPPED,'HH24')
All

Reveal answer Fill a bubble to check yourself

Multiple choice technology platforms and products

To define a Node or Domain in PowerCenter 8.x, which type of command is used?

infacmd
infasetup
pmcmd
pmrep

Reveal answer Fill a bubble to check yourself

Multiple choice technology platforms and products

What are the ‘Core Services’ that can be configured by users (admin)?

Domain Service and Licensing Service
Gateway Service and Log Service
Authentication Service and Admin Service
Integration Service and Repository Service

Reveal answer Fill a bubble to check yourself

Multiple choice technology platforms and products

PowerCenter Domain _________

Consists of Zero or more Grids.
Consists of One or more Grids.
Can not have a Grid.
Can have only one Grid.

Reveal answer Fill a bubble to check yourself

Multiple choice technology platforms and products

What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?

$$$SessStartTime returns the session start time as string and SESSSTARTTIME returns as a date/time.
$$$SessStartTime returns the session start time as an integer and SESSSTARTTIME returns as a date/time.
$$$SessStartTime returns the session start time as string and SESSSTARTTIME returns as an integer.
There is no difference in practice. Either can be used to used to return the Session start time.

Reveal answer Fill a bubble to check yourself

← Previous
1
2
…
572
573
574
575
576
577
578
579
580
…
3670
3671
Next →