The Young DBA

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 ? 9.        What is Tail log and how to take backup ? 10.    What is LSN ? 11.    What is Virtual Log File ? 12.    What is Log Marker ? 13.    What is No_Truncate ? 14.    Explain the Clouse like – with – recover, no_recovery, stand by, init, verify only, init . 15.    How to stop log files growing ? 16.    Can we take differenti

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, server_admin,security_admin 12.    What are fixed db Roles – Backup_operator,Data_reader,Data_Writer,Deny_datareader,deny_datawriter, 13.    What is difference between GRANT, Deny and Revoke ? 14.    What are orphaned users ? 15.    How to handle or manage orphaned users ? 16.   

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 server ? 12.   What is file stream ? 13.   What is checksum ? 14.   What is snapshot ? 15.   How to check databse integrity and correct it ? 16.   How to manage database growth and size in sql server ? 17.   How to remove duplicate records ? 18.   How to compress database ? 19.

1.        What is DBMS & RDBMS ? 2.        What is E-R/Entity Relationship Diagram ? 3.        What is ACID ? Explain in Brief ? 4.        What are the CODES rules explain ? 5.        What is Relationship and what are the kind of Relationship ? 6.        What is Normalization . What are the Kinds of Normalization ? 7.        What is Metadata ? 8.        What are Differences between DDL, DML and DCL ? 9.        What is join and what are the kinds of Joins in SQL Server ? 10.    What are the basic modeling of Database ? Conceptual, Logical and Physical 11.    What is Views ? how to create ? 12.    What is Integrity and Constraints ? 13.    What is Entity , Referential and Domain Integrity ? 14.    What is Differences between Primary Key and Unique Key ? 15.     What is Foreign Key ? 16.    What is Trigger ? what are the kinds of Trigger ? 17.    What is DDL and DML Trigger ? 18.    What are types of DML Trigger ? After, Instead Of . 19.    Wha

SSAS (SQL Server Analysis Services) 1.        What is Data warehouse ? 2.        What is Business Intelligence ? 3.        What are the tools in SQL Server which serves for Data warehouse and Business Intelligence ? 4.        What are the Kinds of Data warehouse ? 5.        How do you plan your data warehouse complete project ? 6.        What are the benefits of DW and BI ? 7.        Can you briefly explain the DW project on your working ? 8.        What is OLTP and OLAP ? 9.        What is Analysis Services ? 10.    What is ODS ? 11.    What is Data Mart ? 12.    What is Dimension ? 13.    What are differences between Dimensional Model and Relational Model of System ? 14.    What are the Model of Data ware house ? 15.    What are differences between snowflake and star model? 16.    What is CUBE ? 17.    What is FACT and Dimensions ? 18.    What is Dimensions and Measures ? 19.    How to Build and Deploy Cubes in SSAS ? 20.    What is MDX and D

Contained Database Partially Contained Database User Defined Server Level Role Support for 15,000 Partitions Columnstore Index Online Index Create, Rebuild, and Drop Option for VARCHAR(MAX), NVARCHAR(MAX) and VARBINARY(MAX) columns IntelliSence Feature Enhancements BI Semantic Model Sequence Object Distributed Replay Power View SQL Azure Support Big data support Reference :- http://www.mytechmantra.com/LearnSQLServer/New-Features-SQL-Server-2012-DBA.html http://mcpmag.com/articles/2012/03/14/top-12-features-of-sql-server-2012.aspx

It was very tricky question asked to me during one of DBA session and that time my answer was no Idea, but we can do this very easily with select command. TSQL select * from into ZFI_TAB_4_DAYBUK2 SAP .. MYAC . ZFI_TAB_4_DAYBUK where 1 = 2 ZFI_TAB_4_DAYBUK2 is new table ZFI_TAB_4_DAYBUK  is a source table We can also use SET FMTONLY to view metdata of table or query returns. SET FMTONLY ON ; GO SELECT      BUKRS , BELNR , BUZEI , GJAHR , BLART , LTEXT , CONVERT ( datetime ,LEFT( BUDAT , 4 )+ SUBSTRING ( BUDAT , 5 , 2 )+RIGHT( BUDAT , 2 )) as BUDAT , CONVERT ( datetime ,LEFT( BLDAT , 4 )+ SUBSTRING ( BLDAT , 5 , 2 )+RIGHT( BLDAT , 2 )) as BLDAT , BSCHL , GSBER , GTEXT , UMSKZ , DEB_CRE , DMBTR , WAERS , ACC_TYPE , SGTXT , SAKNR , TXT50 , KUNNR , CUST , LIFNR , VEND , XBLNR , TXT60 , BUSINESS_AREA , CONVERT ( datetime ,LEFT( CPUDT , 4 )+ SUBSTRING ( CPUDT , 5 , 2 )+RIGHT( CPUDT , 2 )) as CPUDT , VEND_CU