The user SCOTT who is the owner of ORDERS and ORDERJTEMS tables issues the following  GRANT command：  GRANT ALL   ON orders， order_items   TO PUBLIC；   What correction needs to be done to the above statement？ （）

相似题目

• 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

  查看最佳答案

• You execute the following command toauditdatabase activities：  SQL>AUDITDROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL；  What is the effect of this command（）

  A . Oneauditrecord is created for every successful DROP TABLE command executed in the session ofSCOTT. B . Oneauditrecord is generated for the session when SCOTT grants the DROP ANY TABLE privilege toother users. C . One audit record is created for the whole session if user SCOTT successfully drops one or more tablesin his session. D . One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully. E . One audit record is created for every successful DROP TABLE command executed by any user to droptables owned by SCOTT.

  查看最佳答案

• You want to check the EMP table in the user， Scott’s schema for block corruption. You also want to fix the corrupted blocks， if any. How will you accomplish the required task？（）

  A . by using the ANALYZE utility B . by using the DBVERIFY utility C . by using the DB_BLOCK_CHECKING parameter D . by using the DBMS_REPAIR package

  查看最佳答案

• The DBA issues this SQL command: https://assets.asklib.com/images/image2/2018080117142684706.jpg 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.

  查看最佳答案

• You executed the following command to drop a user：   DROP USER scott CASCADE；   Which two statements regarding the above command are correct？（）

  A .  All the objects of scott are moved to the Recycle Bin. B .  Any objects in the Recycle Bin belonging to scott are purged. C .  All the objects owned by scott are permanently dropped from the database. D .  All the objects of scott in the Recycle Bin must be purged before executing the DROP command. E .  Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.

  查看最佳答案

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

  查看最佳答案

• User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, whichcommands must you execute to enable SCOTT to flash back the transactions? （）(Choose four.)

  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

  查看最佳答案

• You executed the following command to drop a user: DROP USER scott CASCADE; Which two statements regarding the above command are correct?（）

  A . All the objects of scott are moved to the Recycle Bin. B . Any objects in the Recycle Bin belonging to scott are purged. C . All the objects owned by scott are permanently dropped from the database. D . All the objects of scott in the Recycle Bin must be purged before executing the DROP command. E . Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.

  查看最佳答案

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

  查看最佳答案

• You install Windows Vista on a computer for a user who is visually impaired. You need to configure a High Contrast color scheme on the computer. What should you do?（） https://assets.asklib.com/images/image2/2018073114404765749.jpg

  A . A B . B C . C D . D

  查看最佳答案

• You are performing the shrink operation on the SCOTT.EMP table. You want to perform the same operation on all dependent objects of the SCOTT.EMP table. What is NOT a prerequisite for the operation？（）

  A .  You must enable the row movement on the SCOTT.EMP table. B .  You must define the tablespace of the SCOTT.EMP table for automatic segment space management. C .  You must use the CASCADE clause in the ALTER TABLE SHRINK SPACE statement. D .  You must use the COMPACT clause in the ALTER TABLE SHRINK SPACE statement.

  查看最佳答案

• 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

  查看最佳答案

• A redaction policy was added to the SAL column of the SCOTT.EMP table: All users have their default set of system privileges. For which three situations will data not be redacted?（）

  A . SYS sessions, regardless of the roles that are set in the session B . SYSTEM sessions, regardless of the roles that are set in the session C . SCOTT sessions, only if the MGR role is set in the session D . SCOTT sessions, only if the MGR role is granted to SCOTT E . SCOTT sessions, because he is the owner of the table F . SYSTEM session, only if the MGR role is set in the sessio

  查看最佳答案

• 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

  查看最佳答案

• 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 G . exclusive table-level lock for the table containing the row

  查看最佳答案

• You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table？（）

  A .  You must enable the block change tracking feature. B .  You must have enable the flashback feature. C .  You must use the OMF in your database. D .  You must define the tablespace of the SCOTT.EMP table for automatic segment space management.

  查看最佳答案

• Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query: SQL> SELECT * FROM sales; Which process would retrieve the result from the database and return it to the client program?（）

  A . User process B . Server process C . System Monitor (SMON) D . Process Monitor (PMON) E . Checkpoint process (CKPT)

  查看最佳答案

• F. Scott Fitzgerald is known as the author of one of his greatest novels The Great Gatsby.

  查看最佳答案

• Walte Scott is thought to be the father of the _______ which opens up the rich and lively realm of history.

  查看最佳答案

• Walter Scott is the only novelist of the romantic literature of the 19th-century England and his novels are mainly ( ) novels as far as genre is concerned.

  查看最佳答案

• What is implied by the mention of Scott， Poe and Hawthorne？ 查看材料

  A.Irving enjoyed great popular admiration. B.Scott， Poe and Hawthorne were primarily responsible forIrving’s success. C.Irving’s work was not only popular， but also of highliterary quality. D.More Americans than Britons admired Irving.

  查看最佳答案

• You install Windows Vista on a computer for a user who is visually impaired. You need to configure a High Contrast color scheme on the computer.What should you do？（）

  <img src='https://img2.soutiyun.com/shangxueba/ask/17127001-17130000/17128448/cf381478253cd8632c71f04b7f2d66ae.jpg' /> A．A B．B C．C D．D

  查看最佳答案

• F. Scott Fitzgerald is often acclaimed as the literary spokesman of the___ Age.

  查看最佳答案

• A company finished upgrading the wireless encryption to WPA2 Enterprise. The administratorreceives a call from a user who is unable to connect to the company wireless.Which of the following is MOST likely causing the connection problem？（）

  A. The laptop is missing the software supplicant B. The access point SSID is hidden. C. The laptop only supports TKIP and AES encryption, D. The access point is on the wrong channel.

  查看最佳答案