1Z0-062 | Highest Quality Database 12c 1Z0-062 examcollection


Q61. Identify three valid methods of opening, pluggable databases (PDBs). 

A. ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from the root 

B. ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from a PDB 

C. ALTER PLUGGABLE DATABASE PDB OPEN issued from the seed 

D. ALTER DATABASE PDB OPEN issued from the root 

E. ALTER DATABASE OPEN issued from that PDB 

F. ALTER PLUGGABLE DATABASE PDB OPEN issued from another PDB 

G. ALTER PLUGGABLE DATABASE OPEN issued from that PDB 

Answer: A,E,G 

Explanation: E: You can perform all ALTER PLUGGABLE DATABASE tasks by connecting to a PDB and running the corresponding ALTER DATABASE statement. This functionality is provided to maintain backward compatibility for applications that have been migrated to a CDB environment. 

AG: When you issue an ALTER PLUGGABLE DATABASE OPEN statement, READ WRITE is the default unless a PDB being opened belongs to a CDB that is used as a physical standby database, in which case READ ONLY is the default. 

You can specify which PDBs to modify in the following ways: 

List one or more PDBs. 

Specify ALL to modify all of the PDBs. 

Specify ALL EXCEPT to modify all of the PDBs, except for the PDBs listed. 

Q62. Which two tasks can be performed on an external table? 

A. partitioning the table 

B. creating an invisible index 

C. updating the table by using an update statement 

D. creating a public synonym 

E. creating a view 

Answer: C,D 

Q63. A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 with SQL: 

There is enough free space in the disk group for mirroring to be done. 

What happens if the CONTROLLER1 failure group becomes unavailable due to error of for maintenance? 

A. Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall. 

B. Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 for failure group is brought back online. 

C. The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing is initiated. 

D. ASM does not mirror any data until the controller failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the controller2 failure group, without mirroring. 

E. Transactions accessing database objects contained in any tablespace stored in DGROUP1 will fail but queries will succeed. 

Answer:

Explanation: CREATE DISKGROUP NORMAL REDUNDANCY 

* For Oracle ASM to mirror files, specify the redundancy level as NORMAL REDUNDANCY (2-way mirroring by default for most file types) or HIGH REDUNDANCY (3-way mirroring for all files). 

Q64. You are connected to a pluggable database (PDB) as a common user with DBA privileges. The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following: SQL > ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = ‘*’ SCOPE = SPFILE; Which is true about the result of this command? 

A. The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened. 

B. The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened. 

C. The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted. 

D. Nothing happens; because there is no SPFILE for each PDB, the statement is ignored. 

Answer:

Explanation: 

Note: 

* In a container architecture, the parameters for PDB will inherit from the root database. That means if statistics_level=all in the root that will cascade to the PDB databases. 

You can over ride this by using Alter system set, if that parameter is pdb modifiable, there is a new column in v$system_parameter for the same. 

Q65. Which two statements are true about Oracle Managed Files (OMF)? 

A. OMF cannot be used in a database that already has data files created with user-specified directions. 

B. The file system directions that are specified by OMF parameters are created automatically. 

C. OMF can be used with ASM disk groups, as well as with raw devices, for better file management. 

D. OMF automatically creates unique file names for table spaces and control files. 

E. OMF may affect the location of the redo log files and archived log files. 

Answer: D,E 

Explanation: 

D: The database internally uses standard file system interfaces to create and delete files as needed for the following database structures: 

Tablespaces Redo log files Control files Archived logs Block change tracking files Flashback logs RMAN backups 

Note: 

* Using Oracle-managed files simplifies the administration of an Oracle Database. Oracle-managed files eliminate the need for you, the DBA, to directly manage the operating system files that make up an Oracle Database. With Oracle-managed files, you specify file system directories in which the database automatically creates, names, and manages files at the database object level. For example, you need only specify that you want to create a tablespace; you do not need to specify the name and path of the tablespace's datafile with the DATAFILE clause. 

http://www.oracle-base.com/articles/9i/oracle-managed-files.php http://docs.oracle.com/cd/B10500_01/server.920/a96521/omf.htm Reference: What Are Oracle-Managed Files? 

Q66. Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER by issuing the following command: 

1snrctl > STOP 

What happens to the sessions that are presently connected to the database Instance? 

A. They are able to perform only queries. 

B. They are not affected and continue to function normally. 

C. They are terminated and the active transactions are rolled back. 

D. They are not allowed to perform any operations until the listener LISTENER is started. 

Answer:

Explanation: The listener is used when the connection is established. The immediate impact of stopping the listener will be that no new session can be established from a remote host. Existing sessions are not compromised. 

Q67. You upgraded from a previous Oracle database version to Oracle Database version to Oracle Database 12c. Your database supports a mixed workload. During the day, lots of insert, update, and delete operations are performed. At night, Extract, Transform, Load (ETL) and batch reporting jobs are run. The ETL jobs perform certain database operations using two or more concurrent sessions. 

