Explain the relationship among Database, Tablespace and Data file.?

Question

Explain the relationship among Database, Tablespace and Data file.?

asked Aug 21, 2021 by anonymous

1 Answer

Related questions

Explain the relationship among Database, Tablespace and Data file.?

Description : Explain the relationship among Database, Tablespace and Data file.?

Last Answer : Each databases logically divided into one or more tablespaces one or more data files are explicitly created for each tablespace

Explain the relationship among database, tablespace and data file.

Description : Explain the relationship among database, tablespace and data file.

Last Answer : Each databases logically divided into one or more tablespaces one or more data files are explicitly created for each tablespace.

Can you increase the size of a tablespace ? How ?

Description : Can you increase the size of a tablespace ? How ?

Last Answer : Yes, by adding datafiles to it.

What is a Tablespace?

Description : What is a Tablespace?

Last Answer : A database is divided into Logical Storage Unit called tablespaces. A tabl

Can a Tablespace hold objects from different Schemes?

Description : Can a Tablespace hold objects from different Schemes?

Last Answer : Yes.

Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?

Description : Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?

Last Answer : All the default storage parameters defined for the tablespace can be changed using the ALTER TABLESPACE command. When objects are created their INITIAL and MINEXTENS values cannot be changed.

How can you increase the capacity of an Oracle tablespace? Note: there are 2 correct answers in this question A. Resize the existing data file B. Add a new data file to the existing tablespace C. Enable compression of backup data using Oracle advanced compression D. Increase the value of the database parameter DB_BLOCK_SIZE

Description : How can you increase the capacity of an Oracle tablespace? Note: there are 2 correct answers in this question A. Resize the existing data file B. Add a new data file to ... compression of backup data using Oracle advanced compression D. Increase the value of the database parameter DB_BLOCK_SIZE

Last Answer : B. Add a new data file to the existing tablespace

What is the advantage of a stored procedure over a database trigger ?

Description : What is the advantage of a stored procedure over a database trigger ?

Last Answer : We have control over the firing of a stored procedure but we have no control over the firing of a trigger.

What are the various types of database triggers ?

Description : What are the various types of database triggers ?

Last Answer : There are 12 types of triggers, they are combination of : Insert, Delete and Update Triggers. Before and After Triggers. Row and Statement Triggers. (3*2*2=12)

What are the parts of a database trigger ?

Description : What are the parts of a database trigger ?

Last Answer : The parts of a trigger are: A triggering event or statement A trigger restriction A trigger action

Can U disable database trigger? How?

Description : Can U disable database trigger? How?

Last Answer : With respect to table ALTER TABLE TABLE [[ DISABLE all_trigger ]]

What is Database Link?

Description : What is Database Link?

Last Answer : A database link is a named object that describes a “path” from one database to another.

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode?

Description : What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode?

Last Answer : Complete database recovery from disk failure is possible only in ARCHIVELOG mode. Online database backup is possible only in ARCHIVELOG mode.

What are the different modes of mounting a Database with the Parallel Server?

Description : What are the different modes of mounting a Database with the Parallel Server?

Last Answer : Exclusive Mode If the first instance that mounts a database does so in exclusive mode, only that Instance can mount the database. Parallel Mode If the first instance that mounts a database is ... parallel mode, other instances that are started in parallel mode can also mount the database.

What are the steps involved in Database Startup?

Description : What are the steps involved in Database Startup?

Last Answer : Start an instance, Mount the Database andOpen the Database.

What does a Control file Contain?

Description : What does a Control file Contain?

Last Answer : A Control file records the physical structure of the database. It contains the following information. Database Name Names and locations of a database’s files and redolog files. Time stamp of database creation.

What is the use of Control File?

Description : What is the use of Control File?

Last Answer : When an instance of an ORACLE database is started, its control file is used to identify the database and redo log files that must be opened for database operation to proceed. It is also used in database recovery.

In SQL, the CREATE TABLESPACE isused A. to createa place in the databasefor storageof scheme objects, rollback segments, andnaming the data files to comprise the tablespace B. to createa database trigger C. to add/rename data files, to change storage D. All of theabove E. None of the above

Description : In SQL, the CREATE TABLESPACE isused A. to createa place in the databasefor storageof scheme objects, rollback segments, andnaming the data files to comprise the tablespace B. to createa database trigger C. to add/rename data files, to change storage D. All of theabove E. None of the above

