重要提示: 请勿将账号共享给其他人使用,违者账号将被封禁!
查看《购买须知》>>>
当前位置: 首页 > 计算机类考试 > 其他
网友您好, 请在下方输入框内输入要搜索的题目:
搜题

题目

[主观题]

User Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPAR

TMENTS, 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;

查看参考答案
更多“User Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPAR”相关的问题

第1题

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.

点击查看答案

第2题

Mary has a _______ view of our future、But nobody believes what she said.A、portableB、pr

Mary has a _______ view of our future、But nobody believes what she said.

A、portable

B、primary

C、possession

D、positive

点击查看答案

第3题

A user is unable to view any DVDs on their laptop which has a DVD-ROM drive installed. Aft
er further investigation, the technician realizes that there is not any DVD-ROM or CD-ROM available under the My Computer utility. Which of the following system utilities would MOST likely be used to identify and resolve this issue?()

A. Task Manager

B. Device Manager

C. DEFRAG

D. Event Viewer

点击查看答案

第4题

Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENT
S, 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.

点击查看答案

第5题

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.

点击查看答案

第6题

You are the network administrator for Testking.com. The TestKing networkcontains seven app
lication servers. Each application server runs a database application named TestKingApp.Requirements for TestKingApp state that when you add a new user, you must add the user to the server that has the most available disk space.You need to ensure that you meet the requirements when you add new users to TestKingApp.What should you do?()

A. Use Event Viewer to review the application logs on each of the seven servers.

B. Use Performance Logs and Alerts to record the PhysicalDisk object on all seven servers.

C. Use Task Manager to view the performance data on each of the seven servers.

D. Use System Monitor to generate a histogram view of the LogicalDisk object on all seven servers.

点击查看答案

第7题

You are creating a Web Form. The Web Form allows users to rename or delete products in a l
ist. You create a DataTable named dtProducts that is bound to a GridView. DataTable has the following four rows. dtProducts.Rows(0)("ProductName") = "Soap"dtProducts.Rows(1)("ProductName") = "Book"dtProducts.Rows(2)("ProductName") = "Computer"dtProducts.Rows(3)("ProductName") = "Spoon"dtProducts.AcceptChanges()The user utilizes a Web Form to delete the first product. You need to set the RowStateFilter property of the DataTables DefaultView so that only products that have not been deleted are shown. To which value should you set the DataTabless DefaultView.RowStateFilter?()

A. Data View Row State.Modified Original

B. Data View Row State.Modified Current

C. Data View Row State.Current Rows

D. Data View Row State.Added

点击查看答案

第8题

Your Windows 2000 Professional computer has 10 shared folders that are available to other
network users. A user reports that he cannot access a shared folder named ShareA.

You want to respond to the user's problem as quickly as possible by using an administrative tool.

However, you cannot remember the server location of ShareA. What should you do?

A.Use Windows Explorer to display the file paths of your shared folders.

B.Use Storage in Computer Management to view logical drive properties.

C.Use Event Viewer in Computer Management to search for shared folder error messages.

D.Use System Tools in Computer Management to display the file paths of your shared folders.

点击查看答案

第9题

You are the network administrator for The company has a main office at Toronto and several
branch offices in North America. You work in Toronto.The network contains Windows Server 2003 computers and Windows XP Professional computers.A user named Tess works in a branch office. She reports that her client computers cannot connect to a remote VPN server. You suspect that her client computer did not receive a recent hotfix.You need to verify which hotfixes are installed on Tess‘s computer.What should you do?()

A. From a command prompt, run the update.exe command.

B. From a command prompt, run the wmic qfe command.

C. View the History-synch.xml file.

D. View the History-apprive.xml file.

点击查看答案

第10题

You have a server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2).Server1

You have a server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2).Server1 has a scheduled task that runs Ntbackup.exe every night. The scheduled task is configured to run by a usernamed BackupUser. BackupUser is a member of the local Backup Operators group.You apply a custom security template that modifies the user rights on Server1.You discover that the scheduled backup job does not work anymore.You use the Local Security Settings console to view the current user rights assignments. The relevant output from the console is shown in the exhibit. (Click the Exhibit button.)You need to ensure that the scheduled backup job executes successfully on Server1.Which user right should you assign to BackupUser? ()

You have a server named Server1 that runs Windows

A. Allow log on locally.

B. Log on as a service.

C. Log on as a batch job.

D. Act as part of the operating system.

点击查看答案
赏学吧APP
TOP
重置密码
账号:
旧密码:
新密码:
确认密码:
确认修改
购买搜题卡查看答案
购买前请仔细阅读《购买须知》
请选择支付方式
微信支付
支付宝支付
点击支付即表示你同意并接受《服务协议》《购买须知》
立即支付
搜题卡使用说明

1. 搜题次数扣减规则:

功能 扣减规则
基础费
(查看答案)
加收费
(AI功能)
文字搜题、查看答案 1/每题 0/每次
语音搜题、查看答案 1/每题 2/每次
单题拍照识别、查看答案 1/每题 2/每次
整页拍照识别、查看答案 1/每题 5/每次

备注:网站、APP、小程序均支持文字搜题、查看答案;语音搜题、单题拍照识别、整页拍照识别仅APP、小程序支持。

2. 使用语音搜索、拍照搜索等AI功能需安装APP(或打开微信小程序)。

3. 搜题卡过期将作废,不支持退款,请在有效期内使用完毕。

请使用微信扫码支付(元)
订单号:
遇到问题请联系在线客服
请不要关闭本页面,支付完成后请点击【支付完成】按钮
遇到问题请联系在线客服
恭喜您,购买搜题卡成功 系统为您生成的账号密码如下:
重要提示: 请勿将账号共享给其他人使用,违者账号将被封禁。
发送账号到微信 保存账号查看答案
怕账号密码记不住?建议关注微信公众号绑定微信,开通微信扫码登录功能
警告:系统检测到您的账号存在安全风险

为了保护您的账号安全,请在“赏学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!

- 微信扫码关注赏学吧 -
警告:系统检测到您的账号存在安全风险
抱歉,您的账号因涉嫌违反赏学吧购买须知被冻结。您可在“赏学吧”微信公众号中的“官网服务”-“账号解封申请”申请解封,或联系客服
- 微信扫码关注赏学吧 -
请用微信扫码测试
温馨提示
每个试题只能免费做一次,如需多次做题,请购买搜题卡
立即购买
稍后再说
赏学吧