Creating SQL Server Database Project

1. Open Visual Studio
2. Create a new project and select SQL Server and select "SQL Server Database Project".

3. Right Click Solution and select Schema Compare.

4. Select the Source and Destination Database.

5. Click compare. and see the changes between the source and destination database.
6. Click update to update the destination database. you will see the generated .sql files in the project dbo folder.
7. If you want to load data with that .sql files then right-click the Solution Explorer and click publish.
8. You can also import Database and .sql script to project.
9. Right-click solution and click publish export .sql script to database.

Create Asp.net MVC Demo Application using Entity Framework

1. Open Visual Studio
2. Create a New Project
3. Select Asp.net Web Application and select MVC template

4. Create Database
5. Install Entity Framework using "Manage Nuget Packages".
6. Right Click the project and add "ADO.Net Entity Data Model"

7. Add a new Controller to the Controller Folder named EmployeeController.

8. Change RouteConfig.cs accordingly and run the project.

C interview questions

1. Is C Object-Oriented Language?
Ans. No, C is a Procedural Language.

2. What are the storage classes in C?
Ans. auto, register, static, extern

3. Who is the father of the C language?
Ans Dennis Ritchie

4. What are the data types supported by the C language?
Ans. char, int, float, double

5. What is the variable?
Ans. Variable is used to store data for later use.

6. What is constant in C?
Ans. Constant is like variable except for its value never changed during the execution of the program.

7. What are the keywords in C?
Ans. Keywords have a specific meaning in C and it can not be used as a variable name.

8. What are the C operators?
Ans C operators are used to perform mathematical operations.

9. List Operators in C.
Ans. +, -, *, /, %

10. What is the NULL pointer in C?
Ans. The pointer that doesn't refer to any address of value but NULL is known as a NULL pointer.

11. How many types of loops are used therein C?
Ans. While loop
         For loop
         Do-While loop
         Nested loop

12. What is Void?
Ans. Void is the datatype that has no value.

Java Interview questions

1. What is Java?
Ans. Java is an object-oriented programming language. It is a platform independent language.

2. Which is the most important feature of java?
Ans. Java is a platform independent language.

3. Who is the father of the Java programming language?
Ans. James Gosling.

4. What are the supported platforms by java programming language?
Ans. Java runs on Windows, Mac OS, Linux/Unix.

5. What are the data types supported by java?
Ans. byte, short, int, long, char, float, double.

6. What is JVM?
Ans, JVM is a Java Virtual Machine which is a run time environment for the compiled java classes.

7. Is java pure object oriented language?
Ans. No.

8. What is constructor?
Ans. The constructor is just like method and invoked at the time of object creation.

9. Can we make a constructor final?
Ans. No

10. Is constructor inherited?
Ans. No

SharePoint Interview Questions

1. What is Microsoft SharePoint?
Ans. Microsoft SharePoint is a browser-based collaboration and document management platform. It allows groups to set up a centralized, password-protected space for document sharing.

2. What are web parts?
Ans. WebParts are packages that can be dropped on the sharepoint web part page.

3. Who is the father of Microsoft SharePoint?
Ans. Jeff Teper

4. What is CAML?
Ans. CAML stands for Collaborative Application Markup Language. It is XML based markup language that is used in Microsoft Sharepoint.

5. What are the zones in SharePoint?
Ans. Zones provide separate authentication for the same web application.

6. How many zones we can create for each web application?
Ans. we can create 5 zones for each web application.
         1. Default
         2. Intranet
         3. Extranet
         4. Internet
         5. Custom

7. What is DWP?
Ans. It is a web part file extension.

8. What is the central administration?
Ans. This is a site used by admins to manage and configure settings.

9. What is SharePoint Theme?
Ans. It contains files which defines look and feel of content pages in SharePoint.

10. What is custom action?
Ans. It represents link, toolbar button,menu item o any control that can be added to the toolbar or                menu that appears in the UI.

11. What are the type of input forms that can be created for the WorkFlow in SharePoint?
Ans. We can create different type of input forms like
         An association form
         An initiation form
         A modification form
         A task edit form

12. How to create an instance of the list?
Ans. We can create instance of the list by creating an instance XML file.

IOS Interview Questions

1. What is iOS?
Ans. It is an operating system used in mobile devices manufactured by Apple Inc.

2. Who is the father of iOS?
Ans. Scott Forstall

3. Which programming language is used to develop iOS applications?
Ans. Objective C and C.

4. Which JSON framework is used in iOS?
Ans SBJson framework is used by iOS.

5. What are the tools required to develop iOS applications?
Ans. Intel-based Macintosh computer and iOS SDK.

6. Who invented Objective-C?
Ans. Broad cox and Tom love

