BS Artificial Intelligence · Database Systems

Unit 4: SQL MCQs

50 solved multiple choice questions with answers and short explanations.

Q1. Which statement best describes SQL Concepts within SQL? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. AIts meaning can be determined without considering the task.
  2. BIt should be understood through its assumptions, representation, inputs, outputs, objective, and role in the AI pipeline.
  3. CIt is only a user-interface style and has no effect on model behavior.
  4. DIt guarantees intelligence regardless of data or assumptions.
Show answer
Answer: B. It should be understood through its assumptions, representation, inputs, outputs, objective, and role in the AI pipeline.Database Systems → SQL → SQL Concepts: It should be understood through its assumptions, representation, inputs, outputs, objective, and role in the AI pipeline.
Report a mistake

Q2. What is the primary purpose of SQL Concepts in an AI system? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. AIts purpose is always to maximize model size.
  2. BIt eliminates the need for data quality checks.
  3. CIt guarantees perfect predictions once implemented.
  4. DIt supports a defined intelligent behavior or prediction objective using an appropriate representation and method.
Show answer
Answer: D. It supports a defined intelligent behavior or prediction objective using an appropriate representation and method.Database Systems → SQL → SQL Concepts: It supports a defined intelligent behavior or prediction objective using an appropriate representation and method.
Report a mistake

Q3. An AI team is working with SQL Concepts. Which approach is most appropriate? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. AIgnore assumptions because AI methods automatically adapt to every problem.
  2. BDefine the objective and metric, examine the data and assumptions, select an appropriate method, and validate the result.
  3. CSelect the largest model before defining the task.
  4. DTrain on all available data and skip independent evaluation.
Show answer
Answer: B. Define the objective and metric, examine the data and assumptions, select an appropriate method, and validate the result.Database Systems → SQL → SQL Concepts: Define the objective and metric, examine the data and assumptions, select an appropriate method, and validate the result.
Report a mistake

Q4. Which consideration is most important when preparing or using data for SQL Concepts? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. AUse any available data even when it leaks the target.
  2. BAssume more rows always remove sampling bias.
  3. CIgnore privacy and labeling quality when model accuracy is high.
  4. DAssess data quality, representativeness, leakage, labeling, privacy, and the relationship between the data and target task.
Show answer
Answer: D. Assess data quality, representativeness, leakage, labeling, privacy, and the relationship between the data and target task.Database Systems → SQL → SQL Concepts: Assess data quality, representativeness, leakage, labeling, privacy, and the relationship between the data and target task.
Report a mistake

Q5. Which principle best supports sound modeling involving SQL Concepts? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. AIncrease complexity indefinitely without checking validation results.
  2. BChoose a method whose assumptions and capacity fit the task, then validate rather than relying on training performance alone.
  3. CChoose a model only because it is fashionable.
  4. DUse training accuracy as the only evidence of generalization.
Show answer
Answer: B. Choose a method whose assumptions and capacity fit the task, then validate rather than relying on training performance alone.Database Systems → SQL → SQL Concepts: Choose a method whose assumptions and capacity fit the task, then validate rather than relying on training performance alone.
Report a mistake

Q6. How should an AI practitioner evaluate work involving SQL Concepts? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. AEvaluate only on the same examples used for fitting.
  2. BChoose a metric unrelated to the actual task.
  3. CAssume a visually impressive demo is sufficient evidence.
  4. DUse suitable metrics and held-out or otherwise valid evidence that reflects the actual task and expected deployment conditions.
Show answer
Answer: D. Use suitable metrics and held-out or otherwise valid evidence that reflects the actual task and expected deployment conditions.Database Systems → SQL → SQL Concepts: Use suitable metrics and held-out or otherwise valid evidence that reflects the actual task and expected deployment conditions.
Report a mistake

Q7. Which risk should be considered carefully when applying SQL Concepts? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. ADeployment failures need not be considered before release.
  2. BConsider bias, unreliable generalization, data leakage, privacy, robustness, and harmful failure modes relevant to the application.
  3. CBias cannot occur when a model uses mathematics.
  4. DPrivacy is irrelevant if training is automated.
Show answer
Answer: B. Consider bias, unreliable generalization, data leakage, privacy, robustness, and harmful failure modes relevant to the application.Database Systems → SQL → SQL Concepts: Consider bias, unreliable generalization, data leakage, privacy, robustness, and harmful failure modes relevant to the application.
Report a mistake