Last Answer : to createa place in the databasefor storageof scheme objects, rollback segments, andnaming the data files to comprise the tablespace

What is the use of Data Dictionary ?

Description : What is the use of Data Dictionary ?

Last Answer : Used by Oracle to store information about various physical and logical Oracle structures e.g. Tables, Tablespaces, datafiles, et

Is it possible to prompt a user for data when running a SQL script?

Description : Is it possible to prompt a user for data when running a SQL script?

Last Answer : Yes, prefix the column name with & or &&.

How to define Data Block size?

Description : How to define Data Block size?

Last Answer : A data block size is specified for each ORACLE database when the database is created. A database users and allocated free database space in ORACLE datablocks. Block size is specified in INIT.ORA file and can’t be changed latter.

What are the Characteristics of Data Files?

Description : What are the Characteristics of Data Files?

Last Answer : A data file can be associated with only one database. Once created a data file can’t change size. One or more data files form a logical unit of database storage called a tablespace.

Views do not contain or store data.

Description : Views do not contain or store data.

Last Answer : plsql

Do View contain Data?

Description : Do View contain Data?

Last Answer : Views do not contain or store data.

How do you add a data file to a tablespace

Description : How do you add a data file to a tablespace

Last Answer : ALTER TABLESPACE ADD DATAFILE SIZE

Name a tablespace automatically created when you create a database.

Description : Name a tablespace automatically created when you create a database.

Last Answer : The SYSTEM tablespace.

How many rows will the following SQL return

Description : How many rows will the following SQL return

Last Answer : Select * from emp Where rownum < 10; 9 rows.

Can you use %RowCount as a parameter to a cursor

Description : Can you use %RowCount as a parameter to a cursor

Last Answer : Yes

What are the various types of RollBack Segments ?

Description : What are the various types of RollBack Segments ?

Last Answer : Public Available to all instances Private Available to specific instance

Can you pass a parameter to a cursor ?

Description : Can you pass a parameter to a cursor ?

Last Answer : Explicit cursors can take parameters, as the example below shows. A cursor parameter can appear in a query wherever a constant can appear. CURSOR c1 (median IN NUMBER) IS SELECT job, ename FROM emp WHERE sal > median

What is the significance of the & and && operators in PL SQL ?

Description : What is the significance of the & and && operators in PL SQL ?

Last Answer : The & operator means that the PL SQL block requires user input for a variable. The && operator means that the value of this variable should be the same as inputted by the user previously ... span across different rollback segments or will it terminate ? It will terminate (Please check ).

What is the maximum no. of columns a table can have ?

Description : What is the maximum no. of columns a table can have ?

Last Answer : 254.

Can you Rollback to any savepoint ?

Description : Can you Rollback to any savepoint ?

Last Answer : Yes.

Can you define multiple savepoints ?

Description : Can you define multiple savepoints ?

Last Answer : Yes.

An insert statement followed by a create table statement followed by rollback ? Will the rows be inserted ?

Description : An insert statement followed by a create table statement followed by rollback ? Will the rows be inserted ?

Last Answer : No.

What is the difference between unique key and primary key ?

Description : What is the difference between unique key and primary key ?

Last Answer : Unique key can be null; Primary key cannot be null.

What are the states of a rollback segment ? What is the difference between partly available and needs recovery ?

Description : What are the states of a rollback segment ? What is the difference between partly available and needs recovery ?

Last Answer : The various states of a rollback segment are : ONLINE, OFFLINE, PARTLY AVAILABLE, NEEDS RECOVERY and INVALID.

What are the min. extents allocated to a rollback extent ?

Description : What are the min. extents allocated to a rollback extent ?

Last Answer : Two

Can Check constraint be used for self referential integrity ? How ?

Description : Can Check constraint be used for self referential integrity ? How ?

Last Answer : ? Yes. In the CHECK condition for a column of a table, we can reference some other column of the same table and thus enforce self referential integrity.

Can null keys be entered in cluster index, normal index ?

Description : Can null keys be entered in cluster index, normal index ?

Last Answer : Yes.

Can Long/Long RAW be clustered ?

Description : Can Long/Long RAW be clustered ?

Last Answer : No.

What are the disadvantages of clusters ?

Description : What are the disadvantages of clusters ?

Last Answer : The time for Insert increases.

What are the advantages of clusters ?

Description : What are the advantages of clusters ?

Last Answer : Access time reduced for joins.