databases Online Quiz - 103 Online Test

0

databases Online Quiz - 103

Description: databases Online Quiz - 103
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

The keyword return is compulsory in

technology databases

Procedure definition
Function definition
both A & B
Option in both A & B

Examine this database trigger CREATE OR REPLACE TRIGGER prevent_gross_modification {additional trigger information} BEGIN IF TO_CHAR(sysdate, DY) = MON THEN RAISE_APPLICATION_ERROR(-19999,'user Defined error'); END IF; END; This trigger will error out

technology databases

True
False

_________ is the maximum nuber of Exceptions that the PL/SQL engine will process before exiting out of the BLOCK.

technology databases

only one
All that apply
I Dont know
None of the above

A procedure can have a procedure declaration inside

technology databases

True
False

Multiload will not support

technology databases

USI
NUSI
Both a and b
Neither a nor b

In Teradata, indexes are maintained by the Senior Database Administrator

technology databases

True
False

Secondary Index is used for

technology databases

Access the rows
Distribution of the rows
Both a and b
Only for distribution of rows to particular AMPs

Primary Index is mandatory for teradata table

technology databases

True
False

Primary Index is used for

technology databases

Access the rows
Distribution of the rows
Both a and b
Only for distribution of rows to particular AMPs

Fastload will not support

technology databases

USI
NUSI
Both a and b
Neither a nor b

Primary index value can be changed

technology databases

At a cost of row redistribution
At a cost of table recreation
When the table is empty
None of the above

Reading the rows using Non-Unique Secondary index is

technology databases

One or Two AMP operation
All AMP operation
Many AMP operation
Full table scan

For PPI table, rows are first sorted by ------ at each AMPs

technology databases

Hash Value
Partition Number
First column of the table
Both a and b

Reading the rows using Non-Unique Primary index is one AMP operation

technology databases

True
False

Teradata table will have ------ Primary Index

technology databases

Many
Two
One
64

Reading the rows using Unique Secondary index is

technology databases

One or Two AMP operation depends on the base row location
Always two AMP operation irrespective of the base row location
Many AMP operation
All AMP operation

Views can be specified in a trigger statement

technology databases

True
False

Two functions can be used with the same name in a PL/SQL block

technology databases

True
False

What is the maximum number of statements that can be specified in a trigger statement?

technology databases

1
2
3
4

Which of the following is not a schema object?

technology databases

Index
Tables
Public Synonymns
Triggers

- Hide questions