Q8. Which action is most appropriate when performance involving SQL Concepts is inadequate? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. AChange many components simultaneously without diagnosis.
  2. BHide poor cases from the evaluation set.
  3. CIncrease model size before checking data or error patterns.
  4. DDiagnose the failure using data and evaluation evidence before changing features, model, optimization, or system design.
Show answer
Answer: D. Diagnose the failure using data and evaluation evidence before changing features, model, optimization, or system design.Database Systems → SQL → SQL Concepts: Diagnose the failure using data and evaluation evidence before changing features, model, optimization, or system design.
Report a mistake

Q9. Which trade-off should be evaluated when selecting an approach to SQL Concepts? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. AInterpretability and operational cost are always irrelevant.
  2. BBalance predictive quality with interpretability, compute, latency, data needs, robustness, maintainability, and risk.
  3. COnly accuracy matters in every AI application.
  4. DCompute and latency never affect model selection.
Show answer
Answer: B. Balance predictive quality with interpretability, compute, latency, data needs, robustness, maintainability, and risk.Database Systems → SQL → SQL Concepts: Balance predictive quality with interpretability, compute, latency, data needs, robustness, maintainability, and risk.
Report a mistake

Q10. Which practice best represents responsible use of SQL Concepts? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. ADeploy without documenting limitations.
  2. BRetain sensitive data indefinitely because it may be useful.
  3. CRemove human review even where consequences are high.
  4. DDocument limitations, protect data, test foreseeable failure modes, maintain human oversight where needed, and monitor deployment.
Show answer
Answer: D. Document limitations, protect data, test foreseeable failure modes, maintain human oversight where needed, and monitor deployment.Database Systems → SQL → SQL Concepts: Document limitations, protect data, test foreseeable failure modes, maintain human oversight where needed, and monitor deployment.
Report a mistake

Q11. Which statement best describes SQL Methods within SQL? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. AIt is only a user-interface style and has no effect on model behavior.
  2. BIt guarantees intelligence regardless of data or assumptions.
  3. CIts meaning can be determined without considering the task.
  4. DIt should be understood through its assumptions, representation, inputs, outputs, objective, and role in the AI pipeline.
Show answer
Answer: D. It should be understood through its assumptions, representation, inputs, outputs, objective, and role in the AI pipeline.Database Systems → SQL → SQL Methods: It should be understood through its assumptions, representation, inputs, outputs, objective, and role in the AI pipeline.
Report a mistake

Q12. What is the primary purpose of SQL Methods in an AI system? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. AIt guarantees perfect predictions once implemented.
  2. BIt supports a defined intelligent behavior or prediction objective using an appropriate representation and method.
  3. CIts purpose is always to maximize model size.
  4. DIt eliminates the need for data quality checks.
Show answer
Answer: B. It supports a defined intelligent behavior or prediction objective using an appropriate representation and method.Database Systems → SQL → SQL Methods: It supports a defined intelligent behavior or prediction objective using an appropriate representation and method.
Report a mistake

Q13. An AI team is working with SQL Methods. Which approach is most appropriate? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. ASelect the largest model before defining the task.
  2. BTrain on all available data and skip independent evaluation.
  3. CIgnore assumptions because AI methods automatically adapt to every problem.
  4. DDefine the objective and metric, examine the data and assumptions, select an appropriate method, and validate the result.
Show answer
Answer: D. Define the objective and metric, examine the data and assumptions, select an appropriate method, and validate the result.Database Systems → SQL → SQL Methods: Define the objective and metric, examine the data and assumptions, select an appropriate method, and validate the result.
Report a mistake

Q14. Which consideration is most important when preparing or using data for SQL Methods? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. AIgnore privacy and labeling quality when model accuracy is high.
  2. BAssess data quality, representativeness, leakage, labeling, privacy, and the relationship between the data and target task.
  3. CUse any available data even when it leaks the target.
  4. DAssume more rows always remove sampling bias.
Show answer
Answer: B. Assess data quality, representativeness, leakage, labeling, privacy, and the relationship between the data and target task.Database Systems → SQL → SQL Methods: Assess data quality, representativeness, leakage, labeling, privacy, and the relationship between the data and target task.
Report a mistake

