Explain the relationship among database, tablespace and data file.

Home Answers Viewqa SQL Explain the relationship among database, tablespace and data file.

hemant kumar

Explain the relationship among database, tablespace and data file.
1 Answer(s) 2 years and 6 months ago
Posted in : SQL

Explain the relationship among database, tablespace and data file.

View Answers

November 19, 2010 at 3:06 PM

Hi,

Here is the answer of your question,

Database : Database is the Collection of data is called database.

Table Space : The table space is useful for storing the data in the database. When a database is created two table spaces are created.

1-System Table Space

: This data file stores all the tables related to the system and dba tables.

2-User Table Space

: This data file stores all the user related tables. We should have separate table spaces for storing the tables and indexes so that the access is fast.

Data Files : Every Oracle Data Base has one or more physical data files. They store the data for the database. Every data-file is associated with only one database. Once the Data file is created the size cannot change. To increase the size of the database to store more data we have to add data file.

Thanks,

Explain the relationship among database, tablespace and data file.
Explain the relationship among database, tablespace and data file. Explain the relationship among database, tablespace and data file. Hi... data-file is associated with only one database. Once the Data file is created

Resultset with one to many relationship
Resultset with one to many relationship Suppose there are 5 tables in database named A,B,C,D and E. A has one to many relationship with B,C,D and D has one to many relationship with E. Beam class of A contains array of Class B

Relationship among Design patterns
Relationship among Design patterns Patterns have relationships and work together to form a weave. That is why, it is found that more familiar you

Excel File data upload into postgresql database in struts 1.x
Excel File data upload into postgresql database in struts 1.x Dear members please explain how Excel Files data upload into postgresql database in struts 1.x

Entity relationship model - Design concepts & design patterns
the description is incomplete, list other data the database should store. d. Adjust... Entity relationship model For each of the projects, do... to have a database of all chemicals in the stockroom. The information includes

Insert file data into database
Insert file data into database In this section, you will learn how to insert the file data into database. Description of code: Here we have used FileReader and BufferedReader class to read the file. The data of the file is then stored

data insertion from xml file to database table
data insertion from xml file to database table Hi all, I have data in the XML file. I need to insert it into table in the database using servlet. so please reply me . ThankYou

JPA Relationship
JPA Relationship ... relationship. JPA supports the relationship between entities. There are following types of relationship: One-to-one One-to-many Many-to-one Many-to-many Many

Entity Relationship Diagram 3
Entity Relationship Diagram 3 Task 3 Activities: Identify all entities and attributes from the given scenario. Draw entity relationship diagram... scenario. Scenario: The University is building a database to store lecturer

Explain struts.jar file - Struts
Explain struts.jar file Hi friends am new to java. I read jar file means collection of java files. For executing struts application what are the necessary jar files. " struts.jar " file contains what. can u explain

Question about "Insert text file data into Database"
Question about "Insert text file data into Database" Hey I was reading the tutorial "Insert text file data into Database", (awesome btw), and noticed that both a FileInputStream, a DataInputStream and a BufferedReader

RelationShip
RelationShip i have 2 table with one to many relationship how to add in these tables with hibernate please provide me, sample example. example:- one person have many address, when adding person will simply add, and for address

JSP Get Data Into Dropdown list From Database
JSP Get Data Into Dropdown list From Database In this section we will discuss.... This tutorial explains you that how to fetch data from database and set... data from the database and set it into the dropdown list in JSP using MySQL

database data in xml format
database data in xml format HI, i want to display the database data in the xml format(not as xml file ) on the console using DOM. help will be appreciated. THANKS K.K

