C3I Solutions Trainee Interview Questions and Answers

Fairly easy, includes puzzles and time questions and 1 pattern coding question

Q1. Update column data type in mysql
Ans. 
To update column data type in MySQL, use the ALTER TABLE statement.
• Use ALTER TABLE table_name MODIFY column_name new_data_type;

• Ensure the new data type is compatible with existing data in the column.

• Examples: ALTER TABLE employees MODIFY age INT;

• You can also use CHANGE keyword instead of MODIFY to change column name and data type.
Answered by AI
Add your answer
Q2. Python real world examples
Ans. 
Python is used in real world applications like web development, data analysis, automation, and machine learning.
• Web development: Django and Flask are popular frameworks for building websites.

• Data analysis: Pandas and NumPy are commonly used libraries for analyzing and manipulating data.

• Automation: Python scripts can automate repetitive tasks like file management or data processing.

• Machine learning: Libraries like Tenso...read more
Answered by AI
Add your answer
Q3. What are different sql data types
Ans. 
SQL data types are used to define the type of data that can be stored in a table column.
• Common SQL data types include INTEGER, VARCHAR, DATE, BOOLEAN, and DECIMAL.

• INTEGER is used for whole numbers, VARCHAR for variable-length character strings, DATE for dates, BOOLEAN for true/false values, and DECIMAL for decimal numbers.

• Each data type has specific properties and constraints that determine the kind of data that can be
Answered by AI
Add your answer