Q15. Which principle best supports sound modeling involving SQL Methods? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. AChoose a model only because it is fashionable.
  2. BUse training accuracy as the only evidence of generalization.
  3. CIncrease complexity indefinitely without checking validation results.
  4. DChoose a method whose assumptions and capacity fit the task, then validate rather than relying on training performance alone.
Show answer
Answer: D. Choose a method whose assumptions and capacity fit the task, then validate rather than relying on training performance alone.Database Systems → SQL → SQL Methods: Choose a method whose assumptions and capacity fit the task, then validate rather than relying on training performance alone.
Report a mistake

Q16. How should an AI practitioner evaluate work involving SQL Methods? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. AAssume a visually impressive demo is sufficient evidence.
  2. BUse suitable metrics and held-out or otherwise valid evidence that reflects the actual task and expected deployment conditions.
  3. CEvaluate only on the same examples used for fitting.
  4. DChoose a metric unrelated to the actual task.
Show answer
Answer: B. Use suitable metrics and held-out or otherwise valid evidence that reflects the actual task and expected deployment conditions.Database Systems → SQL → SQL Methods: Use suitable metrics and held-out or otherwise valid evidence that reflects the actual task and expected deployment conditions.
Report a mistake

Q17. Which risk should be considered carefully when applying SQL Methods? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. ABias cannot occur when a model uses mathematics.
  2. BPrivacy is irrelevant if training is automated.
  3. CDeployment failures need not be considered before release.
  4. DConsider bias, unreliable generalization, data leakage, privacy, robustness, and harmful failure modes relevant to the application.
Show answer
Answer: D. Consider bias, unreliable generalization, data leakage, privacy, robustness, and harmful failure modes relevant to the application.Database Systems → SQL → SQL Methods: Consider bias, unreliable generalization, data leakage, privacy, robustness, and harmful failure modes relevant to the application.
Report a mistake

Q18. Which action is most appropriate when performance involving SQL Methods is inadequate? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. AIncrease model size before checking data or error patterns.
  2. BDiagnose the failure using data and evaluation evidence before changing features, model, optimization, or system design.
  3. CChange many components simultaneously without diagnosis.
  4. DHide poor cases from the evaluation set.
Show answer
Answer: B. Diagnose the failure using data and evaluation evidence before changing features, model, optimization, or system design.Database Systems → SQL → SQL Methods: Diagnose the failure using data and evaluation evidence before changing features, model, optimization, or system design.
Report a mistake

Q19. Which trade-off should be evaluated when selecting an approach to SQL Methods? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. AOnly accuracy matters in every AI application.
  2. BCompute and latency never affect model selection.
  3. CInterpretability and operational cost are always irrelevant.
  4. DBalance predictive quality with interpretability, compute, latency, data needs, robustness, maintainability, and risk.
Show answer
Answer: D. Balance predictive quality with interpretability, compute, latency, data needs, robustness, maintainability, and risk.Database Systems → SQL → SQL Methods: Balance predictive quality with interpretability, compute, latency, data needs, robustness, maintainability, and risk.
Report a mistake

Q20. Which practice best represents responsible use of SQL Methods? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. ARemove human review even where consequences are high.
  2. BDocument limitations, protect data, test foreseeable failure modes, maintain human oversight where needed, and monitor deployment.
  3. CDeploy without documenting limitations.
  4. DRetain sensitive data indefinitely because it may be useful.
Show answer
Answer: B. Document limitations, protect data, test foreseeable failure modes, maintain human oversight where needed, and monitor deployment.Database Systems → SQL → SQL Methods: Document limitations, protect data, test foreseeable failure modes, maintain human oversight where needed, and monitor deployment.
Report a mistake

Q21. Which statement best describes SQL Modeling within SQL? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. AIts meaning can be determined without considering the task.
  2. BIt should be understood through its assumptions, representation, inputs, outputs, objective, and role in the AI pipeline.
  3. CIt is only a user-interface style and has no effect on model behavior.
  4. DIt guarantees intelligence regardless of data or assumptions.
Show answer
Answer: B. It should be understood through its assumptions, representation, inputs, outputs, objective, and role in the AI pipeline.Database Systems → SQL → SQL Modeling: It should be understood through its assumptions, representation, inputs, outputs, objective, and role in the AI pipeline.
Report a mistake

Q22. What is the primary purpose of SQL Modeling in an AI system? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. AIts purpose is always to maximize model size.
  2. BIt eliminates the need for data quality checks.
  3. CIt guarantees perfect predictions once implemented.
  4. DIt supports a defined intelligent behavior or prediction objective using an appropriate representation and method.
