- Home
- Oracle
- Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP
- Oracle.1Z0-034.v2018-05-05.q140
- Question 55
Valid 1z0-034 Dumps shared by ExamDiscuss.com for Helping Passing 1z0-034 Exam! ExamDiscuss.com now offer the newest 1z0-034 exam dumps, the ExamDiscuss.com 1z0-034 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 1z0-034 dumps with Test Engine here:
Access 1z0-034 Dumps Premium Version
(148 Q&As Dumps, 35%OFF Special Discount Code: freecram)
<< Prev Question Next Question >>
Question 55/140
You created a tablespace with the following statement:
CREATE BIGFILE TABLESPACE adtbs
DATAFILE '/probdb/data/adtbs.dbf' SIZE 10G;
There is now a requirement to increase the size of the tablespace.
Which two ALTER statements are correct in this scenario? (Choose two.)
CREATE BIGFILE TABLESPACE adtbs
DATAFILE '/probdb/data/adtbs.dbf' SIZE 10G;
There is now a requirement to increase the size of the tablespace.
Which two ALTER statements are correct in this scenario? (Choose two.)
Correct Answer: A,C
Explanation/Reference:
C:\sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jan 28 20:34:23 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> CREATE BIGFILE TABLESPACE adtbs
DATAFILE'C:\adtbs.dbf' SIZE 1G;
Tablespace created.
(A)
SQL> ALTER TABLESPACE adtbs RESIZE 2G
Tablespace altered.
(B) and (D)
SQL> ALTER TABLESPACE adtbs ADD DATAFILE'C:\adtbs.dbf' SIZE 1G;
ALTER TABLESPACE adtbs ADD DATAFILE 'C:\adtbs.dbf' SIZE 1G
ERROR at line 1:
ORA-32771: cannot add file to bigfile tablespace
(C)
SQL> ALTER TABLESPACE adtbs AUTOEXTEND ON;
Tablespace altered.
(E)
SQL> ALTER TABLESPACE adtbs MODIFY DATAFILE 'C:\adtbs.dbf' AUTOEXTEND ON; ALTER TABLESPACE adtbs MODIFY DATAFILE 'C:\adtbs.dbf' AUTOEXTEND ON ERROR at line 1:
ORA-02142: missing or invalid ALTER TABLESPACE option
C:\sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jan 28 20:34:23 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> CREATE BIGFILE TABLESPACE adtbs
DATAFILE'C:\adtbs.dbf' SIZE 1G;
Tablespace created.
(A)
SQL> ALTER TABLESPACE adtbs RESIZE 2G
Tablespace altered.
(B) and (D)
SQL> ALTER TABLESPACE adtbs ADD DATAFILE'C:\adtbs.dbf' SIZE 1G;
ALTER TABLESPACE adtbs ADD DATAFILE 'C:\adtbs.dbf' SIZE 1G
ERROR at line 1:
ORA-32771: cannot add file to bigfile tablespace
(C)
SQL> ALTER TABLESPACE adtbs AUTOEXTEND ON;
Tablespace altered.
(E)
SQL> ALTER TABLESPACE adtbs MODIFY DATAFILE 'C:\adtbs.dbf' AUTOEXTEND ON; ALTER TABLESPACE adtbs MODIFY DATAFILE 'C:\adtbs.dbf' AUTOEXTEND ON ERROR at line 1:
ORA-02142: missing or invalid ALTER TABLESPACE option
- Question List (140q)
- Question 1: You execute these RMAN commands: BACKUP VALIDATE DATABASE; B...
- Question 2: Which two statements are true about the duplexing of the bac...
- Question 3: You are in the middle of a transaction updating a very impor...
- Question 4: The instance abnormally terminates because of a power outage...
- Question 5: UNDO__RETENTION is set to 1000 and retention is not guarante...
- Question 6: Which three types of files can be automatically placed in th...
- Question 7: You executed the following commands: SQL> ALTER SESSION S...
- Question 8: You create two resource plans, one for data warehouse loadin...
- Question 9: Which statement is true about a Scheduler-generated event?...
- Question 10: What does the DB_FLASHBACK_RETENTION_TARGET parameter config...
- Question 11: Multiple RMAN sessions are connected to the database instanc...
- Question 12: Which statement is true regarding the creation of nested pla...
- Question 13: Which two statements are true about a duplicate database tha...
- Question 14: You are using Recovery Manager (RMAN) for backup and recover...
- Question 15: After you have restored and recovered a database to a new ho...
- Question 16: Which two statements are true about the Automatic Diagnostic...
- Question 17: Examine the following scenario: The target database instance...
- Question 18: Which steps are mandatory to enable Direct NFS? 1. Mount all...
- Question 19: You observed the following output for a user session: (Exhib...
- Question 20: Examine the parameter settings in your database. (Exhibit) W...
- Question 21: Which two statements are true regarding hot patching? (Choos...
- Question 22: Examine the following command for RMAN backup: RMAN> RUN ...
- Question 23: You issued the following commands to configure settings in R...
- Question 24: Given below is a list of scenarios: 1) A user terminates his...
- Question 25: You want to track and store all transactional changes to a t...
- Question 26: You configured the default backup device type as disk for RM...
- Question 27: (Exhibit) View the Exhibit and examine the output of the que...
- Question 28: You executed the following command In Recovery Manager {RMAN...
- Question 29: View the Exhibits exhibit1 and exhibit2. Both the processes ...
- Question 30: View Exhibit1 to examine the CRS11G disk group when all the ...
- Question 31: Your database is in NOARCHIVELOG mode. One of the two data f...
- Question 32: Examine the following RMAN script: RMAN> run { debug on; ...
- Question 33: Identify two advantages of using a recovery catalog instead ...
- Question 34: Your database is using a default temporary tablespace that c...
- Question 35: In your production database, users report that they are unab...
- Question 36: You are using the control file to maintain information about...
- Question 37: To enable faster incremental backups, you enabled block chan...
- Question 38: View the Exhibit to observe the error. (Exhibit) You receive...
- Question 39: Which two statements about Oracle Direct Network File System...
- Question 40: Examine the following ALTER command: SQL> ALTER DISKGROUP...
- Question 41: Because of a logical corruption in your production database,...
- Question 42: To accomplish user-managed backup for the USERS tablespace, ...
- Question 43: The DB_BLOCK_CHECKING parameter is set to FALSE. What level ...
- Question 44: Consider the following scenario for your database: Backup op...
- Question 45: Examine the following command that is used to duplicate a da...
- Question 46: Which two statements are true about setting the FAST_ START_...
- Question 47: You are managing an Oracle Database 11g instance with ASM st...
- Question 48: Which three tasks can be performed using a duplicate databas...
- Question 49: You have specified the warning and critical threshold values...
- Question 50: Which two statements are true about a job chain? (Choose two...
- Question 51: There was media failure and you decide to check the data fil...
- Question 52: Automatic PGA Memory Management eliminates the need to manua...
- Question 53: You are using the flash recovery area (fast recovery area in...
- Question 54: You notice that the performance of the database has degraded...
- Question 55: You created a tablespace with the following statement: CREAT...
- Question 56: Given below are RMAN commands to enable backup optimization ...
- Question 57: Because of a logical corruption in the EMPLOYES tables, you ...
- Question 58: Evaluate the following block of code: (Exhibit) What is the ...
- Question 59: Examine the following set of RMAN commands: RMAN> CONFIGU...
- Question 60: Before a Flashback Table operation, you execute the followin...
- Question 61: You are in the process of creating a virtual private catalog...
- Question 62: The database users regularly complain about the difficulty i...
- Question 63: View the Exhibit to examine the replay settings for replay p...
- Question 64: Examine the following command to create an external table fr...
- Question 65: Your database is running in ARCHIVELOG mode. You have been t...
- Question 66: View the Exhibit and examine the steps that you executed to ...
- Question 67: What happens when you run the SQL Tuning Advisor with limite...
- Question 68: Note the following statements that use flashback technology:...
- Question 69: Examine the following RMAN command: RMAN> CONFIGURE ENCRY...
- Question 70: Examine the following scenario: Database is running in ARCHI...
- Question 71: Identify two options that Oracle recommends while configurin...
- Question 72: You have enabled backup optimization for the RMAN environmen...
- Question 73: You are in the process of creating a Virtual Private Catalog...
- Question 74: Note the following parameter settings: Which setting is NOT ...
- Question 75: The DB_BLOCK_CHECKING parameter is set to FULL. What checks ...
- Question 76: What is the effect of increasing the value of the ASM_POWER_...
- Question 77: You realize that the control file is damaged in your product...
- Question 78: You execute the following command to set the redundancy rete...
- Question 79: Which three file types are managed by Data Pump jobs?...
- Question 80: Which four resources can directives be specified by using th...
- Question 81: Evaluate the following statements: CREATE TABLE purchase_ord...
- Question 82: Examine these Data Pump commands to import objects to non-ex...
- Question 83: In your database, the flash recovery area (FRA) is configure...
- Question 84: Identify three key features of Oracle Data Pump (Choose thre...
- Question 85: You need to configure fine-grained access control to externa...
- Question 86: Which statements are true regarding system-partitioned table...
- Question 87: You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parame...
- Question 88: Which two statements are true regarding an Automatic Storage...
- Question 89: View the Exhibit. (Exhibit) You must unload data from the OR...
- Question 90: Which two statements are true about the duplexing of the bac...
- Question 91: You want to create the Recovery Manager (RMAN) Virtual Priva...
- Question 92: User SCOTT wants to back out the transactions on the REGIONS...
- Question 93: Identify two correct statements about the Active Session His...
- Question 94: You are managing an Oracle Database 11g ASM instance with a ...
- Question 95: Examine the following command for RMAN backup: RMAN> RUN ...
- Question 96: What two are the prerequisites for enabling Flashback Databa...
- Question 97: You created a database with the Database Configuration Assis...
- Question 98: To enable faster incremental backups, you enabled block chan...
- Question 99: In which two aspects does hot patching differ from conventio...
- Question 100: In Recovery Manager (RMAN), you are taking Image copies of t...
- Question 101: Which three statements are true about windows?...
- Question 102: While designing a database, you created the EMPLOYEES table ...
- Question 103: Your database initialization parameter file has the followin...
- Question 104: In which two situations would you rebuild an index using the...
- Question 105: You plan to use Flashback Drop feature to recover a dropped ...
- Question 106: memory_target big integer 808M pga_aggregate_target big inte...
- Question 107: You want to create a consumer group, GROUP1, and you execute...
- Question 108: Which are the two prerequisites before setting up Flashback ...
- Question 109: You are managing an Oracle Database 11g database. You config...
- Question 110: You are using Recovery Manager (RMAN) with a recovery catalo...
- Question 111: Which three elements can a job chain process involve? (Choos...
- Question 112: The Automatic Workload Repository (AWR) snapshot interval is...
- Question 113: You are working on a database that was created using Oracle ...
- Question 114: The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the ...
- Question 115: During the installation of Oracle Database 11g, you do not s...
- Question 116: View the following SQL statements: Transaction T1 SQL> IN...
- Question 117: Tablespaces of certain types or in certain states can be ren...
- Question 118: View the Exhibit and examine the RMAN commands. (Exhibit) Wh...
- Question 119: For which two database objects can the VERSIONS clause of th...
- Question 120: Which options would you consider while configuring a flash r...
- Question 121: The database is configured in ARCHIEVELOG mode and regular c...
- Question 122: Which option must you configure while performing an automate...
- Question 123: Note the output of the following query: SQL> SELECTflashb...
- Question 124: Which two statements are true about encrypting RMAN backups?...
- Question 125: The EMP table exists in your schema. You want to execute the...
- Question 126: Which two statements are correct about database transportati...
- Question 127: In one of your online transaction processing (OLTP) applicat...
- Question 128: Which data dictionary view would you query to find the name ...
- Question 129: Refer to the exhibit. (Exhibit) Examine the Following comman...
- Question 130: As part of archiving the historical data, you want to transf...
- Question 131: View the Exhibit and examine the parameter settings in your ...
- Question 132: ENCRYPT_TS is an encrypted tablespace that contains tables w...
- Question 133: Which statements describe the capabilities of the DBMS_NETWO...
- Question 134: You decided to use Direct NFS configuration in a non-RAC Ora...
- Question 135: While exporting data with Data Pump, you find that the expor...
- Question 136: You are managing a 24*7 database. The backup strategy for th...
- Question 137: You work with a newly created database. Presently, there is ...
- Question 138: Your production database is functional on the SHOST1 host. Y...
- Question 139: Which client requests to the database can be captured as a p...
- Question 140: Your database is open and running in ARCHIVELOG mode. You ta...
