- Home
- Oracle
- Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP
- Oracle.1Z0-034.v2018-05-05.q140
- Question 64
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 64/140
Examine the following command to create an external table from EMPLOYEES and DEPARTMENTS database tables.
1. CREATE TABLE employee_ext
2. (employee_id, first_name, department_name)
3. ORGANIZATION EXTERNAL
4. (
5. TYPE ORACLE_LOADER
6. DEFAULT DIRECTORY ext_dir
7. LOCATION ('emp1.dmp')
8. )
9. PARALLEL
10. AS
11. SELECT e.emplyee_id, e.first_name, e.last_name, d.department_name
12. FROM employees e, departments d;
Which line of the command would cause an error?
1. CREATE TABLE employee_ext
2. (employee_id, first_name, department_name)
3. ORGANIZATION EXTERNAL
4. (
5. TYPE ORACLE_LOADER
6. DEFAULT DIRECTORY ext_dir
7. LOCATION ('emp1.dmp')
8. )
9. PARALLEL
10. AS
11. SELECT e.emplyee_id, e.first_name, e.last_name, d.department_name
12. FROM employees e, departments d;
Which line of the command would cause an error?
Correct Answer: F
Explanation/Reference:
External tables are created using the SQL CREATE TABLE...ORGANIZATION EXTERNAL statement.
When you create an external table, you specify the followingattributes:
1. TYPE - specifies the type of external table. The two available types are the ORACLE_LOADER type and the ORACLE_DATAPUMP type. Each type of external table is supported by its own access driver.
* The ORACLE_LOADER access driver is the default. It can perform only data loads, and the data must comefrom text datafiles. Loads from external tables to internal tables are done by reading from the external tables' text-only datafiles .
* The ORACLE_DATAPUMP access driver can perform both loads and unloads. The data must come from binary dump files. Loads to internal tables from external tables are done by fetching from the binary dump files. Unloads from internal tables to external tables are done by populating the external tables' binary dump files.
2. DEFAULT DIRECTORY - specifies the default location of files that are read or written by external tables.
The location is specified with a directory object, not a directory path.
3. ACCESS PARAMETERS - describe the external data source and implements the type of external table that was specified. Each type of external table has its own access driver that provides access parameters unique to that type of external table.
4. LOCATION - specifies the location of the external data. The location is specified as a list of directory objects and filenames. If the directory object is not specified, then the default directory object is used as the file location.
REF.: Oracle(r) Database 10g Utilities, 12-2
External tables are created using the SQL CREATE TABLE...ORGANIZATION EXTERNAL statement.
When you create an external table, you specify the followingattributes:
1. TYPE - specifies the type of external table. The two available types are the ORACLE_LOADER type and the ORACLE_DATAPUMP type. Each type of external table is supported by its own access driver.
* The ORACLE_LOADER access driver is the default. It can perform only data loads, and the data must comefrom text datafiles. Loads from external tables to internal tables are done by reading from the external tables' text-only datafiles .
* The ORACLE_DATAPUMP access driver can perform both loads and unloads. The data must come from binary dump files. Loads to internal tables from external tables are done by fetching from the binary dump files. Unloads from internal tables to external tables are done by populating the external tables' binary dump files.
2. DEFAULT DIRECTORY - specifies the default location of files that are read or written by external tables.
The location is specified with a directory object, not a directory path.
3. ACCESS PARAMETERS - describe the external data source and implements the type of external table that was specified. Each type of external table has its own access driver that provides access parameters unique to that type of external table.
4. LOCATION - specifies the location of the external data. The location is specified as a list of directory objects and filenames. If the directory object is not specified, then the default directory object is used as the file location.
REF.: Oracle(r) Database 10g Utilities, 12-2
- 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...
