1z0-497 무료 덤프문제 온라인 액세스

Which parameter can be changed by explicitly re-creating the control file or by using the DBNEWID utility?

• A.instance_name
• B.control_files
• C.maxdatafiles
• D.db_name

You execute the following command:
SQL> ALTER USER skd ACCOUNT LOCK;
Which two statements are correct?

• A.The objects owned by the SKD user are not accessible to any user.
• B.Other users can access objects owned by the SKD user, to which they have access.
• C.The SKD user's password expires and the user is forced to change the password at the next login.
• D.The SKD user cannot log in to the database instance.

Your customer has three data centers in three different locations, location A has their production database running on Oracle Database 12c. They want to replicate the data from location A to location B.
which is 50 miles away and is used for disaster protection and database rolling upgrades. They also want to create a replica database at location C, which must be open in read-write mode, while synchronizing with the primary database.
Which two solutions would you recommend to your customer?

• A.Oracle GoldenGate
• B.Oracle Active Data Guard
• C.Oracle Streams
• D.Oracle Advanced Replication

YOUR database crashes after a user accidentally kills a background process. What are three possible ways to restart your database?

• A.S sqlplus / as sysdba SQL> restart;
• B.S sqlplus / as sysdba SQL> startup immediate;
• C.S rman target / RMAN> Startup
• D.S srvctl start database -db SORACLE_SID
• E.S sqlplus / as sysdba SQL> startup open recover;

Oracle Database 12c provides new task-specific privileges (SYSBACKUP, SYSDG, and SYSKM) to handle standard administration duties. Which two statements about these standard administration privileges are true?

• A.Without being a member of OSBACKUP. OSDG, and OSKM OS groups, users cannot connect as administrative users by using OS authentication.
• B.These administrative privileges allow a user to view DBA_xxx, GV$, VS, and SELECT on application tables.
• C.After connecting with these privileges, you are connected under a predefined user whose name is the privilege name.
• D.These administrative privileges enable you to connect to the database only if the database is open.