下沙论坛

 找回密码
 注册论坛(EC通行证)

用新浪微博连接

一步搞定

QQ登录

QQ登录

下沙大学生网QQ群8(千人群)
群号:6490324 ,验证:下沙大学生网。
用手机发布本地信息严禁群发,各种宣传贴请发表在下沙信息版块有问必答,欢迎提问 提升会员等级,助你宣传
新会员必读 大学生的论坛下沙新生必读下沙币获得方法及使用
查看: 2129|回复: 0
打印 上一主题 下一主题

Killtest 1Z0-042 题库

[复制链接]
头像被屏蔽

该用户从未签到

跳转到指定楼层
1
发表于 2009-6-18 15:02:13 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
朋友刚考过的。最新1Z0-042
1. You are connecting to an Oracle database server from a client by using the following connect string:
SQL> CONNECT hr/hr@pdserver.us.oracle.com:1521/proddb
Which naming method is being used in this case?
A.Local Naming
B.Easy Connect
C.External Naming
D.Directory Naming
Answer: B
2. User Scott has updated the salary of one of the employees in the EMPLOYEES table and has not
committed the transaction. What are the two types of locks that this scenario would lead to? (Choose
two.)
A.null lock on the row being updated
B.null lock on the table containing the row
C.ROW SHARE lock for the row being updated
D.ROW EXCLUSIVE lock for the row being updated
E.shared rowexclusive
lock for the row being updated
F.a shareable table lock for the table containing the row
G.exclusive tablelevel
lock for the table containing the row
Answer: DF
3. You are using the backup scheduler in Enterprise Manager (EM) to schedule a backup of your
database.
Which type of script does the backup scheduler generate?
A.SQL script
B.PL/SQL script
C.Operating System (OS) script
D.Enterprise Manager (EM) script
E.Recovery Manager (RMAN) script
Answer: E
4. The data file belonging to the SYSTEM tablespace is corrupted and no backup of the file is available.
How do you recover the data file?
A.The data file cannot be recovered.
B.The data file can be restored from the SYSTEM auto backup.
C.Take the tablespace offline, drop, and recreate
it.
D.Recovery Manager (RMAN) is used to recover the data file.
E.The ALTER DATABASE CREATE DATAFILE.. command is used to recover the data file.
Answer: A
5. After being hired as a database administrator, you find that there is only one database that is functional
and that is being accessed by the applications. You want to create a replica of the database, to be used
for testing purposes.
What is the best method to create the replica?
A.create a database by using CREATE DATABASE .. command and manually copy the data
B.use Database Configuration Assistant (DBCA) to create a template from the existing database to
contain the database structure
C.use DBCA to create a template from the existing database to contain the database structure and then
manually copy the data using Oracle Data Pump
D.use DBCA to create a template from the existing database to contain the database structure with data
files and then use the same template to create the database in the new location
Answer: D
6. You are creating a locally managed tablespace to meet the following requirements:
All the extents should be of the same size.
The data should be spread across two data files.
A bitmap should be used to record the free space within the allocated extents.
Which three options would you choose? (Choose three.)
A.set PCTFREE and PCTUSED to 50
B.specify extent allocation as Uniform
C.specify extent allocation as Automatic
D.create the tablespace as bigfile tablespace
E.create the tablespace as smallfile tablespace
F.set segment space management to Automatic
G.use the RESIZE clause while creating the tablespace
Answer: BEF
7. As a result of performance analysis, you created an index on the prod_name column of the prod_det
table, which contains about ten thousand rows. Later, you updated a product name in the table. How does
this change affect the index?
A.A leaf will be marked as invalid.
B.An update in a leaf row takes place.
C.The index will be updated automatically at commit.
D.A leaf row in the index will be deleted and inserted.
E.The index becomes invalid when you make any updates.
Answer: D
8. Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client
while connecting to the database instance from a remote machine?
A.host naming method
B.local naming method
C.external naming method
D.directory naming method
Answer: B
9. In your database, the snapshot interval is set to 10 minutes for the Automatic Workload Repository
(AWR). The database instance is running for the past 30 days.
View the Exhibit to examine the Automatic Database Diagnostic Monitor (ADDM) task.
The ADDM task is performed every 10 minutes, except the last task. What could be the reason for this?
A.The snapshot retention period for the AWR was increased before the last task.
B.The optimizer statistics for few objects in the database were locked before the last task.
C.The STATISTICS_LEVEL initialization parameter was changed to BASIC and reset to TYPICAL before
the last task.
D.The optimizer statistics was collected manually by using the DBMS_STATS package before the last
task.
Answer: C
10. Your database is configured with the following parameters related to SGA:
SGA_TARGET=256MB
SHARED_POOL_SIZE=32MB
DB_CACHE_SIZE=100MB
LARGE_POOL_SIZE=0
JAVA_POOL_SIZE=0
STREAMS_POOL_SIZE=0
Which two statements are true about the configuration? (Choose two.)
A.The SGA_TARGET value cannot be sized smaller than 100 MB.
B.The shared pool and the default buffer pool will not be sized bigger than 32 MB and 100 MB,
respectively.
C.The shared pool and the default buffer pool will not be sized smaller than 32 MB and 100 MB,
respectively.
D.124 MB (256 minus 132) of memory is available for use by all the manually sized components.
E.124 MB (256 minus 132) of memory is available for use by all the manually and automatically sized
components.
Answer: CE
分享到:  QQ好友和群QQ好友和群 QQ空间QQ空间 腾讯微博腾讯微博 腾讯朋友腾讯朋友
收藏收藏 分享分享 顶 踩 转发到微博

本版积分规则

关闭

下沙大学生网推荐上一条 /1 下一条

快速回复 返回顶部 返回列表