20+ Hyundai Mobis Interview Questions and Answers

A database management system (DBMS) is a software that manages and organizes databases. Primary key uniquely identifies a record, while foreign key establishes a relationship between tables.

• A DBMS is a software that allows users to create, manage, and manipulate databases.

• It provides tools for creating, modifying, and deleting databases, tables, and records.

• Primary key is a unique identifier for a record in a table.

• Foreign key establishes a relationship between two tables by ...read more

Composite key is made up of multiple columns while non-composite key is made up of a single column. Primary key can also be defined using unique, not null, or candidate key.

• Composite key uses multiple columns to uniquely identify a row while non-composite key uses a single column

• Primary key can be defined using unique, not null, or candidate key instead of explicitly defining it

• Candidate key is a unique key that can be used as a primary key

I prefer SQL as it is the language of databases and allows for efficient data management.

• SQL is specifically designed for managing and querying databases

• It allows for efficient data retrieval and manipulation

• Other programming languages can be used in conjunction with SQL for more complex tasks

• Examples of other languages commonly used with SQL include Python and Java

Maps, Hash maps, and Skeleton class are OOPS concepts used in programming.

• Maps are data structures that store key-value pairs.

• Hash maps are a type of map that use a hash function to index the keys.

• Skeleton class is a class that provides a basic implementation of an interface.

• OOPS concepts are Object-Oriented Programming concepts that focus on objects and their interactions.

• Example: HashMap in Java is a commonly used implementation of a hash map.

Questions on SQL Database Administration including recursive stored procedures, optimization, recovery and backup, loading JSON files, scheduling, and cursor examples.

• For recursive stored procedures, use common table expressions (CTEs) to simplify the code

• Optimization techniques include indexing, query tuning, and partitioning

• Regular backups and testing of recovery procedures are essential for data protection

• To load JSON files in SQL, use OPENROWSET or BULK INSERT

• Scheduling c...read more

Clustered index determines the physical order of data in a table, while non-clustered index is a separate structure.

• Clustered index sorts and stores the data rows in the table based on their key values.

• Non-clustered index creates a separate structure that contains the key values and a pointer to the data row.

• A table can have only one clustered index, but multiple non-clustered indexes.

• Clustered index is faster for retrieving large amounts of data, while non-clustered index is...read more

Minimum memory configuration is used to allocate the minimum amount of memory required for SQL Server to run.

• Minimum memory configuration is used to ensure that SQL Server has enough memory to function properly.

• It is important to set the minimum memory configuration to a value that is appropriate for the workload of the server.

• If the minimum memory configuration is set too low, SQL Server may experience performance issues.

• For example, if a server has 16GB of RAM and the minim...read more

Clustered index determines physical order of data while non-clustered index is a separate structure.

• Clustered index sorts and stores data in the table based on the key values

• Non-clustered index creates a separate structure to store the index data

• Clustered index can only be created on one column while non-clustered index can be created on multiple columns

• Example: Clustered index on a customer table can be created on the customer ID column while a non-clustered index can be cre...read more

System databases are the default databases created during SQL Server installation.

• System databases include master, model, msdb, and tempdb.

• Master database stores system-level information.

• Model database is used as a template for new databases.

• Msdb database is used for SQL Server Agent and maintenance plans.

• Tempdb database is used for temporary storage of data.

• System databases cannot be deleted or detached.

• Additional system databases may be created by third-party software.

• Syste...read more

Synchronization in Java is a process of controlling access to shared resources by multiple threads.

• Synchronization is achieved using synchronized keyword or locks.

• It prevents race conditions and ensures thread safety.

• Example: synchronized methods, synchronized blocks, ReentrantLock.

• Synchronization can cause performance issues if not used properly.

Joins in SQL are used to combine data from two or more tables based on a related column.

• Joins are used to retrieve data from multiple tables in a single query.

• There are different types of joins such as inner join, left join, right join, and full outer join.

• The join condition is specified using the ON keyword and the related columns.

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;

• Joins can be used to combine data from more than two tables as we...read more

SQL editions are different versions of SQL Server with varying features and capabilities.

• SQL Server Express - free, limited to 10GB database size

• SQL Server Standard - basic features for small to medium businesses

• SQL Server Enterprise - advanced features for large businesses

• SQL Server Developer - full-featured version for development and testing

• SQL Server Web - designed for web applications

• SQL Server Business Intelligence - specialized for data analysis and reporting

Default fill factor is the percentage of space reserved for future data growth in an index.

• It is set to 0 by default, which means the index will be filled to 100% capacity.

• A fill factor of 80% means that 20% of the index space will be left empty for future growth.

• It can be set at the server, database, or index level.

• It can affect performance and disk space usage.

The best method for data migration from SQL to Azure depends on the specific requirements and constraints of the project.

• Consider the size and complexity of the database to determine the most suitable migration approach.

• Options include using Azure Database Migration Service, Azure Data Factory, or manual migration scripts.

• Evaluate factors such as downtime tolerance, data consistency, and cost when choosing the migration method.

• Test the migration process thoroughly before exec...read more

When a database restarts, various processes occur such as recovery, rollback, and reapplying transactions.

• Recovery process ensures that the database is in a consistent state by rolling back uncommitted transactions and redoing committed transactions.

• Rollback process undoes any changes made by transactions that were not committed before the restart.

• Reapplying transactions involves re-executing transactions that were committed but not yet reflected in the database.

• System checks...read more

C/C++ are low-level languages, while JAVA is high-level. C/C++ are compiled, while JAVA is interpreted.

• C/C++ are used for system programming and embedded systems.

• JAVA is used for web development and enterprise applications.

• C/C++ have manual memory management, while JAVA has automatic garbage collection.

• C/C++ have pointers, while JAVA does not.

• C/C++ code is platform-dependent, while JAVA code is platform-independent.

• Examples: C/C++ - operating systems, device drivers, JAVA - w...read more

Views are virtual tables that display data from one or more tables, while stored procedures are precompiled SQL statements that can accept parameters and perform actions.

• Views are read-only and cannot accept parameters, while stored procedures can be used to perform complex logic and can accept input parameters.

• Views are used for simplifying complex queries and providing a layer of abstraction, while stored procedures are used for encapsulating business logic and improving pe...read more

DBCC stands for Database Console Commands. It is a set of commands used to perform maintenance tasks on a SQL Server database.

• DBCC CHECKDB - used to check the logical and physical integrity of all objects in a database

• DBCC SHRINKDATABASE - used to shrink the size of a database

• DBCC SQLPERF - used to display performance statistics for SQL Server

• DBCC TRACEON - used to enable a specific trace flag for troubleshooting purposes

Recovery of corrupt System Database involves restoring from backups, running repair utilities, and potentially rebuilding the database.

• Check for recent backups and restore the database from a known good backup

• Run repair utilities like DBCC CHECKDB to identify and fix corruption

• If necessary, rebuild the database by exporting data, dropping the corrupt database, and recreating it