0

databases Online Quiz - 209

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

what is the maximum length of all Oracle Objects?

  1. <=30 characters

  2. <=40 characters

  3. <=32 characters

  4. <=20 characters


Correct Option: A

In Oracle, is the following Anonymous block is valid? Declare Begin End;

  1. True

  2. False


Correct Option: B

In an Outer Join, what happens to columns that are not matched?

  1. All matched columns returns NULLS.

  2. All unmatched columns returns NULLS.

  3. All matched and unmatched columns returns NULLS.

  4. Cant say


Correct Option: B

User_Source table contains code for which all Objects?

  1. Functions

  2. Package body

  3. Triggers

  4. Cursor


Correct Option: A,B,C
  1. drop foreign keys

  2. cascade constraints

  3. this is not possible in oracle

  4. clear references


Correct Option: D

What is the difference between varchar and varchar2 data types?

  1. maximum length for varchar is 2000 bytes and for varchar2 is 4000 bytes

  2. varchar is used to store fixed length character data, varchar2 is for variable length character data

  3. varchar data type is not supported in oracle

  4. varchar is applicable only to PL/SQL


Correct Option: D

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

  1. 1

  2. 2

  3. 3

  4. 0

  5. 4


Correct Option: A

Which Oracle access method is the fastest way for Oracle to retrieve a single row?

  1. Primary key access

  2. Access via unique index

  3. Table access by ROWID

  4. Full table scan


Correct Option: C

Which character is used to continue a statement in SQL*Plus?

  1. *

  2. /

  3. -

  4. @


Correct Option: C

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

  1. System tablespace

  2. Users tablespace

  3. Default tablespace for the user

  4. Oracle will give an error

  5. Undefined


Correct Option: C

The primary key on table EMP is the EMPNO column. Which of the following statements will not use the associated index on EMPNO?

  1. select * from EMP where nvl(EMPNO, '00000') = '59384'

  2. select * from EMP where EMPNO = '59384'

  3. select EMPNO, LASTNAME from EMP where EMPNO = '59384'

  4. select 1 from EMP where EMPNO = '59834'


Correct Option: A
  1. Column

  2. 1966_Invoices

  3. Catch_#22

  4. #Invoices

  5. None of the above


Correct Option: D

Teradata has been called a __________ architecture.

  1. Anything Goes

  2. Shared Nothing

  3. Shared Everything

  4. Dual Redundant


Correct Option: B
- Hide questions