Which of the following mappings can be created using OWB
Type-1
Type-2
SCD
ALL THE ABOVE
Which of the following target table properties is set for Type-2 mappings.
INSERT
INSERT/UPDATE
UPDATE
UPDATE/INSERT
Which of the folowing is true with regard to deployment manager.
Always deploy the mapping before executing
Newly created/Modified Mappings need not be deployed before executing
Deployment needs depends on the mapping status
Execute the mapping and deploy it only when you need to export
You create the following PL/SQL block: DECLARE var1 CONSTANT NUMBER := 50; var2 NUMBER := 0; BEGIN SELECT acctno INTO var2 FROM bank_acct WHERE name = 'JORDAN'; var1 :=var2 + 2000; END; Which of the following lines in this block of PL/SQL code will produce an error? (Choose One)
var2 NUMBER := 0;
INTO var2
WHERE name = 'JORDAN';
var1 :=var2 + 2000;
There are no errors in this PL/SQL block.
To produce a meaningful result set without any cartesian products, what is the minimum number of conditions that should appear in the WHERE clause of a four-table join?
8
4
2
3
5
Which of the following SQL functions can operate on any datatype?
TO_CHAR
LOWER
LPAD
MAX
CEIL
When a user creates an object without a TABLESPACE clause, where will Oracle store the segment?
System tablespace
Users tablespace
Default tablespace for the user
Oracle will give an error
Undefined
The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true
True
False
The different reporting systems used by Hartford line of business are
BRS
AHS
MRDP
VAS
Data Warehouse is a
Analysis System
transaction system
Repository system
none of the above