Database Administrator (DBA) Question:
Download Questions PDF

How do you add a data file to a tablespace?

Answer:

ALTER TABLESPACE ADD DATAFILE <datafile_name> SIZE <size>

Download Database Administrator (DBA) Interview Questions And Answers PDF

Previous QuestionNext Question
When creating a user, what permissions must you grant to allow them to connect to the database?How do you resize a data file?