The user HR owns

题目

The user HR owns the EMP table. The user HR grants privileges to the user SCOTT by using this command:  SQL> GRANT SELECT,INSERT,UPDATE ON emp TO scott WITH GRANT OPTION; The user SCOTT executes this command to grant privileges to the user JIM: SQL> GRANT SELECT,INSERT,UPDATE ON hr.emp TO jim;  Now, the user HR decides to revoke privileges from JIM using this command: SQL> REVOKE SELECT,INSERT,UPDATE ON emp FROM jim; Which statement is true after HR issues the REVOKE command()

  • A、The command fails because SCOTT still has privileges.
  • B、The command succeeds and privileges are revoked from JIM.
  • C、The command fails because HR cannot revoke the privileges from JIM.
  • D、The command succeeds and only HR has the privilege to perform the SELECT, INSERT, and UPDATEoperations on the EMP table.
如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

View the Exhibit for some of the current parameter settings. A user logs in to the HR schema and issues the following commands:SQL> CREATE TABLE emp(empno NUMBER(3),ename VARCHAR2(20),sal NUMBER(8,2));SQL> INSERT INTO emp(empno,ename) VALUES(1,‘JAMES‘);At this moment, a second user also logs in to the HR schema and issues the following command:SQL> ALTER TABLE emp MODIFY sal NUMBER(10,2);What happens in the above scenario?()

A. The second user‘s session immediately produces the resource busy error.

B. The second user‘s command executes successfully.

C. The second user‘s session waits for a time period before producing the resource busy error.

D. A deadlock is created.


参考答案:C

第2题:

On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command:$> sqlldr hr/hr@pdb table=employeesWhich two statements are true regarding the command?()

A. It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.

B. It fails because no SQL *Loader data file location is specified.

C. It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.

D. It fails because no SQL *Loader control file location is specified.


参考答案:A, C

第3题:

The proprietor owns all of the property of the business and is responsible ________ everything.

A to ;

B for ;

C at


参考答案:B

第4题:

更改oracle用户HR,使其变为不可用(锁定)状态()

  • A、UPDATE  USER  HR  ACCOUNT  DISABLE
  • B、UPDATE  USER  HR  ACCOUNT  LOCK
  • C、ALTER USER  HR  ACCOUNT  DISABLE
  • D、ALTER USER  HR  ACCOUNT  LOCK

正确答案:D

第5题:

下列选项中,能够解除HR用户的锁定的语句是()。

A.alter user hr unlock

B.alter user hr account unlock

C.alter table alter hr unlock

D.alter table alter unlock hr


参考答案:B

第6题:

Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN.You want to issue the following RMAN command:RMAN > BACKUP TABLESPACE hr_pdb:userdata;Which task should you perform before issuing the command?()

A. Place the root container in ARHCHIVELOG mode.

B. Take the user data tablespace offline.

C. Place the root container in the nomount stage.

D. Ensure that HR_PDB is open.


参考答案:D

第7题:

Acustomerasksforthethermalload(BTU/hr)todeterminewhethertheirexistingcoolingsystemwillsupporttheIBMSystemStorageDS8000.Wherecanthesalesrepresentativefindthisinformation()

A.IBMSystemStorageDS8000:IntroductionandPlanningGuide

B.IBMDS8000InteroperabilityMatrixonthesupportpageontheweb

C.IBMSystemStorageDS8000:User’sGuide

D.IBMSystemStorageDS8000:SolutionAssuranceGuide


参考答案:A

第8题:

Which of the following items is a capital asset in the hands of the taxpayer?()

A、Taxpayer owns a 10-year old Harley-Davidson motorcycle

B、Taxpayer owns a used car lot. He owns a 1962 Cadillac that is for sale on the lot

C、Taxpayer owns a notebook computer that he carries to his clients for work purposes

D、Taxpayer, a farmer, has a prize winning steer in his herd

E、None of the above items are capital assets


答案:B

第9题:

Shipowner is a person who ______.

A.has the ownership of a vessel

B.has the ship owned by a shipping company

C.owns no ship of a shipping company

D.owns the ship named by a register of shipping


正确答案:A

第10题:

The user HR receives the following error while inserting data into the TTK table: ERROR at line 1:  ORA-01653: unable to extend table HR.TTK by 128 in tablespace SMDUpon  investigation, you find that SMD is a small file tablespace.  Which three action would allow the user to insert data()

  • A、Add a data file to the SMD tablespace.
  • B、Add a data file to the temporary tablespace associated with the user HR.
  • C、Resize the data file associated with the SMD tablespace to make it larger.
  • D、Alter the data file associated with the SMD tablespace to grow automatically.
  • E、Change the segment space management for the SMD tablespace to automatic. n segments is managed through free lists.

正确答案:A,C,D

更多相关问题