单选题Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She granted SELECT privilege to Scott on this view. Which option enables Scott to eliminate the need to qualify the view with the name MA

题目
单选题
Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She granted SELECT privilege to Scott on this view. Which option enables Scott to eliminate the need to qualify the view with the name MARY.EMP_DEPT_LOC_VU each time the view is referenced?（）
A

Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command CREATE PRIVATE SYNONYM EDL_VU FOR mary.EMP_DEPT_LOC_VU; then he can prefix the columns with this synonym.

B

Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command CREATE SYNONYM EDL_VU FOR mary.EMP_DEPT_LOC_VU; then he can prefix the columns with this synonym.

C

Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command CREATE LOCAL SYNONYM EDL_VU FOR mary.EMP_DEPT_LOC_VU; then he can prefix the columns with this synonym.

D

Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command CREATE SYNONYM EDL_VU ON mary(EMP_DEPT_LOC_VU); then he can prefix the columns with this synonym.

E

Scott cannot create a synonym because synonyms can be created only for tables.

F

Scott cannot create any synonym for Mary's view. Mary should create a private synonym for the view and grant SELECT privilege on that synonym to Scott.

相似考题

1.Get up! Mary. Tom has () called you three times this morning.A、yetB、alreadyC、never

2.Mary has just called and asked__to have lunch with her tomorrow.A.you and I B.you and me C.I and you D.me and you

3.Emerson（）Transcendentalist.A、called himselfB、did not like the termC、never called himselfD、created the term

4.Which command will create a group called ‘delivery’and set the administrators to john’ and ‘mary’?()A.mkgroup -A=john,mary deliveryB.groupadd -A=john,mary deliveryC.mkgroup adms=john,mary deliveryD.groupadd adms=john,mary delivery

