Data manipulation, MCQs

1. What does the SQL command INSERT INTO do?
A. Deletes data from a table
B. Updates existing data in a table
C. Adds new data into a table
D. Retrieves data from a table
Answer: C

2. Which SQL statement is used to delete data from a table?
A. DELETE
B. REMOVE
C. ERASE
D. TRUNCATE
Answer: A

3. What is the purpose of the SQL UPDATE statement?
A. To add new rows to a table
B. To modify existing rows in a table
C. To create a new table
D. To delete specific rows from a table
Answer: B

4. Which SQL clause is used to specify conditions while retrieving or manipulating data?
A. WHERE
B. HAVING
C. GROUP BY
D. ORDER BY
Answer: A

5. What does the SQL function COUNT() do?
A. Calculates the average value of a column
B. Counts the number of rows that meet a specified condition
C. Retrieves the sum of values in a column
D. Retrieves the total number of rows in a table
Answer: D

6. Which SQL command is used to concatenate two or more strings?
A. CONCATENATE
B. MERGE
C. JOIN
D. CONCAT
Answer: D

7. What does the SQL function SUM() do?
A. Retrieves the total number of rows in a table
B. Calculates the average value of a column
C. Retrieves the sum of values in a column
D. Counts the number of rows that meet a specified condition
Answer: C

8. Which SQL command is used to remove duplicate rows from a result set?
A. REMOVE DUPLICATE
B. UNIQUE
C. DISTINCT
D. DELETE DUPLICATE
Answer: C

9. What does the SQL ORDER BY clause do?
A. Groups rows that have the same values into summary rows
B. Filters rows based on a specified condition
C. Orders rows in ascending or descending order
D. Joins rows from two or more tables based on a related column
Answer: C

10. Which SQL command is used to update data based on a condition?
A. MODIFY
B. CHANGE
C. UPDATE
D. SET
Answer: C

More MCQS on Management Sciences

1. Green supply chain management MCQs 
2. Sustainable Operations and Supply Chains MCQs in Supply Chain
3. Decision support systems MCQs in Supply Chain
4. Predictive analytics in supply chains MCQs in Supply Chain
5. Data analysis and visualization MCQs in Supply Chain
6. Supply Chain Analytics MCQs in Supply Chain
7. Demand management MCQs in Supply Chain
8. Sales and operations planning (S&OP) MCQs in Supply Chain
9. Forecasting techniques MCQs in Supply Chain
10. Demand Forecasting and Planning MCQs in Supply Chain
11. Contract management MCQs in Supply Chain
12. Strategic sourcing MCQs in Supply Chain
13. Supplier selection and evaluation MCQs in Supply Chain
14. Procurement and Sourcing MCQs in Supply Chain
15. Just-in-time (JIT) inventory MCQs in Supply Chain
16. Economic order quantity (EOQ )MCQs in Supply Chain
17. Inventory control systems MCQs in Supply Chain
18. Inventory Management MCQs in Supply Chain
19. Total quality management (TQM) MCQs in Supply Chain
20. Quality Management MCQs in Supply Chain
21. Material requirements planning (MRP) MCQs in Supply Chain
22. Capacity planning MCQs in Supply Chain
23. Production scheduling MCQs in Supply Chain
24. Production Planning and Control MCQs
25. Distribution networks MCQs in Supply Chain
26. Warehousing and inventory management MCQs in Supply Chain
27. Transportation management MCQs in Supply Chain
28. Logistics Management MCQs in Supply Chain
29. Global supply chain management MCQs in Supply Chain
30. Supply chain strategy and design MCQs in Supply Chain
31. Basics of supply chain management MCQ in Supply Chains
32. Supply Chain Management MCQs
33. Introduction to Operations Management MCQs in Supply Chain
34. Fundamentals of operations management MCQs 
35. Operations & Supply Chain Management MCQs
36. Business Intelligence MCQs
37. distributed computing frameworks MCQs
38. Handling large datasets MCQs
39. Big Data Analytics MCQs
40. neural networks, ensemble methods MCQs
41. Introduction to algorithms like clustering MCQs
42. Machine Learning MCQs
43. time series forecasting MCQs
44. decision trees MCQs
45. Modeling techniques such as linear and logistic regression MCQs
46. Predictive Analytics MCQs
47. Power BI MCQs
48. using tools like Tableau MCQs
49. Techniques for presenting data visually MCQs
50. Data Visualization MCQs
51. Data manipulation, MCQs
52. SQL queries, MCQs
53. Database fundamentals, MCQs
54. Data Management and SQL, MCQs
55. regression analysis, Mcqs
56. inferential statistics, Mcqs
57. descriptive statistics, Mcqs
58. Probability theory, Mcqs
59. Statistics for Business Analytics
60. regression analysis, Mcqs
61. inferential statistics
62. descriptive statistics, Mcqs
63. Probability theory, Mcqs
64. Statistics for Business Analytics
65. Management Sciences MCQs