Valid 1Z0-052 Dumps shared by ExamDiscuss.com for Helping Passing 1Z0-052 Exam! ExamDiscuss.com now offer the newest 1Z0-052 exam dumps, the ExamDiscuss.com 1Z0-052 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 1Z0-052 dumps with Test Engine here:
Access 1Z0-052 Dumps Premium Version
(285 Q&As Dumps, 35%OFF Special Discount Code: freecram)
<< Prev Question Next Question >>
Question 5/200
User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives the following error after the INSERT statement is issued and few rows are inserted:
INSERT INTO EMP_DEP (emp_id,name,salary,dep_name,mgr_id)
* ERROR at line 1:
ORA-01653: unable to extend table SCOTT.EMP_DEP by 128 in tablespace USERS Identify two actions either of which will help you resolve this problem. (Choose two.)
INSERT INTO EMP_DEP (emp_id,name,salary,dep_name,mgr_id)
* ERROR at line 1:
ORA-01653: unable to extend table SCOTT.EMP_DEP by 128 in tablespace USERS Identify two actions either of which will help you resolve this problem. (Choose two.)
Correct Answer: B,E
Explanation/Reference:
Explanation:
The Oracle docs note this on the ora-01653 error:
ORA-01653: unable to extend table string.string by string in tablespace string Cause: Failed to allocate an extent of the required number of blocks for a table segment in the tablespace indicated.
Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.
Oracle MOSC Documents offer great resources on resolving ORA-01653, namely the nature of the problem as it relates to space availability:
------------
This error does not necessarily indicate whether or not you have enough space in the tablespace, it merely indicates that Oracle could not find a large enough area of free contiguous space in which to fit the next extent.
Diagnostic Steps:
-----------------
1. In order to see the free space available for a particular tablespace, you must use the view DBA_FREE_SPACE. Within this view, each record represents one fragment of space. How the view DBA_FREE_SPACE can be used to determine the space available in the database is described in Note
121259.1 Using DBA_FREE_SPACE
Furthermore, MOSC offers these choices in resolving ORA-01653 (as quoted below):
Manually COALESCE Adjacent Free Extents
Add a DATAFILE
Resize DATAFILE
Enable AUTOEXTEND
Defragment tablespace
View temporary segments for space
Explanation:
The Oracle docs note this on the ora-01653 error:
ORA-01653: unable to extend table string.string by string in tablespace string Cause: Failed to allocate an extent of the required number of blocks for a table segment in the tablespace indicated.
Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.
Oracle MOSC Documents offer great resources on resolving ORA-01653, namely the nature of the problem as it relates to space availability:
------------
This error does not necessarily indicate whether or not you have enough space in the tablespace, it merely indicates that Oracle could not find a large enough area of free contiguous space in which to fit the next extent.
Diagnostic Steps:
-----------------
1. In order to see the free space available for a particular tablespace, you must use the view DBA_FREE_SPACE. Within this view, each record represents one fragment of space. How the view DBA_FREE_SPACE can be used to determine the space available in the database is described in Note
121259.1 Using DBA_FREE_SPACE
Furthermore, MOSC offers these choices in resolving ORA-01653 (as quoted below):
Manually COALESCE Adjacent Free Extents
Add a DATAFILE
Resize DATAFILE
Enable AUTOEXTEND
Defragment tablespace
View temporary segments for space
- 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...
