oracle 1Z0-042
1).You have a large amount of historical data in an operating system file. Some analysts in your organization need to query this data . The file is too large to load into your current database .Which is the most of effective method to accomplish the task?
A-Upgrade the hardware/memory to accommodate the data.
B-Load the data into your database by using the PARALLEL clause.
C-Give analysts DBA privilege , so that they can query DBA_EXTERANL_TABLES.
D-Use an external table so you can have the metadata available in you database , but leave the data in the operation system files.
Correct:D
翻译:
你的操作系统文件中有大量的历史数据,你的组织中的一下分析员需要查询这些数据,文件太大不能加载到现在的数据库中,下面那个方法可以最有效的完成这项任务?
A. 升级你的硬件(内存)来容纳你的数据。
B. 用PARALLEL clause加载数据到你的数据库中。
C. 给分析员DBA权限,因此他可以查询 DBA_EXTERANL_TABLES。
D. 使用外部表,所以你可以在数据库中拥有可用的元数据。但是把数据留在操作系统文件中。
答案:D
2).While planning to manage more than one database in you system , you perform the following activities:
1. Organize different categories of files into independent subdirectories.
2. Use consistent naming convention for database files.
3. Separate administrative information pertaining to each database.
Which option corresponds to the type of activities performed by you ?
A-Oracle Managed Files
B-Oracle Grid Architecture
C-Optimal Flexible Architecture.
D-Oracle database architecture.
Correct:C
翻译:
如果计划在你的系统中管理多个数据库,你可以执行下面的活动:
1.不同类别的文件组织成独立的子目录。
2.为数据库文件使用一致的命名惯例。
3.每个数据库有独立的管理信息。
下面那个选项符合你执行的活动。
A.Oracle管理文件。
B.Oracle网格体系结构。
C.最佳灵活体系结构。
D.Oracle数据库体系结构。
答案:C
3).You want to create a new optimized database for you transactional production environment to be used by financial application . While creating the database,you want the oracle software to take care of all basic settings to optimize the database performance . Which method would you use to achieve this objective?
A.Use the CREATE DATABASE.. command to create the database with Oracle-managed files.
B. Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files.
C. Use Enterprise Manager to create a new databae with the Online Transaction Processing (OLTP) option.
D. Use Database Configuration Assistant (DBCA) to create the database with Transaction Procession template.
E. Use the CREATE DATABASE.. command to create the database with Automatic Storage Mangement (ASM) file system.
Correct:D
翻译:
你想为金融应用程序创建一个新最优化的业务生产环境数据库。当创建数据库的时候,你想用Oracle管理所有的基本设置优化数据库。你将用哪个方法来实现这一目标?
4).You have a text file that maintains information on thousands of items. The end-user application requires
the transfer of that information into a table in the database. What would you use to achieve this task?
(Choose two.)
A. Data Pump
B. SQL*Loader
C. External table
D. Oracle Text
E. Oracle Import
Answer: BC
翻译:
你有一个文本文件,包含数千条条目的数据。终端用户的应用要求把这些数据导入数据库的表中。你会用下面哪个工具实现这一任务?
(选择两项)
A. Data Pump
B. SQL*Loader
C. External table
D. Oracle Text
E. Oracle Import
答案:BC
5).Which step do you need to perform to enable a user with the SYSDBA privilege to log in as SYSDBA in
iSQL*Plus.?
A. The user must be granted the database administrator (DBA) privilege.
B. Set up a user in the Oracle Application Server Containers for J2EE (OC4J) user manager, and grant
the webDba role to the user.
C. The user must be listed in the password file for the authentication.
D. No special setup is needed for the user to connect as SYSDBA in iSQL*Plus.
Answer: B
6).You specified extent management as local for a tablespace. How will it affect space management in the
tablespace?
A. The tablespace will be system managed and the users cannot specify the extent size.
B. Free extents will be managed by the data dictionary tables.
C. All the extents will be of the same size.
D. Bitmap will be used to record free and allocated extents.
Answer: D
7).Which two operations require undo data? (Choose two.)
A. recovering from failed transactions
B. recording a transaction to redo log files
C. rolling back a transaction
D. committing a transaction
E. rolling forward during instance recovery
Answer: AC