Pragati Marine Services Interview Questions and Answers

Q1. Differnce between truncate and drop.
Ans. 
Truncate removes all records from a table, while drop deletes the table itself.
• Truncate is a DDL command, while drop is a DDL command.

• Truncate is faster than drop as it does not log individual row deletions.

• Truncate can be rolled back, while drop cannot be rolled back.

• Truncate resets the identity seed of the table, while drop does not.

• Example: TRUNCATE TABLE TableName; DROP TABLE TableName;
Answered by AI
Add your answer

Q1. Package discussion
Add your answer

Q1. What is endianness and wrote c program for endianness
Ans. 
Endianness refers to the order in which bytes are stored in memory. There are two types: big-endian and little-endian.
• Big-endian systems store the most significant byte first, while little-endian systems store the least significant byte first.

• Endianness can affect how data is interpreted and manipulated in a computer system.

• Example: In a big-endian system, the number 0x12345678 would be stored as 12 34 56 78 in memory.

• ...read more
Answered by AI
Add your answer
Q2. Basic sring programs
Add your answer

Round 1 was both technical and aptitude round

Designing round task is given for around 10 days

Q1. Introduce yourself
Add your answer
Q2. Questions around technical
Add your answer

Consists of both technical and aptitude

Q1. Problem statement are given
Add your answer
Q2. We have to crack this round to enter in 3rd round
Add your answer

Q1. Both Technical and HR round happened
Add your answer

Basics of Mechanical Engineering

Q1. Tolerance Stack Up
Add your answer

Q1. DO 178 B/C Process
Ans. 
DO 178 B/C is a software development standard for airborne systems.
• DO 178 B/C is a set of guidelines for developing software for airborne systems.

• It ensures that software is reliable, safe, and meets regulatory requirements.

• The process includes requirements analysis, design, coding, testing, and verification.

• Compliance with DO 178 B/C is often required for certification of avionics software.
Answered by AI
Add your answer

Q1. Tell me about yourself
Add your answer

Q1. Question based on project architecture
Add your answer
Q2. Access specifiers
Add your answer

Q1. Differentiate between RISC and CISC
Ans. 
RISC stands for Reduced Instruction Set Computing and CISC stands for Complex Instruction Set Computing.
• RISC processors have a smaller set of simple instructions, while CISC processors have a larger set of complex instructions.

• RISC processors typically execute instructions in one clock cycle, while CISC processors may require multiple clock cycles.

• RISC processors rely on optimizing compilers for performance, while CISC...read more
Answered by AI
Add your answer
Q2. Define and differentiate interpreter and compiler
Ans. 
Interpreter translates code line by line while compiler translates entire code at once.
• Interpreter: translates code line by line, slower execution, easier debugging (e.g. Python)

• Compiler: translates entire code at once, faster execution, harder debugging (e.g. C++)
Answered by AI
Add your answer