Online Access Free PCAD-31-02 Exam Questions

Which of the following statistical measures are considered measures of central tendency?
(Choose two)

• A.Interquartile range
• B.Mode
• C.Variance
• D.Mean

Which actions are valid techniques for handling erroneous categorical values in a dataset?
(Choose two)

• A.Normalizing using min-max scaling
• B.Replacing inconsistent labels with a standardized value
• C.Converting all values to integers
• D.Removing rows with invalid labels

When joining two tables in a relational database using SQL, which clause is used to specify the relationship between their columns?

• A.GROUP BY
• B.HAVING
• C.JOIN ON
• D.FROM

Which SQL commands can be used to modify the contents of a table's data directly?
(Choose all that apply)

• A.DELETE
• B.UPDATE
• C.INSERT
• D.SELECT

Which practices help ensure secure and effective execution of SQL queries in Python scripts?
(Choose all that apply)

• A.Using string formatting to build SQL queries dynamically
• B.Wrapping SQL commands in try-except blocks
• C.Using string concatenation to insert variables into SQL
• D.Employing parameterized statements for user-supplied data