Run-time errors arise from
Hardware failures
Design faults
Coding mistakes
None of the above
All of the above
___ exception is raised ___ whenever your PL/SQL program violates an Oracle rule or exceeds a system-dependent limit
internal, explicitly
internal, implicitly
user-defined, explicitly
user-defined, implicitly
PL/SQL raises the predefined exception NO_DATA_FOUND if a SELECT INTO statement returns no rows
True
False
We cannot declare the same exception in two different blocks
which statement(s) does the following If @variable is NULL return '5', else return @variable
ISNULL(@variable,'5')
NULLIF(@variable,'5')
COALESCE(@variable,'5')
NONNULL(@variable,'5')
I want my row numbers to come up as 1,2,2,2,3 while using a ranking function. Which ranking function should I use?
ROW_NUMBER()
RANK()
DENSE_RANK()
NTILE(integer_expression)
What is UNIX equalent of deltree (MS-DOS) command.
rem
ls
rm -R
del
Below is not in the steps to build the Dataware House :
Requirement gathering
Data modeling
Data profiling
Data mining
Process in which data from disparate, homogeneous or heterogeneous systems is cleansed, aggregated, consolidated, de-normalized and loaded into a single database or data warehouse after applying business rules is :
Data Profiling
Data Modelling
Data Integration
Data Staging
Can you convert a snowflake schema in to star schema?