Tag: databases

Questions Related to databases

Which action produces the most accurate Table Definitions for usage with the Oracle Enterprise stage?
technology databases

  1. Use import "Oracle Table Definitions" .

  2. Use import "Via bridges".

  3. Use import "Plug-in Meta Data Definitions".

  4. Use import "Orchestrate Schema Definitions" using orchdbutil.

Show answer
Correct Option: D

How many columns are presented after executing this query: SELECT address1||','||address2||','||address2 "Adress" FROM employee;
technology databases

  1. 3

  2. 4

  3. 1

  4. None

Show answer
Correct Option: C

Which of the following can be a valid column name?
technology databases

  1. Column

  2. 1966_Invoices

  3. #Invoices

  4. Catch_#22

Show answer
Correct Option: D

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

  1. Default tablespace for the user

  2. Oracle will give an error

  3. System tablespace

  4. Users tablespace

Show answer
Correct Option: A

In this PL/SQL statement, which of the following lines will produce an error?
technology databases

  1. cursor CAPITALS is

  2. select CITY, STATE

  3. into my_city, my_state

  4. from CITIES where CAPITAL = 'Y';

Show answer
Correct Option: C

PL/SQL raises an exception, in which TWO of the following cases:
technology databases

  1. When the datatypes of SELECT clause and INTO clause do not match

  2. When a SELECT statement returns more than one row

  3. When a SELECT statement returns no rows

  4. When INTO statement is missing in the SELECT statement

Show answer
Correct Option: B,C

What is the result if two NULL values are compared to each other?
technology databases

  1. True

  2. False

  3. NULL

  4. Undefined

Show answer
Correct Option: C

Which section of a PL/SQL block would most likely contain a RAISE statement?

technology databases

  1. Header

  2. Declarative

  3. Executable

  4. Exception

Show answer
Correct Option: C,D

Assuming today is Monday, 10 July 2000, what is returned by this statement: SELECT to_char(NEXT_DAY(sysdate, 'MONDAY'), 'DD-MON-RR') FROM dual;

technology databases

  1. 10-JUL-00

  2. 17-JUL-00

  3. 12-JUL-00

  4. 11-JUL-00

Show answer
Correct Option: B

SQL statement with “High Selectivity” means

technology databases

  1. No. of rows returned by SQL statement are HIGH

  2. No. of rows returned by SQL statement are FEW

  3. No. of rows returned by SQL statement are > 10000

  4. No. of rows returned by SQL statement are > 50000

Show answer
Correct Option: B