After creating the users which method can you use for

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: 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 Answer: D QUESTION 99: 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? A. ORA_PATH B. ORACLE_SID C. ORACLE_BASE - The Power of Knowing 1Z0-042 D. ORACLE_HOME E. LD_LIBRARY_PATH Answer: B QUESTION 100: 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 Answer: C QUESTION 101: 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); Answer: B - 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 Answer: D QUESTION 103: 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 clustered tables. While migrating the data,...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online