0
Database Programming
Databases are collections of tables that maintain and display information, often collaboratively; this information can be used for interaction with an application or gaining general knowledge. Questions about database engines and modifying or using them belong in this category.
8,803 Questions
CNX stands for CRISIL NSE Indices. CNX ensures common branding of indices, to reflect the identities of both the promoters, i.e. NSE and CRISIL. Thus, 'C' stands for CRISIL, 'N' stands for NSE and X stands for Exchange or Index. The S&P prefix belongs to the US-based Standard & Poor's Financial Information Services.
S&P is Standard and Poor
Advantages and disadvantages of distributed operating system?
Advantages:
Performance: very often a collection of processors can provide higher performance and better price/performance ratio than a centralized computer.
Distribution: many applications involve, by their nature, spatially separated machines (banking, commercial, automotive system).
Reliability : if some of the machines crash, the system can survive.
Incremental growth: as requirements on processing power grow, new machines can be added incrementally.
Sharing of data/resources: shared data is essential to many applications (banking, computer supported cooperative work, reservation systems); other resources can be also shared (e.g. expensive printers).
Communication: facilitates human-to-human communication
Disadvantages:
Security problems: sharing generates the problem of data security.
of developing distributed software: how should operating systems, programming languages and applications look like?
Networking problems: several problems are created by the network infrastructure, which have to be dealt with: loss of messages, overloading.
What are different normal forms?
There are 4 normal forms in databases. First normal form, second, third and fourth normal forms are there.
What are the requirements of operating system for database management system?
A Database Management System ( DBMS ) is a set of computer programs that controls the creation, maintenance, and the use of a database. It allows organizations to place control of database develop.
The int data type requires more memory than the double data type?
No, the int variable uses less memory, and therefore it is preferable to use an int rather than a double where you can.
A boolean variable uses even less memory, but obviously is useful only in limited circumstances.
What is a complex data structure?
A complex data structure is the kind of structure that has two arrays. One array hols the real part of the complex data and the other array holds the imaginary part.
Join query in sql server 2005?
Join query are basically of three types : 1) Cross Join -- That is use to retrieve data from two tables on a condition (optional), there we get m*n no. of records(m is no of rec in first table and n is the no. of records in another table) 2) Inner Join : we use this join to retrieve values from two tables that satisfies given matching condition : as :: select Product_Category from Product_Detail INNER JOIN Product_Scenerio ON Product_Detail.Product_Id = Product_Detail.Product_Id. Product_Scenerio . 3) Outer Join : this is used in three way: a) Left Outer Join -- it is used to retrieve records from both tables that satisfies given condition including all records from left(First) table whether it do not satisfy condition ...try it practically ** related columns in right table has NULL values in records b) Right Outer Join :: It is used when we want to fetch all records from right(second) table whether that do not match with condition specified with JOIN . ** related columns in right table has NULL values in records c) Full Outer Join :: It is combination of Inner join + left Outer join + right Outer join .Here we get all records from both tables that do not match condition .
Types of accounting information systems?
There are so many different types of accounting information systems. Some of the common ones include project accounting, forensic accounting, tax accounting, management accounting and so much more.
DDL statements -Data Definition Language It is used to Retrive,Store,Modify,Delete,Insert,update data in database. 1) Create 2) Alter 3) Drop DML Statements.-Data Manipulation Languag It is used to create and modify the structure of database objects in database. 1) Insert 2) Update 3) Delete 4) select DCL statements-Data Control Language It is used to create roles, permissions, and referential integrity as well it is used to control access to database by securing it. 1) GRANT 2) REVOKE TCL-Transactional Control Language It is used to manage different transactions occurring within a database. 1) COMMIT 2) ROLLBACK 3) Save point DQL-Data Query Language basicallu used for select data from table... 1) SELECT
What is a homogeneous data structure and why is this a weakness for RDBMS?
in homogeneous data structure all the elements of same data types known as homogeneous data structure. example:- array
Not unless the programmer told it to. But, if ur talking about the internet, then yes, because most people type their opinion on the net. Hope this answers ur question!
an entity set may not have sufficient attribute 2 form a primary key is called weak entity set.ex entity set payment has 3 attribute pay-no,pay-date, pay-amount.pay-no is a sequential no generated 4 each loan.each payment entity is distinct,payments 4 different loans may share the same payment no.thus entity set doent have a primary key,so it is a weak entity set.
Placid04
bakhra,muzaffarpur,bihar.
What is the best data type for storing your birthday?
The choice of data type for storage the date of birth of a human depends on how the algorithm will use that data.
For algorithms which store this data merely for display purposes, storing the date of birth as a text might be suitable.
In many cases, however, operations such as comparison for equality or greater-than or less-than relationships are required, for example in order to support sorting and searching algorithms. This typically leads to the implementation of a numeric data format, often using a scalar such as a 16-bit or 32-bit unsigned integer. Such a format could, for example, encode the date of birth as the number of dates since January 1st, 1970.
This method limits the maximum age of people on record (1-1-1970) and has a limited lifetime, as it may only support 216 or 232 days in total. While these limitations may be perfectly acceptable in many applications, a more general approach might use a data structure containing distinct numeric fields for the day, month and year, possibly including other details such as the calendar system, or an uncertainty factor (useful when estimating the age of archaeological finds, for example).
Many databases and some programming languages provide built-in support for data types such as Date and Time, which might be suitable for a given application, subject to the application's requirements and limitations imposed by those data types.
What are the advantages of traditional file system?
Though traditional files have been already replaced with the more conventional and easy way of organizing files (DBMS) it still has some pros versus the latter system...
In the traditional filing,
...there is not much requirement when it comes to facility. Just a space for the different files and you're good to go.
... traditional filing is user friendly and only little training is required for this. The only thing needed is just pure sence of organization, initiative and value for ones files and documents.
...in the end, nothing beats a hard copy for every one to see or review. Since not everyone has the skills to operate an advance system nor have the ability to keep up with these modern changes.
You are comparing Weight with Volume, so this question cannot be answered unless you tell me what substance you are working with.
Impact of computers on transportation?
Most newer vehicles now have computers that help with navigation, rear view vision and are equipped with a sort of smart stop technology that tells the vehicle when to stop. The effect is that cars have now become a smart device that impairs the driver and makes them dependent.
Idea about mini projects on DBMS?
Hi, Iam Mousumi, Iam a Bsc(Csc honours) Student.I want to do a dbms project encorporating the ideas of data mining within three months could you help me in choosing the project
Reference architecture of distributed database management system?
A reference architecture consists of:
Set of global external schemas.
Global conceptual schema (GCS).
Fragmentation schema and allocation schema.
Set of schemas for each local DBMS conforming to 3-level ANSI/SPARC .
Some levels may be missing, depending on levels of transparency supported.
Can be homogeneous or heterogeneous.
Gaurav SinghG.N.I.T MCA,GREATER NOIDAContact: 9458660007
What are the types of data in a hash table?
Well hash tables can store any type of data be it the fundamental data types like int, float, char or derived data types like structure , strings etc
Implementation in C++ at the Related link below.
It is possible, but you have to know what kind of database do you want to access, as well as the opearting system and C-compiler your are using.
In what ways does Accenture use technology to help its clients improve their business?
Accenture uses Microsoft office to get the very best out of it's clients.
Accenture has developed it's very own spread sheet software that enables businesses to input upto 1.5 million unique data points.
Accenture has developed computer monitors built into Ray Ban sunglasses, so it's clients can keep upto date while on the move or on holiday.
Accenture has develpped the most comprehensive web browsing blocker currently on the market. It stops employees accessing explicit material and other time wasting sites.
