COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Yes
|
|
|
No
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -An SQL Server DBA is a database administrator who is an expert in Microsoft’s Structured Query Language (SQL) Server. They utilize software designed to track and store large amounts of personal and financial data and organize and analyze that data using the SQL Server platform.
Detailed explanation-2: -Answers. That’s a hard question as they mean different things to different companies. Basically a DBA is responsible for administering SQL Servers. This involves backups, restored, database structures-like sizing, capacity planing, but also index maintenance, performance tuning, DR and HA.
Detailed explanation-3: -These are mostly used for very large datasets, such as those on large websites where relational databases would not be ideal. Some examples of these databases are Cassandra, Hadoop and MongoDB. But by and large, SQL is still a must-have skill for any serious DBA.
Detailed explanation-4: -What is DBA in SQL? Ans:-DBA stands for Database Administrator, it is referred to as an IT professional who is involved in managing Microsoft SQL Server, Oracle databases, MySQL, and IBM DB2. DBA is also responsible for the security, performance, and availability of data to users and customers.