单选题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

题目
单选题
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;

相似考题

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

2. A web application uses the HttpSession mechanism to determine if a user is “logged in”. When a user supplies a valid user name and password， an HttpSession is created for that user.  The user has access to the application for only 15 minutes after logging in. The code must determine how long the user has been logged in， and if this time is greater than 15 minutes， must destroy the HttpSession.  Which method in HttpSession is used to accomplish this？（）A、 getCreationTimeB、 invalidateAfterC、 getLastAccessedTimeD、 getMaxInactiveInterval

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

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

参考答案和解析
正确答案： A
解析： 暂无解析
更多“User Mary has a view called EMP_DEPT_LOC_VU that was created”相关问题

  • 第1题：

    Upon a user’s first visit to the website， which two operations are always performed when the getSession method is called with no arguments in a servlet？（）

    • A、 All URLs returned by the server are rewritten.
    • B、 An HttpSession object is created if necessary.
    • C、 The user name and password of the user are checked.
    • D、 The session ID is stored in the HTTP response as a cookie.

    正确答案:B,D

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    You are a network administrator for your company. The network consists of a single Active Directory domain. A user named Mary works in the information technology (IT) security department. Mary is a member of the ITSecurity global group. Mary reports that no one in the ITSecurity global group can access the security log from the console of a computer named Server1. You need to grant the ITSecurity global group the minimum rights necessary to view the security log on Server1. How should you modify the local security policy？（）

    • A、Assign the Generate security audits user right to the ITSecurity global group.
    • B、Assign the Manage auditing and security logs user right to the ITSecurity global group.
    • C、Assign the Allow logon through Terminal Services user right to the ITSecurity global group.
    • D、Assign the Act as part of the operating system user right to the ITSecurity global group.

    正确答案:B

  • 第5题：

    单选题
    In order to find out how many database objects a user has created, which view would the DBA query in the Oracle data dictionary? （）
    A

    DBA_USERS 

    B

    DBA_OBJECTS 

    C

    DBA_TS_QUOTAS 

    D

    DBA_TAB_PRIVS 


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

  • 第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题：

    单选题
    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
    解析： 暂无解析

  • 第8题：

    单选题
    When configuring role-based CLI on a Cisco router，which action will be taken first ？（）
    A

    Create a parser view called root view.

    B

    Log in to the router as the root user.

    C

    Enable the root view on the router.

    D

    Enable role-based CLI globally on the router using the privileged EXEC mode Cisco IOS command.


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

  • 第9题：

    多选题
    Upon a user’s first visit to the website， which two operations are always performed when the getSession method is called with no arguments in a servlet？（）
    A

    All URLs returned by the server are rewritten.

    B

    An HttpSession object is created if necessary.

    C

    The user name and password of the user are checked.

    D

    The session ID is stored in the HTTP response as a cookie.


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

  • 第10题：

    单选题
    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
    解析： 暂无解析

  • 第11题：

    A user is browsing to a newly created internal site called www.comptia.org. After putting incredentials the page comes up blank. Which of the following is MOST likely the cause?（）

    • A、The user must add the new site to the local log file.
    • B、A proxy exception has not been configured.
    • C、SMTP has not been configured.
    • D、The loopback address has not been configured.

    正确答案:B

  • 第12题：

    Which statement is true about the database and database-user used during installation of IMS Server？（）

    • A、A preexisting database user may be used but a new database has to be created during installation.
    • B、A preexisting database may be used but a new database user has to be created during installation.
    • C、A preexisting database and user may be used or a new database and user are created during installation.
    • D、A preexisting database and user cannot be used； a new database and user are created during  installation.

    正确答案:C

  • 第13题：

    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of two SQL Server 2008 instance. The two instances are respectively named InstanceA and InstanceB. There is a database named Dworks on InstanceA. You move the Dworks database to InstanceB. A user use a SQL Server login named Mary to access the database on InstanceA with the password "Tk@87#34". On InstanceB, you create the same SQL Server login. The user tries to use the SQL Server login Mark to access the Dworks database on InstanceB. But the user gets an error message, according to the indication of the message, the access to the Dworks database has been denied. You must make sure that the user can access the Dworks database on InstanceB successfully.  So on InstanceB, which Transact-SQL statements should you execute?（）  

    • A、USE AdventureWorks;ALTER USER Mary WITH LOGIN = Mary; 
    • B、USE AdventureWorks;ALTER LOGIN Mary ENABLE; 
    • C、USE AdventureWorks;ALTER LOGIN Mary WITH PASSWORD = "Tk@87#34" UNLOCK; 
    • D、USE AdventureWorks;ALTER LOGIN Mary WITH DEFAULT_DATABASE = AdventureWorks;

    正确答案:A

  • 第14题：

    单选题
    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）两部分组成。“能指”指语言的声音形象，“所指”指语言所反映的事物的概念。

  • 第15题：

    单选题
    A user is browsing to a newly created internal site called www.comptia.org. After putting incredentials the page comes up blank. Which of the following is MOST likely the cause?（）
    A

    The user must add the new site to the local log file.

    B

    A proxy exception has not been configured.

    C

    SMTP has not been configured.

    D

    The loopback address has not been configured.


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

  • 第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题：

    单选题
    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
    解析： 暂无解析

  • 第18题：

    单选题
    A web application uses the HttpSession mechanism to determine if a user is "logged in." When a usersupplies a valid user name and password， an HttpSession is created for that user. The user has access tothe application for only 15 minutes after logging in. The code must determine how long the user has beenlogged in， and if this time is greater than 15 minutes， must destroy the HttpSession. Which method in HttpSession is used to accomplish this？（）
    A

    Getcreationtime

    B

    Invalidateafter

    C

    Getlastaccessedtime

    D

    Getmaxinactiveinterval


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

  • 第19题：

    单选题
    Which statement is true about the database and database-user used during installation of IMS Server？（）
    A

    A preexisting database user may be used but a new database has to be created during installation.

    B

    A preexisting database may be used but a new database user has to be created during installation.

    C

    A preexisting database and user may be used or a new database and user are created during installation.

    D

    A preexisting database and user cannot be used； a new database and user are created during  installation.


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

相关内容