AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Reckon Sales SQL Database Administrator Interview Questions and Answers
Reckon Sales SQL Database Administrator Interview Experiences
1 interview found
I applied via Walk-in and was interviewed in Nov 2020. There was 1 interview round.
Interview Questionnaire
3 Questions
- Q1. What is SQL?
- Ans.
SQL is a programming language used to manage and manipulate relational databases.
SQL stands for Structured Query Language
It is used to create, modify, and query databases
Commonly used in web development and data analysis
Examples of popular SQL databases include MySQL, Oracle, and Microsoft SQL Server
- Q2. What is CSS and HTML?
- Ans.
CSS and HTML are languages used for creating and styling web pages.
HTML (Hypertext Markup Language) is used for creating the structure of a web page.
CSS (Cascading Style Sheets) is used for styling the elements on a web page.
HTML uses tags to define elements like headings, paragraphs, and images.
CSS allows for customization of colors, fonts, layouts, and more.
Both HTML and CSS are essential for web development.
- Q3. Define SQL and its version and how to install sql server
- Ans.
SQL is a relational database management system used to manage and store data.
SQL stands for Structured Query Language
Versions include SQL Server 2019, 2017, 2016, etc.
To install SQL Server, download the installation file from Microsoft's website
Run the installation file and follow the prompts to complete the installation process
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Selected
I applied via Referral and was interviewed in Sep 2024. There was 1 interview round.
(2 Questions)
- Q1. What is dirty read.
- Ans.
Dirty read is when a transaction reads data that has been modified by another transaction but not yet committed.
Occurs when a transaction reads uncommitted data from another transaction
Can lead to inconsistent or incorrect results
Can be prevented by using proper isolation levels in database transactions
- Q2. What all processes occurres when a db restarts.
- Ans.
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 com...
I applied via Company Website and was interviewed in Apr 2024. There were 3 interview rounds.
Test your algorithmic thinking and problem solving skills
(1 Question)
- Q1. Communications,clearity of answers
(1 Question)
- Q1. Discussion about packages,joining date
Interview Preparation Tips
I applied via Campus Placement
It was simple round.
It fully based on the array concept
Interview Preparation Tips
Raj G
Selected
I applied via Approached by Company and was interviewed in Oct 2023. There was 1 interview round.
(2 Questions)
- Q1. Salary discussion
- Q2. About previous company and quit reason
(1 Question)
- Q1. What major issues have you faced in your professional experience?
(1 Question)
- Q1. What are your salary expectations for this position?
Selected
I applied via Campus Placement and was interviewed before Feb 2023. There were 2 interview rounds.
It was a normal assessment including coding questions and then English Test.
(1 Question)
- Q1. Basic questions about DB, OS and Networking
SQL Database Administrator Interview Questions & Answers
Tech Mahindra
Anonymous
posted on 26 May 2022
I applied via Referral and was interviewed in Apr 2022. There was 1 interview round.
(1 Question)
- Q1. Logshipping, mirroring, failover clustering and always on
Interview Preparation Tips
Selected
I applied via Job Fair and was interviewed before Aug 2022. There were 3 interview rounds.
Aptitude test was conducted.
(1 Question)
- Q1. Technical questions were asked
(1 Question)
- Q1. What's the salary expectation
(2 Questions)
- Q1. Difference between view and stored procedure
- Ans.
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 ...
- Q2. What is DBCC ? Explain
- Ans.
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 purpo
Skills evaluated in this interview
Reckon Sales Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
- Oracle Database Administrator Interview Questions
- Database Developer Interview Questions
- SQL Server Database Administrator Interview Questions
- Senior Database Administrator Interview Questions
- MS SQL DBA Interview Questions
- Database Engineer Interview Questions
- Database Architect Interview Questions
- Mysql Database Administrator Interview Questions
- Show more
SQL Database Administrator Interview Questions from Similar Companies
|
Technical Support Engineer
5
salaries
|  ₹2.4 L/yr - ₹3 L/yr |
|
Associate ERP Consultant
3
salaries
| ₹3.6 L/yr - ₹3.6 L/yr |
TCS
Accenture
Wipro
Cognizant
- Home >
- Interviews >
- Reckon Sales Interview Questions >
- Reckon Sales SQL Database Administrator Interview Questions
