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
What is the difference of management information system and operation information system?
management information systems are systems that record transactions in an organisation and provide management with information to make decisions that affect the whole organisation whereas operation information system is the systems that help with daily running of an organisation.
What are the five main parts of information processing?
Information processing involves five phases: input, process, output, storage, and retrieval. Each of these phases and the devices associated with each are discussed below.
What is the different version of oracle?
Early versions of the oracle did not bear the latest features added to the latest version of the oracle. There are series of new features implemented in the newer version of the oracle.
new features are:
New "pivot" SQL clause - The new "pivot" SQL clause will allow quick rollup, similar to an MS-Excel pivot table, where you can display multiple rows on one column with SQL. MS SQL Server 2005 also introduced a pivot clause. Laurent Schneider notes that the new SQL "pivot" syntax is great for converting rows-to-columns and columns-to-rows.
The /*+result_cache*/ SQL hint - This suggests that the result data will be cached in the data buffers, and not the intermediate data blocks that were accessed to obtain the query results. You can cache SQL and PL/SQL results for super-fast subsequent retrieval. The "result cache" ties into the "scalable execution" concept. There are three areas of the result cache:
The SQL query result cache - This is an area of SGA memory for storing query results.
The PL/SQL function result cache - This result cache can store the results from a PL/SQL function call.
The OCI client result cache - This cache retains results from OCI calls, both for SQL queries or PL/SQL functions.
Scalable Execution - This 11g feature consists of a number of features, the first of which is query results caching; this feature automatically caches the results of an SQL query as opposed to the data blocks normally cached by the buffer cache, and works both client (OCI) and server side - this was described as "buffer cache taken to the next level". The DBA sets the size of the results cache and turns the feature on at a table level with the command "alter table DEPT cache results", the per-process cache is shared across multiple session and at the client level, is available with all 11g OCI-based clients. Mark Rittman
XML SQL queries - Oracle11g will support query mechanisms for XML including XQuery and SQL XML, emerging standards for querying XML data stored inside tables.
- SQL Replay - Similar to the previous feature, but this only captures and applies the SQL workload, not total workload. Source: Dr. Tim Hall
- Improved optimizer statistics collection speed - Oracle 11g has improved the dbms_stats performance, allowing for an order of magnitude faster CBO statistics creation. Oracle 11g has also separated-out the "gather" and "publish" operations, allowing CBO statistics to be retained for later use. Also, Oracle 11g introduces multi-column statistics to give the CBO the ability to more accurately select rows when the WHERE clause contains multi-column conditions or joins.
- SQL execution Plan Management - Oracle 11g SQL will allow you to fix execution plans (explain plan) for specific statements, regardless of statistics or database version changes. See Inside the 11g SQL Performance Advisor.
Dynamic SQL. DBMS_SQL is here to stay. It's faster and is being enhanced. DBMS_SQL and NDS can now accept CLOBs (no more 32k limit on NDS). A ref cursor can become a DBMS_SQL cursor and vice versa. DBMS_SQL now supprts user defined types and bulk operations. Source: Lewis Cunningham
- SQL Performance Advisor - You can tell 11g to automatically apply SQL profiles for statements where the suggested profile give 3-times better performance that the existing statement. The performance comparisons are done by a new administrative task during a user-specified maintenance window.
- Improved SQL Access Advisor - The 11g SQL Access Advisor gives partitioning advice, including advice on the new interval partitioning. Interval partitioning is an automated version of range partitioning, where new equally-sized partitions are automatically created when needed. Both range and interval partitions can exist for a single table, and range partitioned tables can be converted to interval partitioned tables.
- Oracle 11g SQL tuning transformations
Difference between procedure and stored procedures?
STORED PROCEDURE :
A stored procedure can be created with no parameters, IN parameters, OUT parameters, or IN/OUT parameters.There can be many parameters per stored procedure.
It is also called as a FUNCTION.
EXAMPLE:
1.
-- Hello World in Oracle PL/SQL (stored procedure)
SET SERVEROUTPUT ON
BEGIN
dbms_output.enable(10000); dbms_output.put_line('Hello World');
END;/
OUTPUT : Hello World
2.
SET SERVEROUTPUT ON
BEGINDBMS_OUTPUT.ENABLE;DBMS_OUTPUT.PUT_LINE('Hello World');END;/
SET SERVEROUTPUT OFF
3.
DECLARE
annapurna VARCHAR2(20) := &'annapurna'; -- variable with a value assignment HOURLY_WAGE NUMBER := 5.15; -- until congress changes it HOURLY_WAGE NUMBER DEFAULT 5.15; --using defaultHOURLY_WAGE NUMBER NOT NULL := 5.15; --using not null -- default n not null both r having same functionality -- but, not null requires a valueBEGINDBMS_OUTPUT.PUT_LINE('Hello ' annapurna '!!!');END;/
4.SET SERVER OUTPUT ON
BEGIN DBMS_OUTPUT.ENABLE; DBMS_OUTPUT.PUT_LINE('hello miSS'); END;/
5.
-- calling of a PL/SQL function
SET SERVEROUTPUT ON SIZE 1000000
DECLARE msg VARCHAR2(30);BEGIN msg := message_for_the_world; DBMS_OUTPUT.PUT_LINE(msg);END;/
6.
-- a simple PL/SQL function to return a string
CREATE OR REPLACE FUNCTION message_for_the_worldRETURN VARCHAR2ASBEGIN RETURN 'hello, world';END;/
SHOW ERRORS
TRIGGER :
Ii is a fragment of code that tells Oracle to fire or run BEFORE or AFTER a table is modified.
ADVANTAGE : It has the power to make sure that a column is filled in with default information make sure that an audit row is inserted into another table after finding that the new information is inconsistent with other stuff in the database.
Example :
1.
create table my_trigger ( comment_id integer primary key, on_what_id integer not null, on_which_table varchar(50), user_id not null references users, comment_date date not null, ip_address varchar(50) not null, modified_date date not null, content clob, html_p char(1) default 'f' check(html_p in ('t','f')), approved_p char(1) default 't' check(approved_p in ('t','f')));/
SHOW ERRORS
2.
Banks Transactions , updations and ONLINE SHOPPING MALLS BUSINESS transactions are the best Examples for TRIGGERS.
One more thing according to my knowledge we write the TRIGGERS in STORED PROCEDURES.
Annapurna.
What is the centralized directory database in the domain model SAM?
the centralized directory database in the domain model
is NTDS.DIT(directory information tree)
but for the local sstem not connected to domain is SAM
How do you run an XAMPP Server?
Let's talk about what kind of server you are trying to run. There are 2 different types of servers in gaming.
There are the servers that can be run 'ingame' (ISG's) and there are servers that are ran outside of the game (OSG's)
XAMPP works best for those willing to run an OSG server, such as those running a Minecraft Server (bukkit, vanilla, smp, etc...)
XAMPP performs more tasks than Hamachi can, however Hamachi is very small and simple to use for those just beginning their Minecraft servers.
I can't judge what kind of server you are asking about running, whether that server is an FTP, CloudOS, Gaming, Instant Messenger, Video Chatting, Social Networking, Mail Server, or a VPS (Virtual Private Server)
However I found a tutorial on running a bukkit server for Minecraft with XAMPP, and most of it can be used on any other type of server, since its a basic tutorial on XAMPP.
See the related link.
:FROM HERE ON, IS OSG INFORMATION, IT HAS NOTHING TO DO ABOUT THE QUESTION IT'S JUST FOR THOSE WHO DON'T KNOW MUCH ABOUT OSG'S:
OSG's are typically ran with a configuration file and another file that comes with the server to control the server settings without shutting your server down.
For Bukkit the configuration file is "server.properties" or a .properties file, which is a file that can be read inside of the server's coding when it was developed.
The properties file is airtight and is very limited according to what changes can be made, however there is 1 property that is named "IP:" which the area outside of the colon belongs to a 4-digit ID known as the Internet Protocol, or IP. An IP is used to connect with the WWW or the World Wide Web, you are using IP/TCP protocol every single day.
When running a server, knowing the difference between a Static IP and a Non-Static IP is important.
To set your IP to static you would open up CMD, and type in "ipconfig/all" (without quotations)
Your network information should be shown in the Command Prompt screen.
There is IPv4 and IPv6, only use IPv4 for your 32-Bit server, and IPv6 for 64-Bit servers. (Bukkit only runs 32-Bit servers)
Your IPv4 address looks similar to this xxx.xxx.xxx.xxx (x = any # 0-9)
For example, let's say that I was running a server with the IP 172.127.0.9, for the properties file I would have the IP: reading IP: 172.127.0.9, and when I ran that server, it would automatically run on that IP, and when anyone else playing that game wanted to join my server, they would need the IP address and other information (depending on server)
A static IP is an IP that is preset, and it doesn't fluctuate or change in any way.
My IP is automatically chosen by default, which is not static.
To change that, I would get the IP from CMD "ipconfig/all" and then go to my control panel.
Then going to Network and Sharing Center
Then going to Manage Network Connections
Then going to my Local Area Connection (LAN)
Then going to its properties
Then to the IPv4 Configuration
In the General Tab I would uncheck the "Obtain an IP Automatically" box or button and then with my CMD, I will copy my IP address from the IPv4 which was 172.127.0.9
set my Subnet Mask to 255.255.0.0
set my Default Gateway to 124.126.0.1 (not real, just an example)
and then I will set my DNS (both of them)
124.126.1.1 & 124.126.0.1 (examples)
and then I would save those settings, and test them out with my web browser.
If my homepage shows up, then it worked. If it didn't, then set it back to "Obtain an IP Address Automatically" and then try again, but being very careful and making sure that I am copying the right numbers from the "ipconfig/all"
Once you have set your IP to static, then you can use it to run any server.
however a Hamachi server would make its own network connection and you would run your server from the given IP Address for Hamachi, if it is 5.28.0.210 then you would not need to make it static (it's automatically static) and you would put that into the IP: in the server.properties file.
However for other people to connect, you will need to make a network through hamachi using the Create a new Network option in Hamachi
Then you would give out the Network Name, Network Pass, and the Hamachi IP address to the people wanting to join your server through Hamachi.
(They would require the Hamachi client in order to join your network and server)
What do you call arpanet's development today?
The Internet, or the World Wide Web.
---HG MS. Vereen Class
- Data Security
- Data Integrity
- Interactive Query
- Interactive Data Entry and Updating
- Data Independence
Firewall Log Analysis
Log Analysis & Reporting Software for Firewalls, VPN & Proxy Servers.
www.FWAnalyzer.com
C2C -Campus to Consulting
BI Concepts, BI Tools & Data Mining Training starts 21st Oct, 09, Blore
keymedia.keysoft.co.in
Advantages and disadvantages of Electronic Filing Systems?
Advantages:
-Less paper work
-No lost files
-Easier to maintain
-Easier to backup
Disadvantages:
-Lack of security
-Data can be misplace easily
How many objects can a access database contain?
An Access database can hold up to 2GB (two gigabytes) of information.
These include up to 32,768 objects ( tables, queries, forms, etc).
From this up to 255 people can use the database at the same time.
My source: MS Access 2010 Comprehensive, New Perspectives, Adamski::Finegan
rosie stjulian
What fields are in a shop database?
In most shops now they have a system called EPOS (Electronic Point Of Sale) This is a combination of a till and a database. It has been designed as a database which carries all the inventory of the store (all the data regarding the stock) It will record stock in through deliveries, internal stock transfers and even retrurned stock. Each stock line in broken in to groups for instance Chilled, Frozen or White goods, Audio, even book types or music genre. Its that adaptable. In additon it will record sales by department and account for cash and non cash sales. In many newer version in multi-national stores there can be facilities to order stcok at the point of sale directly from manufacture. The system is in two parts, the till system and teh back office system the prior is where the transactions happen, the latter is where management of the system occurs
What is decomposition in database management system?
We can explain the given information using smaller amount of dats's by using decomposition. also, we can get separate details.
What is the difference between soft key and normal key?
A normal key is when you type on a keyboard or cell phone a letter or number and that is what shows on the screen. For example you type a X you see a X, you type a 9 you see a 9. The keys function is only to produce that letter or number. A soft key is keys on a keyboard or cell phone will preform multiple functions. Like the function keys or 'F-Keys'. These keys can be programmed to do more than one task at a time. Or on a cell phone you can hit the number 3 and a 3 will show on the screen or if you hold the 3 key for a moment it will call a programmed phone number.
What is the difference between microcomputer supercomputer microcomputer and mainframe?
Truth be told, the difference is mostly historical. A minicomputer is designed to handle the computing needs of a whole team of people; a microcomputer is a personal computer. Today, however, microcomputers are more powerful than supercomputers of yesteryear and microcomputer processors are used to drive large-scale applications... in certain cases microcomputer processors are even used in parallel to drive today's supercomputers.
How do you connect access database to vb6.0?
first open a data application in the opening window there is a dataenviroment and bind your database to the environment
you can select a text box and in the property table under the data there is data sourse and field l
after run the application it will bind whithout any code
first of all create a database file,then open the vb application.after opening place any control as you like.then connect the datasource as file name and data fields.
or
Use DAO scripting Runtime..
Explain in detail about performance management system?
The performance management system refers to the systematic process by which a given organization involves its employees in various activities within the organization so as to improve the effectiveness in the accomplishment of its goals and missions. The performance management system is usually used to communicate organizational objectives and goals.
What are the disadvantages of the Concurrent Development Model?
Because all of the stages are working simultaneously, any changes to user requirements halts the work on any component dependent on the component being changed. This can lead to a much longer development cycle than originally planned for. Additionally, this model requires excellent and current communication between all teams, which is sometimes not easily feasible.
Is it true that access helps you organize and identify your database by using database properties?
Yes, the properties help to identify your file. Access has facilities in the Database Tools to show the full design of the database and analyse it.
emergency repair disk: contains information unique to your OS and hard drive, ERD enables restoration on your hard drive of the windows registry, in addition the disk contain information used to build a command window to run DOS-like commands
What aspect of an organization is supported by a management information system?
Those support activities include planning, monitoring, and control. Specific technology activities might include providing periodic reports on operational efficiency, effectiveness, and productivity.
