10+ SYSTRONICS Interview Questions and Answers

Answering questions related to SQL concepts and syntax.

• Projects in SQL refer to selecting specific columns from a table.

• View in SQL is a virtual table created by a query.

• Union combines the results of two or more SELECT statements, while Union All includes duplicates.

• Referential integrity is maintained through foreign key constraints.

• Types of triggers in SQL include DML triggers and DDL triggers.

• Where clause is used to filter rows based on a specified condition, while Having c...read more

Transformer is a deep learning model that uses self-attention mechanism. Multi Head Attention is a variant of attention mechanism. Positional Encoding is used to inject information about the position of tokens in the sequence.

• Transformer is a deep learning model introduced in the paper 'Attention is All You Need' by Vaswani et al.

• Multi Head Attention allows the model to focus on different parts of the input sequence simultaneously.

• Positional Encoding is added to the input emb...read more

TCP/IP model is a networking protocol suite that defines how data is transmitted over a network. DNS is a system that translates domain names to IP addresses. DHCP is a protocol that assigns IP addresses to devices on a network. Networking protocols are rules that define how data is transmitted and received over a network. Active Directory is a directory service used in Windows environments to manage users, computers, and resources. Organizational Unit is a container within A...read more

RAG stands for Retrieve, Aggregate, and Group. Data can be retrieved from Vector DB using SQL queries.

• RAG is a process used to retrieve, aggregate, and group data from a database.

• SQL queries are commonly used to retrieve data from Vector DB.

• Example: SELECT * FROM table_name WHERE condition;

Dynamic Xpath for Date element in cleartrip website

• Use contains() function to match partial attribute value

• Use @class attribute to uniquely identify the Date element

• Combine multiple attributes to create a dynamic Xpath

Python code to separate numbers and special characters from a string into an array of strings.

• Use regular expressions to match numbers and special characters in the string.

• Split the string based on the matched patterns to separate numbers and special characters.

• Store the separated numbers and special characters in an array of strings.

HTTP is a protocol used for transferring data over the internet, while cloud refers to the delivery of computing services over the internet.

• HTTP stands for Hypertext Transfer Protocol and is used for transmitting data on the web

• Cloud computing refers to the delivery of computing services like storage, databases, networking, software, and more over the internet

• Examples of cloud services include Amazon Web Services (AWS), Microsoft Azure, and Google Cloud Platform

Port numbers are communication endpoints in a network, allowing multiple applications to use the same network connection.

• Port numbers range from 0 to 65535

• Well-known ports (0-1023) are reserved for specific services (e.g. HTTP uses port 80)

• Registered ports (1024-49151) are assigned by IANA for specific purposes

• Dynamic or private ports (49152-65535) are used for temporary connections

The OSI model is a conceptual framework that standardizes the functions of a telecommunication or computing system into seven layers.

• The OSI model stands for Open Systems Interconnection model.

• It helps in understanding how different networking protocols work together.

• The seven layers are: Physical, Data Link, Network, Transport, Session, Presentation, and Application.

• Each layer has specific functions and communicates with the adjacent layers.

• For example, HTTP operates at the ...read more

Azure services are a collection of cloud computing services provided by Microsoft.

• Azure Virtual Machines - allows users to create and manage virtual machines in the cloud

• Azure App Services - platform as a service (PaaS) offering for building, deploying, and scaling web apps

• Azure Blob Storage - scalable object storage for unstructured data

• Azure SQL Database - fully managed relational database service

• Azure Cognitive Services - AI services for vision, speech, language, and decis...read more

OOPs (Object-Oriented Programming) is a programming paradigm based on the concept of objects, which can contain data in the form of fields and code in the form of procedures.

• OOPs concepts include encapsulation, inheritance, polymorphism, and abstraction.

• Encapsulation involves bundling data and methods that operate on the data into a single unit.

• Inheritance allows a class to inherit properties and behavior from another class.

• Polymorphism allows objects to be treated as instanc...read more

Question covers CLR, CTS, C# generics, Web API, and SQL.

• CLR (Common Language Runtime) is the execution engine of .NET Framework.

• CTS (Common Type System) defines how types are declared, used, and managed in .NET.

• C# generics allow type-safe programming and reduce code duplication.

• Web API is a framework for building HTTP services using .NET.

• SQL is a standard language for managing relational databases.