After the upgrade, you notice that the performance of ETL jobs has degraded. To ascertain the cause of performance degradation, you want to collect basic statistics such as the level of parallelism, total database time, and the number of I/O requests for the ETL jobs. 

How do you accomplish this? 

A. Examine the Active Session History (ASH) reports for the time period of the ETL or batch reporting runs. 

B. Enable SQL tracing for the queries in the ETL and batch reporting queries and gather diagnostic data from the trace file. 

C. Enable real-time SQL monitoring for ETL jobs and gather diagnostic data from the V$SQL_MONITOR view. 

D. Enable real-time database operation monitoring using the DBMS_SQL_MONITOR.BEGIN_OPERATION function, and then use the DBMS_SQL_MONITOR.REPORT_SQL_MONITOR function to view the required information. 

Answer:

Explanation: * Monitoring database operations Real-Time Database Operations Monitoring enables you to monitor long running database tasks such as batch jobs, scheduler jobs, and Extraction, Transformation, and Loading (ETL) jobs as a composite business operation. This feature tracks the progress of SQL and PL/SQL queries associated with the business operation being monitored. As a DBA or developer, you can define business operations for monitoring by explicitly specifying the start and end of the operation or implicitly with tags that identify the operation. 

Q68. Examine the memory-related parameters set in the SPFILE of an Oracle database: 

memory_max_target—6G memory_target=5G pga_aggregate_target=500M sga_max_size=0 sga_target=0 

Which statement is true? 

A. Only SGA components are sized automatically-

B. Memory is dynamically re-allocated between the SGA and PGA as needed. 

C. The size of the PGA cannot grow automatically beyond 500 MB. 

D. The value of the MEMORY_TARGET parameter cannot be changed dynamically. 

Answer:

Q69. Which three statements are true about Automatic Workload Repository (AWR)? 

A. All AWR tables belong to the SYSTEM schema. 

B. The AWR data is stored in memory and in the database. 

C. The snapshots collected by AWR are used by the self-tuning components in the database 

D. AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views. 

E. AWR contains system wide tracing and logging information. 

Answer: B,C,E 

Explanation: * A fundamental aspect of the workload repository is that it collects and persists database performance data in a manner that enables historical performance analysis. The mechanism for this is the AWR snapshot. On a periodic basis, AWR takes a “snapshot” of the current statistic values stored in the database instance’s memory and persists them to its tables residing in the SYSAUX tablespace. 

* AWR is primarily designed to provide input to higherlevel components such as automatic tuning algorithms and advisors, but can also provide a wealth of information for the manual tuning process. 

Q70. You are administering a database and you receive a requirement to apply the following restrictions: 

1. A connection must be terminated after four unsuccessful login attempts by user. 

2. A user should not be able to create more than four simultaneous sessions. 

3. User session must be terminated after 15 minutes of inactivity. 

4. Users must be prompted to change their passwords every 15 days. 

How would you accomplish these requirements? 

A. by granting a secure application role to the users 

B. by creating and assigning a profile to the users and setting the REMOTE_OS_AUTHENT parameter to FALSE 

C. By creating and assigning a profile to the users and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameter to 4 

D. By Implementing Fine-Grained Auditing (FGA) and setting the REMOTE_LOGIN_PASSWORD_FILE parameter to NONE. 

E. By implementing the database resource Manager plan and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameters to 4. 

Answer:

Explanation: You can design your applications to automatically grant a role to the user who is trying to log in, provided the user meets criteria that you specify. To do so, you create a secure application role, which is a role that is associated with a PL/SQL procedure (or PL/SQL package that contains multiple procedures). The procedure validates the user: if the user fails the validation, then the user cannot log in. If the user passes the validation, then the procedure grants the user a role so that he or she can use the application. The user has this role only as long as he or she is logged in to the application. When the user logs out, the role is revoked. 

Incorrect: 

Not B: REMOTE_OS_AUTHENT specifies whether remote clients will be authenticated with the value of the OS_AUTHENT_PREFIX parameter. 

Not C, not E: SEC_MAX_FAILED_LOGIN_ATTEMPTS specifies the number of authentication attempts that can be made by a client on a connection to the server process. 

After the specified number of failure attempts, the connection will be automatically dropped by the server process. 

Not D: REMOTE_LOGIN_PASSWORDFILE specifies whether Oracle checks for a password file. 

Values: 

shared 

One or more databases can use the password file. The password file can contain SYS as well as non-SYS users. 

exclusive 

The password file can be used by only one database. The password file can contain SYS as well as non-SYS users. 

none 

Oracle ignores any password file. Therefore, privileged users must be authenticated by the operating system. 

Note: 

The REMOTE_OS_AUTHENT parameter is deprecated. It is retained for backward compatibility only.