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 122/170
You execute the following command to change the status of the SALES tablespace:
SQL> ALTER TABLESPACE sales OFFLINE;
Which statements describe the effect of the command? (Choose all that apply.)
SQL> ALTER TABLESPACE sales OFFLINE;
Which statements describe the effect of the command? (Choose all that apply.)
Correct Answer: B,C
Explanation/Reference:
Explanation:
Altering a Tablespace (continued)
* Offline: You can take an online tablespace offline so that this portion of the database is temporarily unavailable for general use. The rest of the database is open and available for users to access data. When you take it offline, you can use the following options:
- Normal: A tablespace can be taken offline normally if no error conditions exist for any of the data files of the tablespace. Oracle Database ensures that all data is written to disk by taking a checkpoint for all data files of the tablespace as it Takes Them offline.
- Temporary: A tablespace can be taken offline temporarily even if there are error conditions for one or more files of the tablespace. Oracle Database takes the data files (which are not already offline) offline, performing checkpointing on them as it does so. If no files are offline, but you use the Temporary clause, media recovery is not required to bring the tablespace back online. However, if one or more files of the tablespace are offline because of write errors, and you take the tablespace offline temporarily, the tablespace requires recovery before you can bring it back online.
- Immediate: A tablespace can be taken offline immediately without Oracle Database taking a checkpoint on any of the data files. When yon specify Immediate, media recovery for the tablespace is required before the tablespace can be brought online. You cannot take a tablespace offline immediately if the database is running in NOARCHIVELOG mode.
- For Recover: The FOR RECOVER setting has been deprecated. The syntax is supported for backward compatibility.
Explanation:
Altering a Tablespace (continued)
* Offline: You can take an online tablespace offline so that this portion of the database is temporarily unavailable for general use. The rest of the database is open and available for users to access data. When you take it offline, you can use the following options:
- Normal: A tablespace can be taken offline normally if no error conditions exist for any of the data files of the tablespace. Oracle Database ensures that all data is written to disk by taking a checkpoint for all data files of the tablespace as it Takes Them offline.
- Temporary: A tablespace can be taken offline temporarily even if there are error conditions for one or more files of the tablespace. Oracle Database takes the data files (which are not already offline) offline, performing checkpointing on them as it does so. If no files are offline, but you use the Temporary clause, media recovery is not required to bring the tablespace back online. However, if one or more files of the tablespace are offline because of write errors, and you take the tablespace offline temporarily, the tablespace requires recovery before you can bring it back online.
- Immediate: A tablespace can be taken offline immediately without Oracle Database taking a checkpoint on any of the data files. When yon specify Immediate, media recovery for the tablespace is required before the tablespace can be brought online. You cannot take a tablespace offline immediately if the database is running in NOARCHIVELOG mode.
- For Recover: The FOR RECOVER setting has been deprecated. The syntax is supported for backward compatibility.
- Question List (170q)
- Question 1: You executed the following command to create a tablespace ca...
- Question 2: Identify the two situations in which the alert log file is u...
- Question 3: View the Exhibit to examine the output for the CROSSCHECK BA...
- Question 4: Why does performance degrade when many UPDATE, INSERT or DEL...
- Question 5: View the Exhibit. (Exhibit) You are creating an additional d...
- Question 6: In a new installation of Oracle Database 11g, you perform th...
- Question 7: User SCOTTexecutes the following command on the EMPtable but...
- Question 8: In a system, large online transaction processing (OLTP) jobs...
- Question 9: Which two files in the database can be configured for automa...
- Question 10: |View the Exhibit to observe the roles assigned to the SL_RE...
- Question 11: Your database instance is started using the server parameter...
- Question 12: Your database is in shutdown state. What will happend if you...
- Question 13: Which task would you perform before you run Oracle Universal...
- Question 14: Which two operations can be performed on an external table? ...
- Question 15: While observing the index statistics, you find that an index...
- Question 16: Automatic Shared Memory Management is disabled for your data...
- Question 17: Which two statements are true about checkpointing? (Choose t...
- Question 18: Examine the values for the following initialization paramete...
- Question 19: You set the following parameters in the parameter file and r...
- Question 20: Identify the two situations in which you use the alert log f...
- Question 21: You plan to move data from a flat file to a table in your da...
- Question 22: Given below is a list of scenarios: 1. A user terminates his...
- Question 23: Your database is functional with a peak load for the last on...
- Question 24: View the Exhibit and examine the output. (Exhibit) Which two...
- Question 25: Which statements listed below describe the data dictionary v...
- Question 26: The instance abnormally terminates because of a power outage...
- Question 27: Which two statements are true regarding listeners? (Choose t...
- Question 28: The database instance is currently using SPFILE. View the Ex...
- Question 29: Which two statements are true regarding undo tablespaces? (C...
- Question 30: Identify two situations in which the block header grows in a...
- Question 31: See the Exhibit: (Exhibit) Which statements are true regardi...
- Question 32: Which naming method uses the tnsnames.ora file to store the ...
- Question 33: You plan to implement the distributed database system in you...
- Question 34: What can you achieve by implementing reverse key index?...
- Question 35: The TRANS_SUMMARY table contains product-wise transaction de...
- Question 36: Examine the following output: (Exhibit) Which two statements...
- Question 37: You want to enable archiving on your database. Presently, th...
- Question 38: You are in the middle of a transaction updating a very impor...
- Question 39: View the Exhibit to examine the error that occurred during t...
- Question 40: Which three operations require undo data? (Choose three.)...
- Question 41: To make audit information more productive, the DBA executes ...
- Question 42: You are using flat files as the data source for one of your ...
- Question 43: You executed the following command to create a password file...
- Question 44: Note the following structures in your database server: 1. Ex...
- Question 45: You perform differential incremental level 1 backups of your...
- Question 46: Which three statements regarding the server parameter file (...
- Question 47: View the Exhibit1, which shows the options that are selected...
- Question 48: You are managing an Oracle Database 11g database with the fo...
- Question 49: You want to check the details of few errors that users have ...
- Question 50: You are installing Oracle Database 11g on your server. Durin...
- Question 51: View the Exhibit and examine the attributes of an undo table...
- Question 52: You are managing an Oracle Database 11g database. You want t...
- Question 53: In your database instance, the user sessions are connected t...
- Question 54: In which situation would you use static database registratio...
- Question 55: You used the IMMEDIATE option to shutdown your database inst...
- Question 56: Which two statements are true about Shared SQL Area and Priv...
- Question 57: Which is the correct description of a pinned buffer in the d...
- Question 58: View the Exhibit and examine the output of the query. (Exhib...
- Question 59: Which two kinds of failures make the Data Recovery Advisor (...
- Question 60: Which two statements are true regarding a PL/SQL package bod...
- Question 61: Identify the memory component from which memory may be alloc...
- Question 62: You are working on an instance started using the SPFILE. You...
- Question 63: Which two statements correctly describe the relation between...
- Question 64: View the Exhibit and examine the privileges granted to the S...
- Question 65: View the Exhibit and examine the privileges granted to the M...
- Question 66: For which database operation would you need the database to ...
- Question 67: You configured the Flash Recovery Area for your database. Th...
- Question 68: You want to configure and schedule offline database backups ...
- Question 69: Which two statements are true regarding the SGA_TARGET initi...
- Question 70: SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SU...
- Question 71: database, DEVDB, to the production database, PRODDB. A datab...
- Question 72: View the Exhibit to examine the details for an incident. (Ex...
- Question 73: You executed the following command to perform a backup of th...
- Question 74: Which statements are true regarding the creation of an incid...
- Question 75: Examine the command: SQL>ALTER USR skd ACCOUNT LOCK; Whic...
- Question 76: You are installing Oracle Database 11g on a machine. When yo...
- Question 77: You have issued a SHUTDOWN ABORTcommand to bring down your d...
- Question 78: Observe the information in the columns: (Exhibit) Which opti...
- Question 79: You have set Tablespace Full Metrics Threshold values for th...
- Question 80: The instance abnormally terminates because of a power outage...
- Question 81: The user HRreceives the following error while inserting data...
- Question 82: View the Exhibit and examine the user information. The user ...
- Question 83: Which statement is true about a whole consistent database ba...
- Question 84: Your database instance is configured with automatic undo man...
- Question 85: View the Exhibit to examine the output of the DBA_OUTSTANDIN...
- Question 86: In which of the scenario will the DBA perform recovery? (Cho...
- Question 87: View the Exhibit and examine the attributes of an undo table...
- Question 88: The job to gather optimizer statistics for objects runs as p...
- Question 89: You notice that the performance of the database has degraded...
- Question 90: In your production database, data manipulation language (DML...
- Question 91: Which statement is true about loading data using the convent...
- Question 92: Which two statements are true regarding listeners? (Choose t...
- Question 93: The instance abnormally terminates because of a power outage...
- Question 94: You want to move all objects of the APPS user in the test da...
- Question 95: You are managing an Oracle Database 11g database. You config...
- Question 96: Examine the values for the following initialization paramete...
- Question 97: Which two statements are true about alerts? (Choose two.)...
- Question 98: You have two tables with referential integrity enforced betw...
- Question 99: You have a large amount of historical data in a flat file. S...
- Question 100: Which two activities are NOT supported by the Data Recovery ...
- Question 101: Which three statements are true about logical structures of ...
- Question 102: You executed this command to create a temporary table: (Exhi...
- Question 103: You configured the flash recovery area (FRA) for your databa...
- Question 104: Which three statements are correct about temporary tables? (...
- Question 105: Examine the command that is used to create a table: (Exhibit...
- Question 106: Note the following points describing various utilities in Or...
- Question 107: You want to access employee details contained in flat files ...
- Question 108: User A executes the following command to drop a large table ...
- Question 109: After performing a clean shut down of the database instance ...
- Question 110: See the Exhibit: (Exhibit) Identify the component marked wit...
- Question 111: Which two statements are true about the Automatic Database D...
- Question 112: SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SU...
- Question 113: You have an ORDERS table with the following structure: (Exhi...
- Question 114: Identify two situations in which you can use Data Recovery A...
- Question 115: Automatic Shared Memory Management (ASMM) has been enabled f...
- Question 116: Examine the values for the following initialization paramete...
- Question 117: Which two statements are true regarding the Oracle Data Pump...
- Question 118: You are working on a database that must be functioning 24 ho...
- Question 119: A user, who is authenticated externally, logs in to a remote...
- Question 120: Examine the following statement that is used to modify the p...
- Question 121: View the Exhibit and examine the undo tablespace attributes....
- Question 122: You execute the following command to change the status of th...
- Question 123: In which situation may the UNDO_RETENTIONparameter be ignore...
- Question 124: You are working on a new Oracle Database 11g server, where o...
- Question 125: You want to create a role to meet these requirements: 1. The...
- Question 126: Examine the following steps performed on a database instance...
- Question 127: You have statistics collected for some selected tables. Your...
- Question 128: You execute this command to drop the ITEM table, which has t...
- Question 129: Which three statements are correct about temporary tables? (...
- Question 130: Which two statements are true regarding the usage of the SQL...
- Question 131: Note the following functionalities of various background pro...
- Question 132: User SCOTT wants to perform a bulk insert operation in the E...
- Question 133: Which two statements are true regarding Oracle Data Pump? (C...
- Question 134: Which of these is true about undo tablespace?...
- Question 135: In your database instance, the STATISTICS_LEVEL initializati...
- Question 136: A constraint in a table is defined with the INITIALLY IMMEDI...
- Question 137: In which situation may the UNDO_RETENTION parameter be ignor...
- Question 138: Some non-DBA users in your database have been granted ANY TA...
- Question 139: You have recently collected statistics on certain objects of...
- Question 140: Your test database is configured to run in NOARCHIVELOGmode....
- Question 141: View the Exhibit to examine the output produced by the follo...
- Question 142: Examine the command: SQL>DBMS_STATS.SET_TABLE_PREFS('SH',...
- Question 143: Which two statements are true regarding a tablespace? (Choos...
- Question 144: Which two statements are true about standard database auditi...
- Question 145: Examine the following command that is used to create a table...
- Question 146: You want to access employee details contained in flat files ...
- Question 147: SQL> CREATE BIGFILE TABLESPACE MRKT 2 DATAFILE '/u01/app/...
- Question 148: View the Exhibit and examine the parameters. User A executes...
- Question 149: Note the following points describing various utilities in Or...
- Question 150: The session of user SCOTT receives the following error after...
- Question 151: Which two statements are true regarding B-tree index? (Choos...
- Question 152: You have two database servers SEMPand SACCT. The database in...
- Question 153: Your database is open and the LISTENER listener is running. ...
- Question 154: Which three statements are correct about temporary tables? (...
- Question 155: Your database is configured in shared server mode. However, ...
- Question 156: Which two statements about the background process of the dat...
- Question 157: Which statement is true about the Manageability Monitor (MMO...
- Question 158: You execute this command to drop the ITEM table, which has t...
- Question 159: Which two statements are true about setting the FAST_START_M...
- Question 160: A database user SMITH tries to query the V$SESSION view and ...
- Question 161: You have executed this command to change the size of the dat...
- Question 162: The database instance has the following parameter setting: (...
- Question 163: Which statement is true about the UNDO_RETENTION parameter w...
- Question 164: View the Exhibit. (Exhibit) You want to create a tablespace ...
- Question 165: Which two statements are true regarding transactions in an O...
- Question 166: You are managing an Oracle Database 11g database. The databa...
- Question 167: Your database instance is running with full workload after d...
- Question 168: All the database users are presently connected to the databa...
- Question 169: You are using Enterprise Manager to schedule backups for you...
- Question 170: The HR user creates a stand-alone procedure as follows and g...
