1Z0-052 Exam Dumps | You receive complaints from users regarding the high waiting time for their transactions. On investigation,

<< Prev Question Next Question >>

Question 128/200

You receive complaints from users regarding the high waiting time for their transactions. On investigation, you find that some users are not committing their transactions though they are not performing any activity for a long time. As a result, SQL statements need to wait for rowlevel locks. Which two actions could you take to prevent this locking problem in the future? (Choose two.)

A. Decrease the IDLE_TIME resource limit in the profile assigned to the blocking users.

B. Use Database Resource Manager to automatically log out sessions that block others and are idle

C. Set the limit in the profile of blocking users to control the number of blocks to be accessed in a session.

D. Decrease the maximum number of interested transaction list (ITL) slots for the segments on which the blocking user performs the transaction.

Question List (200q): Question 1: A database user SMITH tries to query the V$SESSION view and ...; Question 2: After performing a clean shut down of the database instance ...; Question 3: Automatic Shared Memory Management is disabled for your data...; Question 4: You have an ORDERS table with the following structure: (Exhi...; Question 5: User SCOTT wants to perform a bulk insert operation in the E...; Question 6: Examine the following output: (Exhibit) Which two statements...; Question 7: Which two statements are true regarding Oracle Data Pump? (C...; Question 8: You want to create a role to meet these requirements: 1. The...; Question 9: You want to move all objects of the APPS user in the test da...; Question 10: In a new installation of Oracle Database 11g, you perform th...; Question 11: You used the IMMEDIATE option to shutdown your database inst...; Question 12: Which two statements are true regarding listeners? (Choose t...; Question 13: In your database instance, the user sessions are connected t...; Question 14: View the Exhibit. (Exhibit) You are creating an additional d...; Question 15: Note the following points describing various utilities in Or...; Question 16: View the Exhibit and examine the attributes of an undo table...; Question 17: A constraint in a table is defined with the INITIALLY IMMEDI...; Question 18: You plan to move data from a flat file to a table in your da...; Question 19: A database user SMITH tries to query the V$SESSION view and ...; Question 20: Automatic Shared Memory Management (ASMM) has been enabled f...; Question 21: View the Exhibit to examine the output of the DBA_OUTSTANDIN...; Question 22: You are using Enterprise Manager to schedule backups for you...; Question 23: Which two statements are true about checkpointing? (Choose t...; Question 24: Identify the logical structure that will never have more tha...; Question 25: Examine the command that is used to create a table: SQL> ...; Question 26: You execute a command to resize a data file, sales.dbf, of s...; Question 27: Which two statements are true regarding the Oracle Data Pump...; Question 28: Which statement is true regarding undo tablespace?...; Question 29: Examine the command: SQL>DBMS_STATS.SET_TABLE_PREFS('SH',...; Question 30: The session of user SCOTT receives the following error after...; Question 31: Your database instance is running. db01is a net service name...; Question 32: Which two statements are true regarding the usage of the SQL...; Question 33: You execute the following command to change the status of th...; Question 34: Note the following functionalities of various background pro...; Question 35: Which three statements are true about logical structures of ...; Question 36: In which situation may the UNDO_RETENTION parameter be ignor...; Question 37: Your test database is configured to run in NOARCHIVELOGmode....; Question 38: Which three statements are correct about temporary tables? (...; Question 39: The database instance is currently using SPFILE. View the Ex...; Question 40: Which is the correct description of a pinned buffer in the d...; Question 41: Which naming method uses the tnsnames.ora file to store the ...; Question 42: Your database instance is configured with automatic undo man...; Question 43: Evaluate the following code: (Exhibit) Which naming method c...; Question 44: You have recently collected statistics on certain objects of...; Question 45: Given below is a list of scenarios: 1. A user terminates his...; Question 46: View the Exhibit and examine the parameters. User A executes...; Question 47: View the Exhibit and examine the PL/SQL package and procedur...; Question 48: Examine the values for the following initialization paramete...; Question 49: In which three situations does the Oracle Data Pump use exte...; Question 50: Identify two situations in which the block header grows in a...; Question 51: In which situation may the UNDO_RETENTIONparameter be ignore...; Question 52: View the Exhibit and note the files available in the $ORACLE...; Question 53: You are managing an Oracle Database 11g database. You config...; Question 54: The database is running in ARCHIVELOG mode. Examine the init...; Question 55: You are working on an instance started using the SPFILE. You...; Question 56: Which of these is true about undo tablespace?...; Question 57: Which two statements are true regarding B-tree index? (Choos...; Question 58: Which statement is true about a whole consistent database ba...; Question 59: The instance abnormally terminates because of a power outage...; Question 60: Identify the two situations in which the alert log file is u...; Question 61: Your database is open and the LISTENER listener is running. ...; Question 62: In your database, the current status of a PL/SQL procedure h...; Question 63: You are in the middle of a transaction updating a very impor...; Question 64: Which statement describes the effect on an index, when the i...; Question 65: While observing the index statistics, you find that an index...; Question 66: You set the following parameters in the parameter file and r...; Question 67: Examine the commands executed in the following sequence: (Ex...; Question 68: Which two statements are true about standard database auditi...; Question 69: The instance abnormally terminates because of a power outage...; Question 70: The TRANS_SUMMARY table contains product-wise transaction de...; Question 71: The user HRreceives the following error while inserting data...; Question 72: What can you achieve by implementing reverse key index?...; Question 73: Which two activities are NOT supported by the Data Recovery ...; Question 74: See the Exhibit: (Exhibit) Identify the component marked wit...; Question 75: Which two statements are true regarding transactions in an O...; Question 76: You are managing an Oracle Database 11g database with the fo...; Question 77: In which of the scenario will the DBA perform recovery? (Cho...; Question 78: Which two statements are true regarding the SGA_TARGET initi...; Question 79: Your database is in shutdown state. What will happend if you...; Question 80: You have statistics collected for some selected tables. Your...; Question 81: View the Exhibits and examine lock waits. Users HR and SH co...; Question 82: Which two statements describe good practices for an applicat...; Question 83: You are managing an Oracle Database 11g database. You want t...; Question 84: View the Exhibit to examine the output for the CROSSCHECK BA...; Question 85: Which three statements are correct about temporary tables? (...; Question 86: Which two statements are true about the Automatic Workload R...; Question 87: You executed the following command to create a tablespace ca...; Question 88: You perform differential incremental level 1 backups of your...; Question 89: Which two statements are true regarding a tablespace? (Choos...; Question 90: You are managing an Oracle Database 11g database running in ...; Question 91: Note the functionalities of various background processes: 1:...; Question 92: SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SU...; Question 93: You executed this command to create a temporary table: SQL&g...; Question 94: Your database instance is currently configured to support 1,...; Question 95: In a system, large online transaction processing (OLTP) jobs...; Question 96: A user, who is authenticated externally, logs in to a remote...; Question 97: Your database instance is started using the server parameter...; Question 98: View the Exhibit and examine the user information. The user ...; Question 99: Your database instance is functional for the past one month....; Question 100: Some non-DBA users in your database have been granted ANY TA...; Question 101: You executed the following commands to find the location of ...; Question 102: These are points that describe the contents of different mem...; Question 103: View the Exhibit and examine the output of the query. (Exhib...; Question 104: You plan to configure the new Oracle Database 11g installati...; Question 105: View the Exhibit and examine the attributes of an undo table...; Question 106: Which two kinds of failures make the Data Recovery Advisor (...; Question 107: Which two operations can be performed on an external table? ...; Question 108: Which two statements are true regarding undo tablespaces? (C...; Question 109: In which situation would you use static database registratio...; Question 110: The tnsnames.ora file has an entry for the service alias ORC...; Question 111: Which statement is true about loading data using the convent...; Question 112: You are working on a new Oracle Database 11g server, where o...; Question 113: You plan to implement the distributed database system in you...; Question 114: View the Exhibit to examine the details for an incident. (Ex...; Question 115: Examine the following steps performed on a database instance...; Question 116: The job to gather optimizer statistics for objects runs as p...; Question 117: You are installing Oracle Database 11g on your server. Durin...; Question 118: What function is performed by the System Monitor (SMON) back...; Question 119: View the Exhibit and examine the undo tablespace attributes....; Question 120: Identify two situations in which you can use Data Recovery A...; Question 121: View the Exhibit and examine the command used to create the ...; Question 122: You have to create a table, STUDENTS, with the columns: STUD...; Question 123: The database is running in ARCHIVELOG mode. Examine the init...; Question 124: Which two statements are true about setting the FAST_START_M...; Question 125: You created a profile APP_USERand assigned it to the users. ...; Question 126: Which three operations require undo data? (Choose three.)...; Question 127: View Exhibit1 and Exhibit2 to examine the current memory all...; Question 128: You receive complaints from users regarding the high waiting...; Question 129: You want to check the details of few errors that users have ...; Question 130: Note the following points describing various utilities in Or...; Question 131: In your database instance, the STATISTICS_LEVEL initializati...; Question 132: Examine the following statement that is used to modify the p...; Question 133: Observe the information in the columns: (Exhibit) Which opti...; Question 134: User A executes the following command to drop a large table ...; Question 135: Your database is functional with a peak load for the last on...; Question 136: You execute this command to drop the ITEM table, which has t...; Question 137: Examine the command: SQL>ALTER USR skd ACCOUNT LOCK; Whic...; Question 138: You have a large amount of historical data in a flat file. S...; Question 139: You executed the following command to perform a backup of th...; Question 140: View the Exhibit and examine the setting for a table. (Exhib...; Question 141: In which situations does the Oracle Data Pump use external t...; Question 142: You notice that the performance of the database has degraded...; Question 143: View the Exhibit. What would happen if Oracle Home is not em...; Question 144: User SCOTTexecutes the following command on the EMPtable but...; Question 145: Which statements listed below describe the data dictionary v...; Question 146: Which three statements regarding the server parameter file (...; Question 147: See the Exhibit: (Exhibit) Which statements are true regardi...; Question 148: You configured the Flash Recovery Area for your database. Th...; Question 149: The user SCOTT owns the CUST table that is placed in the SAL...; Question 150: View the Exhibit and examine the privileges granted to the S...; Question 151: You are working on a database that must be functioning 24 ho...; Question 152: You are managing an Oracle Database 11g database. The databa...; Question 153: View the Exhibit and examine the output. (Exhibit) Which two...; Question 154: Note the following structures in your database server: 1. Ex...; Question 155: The database instance has the following parameter setting: O...; Question 156: You executed the following command to create a password file...; Question 157: Examine the values for the following initialization paramete...; Question 158: Identify the two situations in which you use the alert log f...; Question 159: The HR user creates a stand-alone procedure as follows and g...; Question 160: You have issued a SHUTDOWN ABORTcommand to bring down your d...; Question 161: The instance abnormally terminates because of a power outage...; Question 162: SQL> CREATE BIGFILE TABLESPACE MRKT 2 DATAFILE '/u01/app/...; Question 163: You have issued a SHUTDOWN ABORTcommand to bring down your d...; Question 164: Examine the values for the following initialization paramete...; Question 165: Which two statements are true about alerts? (Choose two.)...; Question 166: View the Exhibit to examine the output produced by the follo...; Question 167: You suspect unauthorized data manipulation language (DML) op...; Question 168: Which two statements are true about Shared SQL Area and Priv...; Question 169: Why does performance degrade when many UPDATE, INSERT or DEL...; Question 170: Which three descriptions are correct about the effects of th...; Question 171: The user HR owns the EMP table. The user HR grants privilege...; Question 172: Which tablespaces are mandatory in an Oracle database for it...; Question 173: You have two database servers SEMPand SACCT. The database in...; Question 174: Your database is configured in shared server mode. However, ...; Question 175: For which database operation would you need the database to ...; Question 176: Which two statements correctly describe the relation between...; Question 177: Your database is down. You log in as the user SYSand issue t...; Question 178: You want to access employee details contained in flat files ...; Question 179: Which task would you perform before you run Oracle Universal...; Question 180: View the Exhibit to examine the error that occurred during t...; Question 181: View the Exhibit and examine the initialization parameter se...; Question 182: You configured the flash recovery area (FRA) for your databa...; Question 183: You have executed this command to change the size of the dat...; Question 184: Which statements are true regarding the creation of an incid...; Question 185: You want to enable archiving on your database. Presently, th...; Question 186: Which two statements are true about the Automatic Database D...; Question 187: You are installing Oracle Database 11g on a machine. When yo...; Question 188: Which two statements about the background process of the dat...; Question 189: In your production database, data manipulation language (DML...; Question 190: You created a profile APP_USERand assigned it to the users. ...; Question 191: You have two tables with referential integrity enforced betw...; Question 192: All the database users are presently connected to the databa...; Question 193: You have set Tablespace Full Metrics Threshold values for th...; Question 194: Identify the memory component from which memory may be alloc...; Question 195: View the Exhibit and examine the privileges granted to the M...; Question 196: You are using flat files as the data source for one of your ...; Question 197: Which two statements are true regarding a PL/SQL package bod...; Question 198: Your database instance is running with full workload after d...; Question 199: |View the Exhibit to observe the roles assigned to the SL_RE...; Question 200: Which two statements are true regarding listeners? (Choose t...

Question 128/200

LEAVE A REPLY

Download PDF File