Win Surprise Gifts!!!
Top 5 Contributors of the Month
Post New Question
Subscribe to Interview Questions
What is DDL (Data Definition Language)?
Posted By :
Posted Date :
October 24, 2008
A data base schema is specifies by a set of definitions expressed by a special language called DDL.
You can also find related Interview Question to
What is DDL (Data Definition Language)?
What is Data Storage - Definition Language?
The storage structures and access methods used by database system are specified by a set of definition in a special type of DDL called data storage-definition language.
What is VDL (View Definition Language)?
It specifies user views and their mappings to the conceptual schema.
What is SDL (Storage Definition Language)?
This language is to specify the internal schema. This language may specify the mapping between two schemas.
What is DML (Data Manipulation Language)?
This language that enable user to access or manipulate data as organised by appropriate data model.
1.Procedural DML or Low level: DML requires a user to specify what data are needed and how to get those data.
2.Non-Procedural DML or High level: DML requires a user to specify what data are needed without specifying how to get those data.
When do you need to specify an external data source by using a linked server?
When you need to access a different instance.
What is Method used to bind the data into gridview ?
DataBind() Method used to bind the data into gridview
What is the .NET that allows the retrieval of data by a unique key?
HashTable is the .NET collection class that allows the retrieval of data by a unique key
What is the Common Language Runtime (CLR)?
The Common Language Runtime is the execution engine for .NET Framework applications.
It provides a number of services, including the following:
1. Code management (loading and execution)
2. Application memory isolation
3. Verification of type safety
4. Conversion of IL to native code
5. Access to metadata (enhanced type information)
6. Managing memory for managed objects
7. Enforcement of code access security
8. Exception handling, including cross-language exceptions
9. Interoperation between managed code, COM objects, and pre-existing DLLs (unmanaged code and data)
10. Automation of object layout
11. Support for developer services (profiling, debugging, and so on)
What is the Common Language Specification (CLS)?
The Common Language Specification is a set of constructs and constraints that serves as a guide for library writers and compiler writers. It allows libraries to be fully usable from any language supporting the CLS, and for those languages to integrate with each other. The Common Language Specification is a subset of the common type system. The Common Language Specification is also important to application developers who are writing code that will be used by other developers. When developers design publicly accessible APIs following the rules of the CLS, those APIs are easily used from all other programming languages that target the Common Language Runtime.
What is the Microsoft Intermediate Language (MSIL)?
MSIL is the CPU-independent instruction set into which .NET Framework programs are compiled. It contains instructions for loading, storing, initializing, and calling methods on objects.
Combined with metadata and the common type system, MSIL allows for true cross-language integration.
Prior to execution, MSIL is converted to machine code. It is not interpreted.
What is managed code and managed data?
Managed code is code that is written to target the services of the Common Language Runtime (see What is the Common Language Runtime?). In order to target these services, the code must provide a minimum level of information (metadata) to the runtime. All C#, Visual Basic.NET, and _JScript.NET code is managed by default. Visual Studio.NET C++ code is not managed by default, but the compiler can produce managed code by specifying a command-line switch (/CLR).
Closely related to managed code is managed data-data that is allocated and de-allocated by the Common Language Runtime's garbage collector. C#, Visual Basic, and _JScript.NET data is managed by default. C# data can, however, be marked as unmanaged through the use of special keywords. Visual Studio.NET C++ data is unmanaged by default (even when using the /CLR switch), but when using Managed Extensions for C++, a class can be marked as managed by using the __gc keyword. As the name suggests, this means that the memory for instances of the class is managed by the garbage collector. In addition, the class becomes a full participating member of the .NET Framework community, with the benefits and restrictions that brings. An example of a benefit is proper interoperability with classes written in other languages (for example, a managed C++ class can inherit from a Visual Basic class). An example of a restriction is that a managed class can only inherit from one base class.
What is data structure?
A data structure is a way of organizing data that considers not only the items stored, but also their relationship to each other. Advance knowledge about the relationship between data items allows designing of efficient algorithms for the manipulation of data.
List out the areas in which data structures are applied extensively?
3.Database Management System,
4.Statistical analysis package,
What are the major data structures used in RDBMS, Network data model & Hierarchical data model.
RDBMS - Array (i.e. Array of structures)
Network data model - Graph
Hierarchical data model - Trees
Quick Links For Interview Questions Categories:
Find questions, FAQ's and their answers related to .NET, C#, Vb.Net, Sql Server and many more.
Now you can find lots of .NET, C#, Vb.Net, SQL Server,Windows, ASP.Net related Questions and their Answers here at www.dotnetspark.com. Our aim is to help you pass your certification Exams (MCP, MCSD, MCAD etc.,) with flying scores and get good name in your company.
So, Start looking our
section daily and improve your .NET Skills. You can also help others by posting Interview Questions and their Answers in this section.
Hall of Fame
Terms of Service
Tell A Friend