Ask a Question

What is the relationship among database, tablespace and data file?

in Technology by

What is the relationship among database, tablespace and data file?

1 Answer

0 votes
by

An Oracle database contains one or more logical storage units called tablespaces. These tablespaces collectively store whole data of databases and each tablespace in Oracle database consists of one or more files called datafiles. These datafiles are physical structure that confirm with the operating system in which Oracle is running.

Related questions

0 votes
Q: A top-to-bottom relationship among the items in a database is established by a
    A top-to-bottom relationship among the items in a database is established by a (a) Hierarchical schema ... in portion Storage and File Structures of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: Each tablespace in an Oracle database consists of one or more files called
    Each tablespace in an Oracle database consists of one or more files called (a) Files (b) name space ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: In order to visually represent relationship among 3 variables, which of the following data visualization should be used?
    In order to visually represent relationship among 3 variables, which of the following data visualization should be used? Select the correct answer from above options...
asked Dec 25, 2021 in Education by JackTerrance
0 votes
Q: A ________ in a table represents a relationship among a set of values.
    A ________ in a table represents a relationship among a set of values. (a) Column (b) Key (c) ... and Answers, Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: Graph-based database stores entities and the relationship between them as edges and nodes of a graph, respectively.
    Graph-based database stores entities and the relationship between them as edges and nodes of a graph, respectively. (1)True (2)False...
asked Apr 21, 2021 in Technology by JackTerrance
+1 vote
Q: Graph-based database stores entities and the relationship between them as edges and nodes of a graph, respectively.
    Graph-based database stores entities and the relationship between them as edges and nodes of a graph, respectively....
asked Oct 11, 2020 in Education by anonymous
0 votes
Q: Which is a bottom-up approach to database design that design by examining the relationship between attributes:
    Which is a bottom-up approach to database design that design by examining the relationship between attributes ... Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: Which is a bottom-up approach to database design that design by examining the relationship between attributes:
    Which is a bottom-up approach to database design that design by examining the relationship between attributes: ... upon Normal Forms in portion Normalization of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: What is a SYSTEM tablespace and when it is created?
    What is a SYSTEM tablespace and when it is created?...
asked Dec 17, 2020 in Technology by JackTerrance
0 votes
Q: What is a tablespace?
    What is a tablespace?...
asked Dec 17, 2020 in Technology by JackTerrance
0 votes
Q: Howto import an oracle dump in an different tablespace
    I want to import an oracle dump into a different tablespace. I have a tablespace A used by User A ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 30, 2022 in Education by JackTerrance
0 votes
Q: Howto import an oracle dump in an different tablespace
    I want to import an oracle dump into a different tablespace. I have a tablespace A used by User A ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 29, 2022 in Education by JackTerrance
0 votes
Q: Cannot grant UNLIMITED TABLESPACE to created user
    I am using oracle 10g. I have a database user TDM_DD which executes a procedure in which it creates ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 3, 2022 in Education by JackTerrance
0 votes
Q: A tablespace is further broken down into ________
    A tablespace is further broken down into ________ (a) Tablespace (b) Segments (c) Extents (d) Blocks The ... Storage in section Storage and File Structures of Database Management...
asked Oct 10, 2021 in Education by JackTerrance

© Copyright 2018-2023 www.Blogmepost.com. All rights reserved. Developed by Blogmepost.

...