搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【多选题】

User Scott has updated the salary of one of the employees in the EMPLOYEES table and has not committed the transaction. What are the two types of locks that this scenario would lead to？（）

A、null lock on the row being updated

B、null lock on the table containing the row

C、ROW SHARE lock for the row being updated

D、ROW EXCLUSIVE lock for the row being updated

E、shared row-exclusive lock for the row being updated

F、a shareable table lock for the table containing the row

H、exclusive table-level lock for the table containing the row

查看正确答案
更多“User Scott has updated the salary of one of the employees in the EMPLOYEES table and has not committed the transaction. What are the two types of locks that this scenario would lead to？（）”相关的问题
第1题
[单选题] 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.  

点击查看答案
第2题
[多选题] You set the undo pool resource plan directive for the consumer group named DSS_USERS that is assigned to the DAY_SHIFT plan. The database users， SCOTT and BLAKE， belong to the DSS_USERS resource group. The user， SCOTT， initiates a database session and executes a batch operation that inserts millions of rows into the HISTORY table. Which two options are true if the total undo space allocated to the DSS_USERS group exceeds the value specified in the undo pool resource plan directive？（）

A、 The batch operation started by the user， SCOTT， terminates with an error.  B、 The batch operation started by the user， SCOTT， hangs and you are required to increase the undo pool resource plan directive.  C、 The batch operation started by the user， SCOTT， runs uninterrupted because the database uses the SYSTEM tablespace for the undo operation.  D、 The user， BLAKE， cannot start a transaction that uses any DML operations until you increase the value of the undo pool resource plan directive.  E、 The user BLAKE can start a transaction that uses any DML operations after the batch operation started by the user， SCOTT， terminates with an error.  

点击查看答案
第3题
[多选题] User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA， which commands must you execute to enable SCOTT to flash back the transactions？（）

A、 ALTER DATABASE FLASHBACK ON  B、 GRANT SELECT any transaction TO scott  C、 GRANT EXECUTE ON dbms_flashback TO scott  D、 ALTER DATABASE ADD SUPPLEMENTAL LOG DATA  E、 ALTER TABLESPACE undots1 RETENTION GUARANTEE  F、 ALTER DATABASE ADD SUPPLEMENTAL LOG DATA （PRIMARY KEY） COLUMNS  

点击查看答案
第4题
[单选题] A technician deploys a computer in a public library and wants to give the ability for a user without an account to use the computer with limited permission. Which of the following accounts would the technician setup？（）

A、 Guest user account  B、 Limited user account  C、 Power user account  D、 Administrator user account  

点击查看答案
第5题
[单选题] You are specifying French case-insensitive sorts by using the NSL_SORT parameter for the user session of the user， Scott. Which value will you set for the NLS_SORT parameter？（）

A、 FRENCH_AI  B、 FRENCH_CI  C、 AI_FRENCH  D、 CI_FRENCH  

点击查看答案
第6题
[单选题] An administrator received a call from a user whose PC crashed while using vi to edit a file. The user wants the edited file back. Where should the administrator look for the file（）

A、/tmp  B、/var/preserve  C、/var/tmp/$USER  D、$HOME/.vi  

点击查看答案
第7题
[单选题] You have an Exchange Server 2010 organization.A user named User1 connects to his mailbox by using Microsoft Office Outlook.User1 reports that he is unable to send encrypted e-mail messages to an external recipient named User2.You verify that User1 and User2 have e-mail encryption certificates.You need to ensure that User1 can send encrypted e-mail messages to User2.What should you do first？（）

A、Instruct User2 to add a delegate  B、Instruct User2 to send a signed e-mail message to User1.  C、Instruct User1 to send a signed e-mail message to User2.  D、Instruct User1 to modify the sensitivity settings of the e-mail message  

点击查看答案
第8题
[单选题] A user has used all of the allowed logon attempts for the userid. Which command can be used to reset the unsuccessful_login_count to 0 for that user？（）

A、usrck  B、chsec  C、chuser  D、passwd  

点击查看答案
第9题
[单选题] A remote user is trying to telnet to the production server. The session is getting a timeout error. Which command should the user issue to verify the network connection？（）

A、iptrace  B、nslookup  C、netstat  D、traceroute  

点击查看答案
第10题
[单选题] The DBA issues this SQL command: CREATE USER scott IDENTIFIES by tiger; What privileges does the user Scott have at this point?（）

A、No privileges.  B、Only the SELECT privilege.  C、Only the CONNECT privilege.  D、All the privileges of a default user.  

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服