iphone Interview Questions part-3
21-What is Automatic Reference Counting (ARC)? ARC is a compiler-level feature that simplifies the process of managing the lifetimes of Objective-C objects. Instead of you having to remember when to retain or release an object, ARC evaluates the lifetime…
iphone Interview Questions part-2
11-Can you explain what happens when you call autorelease on an object? When you send an object a autorelease message, its retain count is decremented by 1 at some stage in the future. The object is added to an autorelease pool on the current thread. The…
iphone Interview Questions part-1
1-How would you create your own custom view? By Subclassing the UIView class. 2-Whats fast enumeration? Fast enumeration is a language feature that allows you to enumerate over the contents of a collection. (Your code will also run faster because the…
iPhone Interview Questions 2
1)what happens if you remove the object from the array, and you try to use it?our application crashes 2)Difference between HTML & XML? XML was designed to transfer and store the data XML was to carry data not to display the data XML is designed to be…
iphone interview questions
1. Explain what ARC is and how it works Since it doesn’t make much sense to talk about the old retain-release cycle, instead I like to find out if the candidate actually knows what ARC really is, or if they just consider a bit of Apple magic. ARC stands…
DELETE From SELECT Statement – Using JOIN in DELETE Statement – Multiple Tables in DELETE Statement
DELETE From SELECT Statement It is totally possible to use JOIN and multiple tables in the DELETE statement. Let us use the same table structure which we had used previously. Let us see the following example. We have two tables Table 1 and Table 2. --…
Reasons for Statement Recompilation
What is recompilation in SQL Server? Recompilation is the same process as a compilation, just executed again. If the database structure or data changes significantly, a recompilation is required to create a new query execution plan that will be optimal…
SQL SERVER – Azure SQL Databases Backup Made Easy with SQLBackupAndFTP
Azure SQL database backup used to be a difficult task. Not any more. With SQLBackupAndFTP with Azure it became trivial. Here’s what you basically need to do: Once SQLBackupAndFTP with Azure is installed, click at “Connect to SQL Server /…
RESEED Identity Column in Database Table – Rest Table Identity Value – SQL in Sixty Seconds
Identity Column in Database Syntax DBCC CHECKIDENT ( table_name [, { NORESEED | { RESEED [, new_reseed_value ] } } ] ) [ WITH NO_INFOMSGS ] table_name Is the name of the table for which to check the current identity value. The table specified must…
Interesting Observation of CONCAT_NULL_YIELDS_NULL and CONCAT in SQL Server 2012 onwards
CONCAT_NULL_YIELDS_NULL will be always ON in the future so avoid setting it off. What this function essentially does is that when it is on it will return a null value when any other value is connected it with using + operator.…