Barclays PLC Interview Questions and Answers

Asked about simple sorting question and one based on two pointers.

Q1. In this asked about basic concepts of OOPS like runtime and compile time polymorphism, basic operating system concepts, some java related questions and DBMS.
Add your answer
Q2. What is difference between DDL and DML commands in DBMS?
Ans. 
DDL commands are used to define the structure of the database, while DML commands are used to manipulate the data within the database.
• DDL (Data Definition Language) commands are used to create, modify, and delete database objects such as tables, indexes, and views.

• Examples of DDL commands include CREATE, ALTER, and DROP.

• DML (Data Manipulation Language) commands are used to retrieve, insert, update, and delete data in t...read more
Answered by AI
Add your answer
Q3. Difference between delete, drop and truncate.
Ans. 
Delete removes specific rows from a table, drop removes the entire table, and truncate removes all rows from a table.
• Delete is a DML command used to remove specific rows from a table based on a condition.

• Drop is a DDL command used to remove an entire table along with its structure and data.

• Truncate is a DDL command used to remove all rows from a table but keeps the table structure intact.

• Example: DELETE FROM table_name...read more
Answered by AI
Add your answer

Q1. Introduce yourself and your work
Ans. 
I am a dedicated Fraud Analyst with 5 years of experience in detecting and preventing fraudulent activities.
• Experienced in analyzing financial data to identify suspicious patterns

• Proficient in using fraud detection software and tools

• Skilled in conducting investigations and collaborating with law enforcement agencies

• Implemented fraud prevention strategies that resulted in a 20% decrease in fraudulent transactions
Answered by AI
Add your answer

Q1. Difference between US and UK customers, what is fraud and scam
Ans. 
US and UK customers have different fraud perceptions. Fraud is intentional deception for financial gain, while scam is a fraudulent scheme.
• US customers may be more cautious due to higher exposure to fraud, while UK customers may be more trusting.

• Fraud involves intentional deception for financial gain, such as identity theft or credit card fraud.

• Scams are fraudulent schemes designed to trick individuals into giving away...read more
Answered by AI
Add your answer

Q1. PLC gate logics
Add your answer
Q2. What is involved in the process of SCADA development?
Ans. 
SCADA development involves designing, implementing, and maintaining systems for monitoring and controlling industrial processes.
• Requirements Gathering: Identify user needs and system specifications, e.g., data acquisition from sensors.

• System Architecture Design: Define the overall structure, including hardware and software components, e.g., PLCs and HMI.

• Software Development: Create applications for data visualization a...read more
Answered by AI
Add your answer
Q3. What are the communication protocols used in PLC and SCADA systems?
Ans. 
PLC and SCADA systems utilize various communication protocols for data exchange and control in industrial automation.
• Modbus: A widely used protocol for communication between PLCs and SCADA systems, often over serial lines.

• OPC (OLE for Process Control): Allows different systems to communicate and share data seamlessly, regardless of the manufacturer.

• Ethernet/IP: An industrial Ethernet protocol that enables real-time com...read more
Answered by AI
Add your answer
Q4. HMI development
Add your answer

3 questions on economics and your background

A couple assignments and video recordings