7. How to store data locally in the iPhone?
Ans. Plist
         NSUserDefaults
         SQLite
         CoreData

8. What are the app states in iOS?
Ans. 1. Not running State
         2. Inactive State
         3. Active State
         4. Background State
         5. Suspended State

9. How many bytes we can send to apple push-notification server?
Ans. 256 bytes

10. Does iOS support multi-tasking?
Ans. iOS 4 and above supports multitasking.

35 - Android Interview Questions

1.  What is Android?
Ans. Android is an open-source, Linux based operating system that is used in mobile devices.

2. Who is the father of Android?
Ans. Rubin

3. What is an Activity?
Ans. Activity is a User interface single screen.

4. Explain life-cycle methods of android activity.
Ans. onCreate()
         onStart()
         onResume()
         onPause()
         onStop()
         onRestart()
         onDestroy()

5. Name the database used in Android.
Ans. SQLite

6. What are the advantages of Android?
Ans. 1. Open Source
         2. Platform independent
         3. It supports various technologies
         4. Highly optimized virtual machine

7. Explain Android Architecture.
Ans. Android Architecture contains 4 key components.
         1. Linux Kernel
         2. Libraries
         3. Android Framework
         4. Android Applications

8. Write important items of the Android Project.
Ans. AndroidManifest.xml
        build.xml
        bin/
        src/
        res/
        assests/

9. Write tools required for developing Android Apps.
Ans. JDK
        Eclipse + ADT Plugin
        SDK Tools

10. Which language is used to develop android apps?
Ans Java and XML

11. Write a full form of ADT.
Ans. Android Development Tools.

12. What is the difference between mobile app testing and mobile testing?
Ans. Mobile app testing means testing the application features on a mobile device and mobile testing means testing the mobile features like SMS, Call, etc.

13. Which are the core components of the Android OS?
Ans. Here are listed the core components of Android OS
        Activity
        Intents
        Services
        Content provider
        Fragments
       
14. What is an ANR notification in android?
Ans ANR means application not responding, Android display this dialog when the application has been unresponsive for a long time.

15. What is the 'Application' class?
Ans. Application class is the main class which is initialized before anything else in android. It is the primary class which contains the most important elements for the actions and the services.

16. What is the use of an Adapter in Android?
Ans. Adapters are used to connect the AdapterView with an external source of data.

17. What is the use of OnCreate() and OnStart() method?
Ans. The OnCreate() method is called only once during the lifecycle when the application starts and when the activity is recreated.
OnStart() method is called after the OnCreate() method whenever the activity becomes visible to the user.

18. Where to declare your activity so that the system can access it?
Ans. The activity can be declared in the manifest file.
        For Example:
        <manifest></manifest>
        <application></application>
        <activity android:name=".EmployeeActivity">

19. What is the intent?
Ans. Android has an intent class that displays a notification from the device to the user when the user is navigated from one activity to another.

20. How many types of intent class are there?
Ans. There are 2 types of intent classes.
         1. Implicit Intents
         2. Explicit Intents
         Implicit Intents calls the components while explicit intent invokes the activity class.

21. Where we can define the icon for the Activity?
Ans. In manifest file

22. What is a Toast Notification?
Ans. Toast Notification is a message that pops up on the top of the window. 

23. What are the different storage methods in Android?
Ans. There are two types of storage methods in Android.
         1. Shared Preferences: Store private primitive data in key-value pairs.
         2. Internal Storage: Store private data in device memory.

24. What is broadcast reciever?
Ans. It is a component of android which is used to listen important events.

25. How to start a reciever?
Ans. using sendBroadcast() method.

26. How to kill receiver?
Ans. using abortBraodcast() method.

27. How to pass data to fragment?
Ans. using setArguments() method.

28. What is fragment?
Ans. Fragment is the re-usable UI componet.

29. What are containers?
Ans. Containers hold objects and widgets together like labels, buttons, and fields, etc..

30. How do you start fragment?
Ans. Using FragmentManager, FragmentTransaction, and add() method.

31. How to destroy fragment?
Ans. using fragmenttransaction.Backstack method.

32. What are Services?
Ans. Services run in the background and acts independently.

33. What is AndroidManifest.xml file?
And. The AndroidManifest.xml file is the structured XML file. Every application must have an AndroidManifest.xml file in its root directory. It holds important information about the application.
34. What is .apk extension?
Ans. Application Package Kit is used for the installation of Android apps. It contains resource files, manifest files, certificate, and other code.

35. Which dialog boxes are used in the Android platform?
Ans. 1. AlertDialog
         2. ProgressDialog
         3. TimePickerDialog
         4. DatePickerDialog