Unformatted text preview: he required privileges?
A. grant CONNECT role to all of the three users
B. grant RESOURCE role to all of the three users
C. grant both CONNECT and RESOURCE role to all of the three users
D. execute ALTER USER .. QUOTA UNLIMITED ON publisher_tbs command for all
of the three users
E. create role with UNLIMITED TABLESPACE system privilege and assign the role to
all of the three users
You have two databases, FINDB and PAYDB, on single operating system and using
Optimal Flexible architecture (OFA). FINDB is functional and is currently being
accessed by the users. While starting up the instance for the PAYDB database you
get the following error:
ORA-01081: cannot start - already running ORACLE - shut it down first
Which environmental variable would you set before starting up the PAYDB
database to overcome this error?
Actualtests.com - The Power of Knowing 1Z0-042
Your database is in the NOARCHIVELOG mode. Since last night's offline backup,
the logs in group 1 have been written to twice. This morning, the SYSTEM data file
has become corrupted. Up to what point can it be recovered?
A. until the last commit
B. cannot be recovered
C. until the last offline backup
D. until the beginning of the last transaction
Exhibit. Which statement causes more undo generation?
A. SELECT * FROM emp;
B. DELETE FROM emp WHERE empno=7934;
C. UPDATE emp SET comm=400 WHERE empno=7844;
D. INSERT INTO emp VALUES(7999,'JHON','CLERK',10MAY-83',1500,NULL,10);
Actualtests.com - The Power of Knowing 1Z0-042 QUESTION 102:
Where do you find information about a missing redo log file?
A. trace file
B. audit trail
C. control file
D. alert log file
E. event viewer
You are using flat files as the data source for one of your data warehousing
applications. You plan to move the data from the flat file structures to an Oracle
database to optimize the application performance. In your database you have
While migrating the data,...
View Full Document
- Fall '09
- administrator, Oracle Database, Certkiller