From the V$SESSION_LONGOPS view， you find that some of the database users have long/x7frunning queries that consume a lot of CPU time. This causes performance problems for other users in the database， who have much shorter queries. You would like to make sure that the users with large queries do not use all the CPU time， but you still do not want to terminate them with an error message. Which method would you follow to achieve this？（）A、set the CPU time per call in the users profileB、set the CPU time per session in the users profilesC、set the CPU levels for the users’ group using Resource ManagerD、set the TIMED_STATISTICS parameter to TRUE in the parameter file
From the V$SESSION_LONGOPS view， you find that some of the database users have long/x7frunning queries that consume a lot of CPU time. This causes performance problems for other users in the database， who have much shorter queries. You would like to make sure that the users with large queries do not use all the CPU time， but you still do not want to terminate them with an error message. Which method would you follow to achieve this？（）
- A、set the CPU time per call in the users profile
- B、set the CPU time per session in the users profiles
- C、set the CPU levels for the users’ group using Resource Manager
- D、set the TIMED_STATISTICS parameter to TRUE in the parameter file
相关考题：
在SQL Server 2000中，有学生表(学号，姓名，年龄，所在系)，学号是主码。在这个表上建有视图V1,V1视图的定义语句为： CREATE VIEW V1 AS SELECT姓名，年龄，所在系FROM学生表 WHERE年龄＞=(SELECT AVG(年龄)FROM学生表) 有下列操作语句： Ⅰ.UPDATE V1 SET年龄=年龄+1 Ⅱ.SELECT*FROM V1 WHERE年龄＞20 Ⅲ.DELETE FROM V1 WHERE年龄＞20 Ⅳ.INSERT INTO V1 VALUES(，张三，20,‘计算机系’) 以上语句能正确执行的是A．仅Ⅰ和ⅡB．仅ⅡC．仅Ⅱ和ⅣD．仅Ⅰ、Ⅱ和Ⅲ
Given the following DDL and INSERT statements:CREATE VIEW v1 AS SELECT col1 FROM t1 WHERE col1 10; CREATE VIEW v2 AS SELECT col1 FROM v1 WITH CASCADED CHECK OPTION; CREATE VIEW v3 AS SELECT col1 FROM v2 WHERE col1 100; INSERT INTO v1 VALUES(5); INSERT INTO v2 VALUES(5); INSERT INTO v3 VALUES(20); INSERT INTO v3 VALUES(100);How many of these INSERT statements will be successful?（）A.0B.1C.2D.3
当需要查询日志文件所有组及其成员的名称和文件位置,可以使用()方式。 A.SELECT * FROM V$LOGFILEB.SELECT * FROM V$LOGC.SELECT * FROM V$LOGHISTORYD.SELECT * FROM V$DBA
当需要查询Oracle的控制文件的名称、位置和状态时,可以使用()语句。 A.SELECT name FROM V$CONTROLFILEB.SELECT name FROM V$CTRLLFILEC.SELECT name FROM V$USERFILESD.SELECT name FROM V$DBAFILE
Vessels to which Annex V to MARPOL 73/78 applies may discharge garbage containing plastics ______.A.5 nautical miles from nearest landB.12 nautical miles from nearest landC.25 nautical miles from nearest landD.None of the above
Other than through the Purchase Orders application， how can Purchase Orders be created in IBM Maximo Asset Management V6.2？（）A、 from an approved Lease， Rental， Master， or Purchase contractB、 from a Purchase Requisitions Create PO action， create the approved Purchase OrderC、 from a Purchase Requisition， a Request for Quotation， a Master Contract， or a reorder processD、 from a Purchase Requisition， a Request for Quotation， a Purchase Contract， or a reorder process
变量v_time=’23-MAY-00’， 如下那条语句返回值为’01-JAN-00’？（）A、select round（v_time，’DAY’） from dualB、select round（v_time，’YEAR’） from dualC、select round（v_time，’MONTH’） from dualD、A select round（to_char（v_time，’yyyy’）） from dual
V5.x系统中，用SQL语句查询Sybase版本的语句是（）A、select ##versionB、select ##version from masterC、select @@version from masterD、select @@version
有关系模式：学生表（学号，姓名，所在系），建立统计每个系的学生人数的视图的正确语句是（）A、CREATE VIEW v1AS SELECT所在系，COUNT（*）FROM学生表GROUP BY所在系B、CREATEVIEW v1AS SELECT所在系，SUM（*）FROM学生表GROUP BY所在系C、CREATE VIEW v1（系名，人数）AS SELECT所在系，SUM（*）FROM学生表GROUP BY所在系D、CREATE VIEW v1（系名，人数）AS ELECT所在系，COUNT（*）FROM学生表GROUP BY所在系
A database user SMITH tries to query the V$SESSION view and fails to access it as follows： SQL connect smith/smith Connected. SQL SELECT * FROM v$session； SELECT * FROM v$session * ERROR at line 1： ORA-00942： table or view does not exist Which are the two possible solutions to enable SMITH to query the data in V$SESSION（）A、granting SELECT privilege to SMITH on V$SESSIONB、granting SELECT privilege to SMITH on V_$SESSIONC、asking the user SMITH to run the catalog.sql scriptD、granting SELECT privilege to SMITH on V$FIXED_TABLESE、setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUEF、creating a view based on V$SESSION and granting SELECT privilege to SMITH on the view that was created
In what view are you likely to see the following output？（） SID SERIAL# EVENT SECONDS_IN_WAIT 121 269 RMAN backup recovery I/O 2 129 415 SQL*Net message from client 63 130 270 SQL*Net message from client A、 V$SESSION_EVENTB、 V$SESSIONC、 V$WAITSD、 V$WAITSTATE、 V$SYSSTAT
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
Your network includes the following elements： VMware ESX 3.5 serversWindows Server 2008 R2 Hyper-V serversMicrosoft System Center Virtual Machine Manager （VMM） 2008 R2 with the Subsystem for UNIX-based Applications feature installed You run several ESX-hosted virtual machines （VMs） from an NFS share， and you run several Hyper-V VMs from a Windows file share. You need to migrate the ESX-hosted VMs to Hyper-V. Which two actions should you perform？（）A、Shut down the VMsB、Copy the .vmx and .vmdk files to the VMM libraryC、Copy the .vmx and .vmdk files from the NFS share to the Windows file shareD、Run the New-V2V PowerShell cmdlet and point to the .vmx files
单选题A vessel to which Annex V to MARPOL 73/78 applies is 24 nautical miles from the nearest land. Which type of garbage is prohibited from being discharged? （）AGlassBCrockeryCMetalDDunnage
单选题No person on board any vessel to which Annex V to MARPOL 73/78 applies may discharge garbage of any type when（）.Aless than 12 nautical miles from PRCBless than 12 nautical miles from nearest landCin the navigable waters of the PRCDless than 25 nautical miles from nearest land
单选题关于两个表对应的不匹配查询的正确语句为（）ASELECT[ccode]FROM[GL_accsum]where not exists（SELECT*FROM[code]group by ccode having[ccode]=[GL_accsum].[ccode]）BSELECT[ccode]FROM[GL_accsum]v where ccode not in（SELECTccodeFROM[code] where[ccode]=[v].[ccode]）CC.select ccode from[GL_accsum]a left join code bon A.[ccode]=[b].[ccode] where B.ccode is nullDD.select ccode codes from[GL_accsum]a join code bon A.[ccode]=[b].[ccode] where B.ccode is null
单选题当需要查询日志文件所有组及其成员的名称和文件位置，可以使用（）方式。ASELECT * FROM V$LOGFILEBSELECT * FROM V$LOGCSELECT * FROM V$LOGHISTORYDSELECT * FROM V$DBA
单选题Vessels to which Annex V to MARPOL 73/78 applies may discharge garbage containing plastics （）.A5 nautical miles from nearest landB12 nautical miles from nearest landC25 nautical miles from nearest landDNone of the above
单选题Given the following DDL and INSERT statements: CREATE VIEW v1 AS SELECT col1 FROM t1 WHERE col1 10; CREATE VIEW v2 AS SELECT col1 FROM v1 WITH CASCADED CHECK OPTION; CREATE VIEW v3 AS SELECT col1 FROM v2 WHERE col1 100; INSERT INTO v1 VALUES(5); INSERT INTO v2 VALUES(5); INSERT INTO v3 VALUES(20); INSERT INTO v3 VALUES(100); How many of these INSERT statements will be successful?（）A0B1C2D3
单选题“客户”表和“贷款”表的结构如下：客户（客户号，姓名，出生日期，身份证号）贷款（贷款编号，银行号，客户号，贷款金额，贷款性质）建立视图统计每个客户贷款的次数，正确的SQL语句是（ ）。ACREATE VIEW v_dk AS SELECT客户号，count（*）AS次数FROM贷款BCREATE VIEW v_dk AS SELECT客户号，count（*）AS次数FROM贷款COMPUTE BY客户号CCREATE VIEW v_dk AS SELECT客户号，count（*）AS次数FROM贷款ORDER BY客户号DCREATE VIEW v_dk AS SELECT客户号，count（*）AS次数FROM贷款GROUP BY客户号
单选题当需要返回当前用户的名字，可以执行如下（）SQL语句。ASELECT user FROM V$DBABSELECT user FROM dualCSELECT name FROM dualDSELECT name FROM V$DBA
单选题假设需要查询Oracle数据文件的文件名和存储位置，可以使用如下（）方式。ASELECT name，status FROM V$datafileBSELECT name，statusFROM V$userfileCSELECT name，status FROM V$DBADSELECT name，status FROM V$ctrlfile
单选题SGA是一块巨大的共享内存区域，被看成是Oracle数据库的一个大缓冲池，如果需要查看SGA的大小信息，可以使用如下（）语句。ASELECT SGA FROM V$DBABSELECT * FROM V$DBACSELECT * FROM V$SGADSELECT size FROM V%DBA
多选题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
单选题A view is created with the following statement:CREATE VIEW v1 AS SELECT col1, col2, col3 FROM t1 WHERE col4 1000 ; When will DB2 access the data from table T1 for view V1?（）AWhen view V1 is createdBEach time the REFRESH VIEW v1 statement is executedCEach time an SQL statement is executed against view V1DOnly the first time an SQL statement is executed against view V1
单选题当需要查询Oracle的控制文件的名称、位置和状态时，可以使用（）语句。ASELECT name FROM V$CONTROLFILEBSELECT name FROM V$CTRLLFILECSELECT name FROM V$USERFILESDSELECT name FROM V$DBAFILE
单选题In what view are you likely to see the following output？（） SID SERIAL# EVENT SECONDS_IN_WAIT 121 269 RMAN backup recovery I/O 2 129 415 SQL*Net message from client 63 130 270 SQL*Net message from clientA V$SESSION_EVENTB V$SESSIONC V$WAITSD V$WAITSTATE V$SYSSTAT
单选题变量v_time=’23-MAY-00’， 如下那条语句返回值为’01-JAN-00’？（）Aselect round（v_time，’DAY’） from dualBselect round（v_time，’YEAR’） from dualCselect round（v_time，’MONTH’） from dualDA select round（to_char（v_time，’yyyy’）） from dual