REVOKE ACCESS ON DATABASE FROM USER bob
REVOKE CONNECT ON DATABASE FROM USER tom
REVOKE tom FROM ACCESS ON DATABASE BY USER bob
REVOKE tom FROM CONNECT ON DATABASE BY USER bob
第1题:
A.REVOKE ALL PRIVILEGES FROM USER tom
B.REVOKE ALL ON EMPLOYEE FROM USER tom
C.REVOKE EXECUTE ON EMPLOYEE FROM USER tom
D.REVOKE PRIVILEGES ON EMPLOYEE FROM USER tom
第2题:
下列SQL语句中,能够实现“收回用户ZHAO对学生表(STUD)中学号(XH) 的修改权”这一功能的是()
第3题:
Which of the following statements allows BOB to revoke access to the SAMPLE database from user TOM?()
第4题:
Which of the following statements is used to revoke all DML privileges on table EMPLOYEE from user TOM?()
第5题:
How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog?()
第6题:
You have two database servers SEMP and SACCT. The database in the SEMP server maintains the employeeinformation and the database in the SACCT server maintains the accounts payable information. The employeessubmit the expense reports to the accounts payable department. A user of the accounts payable databasewants to extract the employee information from the database in the SEMP server for cross-verification. Whichschema object enables the user to access the information from the remote database()
第7题:
You have two database servers SEMP and SACCT. The database in the SEMP server maintains theemployee information and the database in the SACCT server maintains the accounts payable information.The employees submit the expense reports to the accounts payable department. A user of the accountspayable database wants to extract the employee information from the database in the SEMP server for cross-verification. Which schema object enables the user to access the information from the remote database()
第8题:
Cluster
Database link
Mapping table
Materialized view
第9题:
The user SKD can grant only the MGR_ROLE role to other users, but not the privileges in it.
The user SKD can revoke the MGR_ROLE only from the users for whom he/she is the grantor.
The user SKD can grant the privileges in the MGR_ROLE role to other users, but not with ADMIN OPTION.
The user SKD can grant the privileges in the MGR_ROLE role to other users, but cannot revoke privilegesfrom them
第10题:
REVOKE ADD, DELETE FROM USER tom ON TABLE tab1
REVOKE ADD, DELETE ON TABLE tab1 FROM USER tom
REVOKE INSERT, DELETE FROM USER tom ON TABLE tab1
REVOKE INSERT, DELETE ON TABLE tab1 FROM USER tom
第11题:
The command fails because SCOTT still has privileges.
The command succeeds and privileges are revoked from JIM.
The command fails because HR cannot revoke the privileges from JIM.
The command succeeds and only HR has the privilege to perform the SELECT, INSERT, and UPDATEoperations on the EMP table.
第12题:
Issue the grant command from the SYS user (or equivalent) of the target database.
Issue the grant command from the SYS user (or equivalent) of the recovery-catalog database.
Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.
Issue the grant command from RMAN when connected to the recovery catalog-owning schema.
Issue the grant command from RMAN when connected to the target database.
第13题:
Users of your web application have requested that they should be able to set the duration of their sessions.So for example, one user might want a webapp to stay connected for an hour rather than the webapp’sdefault of fifteen minutes; another user might want to stay connected for a whole day. Furthermore, youhave a special login servlet that performs user authentication and retrieves the User object from the database. You want to augment this code to set up the user’s specified session duration. Which codesnippet in the login servlet will accomplish this goal?()
第14题:
Which of the following statements is used to prevent user TOM from adding and deleting data in table TAB1?()
第15题:
Which of the following statements allows USER1 to take away read access on the table ORG.TAB1 from USER2?()
第16题:
Assuming PUBLIC has been granted all privileges on table T1, which of the following statements would continue to permit any user to add rows to table T1, but not remove them?()
第17题:
The user Sue issues this SQL statement: GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement: GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement: GRANT SELECT ON sue. EMP TO timber; The user Sue issues this SQL statement: REVOKE select on sue. EMP FROM alice; For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?()
第18题:
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()
第19题:
REVOKE ACCESS ON DATABASE FROM USER bob
REVOKE CONNECT ON DATABASE FROM USER tom
REVOKE tom FROM ACCESS ON DATABASE BY USER bob
REVOKE tom FROM CONNECT ON DATABASE BY USER bob
第20题:
Alice only
Alice and Reena
Alice, Reena, and Timber
Sue, Alice, Reena, and Timber
第21题:
Cluster
Database link
Mapping table
Materialized view
第22题:
REVOKE SELECT FROM user2 ON TABLE org.tab1
REVOKE SELECT ON TABLE org.tab1 FROM user2
REVOKE READ ACCESS FROM user2 ON TABLE org.tab1
REVOKE READ ACCESS ON TABLE org.tab1 FROM user2
第23题:
REVOKE ALL PRIVILEGES FROM USER tom
REVOKE ALL ON EMPLOYEE FROM USER tom
REVOKE EXECUTE ON EMPLOYEE FROM USER tom
REVOKE PRIVILEGES ON EMPLOYEE FROM USER tom
第24题:
User user = // retrieve the User object from the database session.setDurationInterval(user.getSessionDuration());
User user = // retrieve the User object from the database session.setMaxDuration(user.getSessionDuration());
User user = // retrieve the User object from the database session.setInactiveInterval(user.getSessionDuration());
User user=//retrieve the User object from the database session.setDuration(user.getSessionDuratio());
User user = // retrieve the User object from the database session.setMaxInactiveInterval(user.getSessionDuration());