检索和名叫SCOTT的员工相同工资的员工信息，但不显示SCOTT。显示字段：员工号、员工名、工资。
检索和名叫SCOTT的员工相同工资的员工信息，但不显示SCOTT。显示字段：员工号、员工名、工资。
相关考题：
在Oracle中，将scott的资源文件改为otherprofile，下列哪个是正确的？（ ）A.ALTER PROFILE USER scott otherprofileB.ALTER otherprofile USER scottPROFILEC.ALTER USER scott PROFILE otherprofileD.ALTER scott USER PROFILE otherprofile
You executed the following command to drop a user:DROP USER scott CASCADE;Which two statements regarding the above command are correct?() A. All the objects of scott are moved to the Recycle Bin.B. Any objects in the Recycle Bin belonging to scott are purged.C. All the objects owned by scott are permanently dropped from the database.D. All the objects of scott in the Recycle Bin must be purged before executing the DROP command.E. Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.
YousettheundopoolresourceplandirectivefortheconsumergroupnamedDSS_USERSthatisassignedtotheDAY_SHIFTplan.Thedatabaseusers，SCOTTandBLAKE，belongtotheDSS_USERSresourcegroup.Theuser，SCOTT，initiatesadatabasesessionandexecutesabatchoperationthatinsertsmillionsofrowsintotheHISTORYtable.WhichtwooptionsaretrueifthetotalundospaceallocatedtotheDSS_USERSgroupexceedsthevaluespecifiedintheundopoolresourceplandirective？（）A.Thebatchoperationstartedbytheuser，SCOTT，terminateswithanerror.B.Thebatchoperationstartedbytheuser，SCOTT，hangsandyouarerequiredtoincreasetheundopoolresourceplandirective.C.Thebatchoperationstartedbytheuser，SCOTT，runsuninterruptedbecausethedatabaseusestheSYSTEMtablespacefortheundooperation.D.Theuser，BLAKE，cannotstartatransactionthatusesanyDMLoperationsuntilyouincreasethevalueoftheundopoolresourceplandirective.E.TheuserBLAKEcanstartatransactionthatusesanyDMLoperationsafterthebatchoperationstartedbytheuser，SCOTT，terminateswithanerror.
Youissuethefollowingcode:EXECDBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP(’SCOTT’’GRP1’,TRUE);Whatwillbetheresultofexecutingtheabovecode?() A.Theswitchprivilegewillbegrantedtotheuser，Scott，forchangingtheconsumergrouptoGRP1.B.Theswitchprivilegewillbegrantedtotheuser，Scott，forchangingtheconsumergroupfromGRP1toanyothergroup.C.ThecodewillnotexecutesuccessfullybecausethereisnoGRANT_SWITCH_CONSUMER_GROUPprocedureintheDBMS_RESOURCE_MANAGER_PRIVSpackage.D.Thecodewillexecutesuccessfullybutnoprivilegewillbegrantedtotheuser，Scott.
在Oracle中，用ALTER将scott的口令改为hello，下列哪个是正确的？（ ）A.ALTER USER scott IDENTIFIED BY helloB.ALTER scott USER IDENTIFIED BY helloC.ALTER USER scott IDENTIFIED AS helloD.ALTER USER hello IDENTIFIED BY scott
假定某非本机数据库的全局数据库名为ORCL.COM,数据库实例的SID为ORCL,定义的这个数据库的连接串为ORCLDB,数据库的用户名为scott,口令为tiger.那么以下哪个命令可以登录这个数据库() A.sqlplus scott/tigerB.sqlplus scott/tiger@ORCL.COMC.sqlplus scott/tiger@ORCLD.sqlplus scott/tiger@ORCLDBE.以上所述都不正确
授予sa用户在SCOTT.EMP表中SAL列的更新权限的语句是()。 A.GRANT CHANGE ON SCOTT.EMP TO SAB.GRANT UPDATE ON SCOTT.EMP（SAL） TO SAC.GRANT UPDATE （SAL） ON SCOTT.EMP TO SAD.GRANT MODIFY ON SCOTT.EMP（SAL） TO SA
数据库中有两个用户scott和myuser，物资表wz是属于myuser用户的，但当前用户是scott，要求查询物资表wz（wno，wname，wtype，wunit）物资单位wunit列为null的记录，取结果的前5条记录显示，以下正确的SQL语句是（）A、select*from scott.wz where wunit is null and rownum5B、select*from myuser.wz where wunit = null and rownum5C、select*from myuser.wz where wunit is null and rownum6D、select*form scott.wz where wunit is null and rownum6
在Oracle中，将scott的缺省表空间改为data2_ts，下列哪个是正确的？（）A、ALTER USER scott DEFAULT TABLESPACE data2_tsB、ALTER DEFAULT TABLESPACE data2_ts USER scottC、ALTER USER scott TABLESPACE DEFAULT data2_tsD、ALTER scott USER DEFAULT TABLESPACE data2_ts
多选题User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, whichcommands must you execute to enable SCOTT to flash back the transactions? （）(Choose four.)AALTER DATABASE FLASHBACK ON;BGRANT SELECT any transaction TO scott;CGRANT EXECUTE ON dbms_flashback TO scott;DALTER DATABASE ADD SUPPLEMENTAL LOG DATA;EALTER TABLESPACE undots1 RETENTION GUARANTEE;FALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;
单选题What will be the result of using the SQL DROP USER SCOTT CASCADE； command？（）A The user， Scott， is dropped， all the objects in Scott’s schema are placed in the Recycle Bin， and the objects that are already in the Recycle Bin are dropped.B The user， Scott， is dropped， all the objects in Scott’s schema are placed in the Recycle Bin， and all the objects in the Recycle Bin， belonging to the user Scott， are not dropped.C The user， Scott， is dropped， all the objects in the Scott’s schema are not placed in the Recycle Bin， and the objects in the Recycle Bin， belonging to the user， Scott， are not dropped.D The user， Scott， is dropped， all the objects in Scott’s schema are not placed in the Recycle Bin， and the objects in the Recycle Bin are dropped.
多选题In which two scenarios should you issue the following command？（） FLASHBACK TABLE SCOTT.EMP TO TIMESTAMP SYSTIMESTAP- INTERVAL ’15’ MINUTE；Awhen the schema of the user， SCOTT， was deleted by mistake 15 minutes agoBwhen the table EMP of the SCOTT schema was dropped by mistake 15 minutes agoCwhen some rows of the table， EMP， in the SCOTT schema were deleted by mistake 15 minutes agoDwhen some incorrect values were inserted in the EMP table in the user Scott’s schema during the last 15 minutesEnever， because FLASHBACK TABLE is not a valid command in Oracle 10g.
多选题You executed the following command to drop a user: DROP USER scott CASCADE; Which two statements regarding the above command are correct?（）AAll the objects of scott are moved to the Recycle Bin.BAny objects in the Recycle Bin belonging to scott are purged.CAll the objects owned by scott are permanently dropped from the database.DAll the objects of scott in the Recycle Bin must be purged before executing the DROP command.EAny objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.
单选题Seven years ago, Scott was 3 times as old as Kathy was at that time. If Scott is now 5 years older than Kathy, how old is Scott ?A12.5B13C14D14.5
单选题授予sa用户在SCOTT.EMP表中SAL列的更新权限的语句是（）。AGRANT CHANGE ON SCOTT.EMP TO SABGRANT UPDATE ON SCOTT.EMP（SAL） TO SACGRANT UPDATE （SAL） ON SCOTT.EMP TO SADGRANT MODIFY ON SCOTT.EMP（SAL） TO SA
单选题You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table？（）A You must enable the block change tracking feature.B You must have enable the flashback feature.C You must use the OMF in your database.D You must define the tablespace of the SCOTT.EMP table for automatic segment space management.
单选题假定某非本机数据库的全局数据库名为ORCL.COM，数据库实例的SID为ORCL，定义的这个数据库的连接串为ORCLDB，数据库的用户名为scott，口令为tiger.那么以下哪个命令可以登录这个数据库（）Asqlplus scott/tigerBsqlplus scott/tiger@ORCL.COMCsqlplus scott/tiger@ORCLDsqlplus scott/tiger@ORCLDBE以上所述都不正确
多选题User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives the followingerror after the INSERT statement is issued and few rows are inserted：INSERT INTO EMP_DEP （emp_id，name，salary，dep_name，mgr_id） *ERROR at line 1： ORA-01653： unable to extend table SCOTT.EMP_DEP by 128 in tablespace USERS Identify two actions eitherof which will help you resolve this problem. （）AGrant the RESOURCE role to SCOTT.BAdd data files to the USERS tablespace.CGrant the CREATE ANY TABLE privilege to SCOTT.DIncrease the space for SCOTT on the USERS tablespace.EIncrease the size of the data file associated with the USERS tablespace