1 |
How to restore backup database into SQL server 2000? |
|
RESTORE FILELISTONLY
FROM DISK = 'c:\BackDatabaseName'
RESTORE DATABASE TestDB
FROM DISK = 'c:\BackDatabaseName'
WITH MOVE 'BackDatabaseNameh_data' TO 'c:\BackDatabaseName_data.mdf',
MOVE 'BackDatabaseName_log' TO 'c:\BackDatabaseName_log.ldf'
GO |
2 |
What Is an Object? |
|
An object is merely a collection of related information and functionality.
Or
An object is composed of the data that describes the object and the operations that can be performed on the object
|
3 |
What is Assemblies? |
| |
In the .NET Runtime, the mechanism of packaging is the assembly. When code is compiled by one of the .NET compilers, it is converted to an intermediate form known as “IL”. The assembly contains all the IL, metadata, and other files required for a package to run, in one complete package. Each assembly
contains a manifest that enumerates the files that are contained in the assembly, controls what types and resources are exposed outside the assembly, and maps references from those types and resources to the files that contain the types and resources. The manifest also lists the other assemblies that an
assembly depends upon.
Assemblies are self-contained; there is enough information in the assembly for it to be self-describing. When defining an assembly, the assembly can be contained in a single file or it can be split amongst several files. Using several files will enable a scenario where sections of the assembly are downloaded only as needed. |
4. |
What is Namespaces and Using in .NET? |
| |
Namespaces in the .NET Runtime are used to organize classes and other types into a single hierarchical structure. The proper use of namespaces will make classes easy to use and prevent collisions with classes written by other authors.
Using is merely a shortcut that reduces the amount of typing that is required when referring to elements. |
5. |
What is Enums in C#? |
| |
Enumerators are used to declare a set of related constants—such as the colors that a control can take—in a clear and type-safe manner. For example:
enum Colors
{
red,
green,
blue
} |
6 |
What is Delegates? |
| |
Delegates are a type-safe, object-oriented implementation of function pointers and are used in many situations where a component needs to call back to the component that is using it. They are used most heavily as the basis for events, which allow a delegate to easily be registered for an event. |
7 |
What is Overloading? |
| |
Sometimes it may be useful to have two functions that do the same thing but take different parameters. |
8 |
What is Virtual Functions? |
| |
To make this work cleanly, object-oriented languages allow a function to be specified as virtual. Virtual means that when a call to a member function is made, the compiler should look at the real type of the object (not just the type of the reference), and call the appropriate function based on that type. |
9 |
Can constructors has parameter? |
| |
No, constructors is parameterless |
10 |
What is Static Assembly and Dynamic Assembly.? |
| |
Static assemblies can include .NET Framework types
(interfaces and classes) as well as resources for the assembly (bitmaps, JPEG files, resource files,
and so forth). Static assemblies are stored on disk. Dynamic assemblies run directly from memory
and are not saved to disk before execution. |
11 |
Functionality of Assembly in .NET. |
| |
It contains code that the common language runtime executes.
It is the unit at which security permissions are requested and granted.
It forms a type boundary. Every type's identity includes the name of the assembly in which it resides.
It identifies the types and resources exposed outside the assembly as well as the otherassemblies on which it depends.
It is the smallest unit that has version control. All types and resources in the same assembly are versioned as a unit.
It is the deployment unit.
It is the unit at which side−by−side execution is supported. |
12 |
Which Namespaces That Are Automatically Imported in ASP.NET |
| |
| Namespace |
Description |
| System |
Contains fundamental classes and base classes that define
commonly-used value and reference data types, events and
event handlers, interfaces, attributes, and processing
exceptions. |
| System.Collections |
Contains interfaces and classes that define various collections
of objects, such as lists, queues, arrays, hash tables,
and dictionaries. |
| System.IO |
Provides access to the File and Directory objects, which
enable you to add, move, change, create, or delete folders
(directories) and files on the Web server. |
| System.Web |
Includes the HTTPRequest class that provides extensive
information about the current HTTP request, the
HTTPResponse class that manages HTTP output to the
client, and the HTTPServerUtility object that provides
access to server-side utilities and processes. System.Web
also includes classes for cookie manipulation, file transfer,
exception information, and output cache control. |
| System.Web.UI |
Contains the ASP.NET control classes. |
| System.Web.UI.HtmlControls |
Contains the HTML server controls. |
| System.Web.UI.WebControls |
Contains the Web controls. |
|
13 |
Which namespaces are used for data access? |
| |
| Namespace |
Description |
| System.Data |
Provides access to general data access services. |
| System.Data.OleDb |
Provides access to OLEDB -specific data access services. |
| System.Data.SQLClient |
Provides access to SQL Server data access services. |
|
| |
|
