Infocepts Technologies
20+ Bombay Intelligence Security Interview Questions and Answers
Q1. Which command is used to check the memory status?
The command used to check memory status is 'free'.
The 'free' command displays the total amount of free and used physical and swap memory in the system.
It also shows the buffers and cache used by the kernel.
The output of the 'free' command can be customized using various options like '-h' for human-readable format and '-s' for a continuous display.
Another command that can be used to check memory status is 'top', which displays the memory usage of individual processes in real-t...read more
Q2. What is lvm and why is it required?
LVM stands for Logical Volume Manager. It is required for flexible management of storage devices in Linux systems.
LVM allows for the creation of logical volumes that span multiple physical disks.
It enables resizing of logical volumes without the need to unmount the file system.
LVM also provides features such as snapshots and mirroring for data backup and redundancy.
It is commonly used in enterprise environments where storage requirements are dynamic and constantly changing.
Q3. Maximum size (in bytes) of the filename in Linux can be?
The maximum size of a filename in Linux is 255 bytes.
The maximum length includes the entire path and filename.
The limit is imposed by the file system, not the operating system.
Some file systems, such as ext4, support longer filenames with special configuration.
Long filenames can cause issues with some applications and scripts.
Q4. What is the function of grep command?
grep command is used to search for a specific pattern in a file or output.
Used to search for a specific pattern in a file or output
Can be used with regular expressions
Can be used to search for multiple patterns at once
Can be used with other commands like find and ls
Example: grep 'error' file.txt
Q5. how you have optimised the performance of the dashboard
I optimized the performance of the dashboard by streamlining data sources, improving data visualization, and implementing automated updates.
Identified and removed unnecessary data sources to reduce load times
Utilized data caching techniques to improve dashboard loading speed
Implemented data visualization best practices to enhance user experience
Set up automated data refresh schedules to ensure real-time updates
Optimized queries and data processing to improve overall performan...read more
Q6. What is the pink command?
The pink command is not a valid Linux command.
There is no pink command in Linux.
It is possible that the interviewer is testing the candidate's honesty and ability to admit when they don't know something.
The candidate should respond honestly and explain that they are not familiar with the pink command.
Alternatively, the candidate could ask for clarification or context to better understand the question.
Q7. types of joins and explain it with one example for each
Types of joins in SQL with examples
Inner Join: Returns rows when there is a match in both tables. Example: SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id
Left Join: Returns all rows from the left table and the matched rows from the right table. Example: SELECT * FROM table1 LEFT JOIN table2 ON table1.id = table2.id
Right Join: Returns all rows from the right table and the matched rows from the left table. Example: SELECT * FROM table1 RIGHT JOIN table2 ON table...read more
Q8. What is netstat command
Netstat is a command-line tool used to display network connections, routing tables, and network interface statistics.
Displays active network connections and their status
Shows routing tables and network interface statistics
Can be used to troubleshoot network issues
Can be used to identify open ports and listening services
Syntax: netstat [options]
Q9. what is the custom chart you have worked on
I have worked on creating a custom sales performance chart for tracking monthly revenue
Utilized Excel to create a custom chart with data from multiple sources
Implemented color coding to highlight trends and outliers
Added interactive features for easy data analysis
Presented the chart to senior management for decision-making purposes
Q10. What is difference between where and having?
WHERE is used to filter rows in a SQL query while HAVING is used to filter groups in a SQL query.
WHERE is used with SELECT, UPDATE, DELETE statements while HAVING is used with GROUP BY clause.
WHERE filters rows before grouping while HAVING filters groups after grouping.
WHERE is used to filter individual rows based on a condition while HAVING is used to filter groups based on a condition.
Example: SELECT * FROM table WHERE column = 'value';
Example: SELECT column, COUNT(*) FROM ...read more
Q11. Power bi app service, number of projects completed so far
We have completed 15 Power BI app service projects so far.
We have successfully completed 15 projects using Power BI app service.
Our team has a track record of delivering high-quality projects on time.
Some examples of our completed projects include sales dashboards, financial reports, and operational analytics.
Q12. DIFFERENCE B/W Groups and sets in tableau
In Tableau, groups are used to combine related dimension members, while sets are used to create custom fields based on a condition.
Groups in Tableau are used to combine related dimension members into higher-level categories. For example, grouping different product categories into a single 'Other' category.
Sets in Tableau are used to create custom fields based on a condition. For example, creating a set of 'High Sales' based on products with sales above a certain threshold.
Gro...read more
Q13. types of filters and execution order in tableau
Tableau filters include context filters, extract filters, data source filters, and user filters. Execution order is top-down.
Context filters are applied first and limit the data set for subsequent filters.
Extract filters are applied next, filtering data before it is extracted into Tableau.
Data source filters are applied after extract filters, limiting the data at the data source level.
User filters are applied last, allowing users to further refine the data based on their pref...read more
Q14. What are the diifrent ML algoritham & Explain in details
Various ML algorithms include linear regression, decision trees, random forests, support vector machines, and neural networks.
Linear Regression: Used for predicting continuous values based on input features.
Decision Trees: Tree-like model of decisions used for classification and regression.
Random Forests: Ensemble learning method using multiple decision trees for improved accuracy.
Support Vector Machines: Classify data by finding the hyperplane that best separates different c...read more
Q15. difference between tree map and heat map
Tree map displays hierarchical data using nested rectangles, while heat map visualizes data using colors.
Tree map organizes data in a hierarchical structure with nested rectangles
Heat map uses colors to represent data values on a matrix
Tree map is useful for showing proportions within a whole, while heat map is good for visualizing patterns or correlations in data
Q16. union and union all major difference
UNION combines the results of two or more SELECT statements, while UNION ALL does the same but includes duplicates.
UNION removes duplicates from the result set, while UNION ALL includes duplicates
UNION is slower than UNION ALL because it has to perform an additional step to remove duplicates
UNION requires the same number of columns in the SELECT statements, while UNION ALL does not have this requirement
Q17. What is the use of union
Unions are organizations that represent workers in negotiations with employers to improve working conditions, wages, and benefits.
Unions help workers negotiate better pay, benefits, and working conditions
They provide a collective voice for workers to address grievances and concerns
Unions also advocate for workplace safety and training programs
They can help workers navigate disputes with management and provide legal representation
Examples of unions include the AFL-CIO, SEIU, a...read more
Q18. Feature of power bi, some SQL queries
Power BI is a business analytics tool that provides interactive visualizations and business intelligence capabilities.
Power BI allows users to create interactive reports and dashboards to visualize data from various sources.
Users can connect to databases using SQL queries to retrieve and manipulate data for analysis.
Power BI supports a wide range of data sources including SQL Server, Excel, and cloud services like Azure SQL Database.
Users can write custom SQL queries within P...read more
Q19. rank vs rank dense in SQL
Rank function assigns a unique rank to each row in the result set, while dense_rank function assigns a unique rank to each distinct row in the result set.
Rank function leaves gaps in the ranking if there are ties, while dense_rank function does not leave gaps.
Rank function is used to assign a unique rank to each row based on the specified order, while dense_rank function is used to assign a unique rank to each distinct row.
Example: SELECT name, salary, RANK() OVER (ORDER BY s...read more
Q20. what are the diffrent datatype in python
Python has various data types including int, float, str, list, tuple, dict, set, bool, and more.
int - integer numbers (e.g. 5)
float - floating point numbers (e.g. 3.14)
str - strings (e.g. 'hello')
list - ordered collection of items (e.g. [1, 2, 3])
tuple - ordered collection of items that cannot be changed (e.g. (1, 2, 3))
dict - collection of key-value pairs (e.g. {'name': 'John', 'age': 30})
set - unordered collection of unique items (e.g. {1, 2, 3})
bool - boolean values True o...read more
Q21. Difference between table and view
Tables store data in a structured format while views are virtual tables created from a query.
Tables are physical objects that store data in a structured format with columns and rows.
Views are virtual tables created from a query that retrieves data from one or more tables.
Tables can be modified directly while views are read-only.
Views can be used to simplify complex queries and provide a layer of abstraction for security purposes.
Examples: Employee table vs Employee view that ...read more
Q22. OLAP VS OLTP difference
OLAP is used for analyzing historical data while OLTP is used for managing real-time transactional data.
OLAP stands for Online Analytical Processing and is used for complex queries and data analysis.
OLTP stands for Online Transactional Processing and is used for managing real-time transactional data.
OLAP databases are optimized for read-heavy workloads while OLTP databases are optimized for write-heavy workloads.
OLAP databases typically have a denormalized schema for faster q...read more
Q23. What is broadcasting?
Broadcasting is a feature in Apache Spark that allows for efficient data distribution across cluster nodes.
Broadcasting is used to efficiently distribute read-only data to all nodes in a Spark cluster.
It helps reduce data shuffling and improve performance by avoiding unnecessary data transfers.
Common use cases include broadcasting small lookup tables or configuration data.
Example: Broadcasting a small reference dataset to all nodes for join operations.
Q24. What is ETL? Different process
ETL stands for Extract, Transform, Load. It is a process used to extract data from various sources, transform it into a consistent format, and load it into a target database.
Extract: Data is extracted from multiple sources such as databases, files, APIs, etc.
Transform: Data is cleaned, filtered, aggregated, and converted into a consistent format.
Load: Transformed data is loaded into a target database or data warehouse for analysis.
Examples: Extracting customer data from a CRM...read more
Q25. Data structures Definitions What is tuple
A tuple is an ordered collection of elements of different data types.
Tuples are immutable, meaning their values cannot be changed once created.
They are often used to return multiple values from a function.
Example: ('John', 25, 'Male')
Example: (3.14, 'pi')
Q26. whats your quvalifycation?
I have a Bachelor's degree in Computer Science and 5 years of experience in software development.
Bachelor's degree in Computer Science
5 years of experience in software development
More about working at Infocepts Technologies
Top HR Questions asked in Bombay Intelligence Security
Interview Process at Bombay Intelligence Security
Top Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month