更多“Mary has a view called EMP_DEPT_LOC_VU that was created base”相关问题

  • 第1题：

    Derek has created a view in the products.nsf database. Derek wants the markup column in the view to display the selling price of the cost. He wants this value to display in currency. Which one of the following should derekl do? （）

    • A、 use the @currenty in thr column formula in the view  
    • B、 Select currency on the numbers tab in the view properties box 
    • C、 Select currency on the numbers tab in the column properties box 
    • D、 Select currency on the numbers tab in the field properties box 

    正确答案:C

  • 第2题：

     Derek has created a view in the sales.nsf db. Derek wants the sales value column in the view to be punctuated to display two decimal places . which one of the following should he do?（）

    • A、 use the @function @decimal in the column formula in the view 
    • B、 select decimal on the numbers tab in the view properties box 
    • C、 select decimal on the numbers tab in the column properties box
    • D、 use the @function @decimal to format the value in the field on the form that will display in the view 

    正确答案:C

  • 第3题：

    tommy has created a sales view in his sales.nsf database. Tommy wants negative numbers in the sales number column in the view parenthesis. which one of the following should tommy do?（）

    • A、select the parenthesis when negative value in the view properties box 
    • B、select the parenthesis when negative value in the column properties box 
    • C、use the @function @negative to set this in the column formula in the view 
    • D、use a formula to format the value in the field on the form that will be displaying in the view

    正确答案:B

  • 第4题：

    Which two statements are true regarding views?（）

    • A、A subquery that defines a view cannot include the GROUP BY clause 
    • B、A view that is created with the subquery having the DISTINCT keyword can be updated 
    • C、A view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updated 
    • D、A data manipulation language (DML) operation can be performed on a view that is created with the subquery having all the NOT NULL columns of a table

    正确答案:C,D

  • 第5题：

    单选题
    _____
    A

    The woman has bought a few things for the man.

    B

    The woman has bought a lot of things for Mary.

    C

    The woman has bought nothing for Mary.

    D

    The woman has bought a few things for herself.


    正确答案： D
    解析：
    推理判断题。女士说“我给玛丽买了一点东西”，男士说“一点？看起来你已经把整个超市都买给她了。”由该男士的答语“买了整个超市”，可以推断出这名女士给玛丽买的东西相当多，B项“这位女士给玛丽买了很多东西”为正确选项。
    【录音原文】
    W: I’ve got a few things for Mary.
    M: A few? It seems you’ve bought the whole supermarket for her.
    Q: What can we learn from this conversation?

  • 第6题：

    单选题
    Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES,DEPARTMENTS, and LOCATIONS tables. She granted SELECT privilege to Scott on this view. Which option enables Scott to eliminate the need to qualify the view with the name MARY .EMP_DEP_LOC_VU each time the view is referenced? （）
    A

    Scott can create a synonym for the EMP_DEPT_LOC_VU bus using the command: CREATE PRIVATE SYNONYM EDL_VU FOR mary. EMP DEPT_LOC_VU; then he can prefix the columns with this synonymn.

    B

    Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command: CREATE SYNONYM EDL_VU FOR mary. EMP DEPT_LOC_VU; then he can prefix the columns with this synonym.

    C

    Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command: CREATE LOCAL SYNONYM EDL_VU FOR mary. EMP DEPT_LOC_VU; then he can prefix the columns with this synonym.

    D

    Scott cannot create a synonym because synonyms can be created only for tables.

    E

    Scott cannot create any synonym for Mary's view. Mary should create a private synonym for the view and grant SELECT privilege on that synonym to Scott.


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

  • 第7题：

    多选题
    Which two statements are true regarding views?（）
    A

    A subquery that defines a view cannot include the GROUP BY clause

    B

    A view that is created with the subquery having the DISTINCT keyword can be updated

    C

    A view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updated

    D

    A data manipulation language (DML) operation can be performed on a view that is created with the subquery having all the NOT NULL columns of a table


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

  • 第8题：

    单选题
    You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was create.) How do you obtain the definition of the view?（）
    A

    Use the DESCRIBE command in the EMP_DEPT VU view.

    B

    Use the DEFINE VIEW command on the EMP_DEPT VU view.

    C

    Use the DESCRIBE VIEW command on the EMP_DEPT VU view.

    D

    Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.

    E

    Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.

    F

    Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.


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

  • 第9题：

    单选题
    What does the FORCE option for creating a view do?（）
    A

    creates a view with constraints

    B

    creates a view even if the underlying parent table has constraints

    C

    creates a view in another schema even if you don't have privileges

    D

    creates a view regardless of whether or not the base tables exist


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

  • 第10题：

    单选题
    You are listening to a radio phone-in programme. Why has the woman called?    
    A

    To criticise the famous.

    B

    To express a different point of view.

    C

    To sympathise with photographers.


    正确答案： A
    解析： 女士的第一句话Well, I can’t believe what your last caller said.明显提示，针对对名人私生活的报道，她与上一位打电话的听众持不同的观点，接下来提到她认为名人的隐私也应该得到尊重。
    【录音原文】
    M: Ok, Mary from Glasgow, go ahead, make your point.
    W: Well, I can’t believe what your last caller said. How would she like it if she was on the beach and some photographer stuck his camera in her face? I mean…
    M: But these people are famous. They must expect it, surely.
    W: Yes, but not all the time. Not when they are not on duty, so to speak. Everybody on your program seems to think these photographers can do anything. But I just want to set the record straight, I don’t. There should be some respect for people’s privacy.
    Q: You are listening to a radio phone-in progrmmne. Why has the woman called?

  • 第11题：

    Which two statements about views are true? （）

    • A、A view can be created as read only.
    • B、A view can be created as a join on two or more tables.
    • C、A view cannot have an ORDER BY clause in the SELECT statement.
    • D、A view cannot be created with a GROUP BY clause in the SELECT statement.
    • E、A view must have aliases defined for the column names in the SELECT statement.

    正确答案:A,B

  • 第12题：

    You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was create.) How do you obtain the definition of the view? （）

    • A、Use the DESCRIBE command in the EMP_DEPT VU view.
    • B、Use the DEFINE VIEW command on the EMP_DEPT VU view.
    • C、Use the DESCRIBE VIEW command on the EMP_DEPT VU view.
    • D、Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.
    • E、Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.
    • F、Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.

    正确答案:D

  • 第13题：

    Which command will create a group called ’delivery’ and set the administrators to ’john’ and ’mary’？（）  

    • A、mkgroup -A=john，mary delivery
    • B、groupadd -A=john，mary delivery
    • C、mkgroup adms=john，mary delivery
    • D、groupadd adms=john，mary delivery

    正确答案:C

  • 第14题：

    You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was created.) How do you obtain the definition of the view?（）

    • A、Use the DESCRIBE command on the EMP_DEPT_VU view.
    • B、Use the DEFINE VIEW command on the EMP_DEPT_VU view.
    • C、Use the DESCRIBE VIEW command on the EMP_DEPT_VU view.
    • D、Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.
    • E、Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.
    • F、Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.

    正确答案:D

  • 第15题：

    单选题
    In Saussure’s view, a sign is just like a coin. It has two sides. One is the signifier, the other is called the _____.
    A

    significant

    B

    signified

    C

    sign

    D

    index


    正确答案： C
    解析：
    索绪尔认为语言是一种符号系统，符号由“能指”（signifiant, signifier）和“所指”（signifie, signified）两部分组成。“能指”指语言的声音形象，“所指”指语言所反映的事物的概念。

  • 第16题：

    单选题
    User Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She has the privilege to create a public synonym, and would like to create a synonym for this view that can be used by all users of the database.Which SQL statement can Mary use to accomplish that task?（）
    A

    CREATE PUBLIC SYNONYM EDL_VU ON emp_dept_loc_vu

    B

    CREATE PUBLIC SYNONYM EDL:VU FOR mary (emp_dept_loc_vu);

    C

    CREATE PUBLIC SYNONYM EDL_VU FOR emp _dept_loc_vu;

    D

    CREATE SYNONYM EDL_VU ON emp_dept_loc_vu FOR EACH USER;

    E

    CREATE SYNONYM EDL_VU FOR EACH USER ON emp_dept_loc_vu

    F

    CREATE PUBLIC SYNONYM EDL_VU ON emp_dept_loc_vu FOR ALL USERS;


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

  • 第17题：

    单选题
    Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She granted SELECT privilege to Scott on this view. Which option enables Scott to eliminate the need to qualify the view with the name MARY .EMP_DEP_LOC_VU each time the view is referenced?（）
    A

    Scott can create a synonym for the EMP_DEPT_LOC_VU bus using the command:   CREATE PRIVATE SYNONYM EDL_VU   FOR mary.EMP DEPT_LOC_VU;   then he can prefix the columns with this synonymn.

    B

    Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command:   CREATE SYNONYM EDL_VU   FOR mary.EMP_DEPT_LOC_VU;   then he can prefix the columns with this synonym.

    C

    Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command:   CREATE LOCAL SYNONYM EDL_VU   FOR mary.EMP DEPT_LOC_VU;   then he can prefix the columns with this synonym.

    D

    Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command:   CREATE SYNONYM EDL_VU   ON mary(EMP_DEPT_LOC_VU);   then he can prefix the columns with this synonym.

    E

    Scott cannot create a synonym because synonyms can be created only for tables.

    F

    Scott cannot create any synonym for Mary’s view. Mary should create a private ynonym for the view and grant SELECT privilege on that synonym to Scott.


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

  • 第18题：

    多选题
    Which two statements about views are true?（）
    A

    A view can be created as read only.

    B

    A view can be created as a join on two or more tables.

    C

    A view cannot have an ORDER BY clause in the SELECT statement.

    D

    A view cannot be created with a GROUP BY clause in the SELECT statement.

    E

    A view must have aliases defined for the column names in the SELECT statement.


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

  • 第19题：

    单选题
    You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was created.) How do you obtain the definition of the view?（）
    A

    Use the DESCRIBE command on the EMP_DEPT_VU view.

    B

    Use the DEFINE VIEW command on the EMP_DEPT_VU view.

    C

    Use the DESCRIBE VIEW command on the EMP_DEPT_VU view.

    D

    Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.

    E

    Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.

    F

    Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.


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

相关内容