Show answer
Answer: D. It supports a defined intelligent behavior or prediction objective using an appropriate representation and method.Database Systems → SQL → SQL Modeling: It supports a defined intelligent behavior or prediction objective using an appropriate representation and method.
Report a mistake

Q23. An AI team is working with SQL Modeling. Which approach is most appropriate? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. AIgnore assumptions because AI methods automatically adapt to every problem.
  2. BDefine the objective and metric, examine the data and assumptions, select an appropriate method, and validate the result.
  3. CSelect the largest model before defining the task.
  4. DTrain on all available data and skip independent evaluation.
Show answer
Answer: B. Define the objective and metric, examine the data and assumptions, select an appropriate method, and validate the result.Database Systems → SQL → SQL Modeling: Define the objective and metric, examine the data and assumptions, select an appropriate method, and validate the result.
Report a mistake

Q24. Which consideration is most important when preparing or using data for SQL Modeling? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. AUse any available data even when it leaks the target.
  2. BAssume more rows always remove sampling bias.
  3. CIgnore privacy and labeling quality when model accuracy is high.
  4. DAssess data quality, representativeness, leakage, labeling, privacy, and the relationship between the data and target task.
Show answer
Answer: D. Assess data quality, representativeness, leakage, labeling, privacy, and the relationship between the data and target task.Database Systems → SQL → SQL Modeling: Assess data quality, representativeness, leakage, labeling, privacy, and the relationship between the data and target task.
Report a mistake

Q25. Which principle best supports sound modeling involving SQL Modeling? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. AIncrease complexity indefinitely without checking validation results.
  2. BChoose a method whose assumptions and capacity fit the task, then validate rather than relying on training performance alone.
  3. CChoose a model only because it is fashionable.
  4. DUse training accuracy as the only evidence of generalization.
Show answer
Answer: B. Choose a method whose assumptions and capacity fit the task, then validate rather than relying on training performance alone.Database Systems → SQL → SQL Modeling: Choose a method whose assumptions and capacity fit the task, then validate rather than relying on training performance alone.
Report a mistake

Q26. How should an AI practitioner evaluate work involving SQL Modeling? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. AEvaluate only on the same examples used for fitting.
  2. BChoose a metric unrelated to the actual task.
  3. CAssume a visually impressive demo is sufficient evidence.
  4. DUse suitable metrics and held-out or otherwise valid evidence that reflects the actual task and expected deployment conditions.
Show answer
Answer: D. Use suitable metrics and held-out or otherwise valid evidence that reflects the actual task and expected deployment conditions.Database Systems → SQL → SQL Modeling: Use suitable metrics and held-out or otherwise valid evidence that reflects the actual task and expected deployment conditions.
Report a mistake

Q27. Which risk should be considered carefully when applying SQL Modeling? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. ADeployment failures need not be considered before release.
  2. BConsider bias, unreliable generalization, data leakage, privacy, robustness, and harmful failure modes relevant to the application.
  3. CBias cannot occur when a model uses mathematics.
  4. DPrivacy is irrelevant if training is automated.
Show answer
Answer: B. Consider bias, unreliable generalization, data leakage, privacy, robustness, and harmful failure modes relevant to the application.Database Systems → SQL → SQL Modeling: Consider bias, unreliable generalization, data leakage, privacy, robustness, and harmful failure modes relevant to the application.
Report a mistake

Q28. Which action is most appropriate when performance involving SQL Modeling is inadequate? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. AChange many components simultaneously without diagnosis.
  2. BHide poor cases from the evaluation set.
  3. CIncrease model size before checking data or error patterns.
  4. DDiagnose the failure using data and evaluation evidence before changing features, model, optimization, or system design.
Show answer
Answer: D. Diagnose the failure using data and evaluation evidence before changing features, model, optimization, or system design.Database Systems → SQL → SQL Modeling: Diagnose the failure using data and evaluation evidence before changing features, model, optimization, or system design.
Report a mistake

Q29. Which trade-off should be evaluated when selecting an approach to SQL Modeling? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. AInterpretability and operational cost are always irrelevant.
  2. BBalance predictive quality with interpretability, compute, latency, data needs, robustness, maintainability, and risk.
  3. COnly accuracy matters in every AI application.
  4. DCompute and latency never affect model selection.
