Youwanttoenabletheuser，Scott，tochangetotheGRP1consumergroupbyissuingthefollowingcode：SQL>EXECDBMS_SESSION.SWITCH_CURRENT_CONSUMER_GROUP（’SCOTT’，’GRP1’，FALSE）；Howwillyougranttheswitchprivilegetotheuser，Scott？（）A.byusingtheDBMS_SESSIONpackageB.bygrantingthe

题目

Youwanttoenabletheuser，Scott，tochangetotheGRP1consumergroupbyissuingthefollowingcode：SQL>EXECDBMS_SESSION.SWITCH_CURRENT_CONSUMER_GROUP（’SCOTT’，’GRP1’，FALSE）；Howwillyougranttheswitchprivilegetotheuser，Scott？（）

A.byusingtheDBMS_SESSIONpackage

B.bygrantingtheDBArole

C.byusingtheDBMS_RESOURCE_MANAGERpackage

D.byusingtheDBMS_RESOURCE_MANAGER_PRIVSpackage

相似考题

1.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.

2.WhatwillbetheresultofusingtheSQL>DROPUSERSCOTTCASCADE;command?()A.Theuser，Scott，isdropped，alltheobjectsinScott’sschemaareplacedintheRecycleBin，andtheobjectsthatarealreadyintheRecycleBinaredropped.B.Theuser，Scott，isdropped，alltheobjectsinScott’sschemaareplacedintheRecycleBin，andalltheobjectsintheRecycleBin，belongingtotheuserScott，arenotdropped.C.Theuser，Scott，isdropped，alltheobjectsintheScott’sschemaarenotplacedintheRecycleBin，andtheobjectsintheRecycleBin，belongingtotheuser，Scott，arenotdropped.D.Theuser，Scott，isdropped，alltheobjectsinScott’sschemaarenotplacedintheRecycleBin，andtheobjectsintheRecycleBinaredropped.

3.YouaremaintainingyourdatabaseinARCHIVELOGmode.Animportanttable，SCOTT.EMPLOYEE，isdroppedandpurgedfromtheRecycleBinonMondayat2：00P.M.YoudonotuseRMANtoperformbackups.Youperformedthelastfulluser-managedbackupat9：00P.M.onSunday.Howwillyourecoverthedroppedtable，SCOTT.EMPLOYEE？（）A.byusingtheFlashbackTablefeatureB.byusingtheFlashbackDatabasefeatureC.byperformingincompleterecoveryusingRMANutilityD.byperformingincompleterecoveryusinguser-managedrecovery

4.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.

