Com the power of knowing 1z0 042 how would you

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: perform this? A.Bring the database to the NOMOUNT state, rename the data file using the operating system, and then execute the ALTER TABLESPACE... RENAME DATAFILE... statement. B.Take thetablespacethat contains the data file offline, rename the data file using the operating system, and then execute the ALTER DATABASE... RENAME DATAFILE... statement. C.Take thetablespacethat contains the data file offline, rename the data file using the operating system, and then execute the ALTER TABLESPACE... RENAME DATAFILE... statement. D.Make thetablespacethat contains the data file read only, rename the data file using the operating system, and then execute the ALTER TABLESPACE... RENAME DATAFILE... statement. Answer: C QUESTION 70: You work as a database administrator for Certkiller .com. According to your backup strategy, you performed an incremental level 0 backup of your database. Which statement regarding this backup is true? A.The backup is similar to image copy. B.The backup contains all used data blocks. C.The backup contains only unused data blocks. D.The backup contains all data blocks changed since the last incremental level 1 backup. Answer: B QUESTION 71: Exhibit You work as a database administrator for Certkiller .com. While executing the command line to create a table, the user gets the following error message and the CREATE TABLE... command fails. ERROR at line 1: ORA-01950: no privileges ontablespace What could be the possible reason for this error message? Actualtests.com - The Power of Knowing 1Z0-042 A.Thetablespace Certkiller tbs7 is full. B.The user is not the owner of the SYSTEMtablespace. C.The user does have quota on the Certkiller 7tablespace. D.The user does not have sufficient system privileges to create table in the Certkiller 7 tablespace. E.The user does not have sufficient privileges to create table on the default permanent tablespace Answer: C QUESTION 72: You work as a database administrator for Certkiller .com. You are using Recovery Manager (RMAN) for backu...
View Full Document

Ask a homework question - tutors are online