Get Latest [Sep-2021] Conduct effective penetration tests using TrainingDump 1z0-062
Penetration testers simulate 1z0-062 exam PDF
NEW QUESTION 168
The ORCL database is configured to support shared server mode. You want to ensure that a user connecting remotely to the database instance has a one-to-one ratio between client and server processes.
Which connection method guarantees that this requirement is met?
- A. connecting by using the local naming method with the server = dedicated parameter set in the tnsnames.ora file for the net service
- B. connecting by using a directory naming method
- C. creating a service in the database by using the dbms_service.create_service procedure and using this service for creating a local naming service
- D. connecting by using an external naming method
- E. connecting by using the easy connect method
Answer: B,C
Explanation:
Explanation/Reference:
Explanation:
NEW QUESTION 169
You Execute the Following command to create a password file in the database server:
$ orapwd file = ‘+DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12’ Which two statements are true about the password file? (Choose two.)
- A. It contains the usernames and passwords of users for whom auditing is enabled.
- B. It supports the SYSBACKUP, SYSDG, and SYSKM system privileges.
- C. Is used by Oracle to authenticate users for remote database administration.
- D. It records the usernames and passwords of all users when they are added to the OSDBA or OSOPER operating system groups.
- E. It records the usernames and passwords of users when granted the DBA role.
Answer: B,C
Explanation:
Explanation/Reference:
Explanation:
NEW QUESTION 170
Examine these two statements:
Which three are true about the MRKT tablespace?
- A. The MRKT tablespace may be dropped if it has no contents.
- B. The MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required
for big file files. - C. The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT
tablespace. - D. No more data files can be added to the tablespace.
- E. Users who were using the old default tablespace will have their default tablespaces changed to the MRKT
tablespace.
Answer: A,D,E
NEW QUESTION 171
A PFILE exists for your database. You want to increase the value of the PROCESSES parameter from 300 to
400 and make it persistent for your database instance.
You plan to use the ALTER SYSTEM command.
Which two methods can be used? (Choose two.)
- A. Create an SPFILE, start the database instance by using the SPFILE, and then execute the ALTER SYSTEM SET PROCESSES=400 SCOPE=SPFILE command.
- B. Edit PFILE manually, re-create the SPFILE from the edited PFILE, and restart the database instance by using the SPFILE.
- C. Start the database instance by using the PFILE, and then execute the ALTER SYSTEM SET PROCESSES=400 SCOPE=BOTH command.
- D. Create an SPFILE, STARTUP MOUNT the database instance by using the SPFILE, and then execute the ALTER SYSTEM SET PROCESSES=400 command.
- E. Create an SPFILE, start the database instance by using the SPFILE, and then execute the ALTER SYSTEM SET PROCESSES=400 SCOPE=DEFERRED command.
- F. Use the PFILE to STARTUP MOUNT the database instance, and then execute the ALTER SYSTEM SET PROCESSES=400 command.
Answer: E,F
NEW QUESTION 172
In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time.
How would you accomplish this?
- A. Implementing Database Resource Manager
- B. Enabling resumable timeout for user sessions
- C. Setting a metric threshold
- D. Decreasing the value of the IDLE_TIME resource limit in the default profile
Answer: D
Explanation:
Explanation/Reference:
Explanation:
An Oracle session is sniped when you set the idle_time parameter to disconnect inactive sessions. (It's only like sniping on ebay in that a time is set for an action to occur.) Oracle has several ways to disconnect inactive or idle sessions, both from within SQL*Plus via resources profiles (connect_time, idle_time), and with the SQL*net expire time parameter. Here are two ways to disconnect an idle session:
Set the idle_time parameter in the user profile
Set the sqlnet.ora parameter expire_time
NEW QUESTION 173
You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces are created by
default in HR_PDB?
- A. SYSAUX
- B. SYSTEM
- C. EXAMPLE
- D. TEMP
- E. UNDO
- F. USERS
Answer: A,B,D
Explanation:
* A PDB would have its SYSTEM, SYSAUX, TEMP tablespaces.It can also contains other user created tablespaces in it.
* Oracle Database creates both the SYSTEM and SYSAUX tablespaces as part of every database.
* tablespace_datafile_clauses
Use these clauses to specify attributes for all data files comprising the SYSTEM and SYSAUX tablespaces in the seed
PDB.
Incorrect:
Not D: a PDB can not have an undo tablespace. Instead, it uses the undo tablespace belonging to the CDB.
Note:
* Example:
CONN pdb_admin@pdb1
SELECT tablespace_name FROM dba_tablespaces;
TABLESPACE_NAME
------------------------------
SYSTEM
SYSAUX
TEMP
USERS
SQL>
NEW QUESTION 174
Your database is open in read/write mode and multiple users are connected to the database instance.
You execute the following command:
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;
What would be the effect on current sessions?
- A. They are not affected.
- B. They are not terminated but may only issue queries.
- C. They are terminated immediately.
- D. They are terminated after completing the transaction.
Answer: A
NEW QUESTION 175
Which two are prerequisites for performing a flashback transaction?
- A. Flashback Database must be enabled.
- B. Recycle bin must be enabled for the database.
- C. EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.
- D. Undo retention guarantee for the database must be configured.
- E. Block change tracking must be enabled tor the database.
- F. Supplemental logging must be enabled.
Answer: D,F
Explanation:
References:http://searchoracle.techtarget.com/tip/How-to-perform-Oracle-Flashback-
Transaction-Queries
NEW QUESTION 176
Which three resources might be prioritized between competing pluggable databases when creating a multitenant container database plan (CDB plan) using Oracle Database Resource Manager? (Choose three.)
- A. Exadata I/O
- B. CPU
- C. Parallel server limit
- D. Maximum Idle time
- E. Maximum Undo per consumer group
- F. Local file system I/O
Answer: A,B,C
NEW QUESTION 177
You execute the following PL/SQL:
Which two statements are true? (Choose two.)
- A. FGA is enabled for all DML operations by JIM on the PRODUCTS.PRICE column.
- B. FGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial.
- C. Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE > 10000 is accessed.
- D. FGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE > 10000 is accessed.
Answer: C,D
Explanation:
Explanation
DBMS_FGA.add_policy
* The DBMS_FGA package provides fine-grained security functions.
* ADD_POLICY Procedure
This procedure creates an audit policy using the supplied predicate as the audit condition.
Incorrect:
Not C: object_schema
The schema of the object to be audited. (If NULL, the current log-on user schema is assumed.)
NEW QUESTION 178
Which two partitioned table maintenance operations support asynchronous Global Index Maintenance in Oracle database 12c? (Choose two.)
- A. ALTER TABLE ADD PARTITION
- B. ALTER TABLE TRUNCATE PARTITION
- C. ALTER TABLE MERGE PARTITION
- D. ALTER TABLE DROP PARTITION
- E. ALTER TABLE MOVE PARTITION
- F. ALTER TABLE SPLIT PARTITION
Answer: B,D
Explanation:
Asynchronous Global Index Maintenance for DROP and TRUNCATE PARTITION
This feature enables global index maintenance to be delayed and decoupled from a DROP and TRUNCATE partition without making a global index unusable. Enhancements include faster DROP and TRUNCATE partition operations and the ability to delay index maintenance to off-peak time.
References:
NEW QUESTION 179
Examine the parameters:
Users complain that their sessions for certain transactions hang. You investigate and discover that some users fail to complete their transactions, causing other transactions to wait on row-level locks.
Which two actions would you take to prevent this problem? (Choose two.)
- A. Decrease the SESSIONS_PER_USER limit in the profiles assigned to blocking users.
- B. Use Database Resource Manager to automatically kill the sessions that are idle and are blocking other sessions.
- C. Increase the maximum number of ITL slots for segments on which a blocking user performs a transaction.
- D. Set a limit in the proles of blocking users to control the number of data blocks that can be accessed in a session.
- E. Decrease the IDLE_TIME resource limit in the profiles assigned to blocking users.
Answer: A,B
NEW QUESTION 180
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. 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. - 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. Examine the Active Session History (ASH) reports for the time period of the ETL or batch reporting runs.
Answer: A
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.
NEW QUESTION 181
You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c.
Examine the table definition:
Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table? (Choose three.)
- A. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.
- B. The valid time columns employee_time_start and employee_time_end are automatically created.
- C. The valid time columns are visible by default when the table is described.
- D. The valid time columns are not populated by the Oracle Server automatically.
- E. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.
Answer: A,B,D
NEW QUESTION 182
Which statement is true about using the Database Upgrade Assistant (DBUA) to upgrade your database from Oracle Database 11g to Oracle Database 12c?
- A. It terminates if the SYSTEM tablespace in the source database is not autoextensible.
- B. It automatically enables unified auditing in the upgraded database.
- C. It automatically makes necessary changes to Oracle environment variables.
- D. Itautomatically adds new data files if there is not enough disk space to grow.
Answer: D
Explanation:
References:https://docs.oracle.com/cd/E18283_01/server.112/e17222/upgrade.htm#insert edID5
NEW QUESTION 183
Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information lifecycle Management (ILM)?
- A. Tracking the most recent write time for a table segment in the SYSAUX tablespace
- B. Tracking the most recent write time for a table block
- C. Tracking insert time by row for table rows
- D. Tracking the most recent read time for a table segment in a user tablespace
- E. Tracking the most recent read time for a table segment in the SYSAUX tablespace
- F. Tracking the most recent write time for a table segment in a user tablespace
Answer: B,D,F
Explanation:
Explanation/Reference:
Explanation:
Incorrect:
Not E, Not F When Heat Map is enabled, all accesses are tracked by the in-memory activity tracking module. Objects in the SYSTEM and SYSAUX tablespaces are not tracked.
* To implement your ILM strategy, you can use Heat Map in Oracle Database to track data access and modification.
Heat Map provides data access tracking at the segment-level and data modification tracking at the segment and row level.
* To implement your ILM strategy, you can use Heat Map in Oracle Database to track data access and modification. You can also use Automatic Data Optimization (ADO) to automate the compression and movement of data between different tiers of storage within the database.
References:
NEW QUESTION 184
You created an encrypted tablespace:
You then closed the encryption wallet because you were advised that this is secure.
Later in the day, you attempt to create the EMPLOYEES table in the SECURESPACE tablespace with the SALT option on
the EMPLOYEE column.
Which is true about the result?
- A. It generates an error when creating the table because the wallet is closed.
- B. It creates the table successfully but does not encrypt any inserted data in the EMPNAME column because the
wallet must be opened to encrypt columns with SALT. - C. It creates the table successfully, and encrypts any inserted data in the EMPNAME column because the wallet needs
to be open only for tablespace creation. - D. It generates error when creating the table, because the salt option cannot be used with encrypted tablespaces.
Answer: C
Explanation:
* The environment setup for tablespace encryption is the same as that for transparent data encryption. Before
attempting to create an encrypted tablespace, a wallet must be created to hold the encryption key.
* Setting the tablespace master encryption key is a one-time activity. This creates the master encryption key for
tablespace encryption. This key is stored in an external security module (Oracle wallet) and is used to encrypt the
tablespace encryption keys.
* Before you can create an encrypted tablespace, the Oracle wallet containing the tablespace master encryption key
must be open. The wallet must also be open before you can access data in an encrypted tablespace.
* Salt is a way to strengthen the security of encrypted data. It is a random string added to the data before it is
encrypted, causing repetition of text in the clear to appear different when encrypted. Salt removes the one common
method attackers use to steal data, namely, matching patterns of encrypted text.
* ALT | NO SALT By default the database appends a random string, called "salt," to the clear text of the column before
encrypting it. This default behavior imposes some limitations on encrypted columns:
/ If you specify SALT during column encryption, then the database does not compress the data in the encrypted
column even if you specify table compression for the table. However, the database does compress data in
unencrypted columns and encrypted columns without the SALT parameter.
NEW QUESTION 185
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. 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.
- B. 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.
- C. Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.
- D. The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing is initiated.
- E. Transactions accessing database objects contained in any tablespace stored in DGROUP1 will fail but queries will succeed.
Answer: B
NEW QUESTION 186
The performance of your database degrades between 11:00 AM and 3:00 PM. Automatic Workload
Repository (AWR) snapshots are collected on an hourly basis.
What is the most efficient way of diagnosing this problem?
- A. Analyze the hourly ADDM reports generated between 11:00 AM and 3:00 PM.
- B. Create a custom ADDM task for the period defined by the snapshots taken between 11:00 AM and
3:00 PM. - C. Analyze the latest Automatic Database Diagnostic Monitor (ADDM) report.
- D. Create a SQL Tuning Set (STS) for the currently cached SQL statements in the shared pool and run
SQL Performance Analyzer (SPA) to generate recommendations.
Answer: B
NEW QUESTION 187
......
Tested Material Used To 1z0-062 Test Engine: https://www.trainingdump.com/Oracle/1z0-062-practice-exam-dumps.html
Steps Necessary To Pass The 1z0-062 Exam: https://drive.google.com/open?id=1wnqblIzAc0gV9U24Qzc3hWgP6UxjG2dX