How do you add a data file to a tablespace, resize a data file?

Home

Help

TUTORIALS

ASP.Net & C#

ASP

Perl and PHP

Java Scripts

C and C++

Ajax Tutorials

J2ee, J2Me, Java

Python & Ruby Rail

Crystal Report

Sap

CGI

XML

Cold Fusion & CFML

HTML, DHTML & CSS

Dreamweaver

FLASH

Photoshop/Web Designing

Tools & Utilities

Oracle/D2K

Sql Server

MySql

Domain Name Registration

Remotely Hosting

Web/Server Application

Hotel Marketing

Internet and Law

Search Engine Optimization/SEO

E-Commerce

Interview Questions

Site Map

Previous < 3 4 5 6 7 8 9 10 11 > Next

Oracle / D2K

Name a tablespace automatically created when you create a database.

The SYSTEM tablespace.

When creating a user, what permissions must you grant to allow them to connect to the database?

Grant the CONNECT to the user.

How do you add a data file to a tablespace?

ALTER TABLESPACE ADD DATAFILE SIZE

How do you resize a data file?

ALTER DATABASE DATAFILE RESIZE ;

What view would you use to look at the size of a data file?

DBA_DATA_FILES

What view would you use to determine free space in a tablespace?

DBA_FREE_SPACE

How would you determine who has added a row to a table?

Turn on fine grain auditing for the table.

How can you rebuild an index?

ALTER INDEX REBUILD;

Explain what partitioning is and what its benefit is.

Partitioning is a method of taking large tables and indexes and splitting them into smaller, more manageable pieces.

Previous < 3 4 5 6 7 8 9 10 11 > Next