Database
Database Hi, i need help building a database based on something like...), multiplicity (or cardinality), in the context of the database system (i.e. give... the database, create and populate tables, query individual tables. (You must

how to display data from jsp file into database
how to display data from jsp file into database this is a jsp file...+",'"+email+"')"); out.println("Data is successfully inserted into database...+","+ph2+")"); out.println("Data is successfully inserted

database
database sir.. how we can uplaod the database in the data file(ms access)please send me a solution

database
database how we ca upload the data in the database file(ms access

Database
Database hi i don't know any thing about database please help me and explain it for me . thank you you can get more data base programs from here View Programs here

selecting data from database
selecting data from database how to select data from database using Dao in struts Hi, You have to load the data from database using hibernate and send the data in a Java file object to jsp page. Please read at http

J2ME Record Data Base
J2ME Record Data Base This Application is used to explain how to store data in the database... the RecordStore class. The RecordStore class is used to get the data through

Insert XML file data to database
Insert XML file data to database In this tutorial, you will learn how to insert the xml file data to database using dom parser. You all are aware of XML... to read the xml file data and save the values of an XML file to a Database

Insert text file data into Database
Insert text file data into Database In this section, you will learn how to insert the text file data into the database. For this purpose, we have created a 'student.txt' file consisting of students information i.e, id, name, course

PHP XML and PHP Backends Sharing Data Tutorial
among programs? This tutorial will explain how it can be done in PHP. XML and PHP... PHP XML and PHP Backends Sharing Data Tutorial PHP XML and PHP Backends Sharing Data Tutorial What if you

Read data from excel file and update database using jsp
Read data from excel file and update database using jsp read data from excel file and update database using jsp Hi, I am using a MySQL database for scientific research analysis. My team members sends research data in excel file

Database
, `file_data` longblob, PRIMARY KEY... to use 'longblob' datatype CREATE TABLE `file

How to Retrieve Data from the database and write into excel file using Java
How to Retrieve Data from the database and write into excel file using Java Hi, I am trying to develop an small application where i trying to retrieve Data from the database and store the details in excel file. Please can

uploading a text file into a database
= conn.prepareStatement("insert into myfile( file_name, file_data) values...uploading a text file into a database how to upload a text file into a database using jchooser import java.io.*; import java.sql.

Data needs to be gathered in XML file from the database (MySql) using JSP
Data needs to be gathered in XML file from the database (MySql) using JSP ... data regarding particular id from the database table. Data needs to be gathered in XML file from the database (MySql) using appropriate JSP/Java Bean functions

Retrieve data from the database and write into ppt file
Java Retrieve data from the database & write into ppt file In this section, we are going to retrieve data from the database and write into the .ppt file. For this purpose, we have used Jakarta POI api to create a .ppt file. The class

Displaying file from database
Displaying file from database I have list of files in my database. I... that corresponding file from database. I have list of file id related to search. I want... strQuery = "select file_data from file where id="+id; ResultSet rs

Add a file into database
into file(file_data) values(?)"); fis = new FileInputStream(f); psmnt.setBinaryStream...Add a file into database Provide the code to upload a file into oracle database? 1)page.jsp <%@ page language="java" %> <

Retrieve Data from the database and write into excel file
Retrieve Data from the database and write into excel file. In this section, we are going to retrieve data from the database and write into the excel file...); fileOut.close(); System.out.println("Data is saved in excel file

Create XML file from flat file and data insert into database
Create XML file from flat file and data insert into database... have developed an application to create xml file from flat file and data...). Create a file "FlatFileXml.java" used to create an XML and data

JPA One-to-One Relationship
JPA One-to-One Relationship ... will learn about the one-to-one relationship. In the one-to-one relation mapping... an example. In this relationship, the Address is defined with a one-to-one

JPA Many-to-one Relationship
JPA Many-to-one Relationship ... about the many-to-one relationship and how to develop a many-to-one relation in your JPA Application. Many-to-One: In this relationship many related records

JPA One-to-Many Relationship
JPA One-to-Many Relationship ... the one-to-many relationship and how to develop a one-to-many relation in your JPA Application. One-to-Many: In this relationship each record in Table-A may have

JPA Many-to-Many Relationship
JPA Many-to-Many Relationship ... the many-to-many relationship and how to develop a many-to-many relation in your JPA Application. Many-to-many: In this relationship each record in Table-A may

Data Normalization
thing in database designing is to make sure that the data get properly... in relational database design to organize the data for minimizing the duplication... a relationship between them. After isolating the data we perform some addition

Identify correct and incorrect statements or examples about the rules and semantics for relationship assignment and relationship updating in a CMP bean.
the rules and semantics for relationship assignment and relationship updating... for relationship assignment and relationship updating in a CMP bean. The assignment... for the relationship multiplicity. In the case of a one

Insert database values in the file
Insert database values in the file In this section, you will learn how to retrieve the data from the database and insert into the file. Description of code... the values from the database and store them into the file

Explain Linked List
Explain Linked List hello, What is Linked List ? hello, Linked List is one of the fundamental data structures. It consists of a sequence of nodes, each containing arbitrary data fields pointing to the next

Insert excel file data into database Using Java Programming
Insert excel file data into database in Java Program In this PHP tutorial section, you will learn how to insert excel file data into the database. We have used Jakarta POI api for inserting excel file data into database in this purpose

Explain the persistence class in hibernate?
Explain the persistence class in hibernate? What is persistence class in hibernate? Persistence class are simple POJO classes... that is used to define the relationship between persistence provider and the managed

Java save file to database
Java save file to database In this section, you will learn how to insert file... between MySql database and java file with the help of various types of APIs... into file( file, file_data) values ( ?, ?)"); pstmt.setString(1, file.getName

Servlet to add the data into database
Servlet to add the data into database ... the data in the database table from a html form. This servlet program.... The data can be inserted in the database that reacquired connection

Hibernate Relationships - Hibernate Relationships mapping example
metadata to persist the data into database tables. For example you can create... into the database. The Java 5 annotation and xml meta-data can be use to define... meta-data. Let's learn it one by one: Setting up database

Database books
Database books- Page 15 ... SYBASE SQL Server handles all data management and transaction... of data on disks, maintains mapping of logical data description to physical

Insert data in Excel File from Database using JSP
the data from database, create an excel file and data insert into newly... Insert data in Excel File from Database using JSP ... developed a application to insert data in excel file from database in JSP. We

To insert attachment file in database in JSP.
To insert attachment file in database in JSP. I am doing project in JSP. How to insert attachment file in mysql database? Please suggest some... = connection.prepareStatement("insert into file(file_data) values(?)"); fis = new FileInputStream(f

Ask Questions?

If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.

Ask your questions, our development team will try to give answers to your questions.

Tutorial Topics