QUESTION NO: 114
A user performs an update on a table. Shortly after committing the transaction, they realize that they had
an error in their WHERE clause causing the wrong rows to be updated. Which...
分类:
其他 时间:
2015-10-05 13:04:24
收藏:
0 评论:
0 赞:
0 阅读:
202
QUESTION NO: 115
A developer calls and reports that he accidentally dropped an important lookup table from a production
database. He needs the table to be recovered. What action would you take?
A....
分类:
其他 时间:
2015-10-05 13:04:14
收藏:
0 评论:
0 赞:
0 阅读:
248
QUESTION NO: 134
How can you reverse the effects of an ALTER DISKGROUP … DROP DISK command if it has not yet
completed?,
A. Issue the ALTER DISKGROUP … ADD DISK command.
B. Issue the ALTER DISKGROU...
分类:
其他 时间:
2015-10-05 13:03:54
收藏:
0 评论:
0 赞:
0 阅读:
201
QUESTION NO: 120
Which of the following are not disabled by default?
A. Jobs
B. Chains
C. Windows
D. Window groups
E. Schedule
A schedule is enabled by default. The others are disabled by defau...
分类:
其他 时间:
2015-10-05 13:03:44
收藏:
0 评论:
0 赞:
0 阅读:
435
QUESTION NO: 116
In a Database Replay workload capture, what client request information is gathered? (Choose all that
apply.)
A. SQL text SQL
B. Shared server requests (Oracle MTS)
C. Bind variab...
分类:
其他 时间:
2015-10-05 13:03:34
收藏:
0 评论:
0 赞:
0 阅读:
251
QUESTION NO: 136
Which background process coordinates the rebalance activity for disk groups?
A. ORBn
B. OSMB
C. RBAL rebalance再平衡
D. ASMn Answer: C哪个后台进程协调磁盘组重新平衡活动?C. RBAL rebalance再平衡...
分类:
其他 时间:
2015-10-05 13:03:24
收藏:
0 评论:
0 赞:
0 阅读:
150
QUESTION NO: 121
You notice that a job in a chain has not completed on a nonconstrained RAC database. Which of these
are valid reasons why that might occur?
A. The job priority is 1 and the resourc...
分类:
其他 时间:
2015-10-05 13:03:14
收藏:
0 评论:
0 赞:
0 阅读:
367
QUESTION NO: 117
Which of the following are true concerning block media recovery? (Choose all that apply.)
A. Any gap in archive logs ends the recovery.
B. If a gap in archive logs is encountered,...
分类:
其他 时间:
2015-10-05 13:03:04
收藏:
0 评论:
0 赞:
0 阅读:
196
QUESTION NO: 132
As DBA for the Rebel Alliance you have decided that you need to facilitate some redundancy in your
database. Using ASM, you want to create a disk group that will provide for the grea...
分类:
其他 时间:
2015-10-05 13:02:54
收藏:
0 评论:
0 赞:
0 阅读:
323
题目链接:codeforces 351B题目大意:给出一个游戏,先手选择一对相邻的数交换位置,后手随机找一对数,然后掷硬币决定是否交换,如果不能交换,那么就重新找。问大致序列有序的采取最优策略的布数的期望。题目分析:
定义dp[i]表示减少i个逆序对的步数的期望。
dp[i]=1+1+dp[i?2]?0.5+dp[i?1+1]]?0.5dp[i] = 1+1 + dp[i-2] \cdot 0.5...
分类:
其他 时间:
2015-10-05 13:02:44
收藏:
0 评论:
0 赞:
0 阅读:
181
QUESTION NO: 118
The DBA has chosen to manage SGA and PGA memory separately in an OLTP database because of his
unique knowledge of the application. Which of these are good starting points to use when...
分类:
其他 时间:
2015-10-05 13:02:34
收藏:
0 评论:
0 赞:
0 阅读:
255
QUESTION NO: 139重复
How can you reverse the effects of an ALTER DISKGROUP … DROP DISK command if it has already
completed?
A. Issue the ALTER DISKGROUP … ADD DISK command.
B. Issue the ALTER DISKGR...
分类:
其他 时间:
2015-10-05 13:02:24
收藏:
0 评论:
0 赞:
0 阅读:
175
QUESTION NO: 133
You want to migrate your database to ASM, so you‘ve done a clean shutdown, made a closed backup of
the entire database, noted the location of your control files and online redo log f...
分类:
其他 时间:
2015-10-05 13:02:14
收藏:
0 评论:
0 赞:
0 阅读:
246
QUESTION NO: 130?
When an ASM instance receives a SHUTDOWN NORMAL command, what command does it pass on to
all database instances that rely on the ASM instance‘s disk groups?
A. TRANSACTIONAL
B. I...
分类:
其他 时间:
2015-10-05 13:02:04
收藏:
0 评论:
0 赞:
0 阅读:
490
QUESTION NO: 137
On the development database rac0, there are six raw devices: /dev/raw/raw1 through /dev/raw/raw6.
/dev/raw/raw1 and /dev/raw/raw2 are 8GB each, and the rest are 6GB each. An existing...
分类:
其他 时间:
2015-10-05 13:01:54
收藏:
0 评论:
0 赞:
0 阅读:
251
QUESTION NO: 138
Which type of database file is spread across all disks in a disk group?A. All types of files are spread across all disks in the disk group. 所有类型的文件散布在磁盘组中的所有磁盘。
B. Datafiles
C. Redo...
分类:
其他 时间:
2015-10-05 13:01:44
收藏:
0 评论:
0 赞:
0 阅读:
242
QUESTION NO: 123
The NLS_TERRITORY parameter specifies the default conventions to be used for which of the following
globalization elements? (Choose all that apply.)
A. Date format
B. Decimal chara...
分类:
其他 时间:
2015-10-05 13:01:34
收藏:
0 评论:
0 赞:
0 阅读:
244
QUESTION NO: 122
The NLS_LANGUAGE parameter specifies the default conventions to be used for which of the following
globalization elements?
A. Languages for server messages
B. Day and month names...
分类:
其他 时间:
2015-10-05 13:01:24
收藏:
0 评论:
0 赞:
0 阅读:
235
QUESTION NO: 119
You notice that a long-running transaction is suspended due to a space constraint, and there is no AFTER
SUSPEND triggered event addressing the issue. You also note that the critical...
分类:
其他 时间:
2015-10-05 13:01:14
收藏:
0 评论:
0 赞:
0 阅读:
196
QUESTION NO: 131
When starting up your ASM instance, you receive the following error: ASM
SQL> startup pfile=?/dbs/init+ASM.ora
ASM instance started+
Total System Global Area 104611840 bytes
Fixed...
分类:
其他 时间:
2015-10-05 13:01:04
收藏:
0 评论:
0 赞:
0 阅读:
248