Mustak Ahmed Apps DBA / Rac DBA



1Z0-497 – DumpsWhich statement about CDB architecture is true?Oracle-supplied metadata resides only in the root container.A seed PDB can sometimes be opened for particular operations.Multiple PDBs with the same name can reside in the same CDB.A CDB can have an infinite number of PDBs.You can create common users in PDBs.Answer: AAs part of your Oracle Database 12c post-installation tasks, you run these commands:cd $ORACLE_HOME/binsrvctl stop database -d myDbchopt enable dmsrvctl start database -d myDbWhat does this do?It enables the Oracle Data Mining option in your Oracle binary files.It creates the Fast Recovery Area disk group.It generates Client Static Library.It configures one of the Oracle user accounts.It configures Oracle Net Services.It configures Oracle Messaging Gateway.Answer: AExamine the command below:SELECT SID, SERIAL#, STATUS FROM V$SESSION WHERE USERNAME=’SCOTT’;SID SERIAL# STATUS---------------------715ACTIVE1263INACTIVEWhich three statements are true about terminating a session?Without any error, you can terminate the active session by executing:SQL> ALTER SYSTEM KILL SESSIOU '7, 15';You can terminate the active session by executing:SQL> ALTER SYSTEM KILL SESSIOM '7, 15';But you also get the error message:ORA-00028: your session has been killedYou cannot terminate the active session. You have to wait until that session becomes inactive.Without any error, you can terminate the inactive session by executing:SQL> ALTER SYSTEM KILL SESSION '12, 63';When an inactive session is killed, the status of that session remains visible in V$SESSION with status KILLED. The row of the terminated session is removed from V$SESSION after the user attempts to use the session again.You cannot terminate the inactive session. You have to wait until that session becomes active again.Answer: B,D,EWhich two statements are true about shared server sessions?No Program Global Area (PGA) is allocated for shared server processes.User Global Area is stored in System Global Area (SGA).Shared SQL Area is allocated from Program Global Area (PGA).Private SQL Area is allocated from Library Cache.Large Pool is used for SQL work areas.Answer:B,DWhich targets can be managed by using Enterprise Manager Cloud Control?Hosts and databasesHosts, databases, and application serversApplication servers and web applicationsDatabases, Oracle Management Server (OMS), and Oracle Management Repository (OMR)Databases, application servers, and web applicationsHosts, databases, application servers, web applications, OMS, and OMRAnswer: FWhich two statements are true regarding SQL*Plus?It has commands for performing database administration operations.It can be used in interactive but not batch mode for SQL commands.It has to be installed separately after the Oracle Database 12c installation.Operating system commands can be executed from the SQL*Plus command prompt.Answer:A,DWhich two statements about the Process Monitor (PMON) process are true?PMON performs process recovery when a client process fails.During instance startup, PMON takes care of instance recovery.PMON performs listener registration.PMON restarts background and dispatcher processes when they fail.PMON resolves failures of distributed transactions.Answer:A,DWhich statement is true about loading data by using the conventional path of SQL*Loader?Redo is not generated while performing conventional path loads.Only PRIMARY KEY, UNIQUE KEY and NOT NULL constraints are checked.No exclusive locks are acquired when the conventional path loads are performed.Instead of performing transactions, SQL*Loader directly writes data blocks to the data files.INSERT triggers are disabled before the conventional path load and re-enabled at the end of the load.Answer: BIdentify three key properties of a transaction in Oracle Database 12c.DurabilityConsistencyConcurrencyIsolationScalabilityManageabilityAnswer:A,B,DWhich type of file system is NOT valid for storing data files, online redo log files, and control files for a pluggable database?Automatic Storage Management (ASM)OS file systemLogical Volume Manager (LVM)Clustered File SystemRAWAnswer: EWhich two statements about ADDM are true?Real-Time ADDM uses AWR snapshots of the last 10 minutes.Real-Time ADDM uses ASH recent activity from SGA data.Real-Time ADDM analyzes performance in a completely different fashion than regular ADDM.Regular ADDM uses AWR snapshots that are not yet purged.Answer: B,DWhich two items are key for maintaining data consistency in Oracle Database 12c?Undo dataIsolation levelLock mechanismSerializabilityAnswer: B,CYou are about to install Oracle Database 12c Enterprise Edition. Which statement is true? You should not install the Oracle Database software into an existing Oracle home from a different release. A multitenant container database (CDB) can have several pluggable databases (PDBs) with different character sets.Oracle recommends that you back up the root. sh script after you complete the installation. Cloning an Oracle home is useful if you are performing multiple Oracle Database Installations. You can stop existing Oracle processes, including the listener and the database running in the Oracle home, before the database software installation.Answer: CWhich logical storage relationship is correct?Tablespace< Segment < Extent < Oracle DatablockSegment < Extent < Oracle Datablock<TablespaceTablespace< Extent < Segment < Oracle DatablockData File <Tablespace< Segment < Extent < Oracle DatablockAnswer: AWhich two statements about multitenant architecture are true?Multiple PDBs on a single server need multiple database instances and multiple sets of database files.Although consolidated into a single physical database, PDBs mimic the behavior of non-CDBs.A PDB administrator can use Oracle Flashback or point-in-time recovery to retrieve lost data from a PDB, only by shutting down all the PDBs from the CDB.It is easier to collect performance metrics for many databases in a CDB than individual non-CDB databases.It takes more time to apply a patch to one CDB that holds hundreds of PDBs than to hundreds of non-CDB databases.Answer: B, DWhich three statements represent the benefits of multitenant architecture for database consolidation?You can unplug a PDB from a development CDB and plug it into a production CDB, which allows for easier and more rapid movement of data and code.You can consolidate shared database memory by combining multiple PDBs in a single CDB.Patching individual PDBs requires the same amount of time as patching individual databases.Consolidating separate databases into a single CDB requires the same amount of storage allocation.In multitenant architecture, a PDB behaves the same as a non-CDB as seen from a client connecting with Oracle Net. No client modification is required.Answer: A,B,EWhich statement about the Oracle Advanced Security Data Redaction feature is true?It transparently encrypts data at rest in Oracle databases.It securely manages encryption keys.It protects against theft or loss of disks and backups.It prevents OS users from inspecting tablespace files.It limits the exposure of sensitive data in applications.It alters data in caches, buffers, and persistent storage.It impacts operational activities such as backup & restore, upgrade & patch, and replication.Answer: EWhich three statements about Automatic Database Diagnostic Monitor (ADDM) are true?It requires the database to be open.It analyzes the performance of specified objects.It implements all recommendations automatically.It recommends solutions and quantifies expected benefits.It retains snapshots in the SYSAUX tablespace until the database is restarted.It analyzes the snapshots stored in the Automatic Workload Repository (AWR).Answer: A,D,FWhich is the default port number for Oracle EM Database Express 12c?780155002243152122Answer: AYour customer is looking for a solution to address these downtime needs:- Online addition and removal of disks should automatically rebalance data across new storage configurations while storage, database, and applications remain online.- Dynamically add or remove clustered nodes without disrupting the database or applications.- Automate the sizing and distribution of shared memory.- Add a column with a default value without disrupting the database or applications.- Perform rolling patch upgrades.Which four would you recommend to address those needs?Automatic Storage Management (ASM)Online Data and Application changeGlobal Data Services (GDS)Real Application Clusters (RAC)Oracle StreamsOnline Table RedefinitionOracle Database VaultOnline System ReconfigurationAnswer: A,B,D,HYour database instance is down because there was a user-initiated shutdown. Which option represents the actions performed, in the correct order, if you start up the instance?a - The control file is read.b - Memory is allocated.c - Background processes pre started.d -The initialization parameter file is read,e- Redo log files and data files are opened.b, c, ad, a, ea, e, d, bd, b, c, a, ec, b, d, a, eAnswer: DWhich three components are always parts of System Global Area?Database Buffer CacheUndo Log BufferShared PoolSmall PoolJava PoolPrivate SQL AreaAnswer: A,C,EWhich two statements about Database Express are true?It uses internal infrastructure components, such as XDB and SQL*Net.It can perform actions outside the database.It has background tasks and processes that periodically collect information via FTP.It has two new features: Performance Hub and Composite Active Reports.It is not supported on Standard Edition (SE) and Express Edition (XE).Answer: A,DWhich three operations can the PUBLIC user with the SYSOPER privilege perform?STARTUPSHUTDOWNCREATE DATABASEDROP DATABASEALTER DATABASE RECOVER (Only complete recovery)Answer: A,B,ETo revoke unnecessary and unused privileges, you can use Privilege Analysis. Which sequence should you follow?1 - Start the analysis.2 - Set up the analysis policy type (database, role, and context).3 - Generate the results.4 - View the results in DBA_USED_PRIVS and DBA_UNUSED_PRIVS.5 - Stop the analysis.1, 2, 3, 4, 52, 1, 5, 3, 45, 1, 2, 3, 42, 3, I, 5, 41, 2, 4, 5, 2Answer: BWhich command do you use to create a local role while you are connected as the local user?create local role l_hr;create role c##_hr container=current;create role l_hr container=current;create role l_hr container=all;Answer: CYou want to move all objects of the CONSULTANT user from the test database to the DB-USER schema of the production database. Which option of IMPDP would you use to accomplish this task?FULLSCHEMASTRANSFORMREMAP_SCHEMAREMAP_TABLESPACEAnswer: DFor which database operation do you need the database to be in MOUNT state?Renaming the control filesRe-creating the control filesDropping a user in your databaseDropping a tablespace in your databaseConfiguring the database instance to operate in ARCHIVELOG or NOARCHIVELOG modeAnswer: EExamine the table:Table name: PRODUCTSSchema: SCOTTTablespace: USERSOrganization: Standard (Heap Organized)Rows: 20Columns: PROD_ID NUMBER(1)PROD_NAME CHAR(5)PROD_RATE NUMBER(4)Which two statements are true regarding the modifications that can be performed to the structure of the PRODUCTS table?PROD_NAME size can be increased from 5 to 10 characters.PROD_ID can be changed from CHAR to NUMBER data type.PROD_RATE size can be changed from NUMBER(4) to NUMBER(6, 2).New columns can be added only if they have a NOT NULL constraint.None of the existing columns can be dropped because they contain data.Answer: A,CA DBA informs you that an Oracle instance has started. What does this imply?Users can access the data in the database.Only SGA has been allocated for the database.Only background and user processes are running.Memory areas have been allocated and background processes have been started.Answer: DReal-Time ADDM detects a high-load performance issue within the database. Which condition triggered it?The average active sessions were more than 3 times the number of CPU cores.Active sessions were more than 10% of total load and CPU utilization was more than 50%.Memory allocations were more than 95% of physical memory.Hung sessions were more than 10% of total sessions.4A deadlock was detected.The session limit was close to 100%.Answer: AWhich command do you use to check for block corruption by validating the database?RMAN> VALIDATE CHECK LOGICALRMAN> VALIDATE BACKUPRMAN> VALIDATE CORRUPT BLOCKSRMAN> VALIDATE DATABASEAnswer: DWhich tool is recommended for moving a PDB to a non-CDB?RMANCold BackupTraditional Export / ImportData PumpSQL*PlusAnswer: DWhich two statements describe data dictionary views?They are stored in the SYSTEM tablespace.They are based on virtual tables.They are owned by the SYS user.They speed up query and data manipulation language (DML) operations.The V$FIXED_TABLE view can be queried to list the names of these views.Answer: A, CWhich two statements about this policy are true?BEGINDBMS_REDACT.ADD_POLICY(object_schema => 'HR', object_name => 'EMPLOYEES', column_name => 'SALARY',column_description => 'emp_sal_comm shows employee salary and commission');policy_name => 'redact_emp_sal_comm', function_type => DBMS_REDACT.PARTIAL,function_parameters => '9,1,4', expression => '1=1',END;/BEGINDBMS_REDACT.ALTER_POLICY(object_schema => 'HR', object_name => 'EMPLOYEES', policy_name => 'redact_emp_sal_comm',action => DBMS_REDACT.ADD_COLUMN,column_name => 'COMMISSION_PCT',function_type => DBMS_REDACT.PARTIAL,function_parameters => '9,1,1',expression => '1=1',END;/It replaces the first four digits of the value from the SALARY column with the number 9.It replaces the first digit of the value from the SALARY column with the number 4.It replaces the first digit of the value from the COMMISSION_PCT column with 9.It replaces the first nine digits of the value from the COMMISSION_PCT column with 1.It uses the full data redaction method.It uses the random redaction method.Answer: A,CWhich option represents a function of Global Data Services (GDS)?A. Performs data replicationB. Performs database failoversC. Replaces the functionality of Oracle Clusterware and Oracle RACD. Coordinates site failoversE. Works seamlessly with Oracle Site GuardAnswer: EWhich two statements represent where Oracle Net must reside?Only on the client for traditional client/server applicationsOnly on the database server for web-based applicationsOn both the web server and database server for web-based applicationsOn both the client and database server for traditional client/server applications.Answer: C,DWhen you start up a CDB, which operations are performed automatically and in what order?a - The instance is started.b - Control files are opened.c - The root container is opened (redo logs and root data files).d - Seed pluggable database is in READ ONLY mode.e - Other PDBs are still in MOUNTED mode.f - Triggers may fire if they exist to open other PDBs.a, b, c, d, e, fb, c, a, d, e, fc, b, a, d, f, ea, b, c, db, c, a, dAnswer: AWhich new process was introduced as of Oracle Database 12c?Result Cache Background process (RCBG)AQ Coordinator process (QMNC)Change Tracking Writer process (CTWR)Listener Registration process (LREG)Answer: DExamine the SQL statement:SQL> select con_id, name, open_mode from v$containers;CON_IDNAMEOPEN_MODE-------------------------------- 1CDB$ROOTREAD WRITE 2PDB$SEEDREAD ONLY 3PDB1READ WRITE 4PDB2MOUNTEDConnected as SYS to CDB$ROOT, you create a new common user c##usr –SQL> CREATE USER c#usr IDNETIFIED BY pwd CONTAINER=ALL;SQL> GRANT CREATE SESSION TO c#user CONTAINER=ALL;Then, you open PDB2:SQL> ALTER PLUGGABLE DATABASE pdb2 OPEN;Which two statements are true about this common user?SQL> conn c##usr/pwd@pdb1You are connected to PDB1 successfully.SQL> conn c##usr/pwd@pdb2You are connected to PDB2 successfully.SQL> conn c##usr/pwd@pdb2You are unable to create a connection. You first need to sync PDB2 by executing:SQL> conn / as sysdbaSQL>exec DBMS_PDB.SYNC_PDB;SQL> conn c##usr/pwd@pdb2You are unable to create a connection. You need to create the common user c# #usr explicitly in PDB2 by executing:SQL>conn system/pwd@pdb2SQL> CREATE USER c##usr IDENTIFIEDBY pwd CONTAINER=CURRENT; Now you are able to connect as common user c##usr to PDB2.NOTE: exec DBMS_PDB.SYNC_PDB is used while creating PDB from Non-CDB.Answer: A,BWhich two statements are true regarding undo data records?They are required to support Flashback features.They are not required if Flashback features are enabled.They are retained until the session making the changes ends.Undo records contain copies of data as it appears after a change is made.Undo records contain copies of data as it appears before a change is made.Answer: A,EYour customer has two CDBs: one for Production and one for development. You are asked to create a new development PDB (salesdev) from an existing production PDB (salesprd). Which two options would accomplish this?You copy all the PDB$SEED data files from the production CDB into the development CDB and execute this on the development CDB;SQL> CREATE PLUGGABLE DATABASE salesdev ADMIN USER salesdm IDENTIFIED by password;You alter the salesprd source database to open in read-only mode, and start cloning the source database:SQL> ALTER PLUGGABLE DATABASE salesprd OPEN READ ONLY; SQL> CREATE PLUGGABLE DATABASE salesdev FROM salesprd;You alter the salesprd source database to open in read-only mode:SQL> ALTER PLUGGABLE DATABASE salesprd OPEN READ ONLY; In the development CDB, you create a database link "PRD" that connects to the root of the source CDB, and start cloning the source PDB:SQL> CREATE PLUGGABLE DATABASE salesdev FROM salesprd@prd;Connected as the salesprd local DBA, you create an XML using:SQL> ALTER PLUGGABLE DATABASE salespdb UNPLUG INTO '/tmp/salesprd-xml'; Copy the XML file and all salesprd-related files to the target CDB and start plugging the copy into the development CDB using:SQL> CREATE PLUGGABLE DATABASE salesdev USING '/tmp/salesprd.xml';Answer: C,DYour database is down. You log in as the SYS user and issue this command:SQL> STARTUPWhat happens after the instance is started?Nothing else happens.The database is mounted but not opened.The database is mounted and finally opened.The database is opened and finally mounted.Answer: CWhich option represents the steps to add a multiplexed copy of the current control file or to rename a control file in Oracle Database 12c?a - Shut down the database.b - Restart the database.c - Copy an existing control file to a new location by using operating system commands. d - Edit the CONTROL_FILES parameter in the database initialization parameter file to add the new control file name, or to change the existing control file name.b, c, da, c, d, ba, d, b, cc, d, bAnswer: BYour database is open and the listener is running. The DBA stops the listener by using the command:LSNRCTL> STOPWhat happens to the sessions that are currently connected to the database instance?They can perform only queries.They are not affected and continue to function normally.They are terminated and the active transactions are rolled back.They are not allowed to perform any operations till the listener is started.Answer: BYour customer wants all email addresses from the database displayed as [hidden]@. What method of data redaction must you use?Full redactionPartial redactionRegular expressionsRandom redactionNo redactionAnswer: CYour customer is looking for a solution that meets these four needs: 1 - Replicate data from source to target for reporting purposes. 2 - Replicate data from one source to multiple targets. 3 - Replicate data between two databases for instant failover. 4 - Replicate data from multiple sources to a single target for a data warehouse.Which GoldenGate-supported topology would you recommended?Uni-directional for 1Peer-to-peer for 2Bi-directional for 3Consolidation for 4Peer-to-peer for 1Broadcast for 2Bi-directional for 3Consolidation for 4Uni-directional for 1Broadcast for 2Bi-directional for 3Consolidation for 4Peer-to-peer for 1Consolidation for 2Broadcast for 3Cascading for 4Answer: CYou execute some DML commands, followed by a COMMIT Statement. Which option correctly describes how the log writer (LGWR) process takes part in the transaction commit?A. 1. LGWR writes the commit record to disk. 2. LGWR writes all redo entries from Redo Log Buffer to disk.B. 1. LGWR writes only the transaction's redo entries from Redo Log Buffer to disk. 2. LGWR writes the commit record to disk.C. 1. LGWR puts the commit record to Redo Log Buffer. 2. LGWR writes all redo entries from Redo Log Buffer to disk.D. 1. LGWR puts the commit record to Redo Log Buffer. 2. If the activity is high, LGWR waits three seconds for other transactions to commit. 3. LGWR writes all redo log entries from Redo Log Buffer to disk.E. 1. LGWR puts the commit record to Redo Log Buffer. 2. LGWR signals the database writer (DBW) process to write dirty blocks to disk. 3. LGWR writes all redo entries from Redo Log Buffer to disk.Answer: CWhich two statements about PDBs and CDBs are true?There is only one SYSTEM tablespace per CDB.There is only one instance per PDB.There is a set of redo log files per PDB.There is only one UNDO tablespace per CDB.There is one SYSAUX tablespace per PDB.Answer: D,EYou want to create a new CDB for your customer. Which two statements are true about the seed pluggable database that will reside in the new CDB?You have to copy the seed data files yourselfYou can use the SEED FILE_NAME_CONVERT clause in the CREATE DATABASE statement.The seed pluggable database is not required.The seed pluggable database does not require data files.The seed pluggable database is always kept in READ ONLY mode.The seed pluggable database is not a container.The seed pluggable database can be dropped.Answer: B,EYou want to clone PDB1 and PDB2 into the same CDB. Which statement is correct?You cannot do this, because you can only clone PDBs into another CDB.You can clone only one PDB (either PDB1 or PDB2) into the same CDB.Cloning a PDB can use the source files copy method to the target PDB files.Cloning PDB can use the NOCOPY clause if the target PDB files use the source files.Answer: CConsider 10 scenarios that result in database downtime. Which five of them are considered as planned downtime?Addition or removal of nodes, memory or disksChanging configuration parameters, upgrading or patching Oracle software.File deletionMigrating to cluster architectureDropped database objectTable definition changesRunaway processes that consume system resourcesAdding Table partitioningOperating System or Storage device/ drive failureDatabase or application deadlocksAnswer:A,B,D,F,HWhat happens if we execute these SQL statements:SQL> SHOW CON_NAMECON_NAME------------------CDB$ROOTSQL> CREATE user 1_freed identified by y container = current;A common user is created in the root containerA local user is created in the root containerA local user is created in all PDBsThe second SQL statement fails because a local user cannot be created in the root container.Answer: DA standby database is in mounted state and you are required to perform a failover to the physical standby. Which solution is best suited for this scenario? ALTER DATABASE RECOVER MANAGED STANDBY DATABASE statement with the FINISH keyword ALTER DATABASE PREPARE TO SWITCHOVER and ALTER DATABASE COMMIT TO SWITCHOVER statements ALTER DATABASE RECOVER TO STANDBY DATABASE statement with the FINISH keyword ALTER DATABASE PREPARE SWITCHOVER and ALTER DATABASE COMMIT TO SWITCHOVER statements Answer: AWhich two statements are true about transactions in Oracle Database 12c?Multiple transactions can use the same undo segment.A transaction is assigned an undo segment when it is started.Multiple transactions cannot share the same extent in an undo tablespace.If all the segments in an undo tablespace are used, transactions use system undo segments to store undo data.Answer: A,BWhich two statements about Data Recovery Advisor are true?Data Recovery Advisor can be used to diagnose and repair data corruptions in non-CDBs.Data Recovery Advisor cannot be used to diagnose and repair data corruptions in the root of a CDB.Data Recovery Advisor can be used to diagnose and repair data corruptions in PDBs.You can use the ADVISE FAILURE command to display repair options after running LIST FAILURE in an rman session.Answer: A,DYou are installing oracle database 12c on a machine. When you run the installer; Oracle Universal Installer (OUI) shows a message that says one of the product-specific prerequisites has failed:Checking available space requirements...Expected Result: 1512 MBActual Result: 1018 MBCheck complete: the overall result of the check is: failed << Problem: the system does not have the required swap space.What happens to the installation in this case?It can be continued.It resizes the swap space automatically when you proceed further.It can be continued, but the instance cannot be started without increasing swap space.It shows message saying one or more prerequisites have failed and the installation aborts.Answer: AExamine the command below –LSNRCTL> SERVICES LISTENER2Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=estb.us.)(PORT=1521)))Services summary…Service “orcl.” has 1 instance(s).Instance “oracle”, status UNKNOWN, has 1 handler(s) for service… Handler(s): “DEDICATED” established: 2 refused: 0 LOCAL SERVERThe command completed successfully.Which two statements are true about LISTENER2?The ORCL instance is registered dynamically with the listener.The ORCL instance is statically registered in the listener.ora file.The number of current client connections handled by the service handler is two.The total number of client connections handled so far by the service handler is two.Answer: B,DWhich three statements are true about a database instance that has mounted a database but has not opened it?System administrators and users with the CREATE SESSION system privilege may connect to instance.Data files are opened in Read-Only mode.A control file is open.System Global Area (SGA) is allocated and background processes are started.An alert log and trace files are open.Instance recovery is performed for the database.Answer: C,D,EView the current parameter settings shown in the output below:NAMETYPEVALUEdb_file_multiblock_read_count integer 107ddl_lock_timeout integer 60Distributed_lock_timeout integer 60dml_locks integer 748Lock_sga Boolean FALSEEnable_ddl_loggingBoolean FALSEResumable_timeout integer 0A user logs into the HR schema and issues the following commands:SQL> CREATE TABLE emp(empno NUMBER (3),Ename VARCHAR2(20),Sal NUMBER(8,2));SQL> INSERT INTO emp (empno,ename) values(1,’JAMES’);At this moment second user also logs in to the HR schema and issues the following command:SQL> ALTER TABLE emp modify sal NUMBER(10,2);What happens in this scenario?The second user’s session immediately produces a ‘resource busy’ error.The second user’s command executes successfully.The second user’s session waits for a time before producing a ‘Resource busy’ error.A deadlock is created.Answer:CYour customer want to migrate their production database from Oracle database 10g on AIX to Oracle Database 12c on Solaris and is concerned about the downtime. Which Oracle solution do you recommend?Active Data guardOracle GoldenGateOracle Real Application ClustersOracle Transportable TablespacesOracle Cloud Platform as a serviceAnswer: BAn Oracle instance is a combination of -----------?Database files and parameter file(initialization parameter file or server parameter file)System Global Area (SGA) and background processes.A listener process, server process and background processes.System Global Area (SGA), server processes and background processes.Database files, System Global Area (SGA) and background processes.Answer: BYou have two database servers EMP and EXP. A user of the database from the EXP server wants to extract some information from the database in the EMP server for cross-verification. Which schema object enables the user to access the information from the remote database? ClusterDatabase link Mapping table Materialized view Answer: BWhich two are the client-side components of Oracle Data Guard Broker?Oracle Enterprise Manager Cloud ControlOracle Data Guard MonitorOracle Data Guard Command Line Interface (DGMGRL)Oracle Data Guard Broker ManagerAnswer: A,CYour customer needs server availability that provides uninterrupted access to database services, handling any unexpected failure of one or more machines hosting the database server, due to a hardware or software fault. Which product should your customer use?Oracle Data GuardOracle StreamsOracle Real Application ClustersOracle GoldenGateAnswer: CYour customer has three data centers in three different locations, location A has their production database running on Oracle Database 12c. They want to replicate their 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?Oracle GoldenGateOracle Advanced ReplicationOracle Active Data GuardOracle StreamsAnswer: A,CYour database instance is running. db01 is a net service name. You issue a connection request by using the command -SQL> CONNECT Scott/tiger@db01Which component receives the request and establishes the appropriate connection? ListenerUser process Service name Server process Answer: AWhich statement about Online Move Data file is true?Moving a data file online prevents DML operations on segments stored in the data file.Flashing back a database to a point in time before a data file had been renamed online retains the new name.Moving a data file online can be performed if the data file is in OFFLINE mode.Moving a data file online cannot be performed if the data file is under BEGIN BACKUP.Answer: BYou execute the following command:SQL>ALTER USER skd ACCOUNT LOCK;Which two statements are correct?The SKD user cannot login to the database instanceThe objects owned by the SKD user are not accessible to any userOther users can access objects owned by the SKD user, to which they have access.The SKD user’s password expires and the user is forced to change the password at the next login.Answer: A,CExamine the statements:SQL> CRATE TABLESPACE MYTBS DATAFILE ‘/disk1/mytbs_1/dbf’ SIZE 10M;SQL> CREATE TABLE mytab(Id NUMBER,discr VARCHAR2(100))PARTITION BY RANGE(id)(PARTITION p1 VALUE LESS THAN (100000) TABLESPACE mytbs STORAGE (INITIAL 1M),PARTITION p2 VALUE LESS THAN (MAXVALUE) TABLESPACE mytbs STORAGE (ITNITIAL 1M));When inserting data, you get the error:ORA-01688: unable to extent table SYS.MYTAB partition P2 by 128 in tablespace MYTBSWhich three operations would allow you to insert data without getting the error message?Extend the logical volume by 10MB where the data files are stored;# lvextent –L_10M /disk1Add a data file:SQL> ALTER TABLEPSACE MYTBS ADD DATAFILE ‘/disk1/mytbs_2.dbf’ SIZE 10M;Move a partition to another tablespace:SQL> CREATE TABLESPACE ADDITIONAL_TBS DATAFILE ‘/disk1/additional_tbs_1.dbf’ SIZE 10M;SQL> ALTER TABLE MYTAB MOVE PARTITION P2 TABLESPACE ADDITIONAL_TBS;Resize the existing data file:SQL> ALTER DATABASE DATAFILE ‘/disk1/mytbs_1.dbf’ RESIZE 20M;Remove a data file:SQL> ALTER TABLESPACE MYTBS DROP DATAFILE ‘/disk1/mytbs_1.dbf’;Answer: B,C,DWhich two statements about Automatic Data Optimization (ADO) are true?ADO policies can automatically compress data when it qualifies.ADO policies can automatically move segments when necessary.ADO is not dependent on Heat Map, and works even if Heat Map is disabled.You cannot compress at block level, but you can compress at segment level.You can compress at row level only for query low.Answer: A,BWhich statement about Oracle Patches is false?Interim Patches, also known as “one-off” patches, are created to provide a specific fix between the releases of patch sets.Security Patch Update (SPU) is the primary means of releasing security features for oracle products. SPU’s are cumulative with respect to prior SPUs and generally contain only security fixes.Patch Set Updates (PSU) is a collection of proactive, stabilizing, cumulative patches for a particular product version (base release or patch set). PSUs are cumulative and include all the security fixes from CPU patches plus additional fixes.Patch set is the main way in which Oracle provides bug fixes in between releases. Oracle bundles a number of fixes, tests them thoroughly together and packages them together for easy download and installation.Terminal Patch set is an unsupported patch set by Oracle Lifetime Support policies.Answer: BWhich three statements represent the difference between a container database (CDB) and a non-container database?A container database has exactly one seed PDB, and a non-container database has no seed PDB.In a newly created non-CDB that does not yet contain user data; the data dictionary contains only system metadata. When application users create their own objects, this metadata is mixed with the system metadata. In a CDB the data dictionary is split between the root and the PDBs. The data dictionary in the PDB contains pointers to the data dictionary in the root.New views are introduced. Next to DBA_views, ALL_views and USER_views, there are CDB_views. Both CDB and non-CDB databases can access this information.You are allowed to create only single HR user in a non-container database. This restriction is identical for a CDB database.Every PDB in a CDB has its own control file. A non-CDB, which has no containers, need only one control file. Answer: A,B,CThe session of user Scott receives the following error after executing an UPDATE command on the EMP table.ERROR at Line 1:ORA-00060: deadlock detected while waiting for resourceYou find out that a session opened by user JIM has a transaction that caused deadlock. Which two statements are true about SCOTT’s session in this scenario?The session is terminated after receiving the error and JIM can continue with his transaction.SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.The session is rolled back after receiving the error and JIM can continue with his transaction.SCOTT has to re-execute the last command in the transaction after he commits the transaction.Answer: B,DExamine the commnd:SQL> CREATE TABLE orders (oid number(6) PRIMARY KEY, odate DATE, ccode NUMBER(6), oamt NUMBER(10,2)) TABLESPACE USERS;Which two statements are true about the execution of the command?A CHECK constraint is created on the OID column.A NOT NULL constraint is created on the OID column.The ORDERS table is the only object created in the USERS tablespace.The ORDERS table and a unique index are created in the USERS tablespace.The ORDERS table is created in the USERS tablespace and a unique index is created on the OID column in the SYSTEM tablespace.Answer: B,DWhich three options correctly match environment variables with their specific functionality?ORACLE_SID specifies the instance name.ORACLE_SID specifies the global database name.ORACLE_BASE specifies the root of the Oracle Database directory in all platforms.ORACLE_BASE specifies the root of the Oracle Database directory only in UNIX and LINUX platforms.ORACLE_HOME specifies the directory containing the Oracle software executables and network files.ORACLE_HOME specifies the directory containing only the Oracle software executables but not the network filesAnswer: A,C,EIdentify the correct order of consolidation density, from worst to best.Multitenant < Schema Consolidation < Dedicated Databases < Virtual Machines Schema Consolidation < Virtual Machines < Dedicated Databases < Multitenant Dedicated Databases < Virtual Machines < Schema Consolidation < Multitenant Virtual Machines(VMs) < Dedicated Databases < Schema Consolidation < Multitenant Answer: DExamine the commands:SQL>CONNECT sys@CDB1 as SYSDBA SQL>STARTUP NOMOUNTSQL>ALTER DATABASE cdb1 MOUNT;Which four options represent what happens when these commands are executed?The instance is startedThe CDB control files are opened for the instanceThe root is mounted.The root is opened.The PDBs are mounted.The PDBs are mounted, and the seed is opened in READ ONLY mode.The PDBs are mounted, and opened in READ WRITE mode, while the seed is opened in READ ONLY mode.Answer: A,B,C,EWhich two statements about switchover and failover are true?A snapshot standby can be the target of a switchover or fast-start failover operation.Neither a switchover nor a failover is possible to a far sync instance.For fast-start failover, you must preselect the target standby database that will be used.You can activate a standby database to test whether it is being updated correctly.Answer: B,CIdentify three types of important statistics collection that you can disable in Oracle Database 12c by setting the STATISTICS_LEVEL parameter to BASIC.ORACLE Database alert.log fileObject level statisticsAutomatic SGA Memory managementOracle database trace filesAll server-generated alerts.Answer:B,C,EYou need to recover a database running in NOARCHIVELOG mode. Which two statements are true in this scenario? You can perform complete recovery by using the command: RESTORE DATABASE FROM TAG "consistent_whole_backup"; RECOVER DATABASE; You can perform incomplete recovery by using the command: RESTORE DATABASE FROM TAG "consistent_whole_backup"; RECOVER DATABASE NOREDO;ALTER DATABASE OPEN RESETLOGS; Only consistent backups can be used for restoring a database in NOARCHIVELOG mode. Media recovery is possible in most cases Answer: B,CWhich statement about a server parameter file (SPFILE) is false?An SPFILE is a binary file that cannot be edited by a text editor.You can create an SPFILE using an existing text initialization parameter file or from memory.You can use the SHOW parameters command to display the values of initialization parameters in an SPFILE.The instance first searches for an SPFILE named spfileOracle_SID.ora and if this is not found. Its searches for spfile.ora.Answer: CWhich statement about the Queryable Patch inventory feature is false?It is used to retrieve installed patch information from a SQL prompt.It uses the PREPROCESSOR feature, which allows the user to preprocess input data before it is sent the access drivers.DBMS_QOPATCH provides a PL/SQL or SQL interface to view the database patches installed.It works in an Oracle Database instance that is mounted. Therefore, it works in ASM instances and DG instances.Answer: D? Which three statements are true about managing shared servers?You can adjust shared servers by executing:SQL> ALTER SYSTEM SET SHARED_SERVERS=2 SCOPE=BOTH;If you have configured your database for shared servers, you cannot connect to a dedicated server process. The tow modes are mutually exclusive.The current setting for a dispatcher is:DISPATCHERS= (PROT=TCP)(DISP=2),(PROT=TCPS(DISP=2)SQL> SELECT NAME FROM v$dispatcher;NAME--------D000D001D002D003You can terminate unwanted dispatchers by executing:SQL> ALTER SYSTEM SHUTDOWN IMMEDIATE ‘D003’;You can switch between shared server and dedicated server by executing:SQL> ALTER SYSTEM SET SHARED_SERVES=0 SCOPE=BOTH;SQL> ALTER SYSTEM SET PROCESSES=300 SCOPE=SPFILE;SQL> STARTUP FORCE;Depending on the connection protocol, you can allocate different number of dispatchers. Example TCP with three dispatchers and TCPS with two dispatchers:SQL> ALTER SYSTEM SET DISPATCHERS=’(PROT=TCP)(DISP=3)’,’(PROT=TCPS(DISP=2)’ SCOPE=BOTH;Answer: C,D,EIdentify two types of solutions in which you would need to use Active Data Guard and Golden Gate together.A solution that provides zero-data-loss protection at any distance without impacting database performance.A solution for disaster protection and database rolling upgrades for a mission-critical OLTP database, where you also want to extract data from a data guard primary database for ETL update of an enterprise data warehouseA solution requiring minimal planned downtime and risk, using standby first patching, database rolling upgrades, and select platform migrationsA solution that helps with integrated automatic database and client failover between source and target, where you also need to establish advanced replication (such as multi master and bidirectional replication and data transformations)Answer: B,DYou create a CDB with four containers: the root, the seed, and two pluggable databases PDB1 and PDB2. Which four items can reside In PDB1, but not in the root?Shared UNDO and default database temporary tablespaceOracle-supplied metadataShared Oracle-supplied dataCDB views providing information across PDBsApplication tablespacesLocal temporary tablespacesLocal users and local rolesNon-shared local metadataAnswer: E,F,G,HWhich two statements are true when you execute an invoker's rights procedure?The owner must have the INHERIT PRIVILEGES object privilege on the invoking user, or the INHERIT ANY PRIVILEGES privilege.Invoking users can control who can access their privileges when they run an invoker's rights procedure.The calling user must be granted the INHERIT PRIVILEGES object privilege on the user owner of the procedure.The calling user must grant the INHERIT PRIVILEGES object privilege on the user owner of the procedure.Answer: A,BWhich parameter can be changed by explicitly re-creating the control file or by using the DBNEWID utility?db_namemaxdatafilescontrol_filesinstance_nameAnswer: ASeveral tables are accidentally deleted from a PDB. Which database would be immediately connect to and as which user, to recover these tables.The CDB as the ROOT userThe CDB as the CDBADMIN user The PDB as the ROOT userThe PDB as the PDB Administrator user.Answer: DIdentify two solutions that Oracle provides for Patch conflict.Merge PatchCombine PatchOverlay PatchDual PatchSuper PatchAnswer: A,CYou are in the middle of transaction, updating the table. The machine on which the database is running reboots because of power outage. This causes a database instance failure. Which statement is true in this scenario?The online redo log files and archived redo log files are required to accomplish a recovery.The uncommitted transaction is committed at the next startup of the database instance.The uncommitted transaction is rolled back automatically at the next opening of the database.The DBA has to perform a recovery on the database to recover the uncommitted transaction.Answer: CWhich three options best describe Patch Set Updates (PSUs) in Oracle Database 12c?Non-cumulativeMulti-versionProactive StabilizingCumulativeAnswer: C,D,EFor which use case would you use a rolling upgrade with the Oracle Active Data Guard feature?When upgrading from Oracle Database 12c to the first patch set of Oracle Database 12c.When upgrading from Oracle Database 10g to Oracle Database 12cWhen upgrading from Oracle Database 11g to Oracle Database 12cWhen upgrading from any previous version of Oracle Database to Oracle Database 12c.Answer: AWhich two statements about multi section backup are true?It is available only for full backups.It supports incremental backups and image copies.Backup for each data file is divided into sections and is backed up in parallel. However, for image copies, sections are backed up sequentially.For image copies, sections are backed up in parallel and recomposed at the end.Answer:A,DWhich tablespace contains the data dictionary, being automatically created at database creation?USERSTEMPSYSAUXSYSTEMEXAMPLEAnswer: DWhich three tasks can you perform in Database Express? View performance and status information about the database instance. Start up the database. Shut down the database. Create database structures. Manage users and security. Answer: A,D,EWhich two statements are true about the B-tree index?The leaf blocks in the index are doubly linked.The leaf node stores a bitmap for each key value.Rows with a null value in key columns also have entries in the Index.The deletion of a row from the table causes a logical deletion in the index leaf block and the space becomes available for a new leaf entry.Answer: A,DWhich two statements are true about listeners?Listeners use only the TCP/IP protocol.Multiple listener processes can run simultaneously on a host.Multiple database instances can be registered with a single listener.Listener-related errors can be traced only at the administrative level.Only one database instance can be registered with a single listener at any time.Answer: B,CYou want to start a global service on your database. Which three conditions must be met?The database is open and registered with a global service manager.The service has been disabled on that database.The database role is different from the role attribute of the service.The replication lag on the database does not exceed the maximum value specified for the service.The service has reached its cardinality defined by the number of preferred databases.No other database in the pool is a better candidate for starting the service.Answer:A,D,F What must you do to an application for it to take advantage of partitioning?Recompile itRewrite its SQL queriesRelinkRework the applications schemaNothing; it is transparentAnswer: EWhich three statements about common and local roles are true? When a common role is granted to a local user, the privileges in the role are limited to the context of the PDB. Local roles can be granted only to local users. Common roles can be granted to both local and common users. A user can create common roles if the user has the CREATE ROLE privilege, and SET CONTAINER for all PDBs. Common roles can be created in the root and PDBs. Answer: A,C,DWhich statement regarding Oracle Active Data Guard 12c is false?Any application compatible with a read-only database can run on an Oracle Active Data Guard standbyIt provides new support for DML to global temporary tables and the use of sequences in the standby database.It repairs block corruptions detected in the primary or standby database.IT supports different patch levels between primary database and its physical standby database for the purpose of applying and validating Oracle patches in a rolling fashion.It supports multi master and bidirectional replication architecture where there are multiple databases that all contain the same data, even if they are not synchronized.Answer:EExamine the command:sqlplus /nologIn which scenario would this command execute successfully?Only from the server, if the database instance is not upFrom either a client or server, even if the database instance is not upFrom either a client or server, only if the database instance is up, and the command connects the session to the instanceFrom either a client or server, only if the database instance is up, but the command does not connect the session to the instanceAnswer:B John is a CDB administrator, and Mike and Time are PDB administrators of their respective databases- John takes a complete CDB backup by using RMAN-> backup Database. Mike and Tim may need point-in-time recovery of their PDBs. Which statement is true?Recovery of individual PDBs is not possible, because John did not backup by using RMAN-> Backup Pluggable Database pdb1 pdb2. However complete CDB recovery is still possible.Mike and Tim needs to individually take backups of their respective PDBs, because CDB-level backup does not include PDB data dictionary objects.Mike and Tim do not need to worry, because recovery of individual PDBs is possible.Recovery of individual PDBs is not possible at all.Answer: CIn this SQL statement, what is the partitioning criterion?CREATE TABLE books_partPARTITION BY RANGE(cell_id)(PARTITION p01 VALUS LESS THAN(2)PARTITION p02 VALUES LESS THAN(3)…PARTITION P14 VALUES LESS THAN(15)PARTITION p15 VALUES LESS THAN(16)PARTITION p16 VALUES LESS THAN(MAXVALUE))AS SELECT * FROM books;BooksPxxMAXVALUECell_idAnswer: D Which four statements about users in Oracle Database 12c are correct?A common user cannot have the same name as any local user across all PDBs.A common user can only be created in the root container.A local user with the proper privileges can also create a common user.If a PDB is closed, the common and local users of PDB are not visible.A common user with the proper privileges can create a common user by using the CONTAINER=CURRENT clause.A common user is one that has the same user name and authentication credentials across multiple PDBs.Answer: A,B,D,FWhich three DBA operations can be performed by using Oracle SQL Developer? Database backup and recovery using RMAN Performance tuning operations such as generation of AWR, ADDM, and ASH reports Storage configuration for archive logs and control files Storage configuration for data files and redo log groups Database status view and Data Pump export and import jobs Answer: A,B,EConsider an application in which memory required for each session 400 KB and memory required for each server process is 4 MB. The pool size is 100 and the number of shared servers used is 100. If there are 5000 client connections, what is the amount of memory used by a dedicated server?615 MB2.5 GB4 GB12 GB22 GBAnswer: EWhen executing shutdown abort in a pluggable database(PDB) you ------Shut down abort the CDBShut down abort the PDBShut down immediate the PDBShut down immediate the CDB.Answer: BWhich is the default isolation level in Oracle Database 12c?serializableread-onlyread committedread uncommittedAnswer: CYour customer is planning for maximum-availability architecture at their data center to address their planned downtime, unplanned downtime, and replication needs. Consider these options:- Instance, site recovery, and heterogeneous setup- Inter-region and intra-region load balancing across replicated databases- Fine-grained error investigation of incorrect results- Integrated client and application failover- Fastest and simplest database replicationWhich four options would you recommend?Oracle Golden GateGlobal Data ServicesOracle Data GuardData Recovery AdvisorOracle Flashback technologyOracle Advanced QueuingAnswer:A,B,C,EWhich two statements are true about Oracle Data Pump?EXPDP and IMPDP are the client components of Oracle Data Pump.DBMS_DATAPUMP PL/SQL packages can be used independently of Data Pump clients.Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.Oracle Data Pump imports can be done from the export files generated in Original Export Release 9.x.EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.Answer: A,BWhich two statements correctly distinguish between undo and redo data?Undo reverses a change, whereas redo re-creates a change.Redo reverses a change, whereas undo re-creates a change.Undo protects against inconsistent reads, whereas redo protects against data loss.Redo protects against inconsistent reads, whereas undo protects against data loss.Answer:A,CAfter a ___________ statement is issued, a transaction MITROLLBACKSAVEPOINTSELECTCREATEAnswer:A,B,EWhich statement about Storage Snapshot Optimization is correct?It enables you to use third-party technologies to take a storage snapshot of your database without putting the database in BACKUP mode. You can then use the snapshot to recover all or part of the database.It enables you to use RMAN to take a storage snapshot of your database. The database must be in BACKUP mode. You can then use the snapshot to recover all or part of the database.It enables you to use RMAN to take a storage snapshot of your database. The database doesn't have to be in BACKUP mode. You can then use the snapshot to recover all or part of the database.It enables you to use third-party technologies to take a storage snapshot of your database. The database must be in BACKUP mode. You can then use the snapshot to recover all or part of the database.Answer:AThere are two listeners, LISTENER1 and LISTENER2 and one service name orcl available for your database. The database is running and currently, only LISTENER1 is started. You issue the command:lsnrctl start listener2What would be the outcome?It starts the second listener without affecting current sessions.It starts the second listener and terminates all current sessions.It gives an error because multiple listeners cannot run simultaneously.It gives an error because multiple listeners can run simultaneously only if there are multiple net service names.Answer:A You add the following code in the tnsnames.ora file on a client PC:Sales=(DESCRIPTION =(ADDRESS=(PROTOCOL=TCP)(HOST=salesdata)(PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=sales.acme)))Which statement is true about the code with respect to creating a new connect identifier?It is created for the sales database in the network domain ACME on the SALESDATA server.It is created for the SALESDATA database on the SALES server in the network domain called ACME.It generates an error because the connect identifier name cannot be a part of SERVICE_NAME.It generates an error because the server configuration mode (dedicated or shared) is not specified.Answer: A Which three statements are true about database storage structures?A data file can span across tablespacesAn extent contains one or more segmentsTablespaces contain one or more data files.Data objects are stored as segments in tablespaces.Segments can span across data files within a tablespace.Answer:C,D,EYou are about to apply a patch to a database. Which recommended action is incorrect?You should check the patch conflict with installed patches before applying the patch.You should make sure that you have a good backup of the software, database, and configuration files.You should install the latest OPatch before applying the patch.You should check the fifth digit of the release information to confirm that the Patch Set Update (PSU) is applied successfully.You should stop all applications running from the software directory that is being patched.Answer: DWhich type of information is included in dynamic performance views?1-System and session parameters2-Memory usage and allocation3-File states (include RMAN backup files)4-Progress of jobs and tasks5-SQL execution6-Statistics and Metrics3,4and 51,2,5 and 61,2,3 and 42,3,5 and 62,3,4,5 and 61,2,3,4,5 and 6Answer:FWhich three statements are true about System Global Area (SGA)?SGA contains shared memory structures for all Oracle processes running on a single server.Each server process has its own SGA.SGA is allocated automatically when a database is started.SGA is used to speed up queries by caching data blocks, program data, information about database objects, and query resultsSGA is allocated automatically when a database is mounted.SGA is read and written by server and background processes.Answer:C,D,FWhy does performance degrade when many update, insert or DELETE statements are issued on a table that has an associated bitmap index?The DML operations re-create the bitmap index blocksThe bitmap index is rebuilt automatically after a DML operationThe smallest amount of a bitmap that can be locked is a bitmap segment.Additional time is taken to remove NULL values from the bitmap index after a DML operation. Answer:CWhich two options can you use to list Oracle Database 12c patches by using Queryable Patch Inventory?Select patch from v$option where opatch_data=’333333’;Select xmltransform(dbms_qopatch.get_opatch_data(333333), dbms_qopatch.get_opatch_xslt()) from dual;Select opatch from v$patchsets where opatch_number=’333333’;Opatch lsinventory –xmlAnswer: B,DWhat new role in Oracle Database 12c encompasses the administrative privileges required for backup and recovery?SYSBKPSYSBKPRMANSYSRMANSYSBACKUPAnswer: DWhich statement is true about Enhanced Real time ADDM in Oracle DB 12c?The analyzed result is lost when the database instance is restarted.It run every 1 hour automaticallyIt is shipped only with Oracle Enterprise manager 12cIt analyzes high CPU trend and identifies problem before they can threaten application performance.Answer: DExamine the error:GSM-45054: GSM error or NET-40006: unable to start GSHWhat is the cause of this error, and what troubleshooting steps should you perform?The GDS catalog database or its listener may be down. Verify that the GDS catalog database and its local listener are running.The GDS pool database may be down. Make sure that the GDS pool databases are up and the service is enabled and started.The GDS pool database's local listener may be down. Make sure that it is running.The global service may be down. Verify that the pool databases are up and the service is started.The global service may be disabled. Make sure that the pool databases are up and the service is enabled and started.Answer: AWhich three events signal a database writer (DWR) to write buffers to disk? The database advances a checkpoint. A client process commits a transaction. The redo log buffer becomes full. A server process cannot find non-dirty blocks after scanning a threshold number of buffers. A tablespace is changed to read-only status. The database is shutdown in immediate mode.Answer: A,D,FWhich background processes are mandatory in a database Instance started with a minimally configured Initialization parameter file?Process Monitor Process (PMON)Flashback Data Archive process (FBDA)Space Management Coordinator process (SMCO)Recoverer process (RECO)Listener Registration process (LREG)Checkpoint process (CKPT)Answer: A,D,E,FOracle database 12c provides a new task specific (SYSBACKUP, SYSDG, and SYSKM) to handle standard administrative duties. Which two statements about these standard administration privileges are true?These administrative privileges enable you to connect to the database only if the database is open.After connecting with these privileges, you are connected under a predefined user whose name is the privilege name.These administrative privileges allow a user to view DBA_xxx, GV$, V$, and select on application tables.Without being a member of OSBACKUP, OSDG, and OSKM OS groups, users cannot connect as administrative users by using OS authentication.Answer: B,DExamine the following output –SQL> select index_name, status, from db_indexes where status=’UNUSABLE’;INDEX_NAMESTATUS----------------------EINDUNUSABLEWhich two statements are true about the index?It is ignored by the query optimizer.It is not used while the index is being rebuilt.The index cannot be rebuilt, and has to be recreated.The index is automatically rebuilt when used the next time.Answer: A,BAll database users are currently connected to the database instance and are working. The HR user opens three database sessions and execute this command in one of the sessions:SQL> update persons set ccode=’U031’ where ccode=’U029’;123 rows updated.SQL> delete from persons where exp=’Y’;3 rows deleted.The SYS user opens a new session after HR executes preceding commands. Which option represents the session that can see the effect of the UPDATE and DELETE commands?All sessions of the HR user.All sessions of the HR user and SYS user.The session of the HR user that executed the commands.All sessions for which database users have access privilege to the PERSONS table.Answer: CWhich three statements about replication options are true?The Oracle Streams information flow consists of three components: capture, redo transfer, arid consumption.Oracle Streams is deprecated in Oracle Database 12c Release 1.Oracle Database Advanced Replication is deprecated in Oracle Database 12c Release 1, including multi master replication, updatable materialized views, multitier materialized views, and deployment templates.Oracle Database Advanced Queuing is independent of Oracle Streams.The Oracle Golden Gate software architecture is composed of three primary components: capture, propagate, and trail files.Answer: B,C,DIdentify the three outcomes of using the Oracle multitenant option in Oracle Database 12c.Less index overheadIncreased storage costMinor application changesFast and easy provisioningSame time needed for patching and upgrade as in the previous release.IsolationAnswer: C,D,FWhich statement is true regarding the connect string?(DESCRIPTION= (FAILOVER=on) (ADDRESS_LIST= (LOAD_BALANCE=ON) (ADDRESS=(host=sales-east1)(port=1522)) (ADDRESS=(host=sales-east2)(port=1522)) (ADDRESS=(host=sales-east3)(port=1522))) (ADDRESS_LIST= (LOAD_BALANCE=ON) (ADDRESS=(host=sales-west1)(port=1522)) (ADDRESS=(host=sales-west2)(port=1522)) (ADDRESS=(host=sales-west3)(port=1522))) (CONNECT_DATA= (SERVICE_NAME=sales) (REGION=east)))It contains three global service managers in the client’s local region (east).Client-size load balancing has been enabled only for the global service managers within the client’s buddy (west).Connect-time failover between regions has not been enabled.The region parameter is optional.Answer: DYou connect to a database instance and execute a DML command that changes one data block. The block is read from the database buffer cache, and modified and marked as dirty. You commit the transaction. What must take place before the data block is written to disk?The buffer must be written to flash cache.A log writer (LGWR) must write all the redo entries that have been copied into the buffer since the last time it wrote.The modified data block must be moved from LRU list to the write queue.The database must advance the checkpoint.Answer: BIn Oracle Database 12c, when does a transaction begin? When a transaction ID is allocated for it When a user explicitly issues a "begin" statement When a transaction is assigned to an available undo data segment to record undo entries for the new transaction When the first executable SQL statement (DML or DDL) is encountered Answer: DYour customer is looking for zero-data-loss failover with maximum data protection and high availability for their primary database. Which two solutions would you recommend to the customer if the distance between the primary and the standby location is more than 300 miles? Asynchronous redo transport with Data Guard Synchronous redo transport with Data Guard Active Data Guard Far Sync Data Guard SQL Apply Answer:B,CWhich database feature can be used for organizing data when there is a very large amount of data?IndexPartitioningTriggersRow-level SecurityDatabase VaultAnswer: BYou create a CDB with four containers: the root, the seed, and two pluggable databases PDB1 and PDB2. Which four items can reside in PDB1, but not in the root?Shared UNDO and default database temporary tablespaceOracle-supplied metadataShared Oracle-supplied dataCDB views providing information across PDBsApplication tablespacesLocal temporary tablespacesLocal users and local rolesNon-shared local metadataAnswer: E,F,G,HExamine the command below: BEGIN DBMS_REDACT.ADD_POLICY(object_schema => 'mavis', object_name => 'cust_info', column_name => 'emp_id', policy_name => 'redact_cust_ids', function_type => DBMS_REDACT.REGEXP, expression => '1=1', regexp_pattern => '(\d\d\d)(\d\d)(\d\d\d\d)', regexp_replace_string => 'XXXXX\3', regexp_position => 1, regexp_occurrence => 0, regexp_match_parameter => 'i', policy_description => 'Redacts customer IDs', column_description => 'emp_id contains employee ID numbers'); END; / What do the regexp_pattern and regexp_replace_string parameters accomplish? They find a pattern of nine digits; break the digits into three groups that contain the first three, the next two, and then the last four digits; and replace all digits with XXXXX concatenated with the last four digits. They find a pattern of six digits; break the digits into two groups that contain the first five, and then the last digit; and replace all digits with XXXXX concatenated with the last digit. They find a pattern of nine digits and display the digits as XXXXX XX XXXX. They find a pattern of nine digits and display the first five digits as XXXXX and the last four digits as 3333. Answer: AWhich normalization is adopted in real-world database systems?1NF2NF3NFBCNFWhat happens when you execute these SQL statements?ALTER SYSTEM SET SGA_TARGET=992M;ALTER SYSTEM SET SHARED_POOL_SIZE=0;ALTER SYSTEM SET LARGE_POOL_SIZE=0;ALTER SYSTEM SET JAVA_POOL_SIZE=0;ALTER SYSTEM SET DB_CACHE_SIZE=0;ALTER SYSTEM SET STREAMS_POOL_SIZE=0;The database stops (shutdown abort).The database stops (shutdown immediate).You activate Automatic Shared Memory Management.You get an error message.Answer: CWhich two statements about Global Data Services (GDS) are correct?GDS allows scaling replication-aware application workloads beyond the cluster (that is, across replicated clusters.)GDS helps in performing data replication.GDS works seamlessly with any combination of oracle RAC database, single-instance database, oracle data guard, oracle active data guard, and oracle golden gate.GDS helps to perform database failovers, and does not require Data Guard Broker.The GDSMGRL utility is a command-line interface for configuring and managing the Global Data Services framework.Answer: A,CWhich three are initialization parameters for backup and recovery? CLONEDB FILESYSTEMIO_OPTIONS DB_CREATE_FILE_DEST RECYCLEBIN TAPE_ASYNCH_IO Answer:A,D,EIn which situation would you use static database registration for a listener?When multiple databases are to be registered with the listenerWhen DBAs need to connect remotely to start up the database instanceWhen users need to connect the database instance by using the host naming methodWhen the database instance to be registered with the listener is configured in shared server modeAnswer: BYour database crashes after a user accidently kills a background process. What are three possible ways to restart your database?$ sqlplus / as sysdbaSQL> restart;$ sqlplus / as sysdbaSQL> startup immediate;$ sqlplus / as sysdbaSQL> startup;$ sqlplus / as sysdbaSQL> startup open recover;$ srvctl start database –d $ORACLE_SIDAnswer:C,D,E Which two statements are true about the database buffer cache?When a buffer is read from the buffer cache, it may be inconsistent and require undo data to make it consistent.A buffer cache stores copies of data blocks from all files of the database.Buffer access is kept efficient by maintaining a least recently (LRU) list for dirty and clean buffers.A buffer cache always resides completely in System Global Area (SGA)A buffer cache contains exactly three pools: default, keep, and recycle bin.Answer:A,EYou want to drop a pluggable database from a multitenant container database that is used for development, which two statements are true?You can drop a PDB only if it is closed.You can drop a seed PDB, but you cannot create any other PDB within the CDB.You can drop the PDB and keep the keep the data files to be reused by another PDB. When you drop the PDB, the data files and redo log files are automatically removed from the storage file system.Answer: A,CWhich process is responsible for writing the contents of database buffers to data files?Process Monitor Process (PMON)Listener Registration Process (LREG)System Monitor Process (SMON)Database Writer Process (DBW)Log Writer Process (LGWR)Checkpoint Process (CKPT) Answer: DWhich two statements about multitenant architecture are true?It ensures full backward compatibility with non-CDBs.It fully operates with RAC.It is integrated with Enterprise manager, but not with the Resource Manager.It allows central management and administration of single databases.Answer: A,B ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download