Free Access Oracle.1Z0-082.v2023-08-24.q111 Practice Test (Page 17)

Question 76

Which two statements are true about the PMON background process? (Choose two.)

A.It registers database services with all local and remote listeners known to the database instance

B.It frees resources held by abnormally terminated processes

C.It records checkpoint information in the control file

D.It frees unused temporary segments

E.It kills sessions that exceed idle time

Question 77

The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different locations.
Each database has a tnsnames.ora file defining DALLAS_DB as a service name.
Examine this command:
CREATE DATABASE LINK dblink1 CONNECT TO scott IDENTIFIED BY tiger USING
`dallas_db';
How do you execute the command so that only SCOTT in BOSTON_DB can access the SCOTT schema in DALLAS_DB?

A.as SYS in both the databases

B.as SCOTT in both the databases

C.as SCOTT in DALLAS_DB

D.as SCOTT in BOSTON_DB and SYS in DALLAS_DB

E.as SCOTT in BOSTON_DB

Question 78

Which two statements are true about Enterprise Manager Database Express? (Choose two.)

A.The same port number can be used for multiple Database Express configurations for multiple databases on the same host

B.It can be used to perform database recovery

C.It is available only when the database is open

D.It can be used to switch a database into ARCHIVELOGMODE

E.The same port number can be used for Database Express configurations for databases on different hosts

Question 79

Which three statements are true about views in an Oracle database? (Choose three.)

A.Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error

B.Views can be updated without the need to re-grant privileges on the view

C.Tables in the defining query of a view must always exist in order to create the view

D.The WITH CHECK clause prevents certain rows from being displayed when querying the view

E.The WITH CHECK clause prevents certain rows from being updated or inserted

F.Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error

G.Data Manipulation Language (DML) can always be used on views

Question 80

Which three statements are true about Oracle synonyms? (Choose three.)

A.A synonym created by one user can refer to an object belonging to another user

B.Any user can drop a PUBLIC synonym

C.A SEQUENCE can have a synonym

D.A synonym cannot be created for a PL/SQL package

E.A synonym can be available to all users

Other Version: 1762Oracle.1Z0-082.v2023-03-31.q49; 4385Oracle.1Z0-082.v2022-07-18.q111; 5761Oracle.1Z0-082.v2022-03-27.q110; 6578Oracle.1Z0-082.v2022-02-11.q110; 98Oracle.Prepawaytest.1Z0-082.v2021-09-10.by.ives.98q.pdf

Latest Upload: 202PaloAltoNetworks.NGFW-Engineer.v2026-05-01.q43; 299Nokia.4A0-113.v2026-05-01.q69; 255EC-COUNCIL.312-49v11.v2026-04-30.q214; 228Microsoft.MB-820.v2026-04-30.q101; 211Salesforce.MC-202.v2026-04-30.q57; 206BICSI.INSTC_V8.v2026-04-29.q53; 335NMLS.MLO.v2026-04-28.q82; 243NCARB.Project-Management.v2026-04-28.q27; 463EMC.D-AV-DY-23.v2026-04-27.q184; 1117ServiceNow.CSA.v2026-04-27.q483

Question 76

Question 77

Question 78

Question 79

Question 80

Download PDF File