0

databases Online Quiz - 117

Description: databases Online Quiz - 117
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

Explicit Cursor attributes

  1. %Found

  2. %NOTFOUND

  3. %ROWCOUNT

  4. %ISOPEN


Correct Option: A,B,C,D

How to view installed Oracle version information

  1. select banner from v$version;

  2. select # from v$version;

  3. select ver from v$version

  4. select version from v$version;


Correct Option: A

Which of the below arePL/SQL Exceptions

  1. No_Data_Found

  2. Too_many_rows

  3. Value_Error

  4. Zero_Error


Correct Option: A,B,C,D

The maximum number of triggers we can apply to a single table is 12

  1. True

  2. False


Correct Option: A

SYSDATE is a pseudo column

  1. True

  2. False


Correct Option: A

Cursor_Already_Open is a valid Cursor exception?

  1. True

  2. False


Correct Option: A

Is it possible to have multiple datasources to display a single report?

  1. True

  2. False


Correct Option: B

Data integrity exists on ACCESS LOCK?

  1. True

  2. False


Correct Option: B

Data integrity exists on READ LOCK?

  1. True

  2. False


Correct Option: A

Teradata maintain rows in the received order

  1. True

  2. False


Correct Option: B

What determines the number of concurrent users to the database ?

  1. PMON

  2. CMON

  3. Both

  4. None of the above


Correct Option: A

FLOAD can be used to load data in

  1. Tables with already existing data

  2. Empty tables

  3. Both 1 & 2

  4. None of the above


Correct Option: B

The TOP option can appear in the

  1. FROM clause

  2. WHERE clause

  3. Correlated sub query

  4. None of the above


Correct Option: C

If the TOP option specifies a number greater than the number of rows in the query result set, then

  1. The query returns the rows in the query result set without producing an error.

  2. Return no rows

  3. Produces an error

  4. The query returns rows


Correct Option: A

MULTILOAD faster than FLOAD

  1. True

  2. False


Correct Option: B

In Teradata's parallel environment, response time is as fast as

  1. the fastest AMP invloved

  2. slowest AMP involved

  3. sum of all amps involved

  4. average performance of all AMPs


Correct Option: B

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

  1. 2

  2. 1

  3. 3

  4. 0


Correct Option: B

What output will the follwing statement produce? Select NVL2(NULL,'NOT NULL', NULL) from dual;

  1. Null

  2. Not Null

  3. Function NVL2 is not defined

  4. None of The above


Correct Option: A

Which three definitions are associated with implicit cursors?

  1. %rowtype, %toomanyrows, %found

  2. %found, %notfound, %rowcount

  3. %rowtype, %rowcount, %notfound

  4. None of the above


Correct Option: B

Which command will delete all data from a table and will not write to the rollback segment?

  1. DROP

  2. DELETE

  3. TRUNCATE

  4. CASCADE


Correct Option: C
- Hide questions