违法和不良信息举报 联系客服
免费注册 登录

The size of the largest datafile， data1.dbf， in your databas

题目
单选题
The size of the largest datafile， data1.dbf， in your database is 30MB. You issued the following command：   RMAN>CONFIGURE MAXSETSIZE 10MB；     What will be the impact of the above setting？（）
A

 While performing the backup of the datafile，data1.dbf，one backup set is created.

B

 While performing the backup of the datafile，data1.dbf，two backup sets are created.

C

 While performing the backup of the datafile，data1.dbf，three backup sets are created.

D

 While performing the backup of the datafile，data1.dbf，the command for performing a backup of the datafile，data1.dbf，will fail.

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

单选题
Your database operates in ARCHIVELOGmode. The redo log files are not multiplexed and one of the online redo logs is missing. The missing redo log sequence， 230， is not archived and it contained information from 10：35 a.m. onwards. The current time is 11：00 a.m. Because of a disk crash， you executed the following command to perform an incomplete recovery：  RMAN> RUN {  2> SET UNTIL SEQUENCE 230 THREAD 1； 3> ALTER DATABASE MOUNT；  4> RESTORE DATABASE；  5> RECOVER DATABASE；  6> ALTER DATABASE OPEN RESETLOGS；  7> }；  With reference to this scenario， which statement is true？（）
A

 RMAN recovers up to log sequence 230， but not including 230.

B

 RMAN returns an error because the log sequence number mentioned in the command should be 229.

C

 RMAN returns an error because the log sequence number mentioned in the command may never be missing.

D

 RMAN recovers up to and including log sequence 229 but then returns an error because log sequence 230 is missing.


正确答案： A
解析： 暂无解析

第2题：

单选题
While creating a job class using the DBMS_SCHEDULER package， you set the logging level to LOGGING_RUNS. What would be the impact of this setting？（）
A

 Oracle Scheduler would write detailed information to the job log for each run of each job in the job class.

B

 Oracle Scheduler would write detailed information to the job log for the first run of each job in the job class.

C

 Oracle Scheduler would write detailed information to the job log for each run of only the first job in the job class.

D

 Oracle Scheduler would write detailed information for all operations performed on all jobs in the job class.


正确答案： A
解析： 暂无解析

第3题：

单选题
The Database Resource Manager is not currently active in your database that is up and running. You created a resource plan named DAY_PLAN that contains two sub-plans named MANAGERS_PLAN and CLERKS_PLAN. You decided to activate DAY_PLAN by executing the following statement：       SQL>ALTER SYSTEM SET RESOURCE_MANAGER_PLAN = ’managers_plan’；  What will be the outcome of this statement？（）
A

 The statement will deactivate DAY_PLAN.

B

 The statement will activate DAY_PLAN as the top plan.

C

 The statement will activate MANAGERS_PLAN as the top plan.

D

 The statement will return an error because MANAGERS_PLAN is not the top plan.


正确答案： D
解析： 暂无解析

第4题：

单选题
The online redo log group configuration for your database is as follows： What will happen if the online redo log file ’ora02/oradata/redo02b.log’is corrupted while working on the database？（）
A

 The database will hang.

B

 The database will be crashed.

C

 The database will be shut down.

D

 The LGWR process writes redo log entries to the other redo log member of the Group2 group


正确答案： A
解析： 暂无解析

第5题：

单选题
You have two listener processes， named L1 and L2. Both the listener processes are currently functional. While viewing the listener.ora file on your database server， you find the following entry： PASSWORDS_L1 = （1sanfrjp43） What would be the impact of this setting？（）
A

The listener process named L1 will disconnect the unauthorized users.

B

The listener process named L1 will be prevented from being started by unauthorized users. 

C

The listener process named L1 will be prevented from being stopped by unauthorized users. 

D

The listener process named L1 will be prevented from being reloaded by unauthorized users.

E

The listener process named L1 will be prevented from accepting connections from unauthorized users.


正确答案： D
解析： 暂无解析

第6题：

单选题
You accepted the recommended SQL Profile by executing the following code：   DECLARE   sqlprofile_name varchar2（30）；  BEGIN   sqlprofile_name ：= DBMS_SQLTUNE.ACCEPT_SQL_PROFILE（  task_name => ’my_task’，   profile_name => ’my_profile’）；   END；   Which advisor will analyze this profile？（）
A

 SQL Access Advisor

B

 Undo Advisor

C

 Segment Advisor

D

 SQL Tuning Advisor


正确答案： A
解析： 暂无解析

第7题：

单选题
Consider the following configuration：   /devices/diskP1 is a member of disk group grp1.        /devices/diskP2 is a member of disk group grp1.        /devices/diskP3 is a member of disk group grp1.        /devices/diskP4 is a candidate disk.        /devices/diskQ1 is a member of disk group grp2.        /devices/diskQ2 is a member of disk group grp2.        /devices/diskQ3 is a member of disk group grp2.        /devices/diskQ4 is a candidate disk.   Which command will add the disk /devices/diskP4 to the disk group， grp1？（）
A

 ALTER DISKGROUP grp1  ADD DISK ’/devices/diskP1’，  ADD DISK ’/devices/diskP4’；

B

 ALTER DISKGROUP grp1  ADD DISK ’/devices/disk*4’；

C

 ALTER DISKGROUP grp1  ADD DISK ’/devices/diskP*’；

D

 ALTER DISKGROUP grp1  ADD DISK ’/devices/diskQ*’，  ADD DISK ’/devices/diskP*’；


正确答案： B
解析： 暂无解析

第8题：

单选题
You observe that the senior database administrator always uses the following command when connecting to Recovery Manager （RMAN）， and then starts executing commands to backup the database files：  $ rman target /  What would be the effect of this command？（）
A

RMAN would use the current operating system location to place the backup.

B

RMAN would use the control file of the target database to maintain the backup.

C

RMAN would use the recovery catalog of the target database to maintain the backup.

D

RMAN would use the control file of the target database to maintain the backup metadata. 

E

RMAN would use the recovery catalog of the target database to maintain the backup metadata.


正确答案： C
解析： 暂无解析

第9题：

多选题
While creating a scheduler window using the DBMS_SCHEDULER package， a user logged in as DBMGR gets the error message insufficient privileges.  Which two commands would you use to resolve this error？（）
A

GRANT dba TO dbmgr;

B

GRANT connect TO dbmgr;

C

GRANT resource TO dbmgr;

D

GRANT hs_admin_role TO dbmgr;

E

GRANT manage scheduler TO dbmgr;


正确答案： B,D
解析： 暂无解析

第10题：

多选题
You want to use the SQL Tuning Advisor to generate recommendations for badly written SQL statements in your development environment.   Which three sources can you select for the advisor to analyze？ （）
A

Top SQL

B

snapshots

C

SQL Tuning sets

D

index access path

E

optimizer statistics

F

materialized view logs


正确答案： A,B
解析： 暂无解析

更多相关问题
相关内容