MCQs on Basic Scripting | Qlikview MCQ Questions
This comprehensive set of 30 multiple-choice questions (MCQs) will test your understanding of Chapter 6: Basic Scripting in QlikView. Topics include Script Editor, ETL operations, QlikView functions, and debugging.
MCQs on Basic Scripting in QlikView
Script Editor Overview
- What is the purpose of the Script Editor in QlikView?
- A) To create data visualizations
- B) To load and transform data
- C) To edit QlikView sheets
- D) To debug QlikView applications
- How can you access the Script Editor in QlikView?
- A) Press Ctrl+E
- B) From the File menu
- C) From the Tools menu
- D) Press Ctrl+S
- Which of the following is NOT a section in the Script Editor?
- A) Data Load
- B) Data Model
- C) Script Area
- D) Field Overview
- What does the Reload button in the Script Editor do?
- A) Refreshes the QlikView dashboard
- B) Executes the script to load data
- C) Saves the script
- D) Resets all the script changes
- What is the purpose of the Set Script Variables option in the Script Editor?
- A) To create global variables for the application
- B) To edit the data model
- C) To export scripts
- D) To reload data
- Which feature in the Script Editor allows you to segment your script into multiple parts?
- A) Tabs
- B) Folders
- C) Sections
- D) Groups
- What happens when you execute an incomplete script in QlikView?
- A) The execution stops with an error message
- B) The script automatically corrects itself
- C) The application crashes
- D) The script reloads without errors
- Which button in the Script Editor helps you view the log after reloading?
- A) Show Log
- B) Reload Log
- C) Execution Details
- D) View Execution History
Basic ETL Operations (Extract, Transform, Load)
- What does the Extract process in ETL primarily involve?
- A) Transforming raw data into a usable format
- B) Loading data into a QlikView document
- C) Retrieving data from source systems
- D) Cleansing and standardizing data
- Which script command is used to load data from a CSV file?
- A) LOAD
- B) SELECT
- C) IMPORT
- D) READ
- How can you join multiple data sources in QlikView scripting?
- A) Using the Join keyword
- B) By creating a pivot table
- C) Using the Combine function
- D) By linking the data directly
- What is the primary function of the Resident Load command in QlikView?
- A) To load data from an external source
- B) To load data from a previously loaded table
- C) To export data to a file
- D) To create a temporary table
- Which transformation operation is used to rename fields in QlikView?
- A) RENAME FIELD
- B) ALIAS
- C) AS
- D) CHANGE FIELD
- What is the purpose of the Concatenate command in QlikView scripting?
- A) To create new calculated fields
- B) To combine data from multiple tables into one
- C) To delete duplicate records
- D) To split data into separate tables
- What type of data does the CrossTable command in QlikView handle?
- A) Normalized data
- B) Pivoted data
- C) Unstructured data
- D) Duplicated data
- In QlikView, how can you filter specific rows during the load process?
- A) Using the WHERE clause
- B) By applying a filter in the dashboard
- C) By using the FILTER keyword
- D) Manually deleting rows from the source file
Introduction to QlikView Functions
- Which QlikView function is used to calculate the total of a numeric field?
- A) Sum()
- B) Count()
- C) Total()
- D) Aggregate()
- How do you extract the year from a date field in QlikView?
- A) Year()
- B) DatePart()
- C) ExtractYear()
- D) Format()
- What does the SubField() function do?
- A) Splits a field into multiple subfields based on a delimiter
- B) Creates a new field with aggregated data
- C) Filters data within a field
- D) Combines two fields
- Which function is used to replace null values in a field?
- A) NullAsValue()
- B) IfNull()
- C) ReplaceNull()
- D) SetNull()
- What is the result of the If() function in QlikView?
- A) Returns the first non-null value in a field
- B) Executes conditional logic and returns a value
- C) Replaces null values
- D) Creates a calculated field
- What does the Peek() function do in QlikView scripting?
- A) Reads a value from a specific row in a table
- B) Appends data to a table
- C) Displays the last record in a field
- D) Deletes duplicate records
- Which function would you use to create a calculated field based on existing data?
- A) If()
- B) Sum()
- C) LoadField()
- D) AddField()
Common Errors and Debugging
- What error typically occurs when a field is missing from the source data?
- A) FieldNotFound Error
- B) MissingField Error
- C) Script Execution Error
- D) UndefinedField Error
- How can you debug a script error in QlikView?
- A) Check the script log
- B) Restart the application
- C) Reload the script
- D) Manually correct the error
- What does the Trace statement do in QlikView scripting?
- A) Displays custom messages during script execution
- B) Reloads the script
- C) Highlights script errors
- D) Terminates script execution
- Which type of error is caused by circular references in data modeling?
- A) Link Error
- B) Circular Loop Error
- C) Data Integrity Error
- D) Field Mapping Error
- What is a synthetic key in QlikView?
- A) A key created due to multiple common fields between tables
- B) A manually defined primary key
- C) A duplicate key in the data source
- D) A key created by the user for joining tables
- How can you resolve a synthetic key issue?
- A) Use Concatenate or rename conflicting fields
- B) Delete duplicate fields
- C) Ignore the issue
- D) Combine the tables into a single table
- What is the first step in resolving a script execution error?
- A) Check the error log
- B) Reload the script
- C) Contact QlikView support
- D) Restart the QlikView application
Answer Key
| Qno | Answer |
|---|---|
| 1 | B) To load and transform data |
| 2 | A) Press Ctrl+E |
| 3 | B) Data Model |
| 4 | B) Executes the script to load data |
| 5 | A) To create global variables for the application |
| 6 | A) Tabs |
| 7 | A) The execution stops with an error message |
| 8 | A) Show Log |
| 9 | C) Retrieving data from source systems |
| 10 | A) LOAD |
| 11 | A) Using the Join keyword |
| 12 | B) To load data from a previously loaded table |
| 13 | C) AS |
| 14 | B) To combine data from multiple tables into one |
| 15 | B) Pivoted data |
| 16 | A) Using the WHERE clause |
| 17 | A) Sum() |
| 18 | A) Year() |
| 19 | A) Splits a field into multiple subfields based on a delimiter |
| 20 | B) IfNull() |
| 21 | B) Executes conditional logic and returns a value |
| 22 | A) Reads a value from a specific row in a table |
| 23 | A) If() |
| 24 | A) FieldNotFound Error |
| 25 | A) Check the script log |
| 26 | A) Displays custom messages during script execution |
| 27 | B) Circular Loop Error |
| 28 | A) A key created due to multiple common fields between tables |
| 29 | A) Use Concatenate or rename conflicting fields |
| 30 | A) Check the error log |