The Young DBA

1.)  Sql-databse-Development & TSQL 2.)  Database-management-and-Maintenance 3.)  Databse-Security 4.)  Backup-Restore & DR 5.) Monitoring-and-automation 6.) Performance-tuning-and-optimization 7.) High-availability and Data- Distribution 8.) Data-ware-house-Business-intelligence

1.        What does meant of HA and Load balancing ? 2.        What are the features available in SQL Server for HA and LB ? a.        HA- Log Shipping, Mirroring, Clustering, Database snapshot, Backup-Restore. b.       Load Balancing-  Replication and Clustering 3.        What is RAID ? explain in brief . 4.        Explain with example where should we use Which Features of HA and Load Balancing ? Log Shipping 5.        What is Log shipping ? 6.        Explain the Architecture and Functionality of Log shipping ? 7.        What are Primary, Target and Monitor Server ? 8.        What are the Jobs running in Log shipping ? Backup, Copy, Restore and Alert. 9.   ...

1.        What are the different ways and methods of performance tuning and optimization ? a.        Indexing b.       Achieving c.        Load Balancing d.       Query Refactoring e.       System/Resource Level Optimization (CPU,Memory,IO Configuration) 2.        What is Index ? 3.        What is Heap ? 4.        What is B-Tree/Balance Tree ? 5.        What are the kinds of Indexes ? – Clustered and Non-Clustered 6.        What are differences between Clustered and Non-Clustered Indexes ? 7.        What is execution plan / query execution plan ? 8.        What is Estimated and Actual Executio...

1.        What are the major facts of monitoring of SQL Server ? a.        Infra Level / Virtual Level / Server Level b.       Instance Level c.        Database Level d.       Application Level 2.        What do you use to monitor of SQL Server based IT Infrastructure at various level ? 3.        What is Perfmon and what are the major counters do you use to monitor production server ? 4.        What is Activity monitor ? 5.        What is Profiler and what are the common Counters of Profiler used in Day to Day activity monitoring ? 6.        What is DMV ? 7.        What are the most common and useful DMV do you use to monitor SQL Server in daily life ...

1.        What is the strategy and planning of DR of your Organization ? 2.        What is the strategy and planning of Backup & Restore of your Organization ? a.        Recovery Model b.       Backup Types c.        Frequency d.       Storage 3.        What is Recovery Model? 4.        What are Recovery model in SQL Server ? – Simple, Full, Bulk-Logged 5.        What are Backup Types in SQL Server Explain ? Full, Differential, Transaction Log, File, FIleGroup, Copy Only. 6.        What is Copy Only Backup and how to take it ? 7.        What is the term Point in Recovery ? 8.        What is the term Point on Failure...

1.        What are the security architecture of sql server ? Principal, securable and permission . 2.        What are authentication modes of sql server ? Windows mode, and mixed modes ? 3.        What is principal and what are principals ? 4.        What is securable and what are securable ? 5.        What is permissions and what are permissions ? 6.        What is roles in sql server ? Fixed server and fixed database role ? 7.        What are fixed database roles in sql server ? 8.        What are principals at various levels ? 9.        What are securable at various levels ? 10.    What are major permissions ? 11.    What are fixed servers – bulk_admin, sys_admin, disk_admin, s...

1.       What is the Architecture of SQL Server 2.       What is the architecture of database? 3.       Explain the physical and logical architecture of database ? 4.       How to plan your database and their physical location? 5.       What are data files in sql server ? 6.       What is mdf, ldf and ndf ? 7.       What is files and filegroups in sql server ? 8.       What is primary and secondary filegroup in sql server ? 9.       What are system databases in sql server ? Master, msdb, tempdb, model, resources, distribution 10.   What are database states in sql server ? Online, offline, emergency, suspended, restoring. 11.   How to attache and de-attache a databse in sql serve...