Tag: databases

Questions Related to databases

Which of the following mappings can be created using OWB
technology databases

  1. Type-1

  2. Type-2

  3. SCD

  4. ALL THE ABOVE

Show answer
Correct Option: A,B

Which of the following target table properties is set for Type-2 mappings.
technology databases

  1. INSERT

  2. INSERT/UPDATE

  3. UPDATE

  4. UPDATE/INSERT

Show answer
Correct Option: B

Which of the folowing is true with regard to deployment manager.
technology databases

  1. Always deploy the mapping before executing

  2. Newly created/Modified Mappings need not be deployed before executing

  3. Deployment needs depends on the mapping status

  4. Execute the mapping and deploy it only when you need to export

Show answer
Correct Option: C

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)
technology databases

  1. var2 NUMBER := 0;

  2. INTO var2

  3. WHERE name = 'JORDAN';

  4. var1 :=var2 + 2000;

  5. There are no errors in this PL/SQL block.

Show answer
Correct Option: D

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?
technology databases

  1. 8

  2. 4

  3. 2

  4. 3

  5. 5

Show answer
Correct Option: D

Which of the following SQL functions can operate on any datatype?
technology databases

  1. TO_CHAR

  2. LOWER

  3. LPAD

  4. MAX

  5. CEIL

Show answer
Correct Option: C

When a user creates an object without a TABLESPACE clause, where will Oracle store the segment?
technology databases

  1. System tablespace

  2. Users tablespace

  3. Default tablespace for the user

  4. Oracle will give an error

  5. Undefined

Show answer
Correct Option: C

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
technology databases

  1. True

  2. False

Show answer
Correct Option: A

The different reporting systems used by Hartford line of business are
technology databases

  1. BRS

  2. AHS

  3. MRDP

  4. VAS

Show answer
Correct Option: A,C,D

Data Warehouse is a
technology databases

  1. Analysis System

  2. transaction system

  3. Repository system

  4. none of the above

Show answer
Correct Option: A