databases Online Quiz - 124
|Description: databases Online Quiz - 124|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
Which two statements are true about REF CURSOR types?
Which two conditions must be true for a PL/SQL function to be cached?
Which one of the following Data Mining Extension (DMX) queries allows you to browse data in mining models?
When is using Relational OLAP most justified?
which one of the following forms the basis of a Dependent Data mart?
Which data fields should be indexed in a data warehouse?
which one of the following is NOT a function of a Data Extraction tool?
How is the Snowflake schema different from the star schema?
When creating Data Mart architecture, which one of the following items do you review?
What are the Text and Image Functions?A. PATINDEX,TEXTPTR,TEXTVALIDB. BINARY_CHECKSUM MIN ,CHECKSUM SUM ,CHECKSUM_AGG STDEV ,COUNT STDEVP ,COUNT_BIG C.BINARY_CHECKSUM MIN ,CHECKSUM SUM ,CHECKSUM_AGG STDEV ,TEXTPTR,TEXTVALID
Instead of Cursor what can be used to perform row by row operation there by increasing performance?
How many clustered and non clustered indexex exists for single table