Posts

Ten Things a Junior DBA Should Learn

Image
There is more to being a Junior DBA than knowing SQL. The DBA works at the intersection of the database, server, operations group, and developers. A DBA must understand concepts from all these facets of IT as well as be able to draw upon knowledge of their production environment to troubleshoot performance, hardware, and software issues. Below is a list of the ten topics I feel every entry level DBA should understand. The list I created stems from my experiences working with databases as both a DBA, Developer, and Manager.  When looking to hire entry level DBA’s, the interview questions I ask are drawn from these areas. If you’re looking to start a job as DBA, then you’ll want to be familiar with these topics,If you are intrested to learn about SQL DBA please visit: ios app development course Backup and Restore Any DBA worth their salt should know the DBMS’ (Database Management System’s) built-in methods to backup and restore data, such as using Oracle Recovery Manager, bu

Android Interview Questions And Answers

Image
A set of questions that I have accumulated over the years in preparation for my many Android Interviews Prep. 1) What is Android? Android is an open-source, Linux-based operating system used in mobiles, tablets, televisions, for more Android Online Training 2) What is the Android Application Architecture? Android application architecture has the following components: Services − It will perform background functionalities Intent − It will perform the interconnection between activities and the data passing mechanism Resource Externalization − strings and graphics Notification − light, sound, icon, notification, dialog box and toast Content Providers − It will share the data between applications 3) What are the advantages of Android? Open-source:  It means no license, distribution and development fee. Platform-independent:  It supports Windows, Mac, and Linux platforms. Supports various technologies:  It supports camera, Bluetooth, wifi, speech, EDGE etc. tech

SQL Server Interview Questions & Answers

Image
What is MySQL MySQL is a fast, easy to use relational database. It is currently the most popular open-source database. It is very commonly used in conjunction with PHP scripts to create powerful and dynamic server-side applications. MySQL is used for many small and big businesses. It is developed, marketed and supported by MySQL AB, a Swedish company. It is written in C and C++,If you are intrested to learn about SQL Server please visit  SQl Server DBA online training Hyderabad 1. What are the two authentication modes in SQL Server? There are two authentication modes – Windows Mode Mixed Mode   Modes can be changed by selecting the tools menu of SQL Server configuration properties and choose security page. 2. What Is SQL Profiler? SQL Profiler is a tool which allows system administrator to monitor events in the SQL server. This is mainly used to capture and save data about each event of a file or a table for analysis. 3. What is recursive stored procedure? SQL

Basics of Database Administration in SQL Server

Image
Databases in SQL Server There are basically the following two types of databases in SQL Server: System Databases. User Databases. System Databases in SQL Server System databases are databases that are created when sql server dba is installed. These databases are used for various operational and management activities for SQL Server. Types of System Databases There are basically four system databases in SQL Server, master msdb tempdb a model that we can see. Apart from that, there is one more system database System Database SystemDatabase Master Database in SQL Server All the system-level information for a SQL Server record by the master database. The dbid (database id ) of a master is 1. The master database has a SIMPLE RECOVERY MODEL. It is a very important database and we must have the backup. Without the master database, the server can't be started.