Show answer
Answer: B. Balance predictive quality with interpretability, compute, latency, data needs, robustness, maintainability, and risk.Database Systems → SQL → SQL Modeling: Balance predictive quality with interpretability, compute, latency, data needs, robustness, maintainability, and risk.
Report a mistake

Q30. Which practice best represents responsible use of SQL Modeling? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. ADeploy without documenting limitations.
  2. BRetain sensitive data indefinitely because it may be useful.
  3. CRemove human review even where consequences are high.
  4. DDocument limitations, protect data, test foreseeable failure modes, maintain human oversight where needed, and monitor deployment.
Show answer
Answer: D. Document limitations, protect data, test foreseeable failure modes, maintain human oversight where needed, and monitor deployment.Database Systems → SQL → SQL Modeling: Document limitations, protect data, test foreseeable failure modes, maintain human oversight where needed, and monitor deployment.
Report a mistake

Q31. Which statement best describes SQL Evaluation within SQL? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. AIt is only a user-interface style and has no effect on model behavior.
  2. BIt guarantees intelligence regardless of data or assumptions.
  3. CIts meaning can be determined without considering the task.
  4. DIt should be understood through its assumptions, representation, inputs, outputs, objective, and role in the AI pipeline.
Show answer
Answer: D. It should be understood through its assumptions, representation, inputs, outputs, objective, and role in the AI pipeline.Database Systems → SQL → SQL Evaluation: It should be understood through its assumptions, representation, inputs, outputs, objective, and role in the AI pipeline.
Report a mistake

Q32. What is the primary purpose of SQL Evaluation in an AI system? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. AIt guarantees perfect predictions once implemented.
  2. BIt supports a defined intelligent behavior or prediction objective using an appropriate representation and method.
  3. CIts purpose is always to maximize model size.
  4. DIt eliminates the need for data quality checks.
Show answer
Answer: B. It supports a defined intelligent behavior or prediction objective using an appropriate representation and method.Database Systems → SQL → SQL Evaluation: It supports a defined intelligent behavior or prediction objective using an appropriate representation and method.
Report a mistake

Q33. An AI team is working with SQL Evaluation. Which approach is most appropriate? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. ASelect the largest model before defining the task.
  2. BTrain on all available data and skip independent evaluation.
  3. CIgnore assumptions because AI methods automatically adapt to every problem.
  4. DDefine the objective and metric, examine the data and assumptions, select an appropriate method, and validate the result.
Show answer
Answer: D. Define the objective and metric, examine the data and assumptions, select an appropriate method, and validate the result.Database Systems → SQL → SQL Evaluation: Define the objective and metric, examine the data and assumptions, select an appropriate method, and validate the result.
Report a mistake

Q34. Which consideration is most important when preparing or using data for SQL Evaluation? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. AIgnore privacy and labeling quality when model accuracy is high.
  2. BAssess data quality, representativeness, leakage, labeling, privacy, and the relationship between the data and target task.
  3. CUse any available data even when it leaks the target.
  4. DAssume more rows always remove sampling bias.
Show answer
Answer: B. Assess data quality, representativeness, leakage, labeling, privacy, and the relationship between the data and target task.Database Systems → SQL → SQL Evaluation: Assess data quality, representativeness, leakage, labeling, privacy, and the relationship between the data and target task.
Report a mistake

Q35. Which principle best supports sound modeling involving SQL Evaluation? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. AChoose a model only because it is fashionable.
  2. BUse training accuracy as the only evidence of generalization.
  3. CIncrease complexity indefinitely without checking validation results.
  4. DChoose a method whose assumptions and capacity fit the task, then validate rather than relying on training performance alone.
Show answer
Answer: D. Choose a method whose assumptions and capacity fit the task, then validate rather than relying on training performance alone.Database Systems → SQL → SQL Evaluation: Choose a method whose assumptions and capacity fit the task, then validate rather than relying on training performance alone.
Report a mistake

Q36. How should an AI practitioner evaluate work involving SQL Evaluation? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. AAssume a visually impressive demo is sufficient evidence.
  2. BUse suitable metrics and held-out or otherwise valid evidence that reflects the actual task and expected deployment conditions.
  3. CEvaluate only on the same examples used for fitting.
  4. DChoose a metric unrelated to the actual task.
