i
Coforge
Filter interviews by
SQL DMVs are dynamic management views that provide information about the current state of a SQL Server instance for performance tuning.
DMVs can be used to identify performance bottlenecks, monitor resource usage, and troubleshoot issues.
Examples of commonly used DMVs include sys.dm_exec_query_stats, sys.dm_os_wait_stats, and sys.dm_io_virtual_file_stats.
Top trending discussions
SQL architecture refers to the structure and components of a SQL database system.
SQL architecture includes components like storage engine, query processor, and buffer manager.
The storage engine manages data storage and retrieval, while the query processor processes SQL queries.
The buffer manager handles caching and memory management to optimize performance.
Examples of SQL architectures include MySQL, Oracle, and SQL Se
posted on 12 Aug 2022
Index is used to speed up data retrieval while statistics are used by the query optimizer to create an efficient query plan.
Indexes are created on columns to speed up data retrieval
Statistics are used by the query optimizer to create an efficient query plan
Indexes are used to enforce uniqueness and primary key constraints
Statistics are used to estimate the number of rows returned by a query
Indexes can be clustered or n...
posted on 11 Sep 2021
I applied via Naukri.com and was interviewed in Aug 2021. There were 3 interview rounds.
posted on 28 Sep 2024
I applied via Campus Placement and was interviewed in Aug 2024. There were 8 interview rounds.
Database Management system SQL and PlSQL
Database Base Management system SQL and PlSQL
Database Management system
Database Management system
Database Management system
Database Management system
Database Base Management system
posted on 17 Oct 2024
I applied via Naukri.com and was interviewed in Jun 2024. There was 1 interview round.
Start up parameters are used to configure the behavior of SQL Server when it starts up.
Start up parameters are specified in the SQL Server Configuration Manager.
Common start up parameters include -d (database files location), -e (error log location), -m (single user mode), -T (trace flags), etc.
Start up parameters can be modified to customize the behavior of SQL Server during startup.
Example: -dC:\Program Files\Microso...
posted on 5 Jul 2020
I applied via Referral and was interviewed in Jan 2020. There were 5 interview rounds.
SQL architecture refers to the structure and components of a SQL database system.
SQL architecture includes components like storage engine, query processor, and buffer manager.
The storage engine manages data storage and retrieval, while the query processor processes SQL queries.
The buffer manager handles caching and memory management to optimize performance.
Examples of SQL architectures include MySQL, Oracle, and SQL Se
based on 3 interviews
Interview experience
based on 3 reviews
Rating in categories
Senior Software Engineer
4.8k
salaries
| ₹6.2 L/yr - ₹26 L/yr |
Technical Analyst
2.6k
salaries
| ₹10.6 L/yr - ₹38.4 L/yr |
Software Engineer
2k
salaries
| ₹2.2 L/yr - ₹9.5 L/yr |
Senior Test Engineer
1.8k
salaries
| ₹4.7 L/yr - ₹19.5 L/yr |
Technology Specialist
1.1k
salaries
| ₹12 L/yr - ₹42 L/yr |
Capgemini
Cognizant
Accenture
Infosys