更多“Youwanttoenabletheuser,Scott,tochangetotheGRP1consumergroupbyissuingthefollowingcode:SQL&g ”相关问题

  • 第1题：

    在oracle数据库下,在启用审计的数据库上执行下面的命令SQL>AUDITDROPANYTABLEBYscottBYSESSIONWHENEVERSUCCESSFUL;有关此命令的影响描述正确的是?()

    A.每一个会话drop属于scott用户的表成功就会产生一条审计记录

    B.凡是每一个scott用户会话成功droptable操作，就会存在一条审计记录

    C.同一个scott会话中，drop一张或多张表成功就会产生一条审计记录

    D.scott用户授权给其它用户droptable权限时就会生成一条审计记录


    参考答案：C

  • 第2题：

    4.检索和名叫SCOTT的员工相同工资的员工信息，但不显示SCOTT。显示字段：员工号、员工名、工资。


    select empno,ename,sal from emp where sal =(select sal from emp where ename='SCOTT') and ename!='SCOTT'。

  • 第3题：

    假设用户SCOTT以管理员身份登录，需授予用户Lisa对SCOTT用户模式下的EMP表 进行查询（SELECT)的权限，请写出该命令 。


    正确

  • 第4题：

    根据提供的信息和语言素材设计教学方案。用英文作答。
    设计任务：请阅读下面学生信息和语言素材，设计一节英语听说课的教学方案。
    教案没有固定格式，但须包含下列要点：?
    teaching objectives
    teaching contents
    key and difficult points
    major steps and time allocation
    activities and justification
    教学时间：45分钟?
    学生概况：某城镇普通中学七年级(初中一年级)学生，班级人数40人，多数学生已经达到?
    《义务教育英语课程标准(2011年版)》二级水平，学生课堂参与积极性一般。
    语言素材：?
    Interviewer: Scott has an interesting job. He works at a radio station. Scott, what time is your radio show?
    Scott: From twelve o'clock at night to six o'clock in the morning.
    Interviewer:. What time do you usually get up?
    Scott: At eight thirty at night. Then ! eat breakfast at nine.
    Interviewer: That's a funny time for breakfast!
    Scott: Yeah. After that, I usually exercise at about ten twenty.
    Interviewer: When do you go to work?
    Scott: At eleven o'clock I so I'm never late for work.


    答案：
    解析：
    【参考设计】
    Class Type: Listening and speaking class
    Teaching Contents: A dialogue between the interviewer and Scott about Scott's daily routine.
    Teaching Objectives:
    Knowledge objectives
    (1) Students can master the following words and expressions: radio station, usually, funny, exercise.
    (2) Students can use the following sentence patterns:
    ①What time do you usually ...
    ② When do you ...
    Ability objectives
    (1) Students can improve their listening ability by listening to the dialogue.
    (2) Students can improve the speaking ability by talking about what they usually do in a day.
    Emotional objectives
    Through this class, students can know something about radio workers' jobs and respect them.
    Teaching Key Point:
    How to help students master the new words, expressions and the usage of the sentence patterns.
    Teaching Difficult Point:
    How to make students master the words and expressions and improve their speaking and listening skills.
    Teaching Aid: multi-media
    Teaching Procedures:
    Step 1 Wanning up and Lead-in (5 minutes)
    The teacher greets the students and asks them two questions. The first question is "What are your parents'jobs " and the second is "Do you know something about the job of a radio host " Then the teacher tells the students that Scott has an interesting job and asks them to listen to the text and get to know about Mr. Scott.
    (Justification: This step can get students to combine English learning with their daily life. Also, it's easy for them to say something about their life.)
    Step 2 Listening (15 minutes)
    The teacher asks students to listen to the tape for the first time with the following questions. After that, asks students to try to answer the questions. Then, the teacher asks them to listen to the tape for the second time with the purpose to repeat it.
    ① Where does Mr. Scott work
    ②Does he eat breakfast in the morning as common people Why
    ③ When does he go to work
    ④Is he usually late for work
    (Justification: This step can get students to have a further understanding of the dialogue.)
    Step 3 Practice and Consolidation (20 minutes)
    (1) Practice the sentence patterns (10 minutes)
    The teacher selects an example in the dialogue, points out the sentence patterns and then makes students to make their own sentences according to the example.
    Sentence Pattern 1. --What time do you usually ... --I usually ...
    Sentence Pattern 2. --When do you ... --I ...
    Examples: ① --What time do you usually get up
    --I usually get up at 7 am.
    ② --When do you go to work
    --I go to work ...
    (Justification: This step can get students to master the sentence patterns.)
    (2) Making an interview (10 minutes)
    The teacher asks two students in pair. One student acts as an interviewer and the other acts as an interviewee.
    The interviewer makes an interview about the interviewee's job. The interviewee should use the above sentence patterns.
    (Justification: Students act out the dialogue in their own way, which helps to consolidate what they have learned in this class.)
    Step 4 Summary and Homework (5 minutes)
    Summary: The teacher asks one student to summarize what he/she has learned in this class.
    Homework: The teacher asks students to do exercises of this part on the exercise book.
    (Justification: Students can review and consolidate what they havelearned in this class.)
    Blackboard Design:
    Words and Expressions: radio station, usually, funny, exercise.
    Sentence Patterns:
    ① What time do you usually ...
    ② When do you ...
    Teaching Reflection.

  • 第5题：

    AT供电方式，Scott接线变压器馈线出口侧不需要加装AT。


    中性点

相关内容