Show answer
Answer: B. Use suitable metrics and held-out or otherwise valid evidence that reflects the actual task and expected deployment conditions.Database Systems → SQL → SQL Evaluation: Use suitable metrics and held-out or otherwise valid evidence that reflects the actual task and expected deployment conditions.
Report a mistake

Q37. Which risk should be considered carefully when applying SQL Evaluation? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. ABias cannot occur when a model uses mathematics.
  2. BPrivacy is irrelevant if training is automated.
  3. CDeployment failures need not be considered before release.
  4. DConsider bias, unreliable generalization, data leakage, privacy, robustness, and harmful failure modes relevant to the application.
Show answer
Answer: D. Consider bias, unreliable generalization, data leakage, privacy, robustness, and harmful failure modes relevant to the application.Database Systems → SQL → SQL Evaluation: Consider bias, unreliable generalization, data leakage, privacy, robustness, and harmful failure modes relevant to the application.
Report a mistake

Q38. Which action is most appropriate when performance involving SQL Evaluation is inadequate? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. AIncrease model size before checking data or error patterns.
  2. BDiagnose the failure using data and evaluation evidence before changing features, model, optimization, or system design.
  3. CChange many components simultaneously without diagnosis.
  4. DHide poor cases from the evaluation set.
Show answer
Answer: B. Diagnose the failure using data and evaluation evidence before changing features, model, optimization, or system design.Database Systems → SQL → SQL Evaluation: Diagnose the failure using data and evaluation evidence before changing features, model, optimization, or system design.
Report a mistake

Q39. Which trade-off should be evaluated when selecting an approach to SQL Evaluation? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. AOnly accuracy matters in every AI application.
  2. BCompute and latency never affect model selection.
  3. CInterpretability and operational cost are always irrelevant.
  4. DBalance predictive quality with interpretability, compute, latency, data needs, robustness, maintainability, and risk.
Show answer
Answer: D. Balance predictive quality with interpretability, compute, latency, data needs, robustness, maintainability, and risk.Database Systems → SQL → SQL Evaluation: Balance predictive quality with interpretability, compute, latency, data needs, robustness, maintainability, and risk.
Report a mistake

Q40. Which practice best represents responsible use of SQL Evaluation? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. ARemove human review even where consequences are high.
  2. BDocument limitations, protect data, test foreseeable failure modes, maintain human oversight where needed, and monitor deployment.
  3. CDeploy without documenting limitations.
  4. DRetain sensitive data indefinitely because it may be useful.
Show answer
Answer: B. Document limitations, protect data, test foreseeable failure modes, maintain human oversight where needed, and monitor deployment.Database Systems → SQL → SQL Evaluation: Document limitations, protect data, test foreseeable failure modes, maintain human oversight where needed, and monitor deployment.
Report a mistake

Q41. Which statement best describes SQL Applications within SQL? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. AIts meaning can be determined without considering the task.
  2. BIt should be understood through its assumptions, representation, inputs, outputs, objective, and role in the AI pipeline.
  3. CIt is only a user-interface style and has no effect on model behavior.
  4. DIt guarantees intelligence regardless of data or assumptions.
Show answer
Answer: B. It should be understood through its assumptions, representation, inputs, outputs, objective, and role in the AI pipeline.Database Systems → SQL → SQL Applications: It should be understood through its assumptions, representation, inputs, outputs, objective, and role in the AI pipeline.
Report a mistake

Q42. What is the primary purpose of SQL Applications in an AI system? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. AIts purpose is always to maximize model size.
  2. BIt eliminates the need for data quality checks.
  3. CIt guarantees perfect predictions once implemented.
  4. DIt supports a defined intelligent behavior or prediction objective using an appropriate representation and method.
Show answer
Answer: D. It supports a defined intelligent behavior or prediction objective using an appropriate representation and method.Database Systems → SQL → SQL Applications: It supports a defined intelligent behavior or prediction objective using an appropriate representation and method.
Report a mistake

Q43. An AI team is working with SQL Applications. Which approach is most appropriate? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. AIgnore assumptions because AI methods automatically adapt to every problem.
  2. BDefine the objective and metric, examine the data and assumptions, select an appropriate method, and validate the result.
  3. CSelect the largest model before defining the task.
  4. DTrain on all available data and skip independent evaluation.
Show answer
Answer: B. Define the objective and metric, examine the data and assumptions, select an appropriate method, and validate the result.Database Systems → SQL → SQL Applications: Define the objective and metric, examine the data and assumptions, select an appropriate method, and validate the result.
Report a mistake

