多选题As the DBA， you run the following query on your ASM instance. What is the implication of the results of the query？（） SQL select group_number， name， state from v$ASM_DISKGROUP； GROUP_NUMBER NAME STATE 0 DGROUP1 DISMOUNTED 2 DGROUP2 MOUNTED 3 DGROUP3 MOUNTEDAThe DGROUP1 disk group was unmounted by another DBA.BA datafile has been lost， causing the ASM disk group DGROUP1 to go into the DISMOUNTED stateCOne of the redundant disks （DGROUP1） has been lost in a disk group.DThis query has no meaning in an ASM instance.EA disk associated with a disk group was discovered after the ASM instance initially opened.
多选题
As the DBA， you run the following query on your ASM instance. What is the implication of the results of the query？（） SQL> select group_number， name， state from v$ASM_DISKGROUP； GROUP_NUMBER NAME STATE 0 DGROUP1 DISMOUNTED 2 DGROUP2 MOUNTED 3 DGROUP3 MOUNTED
A
The DGROUP1 disk group was unmounted by another DBA.
B
A datafile has been lost， causing the ASM disk group DGROUP1 to go into the DISMOUNTED state
C
One of the redundant disks （DGROUP1） has been lost in a disk group.
D
This query has no meaning in an ASM instance.
E
A disk associated with a disk group was discovered after the ASM instance initially opened.
参考解析
解析：
暂无解析
相关考题：
You are a network administrator for your company. You currently automate backups of the System State data on the servers in your network by using NTBackup. Your manager instructs you to document the procedure for restoring a server from a backup of the System State data.You need to select the correct method for performing a restoration of a backup of the System State data.What should you do?（）A. Run the following command: ntbackup.exe backup /F {FileName}B. Run the following command: ntbackup.exe backup systemstate /F {FileName}C. In Control Panel, open System, and configure the Startup and Recovery settings on the Advanced tab.D. Use NTBackup interactively.
AstheDBA，yourunthefollowingqueryonyourASMinstance.Whatistheimplicationoftheresultsofthequery？（）SQLselectgroup_number，name，statefromv$ASM_DISKGROUP；GROUP_NUMBERNAMESTATE0DGROUP1DISMOUNTED2DGROUP2MOUNTED3DGROUP3MOUNTEDA.TheDGROUP1diskgroupwasunmountedbyanotherDBA.B.Adatafilehasbeenlost，causingtheASMdiskgroupDGROUP1togointotheDISMOUNTEDstateC.Oneoftheredundantdisks（DGROUP1）hasbeenlostinadiskgroup.D.ThisqueryhasnomeaninginanASMinstance.E.AdiskassociatedwithadiskgroupwasdiscoveredaftertheASMinstanceinitiallyopened.
The EMPLOYEES table contains these columns:LAST_NAME VARCHAR2 (25)SALARY NUMBER (6,2)COMMISSION_PCT NUMBER (6)You need to write a query that will produce these results:1. Display the salary multiplied by the commission_pct.2. Exclude employees with a zero commission_pct.3. Display a zero for employees with a null commission value. Evaluate the SQL statement:SELECT LAST_NAME, SALARY*COMMISSION_PCT FROM EMPLOYEESWHERE COMMISSION_PCT IS NOT NULL;What does the statement provide? （）A. All of the desired resultsB. Two of the desired resultsC. One of the desired resultsD. An error statement
作为一个oracleDBA,你运行以下的SQL命令查询ASM实例,查询结果的含义是什么?()SQL>select group_number,name,state from v$ASM_DISKGROUP;GROUP_NUMBER NAME STATE 0 DGROUP1DISMOUNTED2 DGROUP2 MOUNTED3 DGROUP3 MOUNTED A.这个查询在ASM实例中没有意义B.一个多余的磁盘(DGROUP1)将在磁盘组中丢失C.一个数据文件丢失，原因是DGROUP1磁盘组正在进入DISMOUNTED状态D.DGROUP1磁盘组被其他的DBA卸载了
You are the network administrator for You currently automate backups of the System State data on the servers in your network by using NTBackup. Your manager instructs you to document the procedure for restoring aserver from a backup of the System State data.You need to select the correct method for performing a restoration of a backup of the System State data.What should you do?（）A. Run the following command: ntbackup.exe backup /F {FileName}B. Run the following command: ntbackup.exe backup systemstate /F {FileName}C. In Control Panel, open System, and configure the Startup and Recovery settings on the Advanced tab.D. Use NTBackup interactively.
Click the Exhibit button and examine the data from the ORDERS and CUSTOMERS tables.Evaluate the SQL statement:SELECT *FROM ordersWHERE cust_id = (SELECT cust_idFROM customersWHERE cust_name = ‘Smith‘);What is the result when the query is executed?（）A.AB.BC.CD.DE.E
Examine the following output： SQL SELECT index_name，status FROM dba_indexes WHERE status=’UNUSABLE’； INDEX_NAME STATUS------------------------------ ----------- EIND UNUSABLE Which two statements about the above index are true（）A、It is ignored by the query optimizer.B、It is not used while the index is being rebuilt.C、The index cannot be rebuilt， and has to be re-created.D、The index is automatically rebuilt when used the next time
作为一个ORACLE DBA，你运行以下的SQL命令查询ASM实例，查询结果的含义是什么？（）SQLselect group_number，name，state fromv$ASM_DISKGROUP；GROUP_NUMBER NAME STATE 0 DGROUP1 DISMOUNTED 2 DGROUP2 MOUNTED 3 DGROUP3 MOUNTEDA、DGROUP1磁盘组被其他的DBA卸载了B、一个多余的磁盘（DGROUP1）将在磁盘组中丢失C、一个数据文件丢失，原因是DGROUP1磁盘组正在进入DISMOUNTED状态D、这个查询在ASM实例中没有意义
The EMPLOYEE tables has these columns: LAST_NAME VARCHAR2(35) SALARY NUMBER(8,2) COMMISSION_PCT NUMBER(5,2) You want to display the name and annual salary multiplied by the commission_pct for all employees. For records that have a NULL commission_pct, a zero must be displayed against the calculated column. Which SQL statement displays the desired results?（）A、SELECT last_name, (salary * 12) * commission_pct FROM EMPLOYEES;B、SELECT last_name, (salary * 12) * IFNULL(commission_pct, 0) FROM EMPLOYEES;C、SELECT last_name, (salary * 12) * NVL2(commission_pct, 0) FROM EMPLOYEES;D、SELECT last_name, (salary * 12) * NVL(commission_pct, 0) FROM EMPLOYEES;
After executing the command alter diskgroup disk group2 drop disk dg2a； you issue the following command from the ASM instance： Select group_number， count（*） from v$asm_operation； What is the implication if the query against V$ASM_OPERATION returns zero rows？（） A、 The drop disk operation is still proceeding and you cannot yet run the undrop disks operation.B、 The drop disk operation is complete and you can run the undrop disks command if needed.C、 The drop disk operation is complete and you cannot run the undrop disk command.D、 The query will fail since there is not a V$ASM_OPERATION view available in an ASM instance. E、 None of the above is true.
The EMPLOYEES table contains these columns: LAST_NAME VARCHAR2 (25) SALARY NUMBER (6,2) COMMISSION_PCT NUMBER (6) You need to write a query that will produce these results: 1. Display the salary multiplied by the commission_pct. 2. Exclude employees with a zero commission_pct. 3. Display a zero for employees with a null commission value. Evaluate the SQL statement: SELECT LAST_NAME, SALARY*COMMISSION_PCT FROM EMPLOYEES WHERE COMMISSION_PCT IS NOT NULL; What does the statement provide? （）A、All of the desired resultsB、Two of the desired resultsC、One of the desired resultsD、An error statement
You need to display the last names of those employees who have the letter "A" as the second character in their names. Which SQL statement displays the required results? （）A、SELECT last_name FROM EMP WHERE last_ name LIKE '_A%';B、SELECT last_name FROM EMP WHERE last name ='*A%'C、SELECT last_name FROM EMP WHERE last name ='_A%';D、SELECT last_name FROM EMP WHERE last name LIKE '*A%'
The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema. What happens when you execute this query? SELECT * FROM HR;（）A、You obtain the results retrieved from the public synonym HR created by the database administrator.B、You obtain the results retrieved from the HR table that belongs to your schema.C、You get an error message because you cannot retrieve from a table that has the same name as a public synonym.D、You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.E、You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a FULL JOIN.
As the DBA， you run the following query on your ASM instance. What is the implication of the results of the query？（） SQL select group_number， name， state from v$ASM_DISKGROUP； GROUP_NUMBER NAME STATE 0 DGROUP1 DISMOUNTED 2 DGROUP2 MOUNTED 3 DGROUP3 MOUNTED A、 The DGROUP1 disk group was unmounted by another DBA.B、 A datafile has been lost， causing the ASM disk group DGROUP1 to go into the DISMOUNTED stateC、 One of the redundant disks （DGROUP1） has been lost in a disk group.D、 This query has no meaning in an ASM instance.E、 A disk associated with a disk group was discovered after the ASM instance initially opened.
You want to view the name of a program associated with a job for making some changes to the program. Which view will you query to find the name of the program associated with the job？（）A、 DBA_SCHEDULER_JOB_RUN_DETAILSB、 DBA_SCHEDULER_RUNNING_JOBSC、 DBA_SCHEDULER_JOBSD、 DBA_SCHEDULER_JOB_LOG
You received complaints about the degradation of SQL query performance. You identified top SQL queries that consume time. What would be your next step to find out recommendations about statistics collection and restructuring of the SQL statement to improve query performance？（）A、run Segment AdvisorB、run SQL Tuning Advisor on top SQL statementsC、run the Automatic Workload Repository （AWR） reportD、run the Automatic Database Diagnostic Monitor （ADDM）on top SQL statements
当需要返回当前用户的名字，可以执行如下（）SQL语句。A、SELECT user FROM V$DBAB、SELECT user FROM dualC、SELECT name FROM dualD、SELECT name FROM V$DBA
Note the output of the following query； SQL SELECT flashback_archieve_name， status FROM dba_flashback_archieve； FLASHBACK_ARCHIEVE_NAME STATUS FLA1 You executed the following command to enable Flashback Data Archive on the EXCHANGB_PATE table： ALTER TABLE exchange_rate FLASHBACK ARCHIEVE； What is the outcome of this command？（） A、 The table uses the default Flashback Data Archive.B、 The Flashback Data Archive Is created In the SYSAUX tablespace.C、 The Flashback Data Archive is created in the same tablespace where the tables are stored.D、 The command generates an error because no flashback Data Archive name is specified and there is no default Flashback Data Achieve.
The following query will provide what information about transportable tablespaces for the current database？（） select d.platform_name "Source"， t.platform_name "Compatible Targets"， endian_format from v$transportable_platform t， v$database d where t.endian_format = （select endian_format from v$transportable_platform t， v$database d where d.platform_name = platform_name）； A、 The list of target platforms having the same endian format as the source databaseB、 The list of target platforms requiring endian conversionC、 The list of target platforms that will not require endian conversionD、 The list of all target platforms that can receive transportable tablespaces from the source databaseE、 None of the above
You are a network administrator for your company. You currently automate backups of the System State data on the servers in your network by using NTBackup. Your manager instructs you to document the procedure for restoring a server from a backup of the System State data.You need to select the correct method for performing a restoration of a backup of the System State data.What should you do?（）A、Run the following command: ntbackup.exe backup /F {"FileName"}B、Run the following command: ntbackup.exe backup systemstate /F {"FileName"}C、In Control Panel, open System, and configure the Startup and Recovery settings on the Advanced tab.D、Use NTBackup interactively.
多选题Examine the following output： SQL SELECT index_name，status FROM dba_indexes WHERE status=’UNUSABLE’； INDEX_NAME STATUS------------------------------ ----------- EIND UNUSABLE Which two statements about the above index are true（）AIt is ignored by the query optimizer.BIt is not used while the index is being rebuilt.CThe index cannot be rebuilt， and has to be re-created.DThe index is automatically rebuilt when used the next time
单选题The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema. What happens when you execute this query? SELECT * FROM HR;（）AYou obtain the results retrieved from the public synonym HR created by the database administrator.BYou obtain the results retrieved from the HR table that belongs to your schema.CYou get an error message because you cannot retrieve from a table that has the same name as a public synonym.DYou obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.EYou obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a FULL JOIN.
单选题You want to view the name of a program associated with a job for making some changes to the program. Which view will you query to find the name of the program associated with the job？（）A DBA_SCHEDULER_JOB_RUN_DETAILSB DBA_SCHEDULER_RUNNING_JOBSC DBA_SCHEDULER_JOBSD DBA_SCHEDULER_JOB_LOG
多选题The following query will provide what information about transportable tablespaces for the current database？（） select d.platform_name "Source"， t.platform_name "Compatible Targets"， endian_format from v$transportable_platform t， v$database d where t.endian_format = （select endian_format from v$transportable_platform t， v$database d where d.platform_name = platform_name）；AThe list of target platforms having the same endian format as the source databaseBThe list of target platforms requiring endian conversionCThe list of target platforms that will not require endian conversionDThe list of all target platforms that can receive transportable tablespaces from the source databaseENone of the above
单选题Note the output of the following query； SQL SELECT flashback_archieve_name， status FROM dba_flashback_archieve； FLASHBACK_ARCHIEVE_NAME STATUS FLA1 You executed the following command to enable Flashback Data Archive on the EXCHANGB_PATE table： ALTER TABLE exchange_rate FLASHBACK ARCHIEVE； What is the outcome of this command？（）A The table uses the default Flashback Data Archive.B The Flashback Data Archive Is created In the SYSAUX tablespace.C The Flashback Data Archive is created in the same tablespace where the tables are stored.D The command generates an error because no flashback Data Archive name is specified and there is no default Flashback Data Achieve.
单选题A user named Arren is executing this query： select table_name，operation，undo_sql from flashback_transaction_query t， （select versions_xid as xid from employees versions between scn minvalue and maxvalue where employee_id = 123） e where t.xid = e.xid； When the query runs，he receives an ORA-01031： insufficient privileges error. Since the user owns the employees table，you know that it is not the problem. Which of the following SQL statements will correct this problem？（）A GRANT SELECT ANY TRANSACTION TO ARRENB GRANT SELECT ON FLASHBACK_TRANSACTION_QUERY TO ARRENC GRANT SELECT_ANY_TRANSACTION TO ARREND GRANT FLASHBACK TO ARRENE GRANT SELECT ANY VIEW TO ARREN
单选题作为一个ORACLE DBA，你运行以下的SQL命令查询ASM实例，查询结果的含义是什么？（）SQLselect group_number，name，state fromv$ASM_DISKGROUP；GROUP_NUMBER NAME STATE 0 DGROUP1 DISMOUNTED 2 DGROUP2 MOUNTED 3 DGROUP3 MOUNTEDADGROUP1磁盘组被其他的DBA卸载了B一个多余的磁盘（DGROUP1）将在磁盘组中丢失C一个数据文件丢失，原因是DGROUP1磁盘组正在进入DISMOUNTED状态D这个查询在ASM实例中没有意义