databases Online Quiz - 124
|Description: databases Online Quiz - 124|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
Which two types of metadata can be retrieved by using the various procedures in the DBMS_METADATA PL/SQL package? (Choose two.)
Which two statements are true about SecureFile LOB options? (Choose two.)
Which two types of query results cannot be stored in the query result cache? (Choose two.)
Identify two methods for immunizing PL/SQL code against SQL injection attacks ?
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 is the purpose of Business Intelligence?
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 the most dynamic kind of business data that can be implemented in a database?
which one of the following is NOT a function of a Data Extraction tool?
Which one of the following mechanisms allows the Data Mining Extensions (DMX) to be used for predictions?
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
Which is the correct query to find the Min, Max and 2nd Max in Sql server?
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