Q44. Which consideration is most important when preparing or using data for SQL Applications? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. AUse any available data even when it leaks the target.
  2. BAssume more rows always remove sampling bias.
  3. CIgnore privacy and labeling quality when model accuracy is high.
  4. DAssess data quality, representativeness, leakage, labeling, privacy, and the relationship between the data and target task.
Show answer
Answer: D. Assess data quality, representativeness, leakage, labeling, privacy, and the relationship between the data and target task.Database Systems → SQL → SQL Applications: Assess data quality, representativeness, leakage, labeling, privacy, and the relationship between the data and target task.
Report a mistake

Q45. Which principle best supports sound modeling involving SQL Applications? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. AIncrease complexity indefinitely without checking validation results.
  2. BChoose a method whose assumptions and capacity fit the task, then validate rather than relying on training performance alone.
  3. CChoose a model only because it is fashionable.
  4. DUse training accuracy as the only evidence of generalization.
Show answer
Answer: B. Choose a method whose assumptions and capacity fit the task, then validate rather than relying on training performance alone.Database Systems → SQL → SQL Applications: Choose a method whose assumptions and capacity fit the task, then validate rather than relying on training performance alone.
Report a mistake

Q46. How should an AI practitioner evaluate work involving SQL Applications? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. AEvaluate only on the same examples used for fitting.
  2. BChoose a metric unrelated to the actual task.
  3. CAssume a visually impressive demo is sufficient evidence.
  4. DUse suitable metrics and held-out or otherwise valid evidence that reflects the actual task and expected deployment conditions.
Show answer
Answer: D. Use suitable metrics and held-out or otherwise valid evidence that reflects the actual task and expected deployment conditions.Database Systems → SQL → SQL Applications: Use suitable metrics and held-out or otherwise valid evidence that reflects the actual task and expected deployment conditions.
Report a mistake

Q47. Which risk should be considered carefully when applying SQL Applications? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. ADeployment failures need not be considered before release.
  2. BConsider bias, unreliable generalization, data leakage, privacy, robustness, and harmful failure modes relevant to the application.
  3. CBias cannot occur when a model uses mathematics.
  4. DPrivacy is irrelevant if training is automated.
Show answer
Answer: B. Consider bias, unreliable generalization, data leakage, privacy, robustness, and harmful failure modes relevant to the application.Database Systems → SQL → SQL Applications: Consider bias, unreliable generalization, data leakage, privacy, robustness, and harmful failure modes relevant to the application.
Report a mistake

Q48. Which action is most appropriate when performance involving SQL Applications is inadequate? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. AChange many components simultaneously without diagnosis.
  2. BHide poor cases from the evaluation set.
  3. CIncrease model size before checking data or error patterns.
  4. DDiagnose the failure using data and evaluation evidence before changing features, model, optimization, or system design.
Show answer
Answer: D. Diagnose the failure using data and evaluation evidence before changing features, model, optimization, or system design.Database Systems → SQL → SQL Applications: Diagnose the failure using data and evaluation evidence before changing features, model, optimization, or system design.
Report a mistake

Q49. Which trade-off should be evaluated when selecting an approach to SQL Applications? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. AInterpretability and operational cost are always irrelevant.
  2. BBalance predictive quality with interpretability, compute, latency, data needs, robustness, maintainability, and risk.
  3. COnly accuracy matters in every AI application.
  4. DCompute and latency never affect model selection.
Show answer
Answer: B. Balance predictive quality with interpretability, compute, latency, data needs, robustness, maintainability, and risk.Database Systems → SQL → SQL Applications: Balance predictive quality with interpretability, compute, latency, data needs, robustness, maintainability, and risk.
Report a mistake

Q50. Which practice best represents responsible use of SQL Applications? Context: BS Artificial Intelligence / Database Systems / SQL.

  1. ADeploy without documenting limitations.
  2. BRetain sensitive data indefinitely because it may be useful.
  3. CRemove human review even where consequences are high.
  4. DDocument limitations, protect data, test foreseeable failure modes, maintain human oversight where needed, and monitor deployment.
Show answer
Answer: D. Document limitations, protect data, test foreseeable failure modes, maintain human oversight where needed, and monitor deployment.Database Systems → SQL → SQL Applications: Document limitations, protect data, test foreseeable failure modes, maintain human oversight where needed, and monitor deployment.
Report a mistake