可学答题网 > 问答 > 1Z0-052题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

All the database users


All the database users are presently connected to the database instance and working. The HR userhas opened three database sessions and executed the following command in one of his sessions: SQL> UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’; 123 rows updated.  SQL> DELETE FROM persons WHERE exp=’Y’; 3 rows deleted.  The SYS user opens a new session after HR executed the above commands.  Which sessions can seethe effect of the UPDATE and DELETE commands ()

  • Aall sessions of the HR user only
  • Ball sessions of the HR user and the SYS user
  • Cthe session of the HR user that executed the commands
  • Dall the sessions for which the database users have access privilege to the PERSONS table
参考答案
参考解析:
分类:1Z0-052题库
相关推荐

1、Twenty database users 

Twenty database users are connected to your database. Five of the users are running long q...

2、The database users are

The database users are connecting to the PROD database from different applications, thereby degradi...

3、The database instance 

The database instance has the following parameter setting:OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE&ensp...

4、The Oracle Database 11

The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log ...

5、In your database, all&

In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN)&en...

6、The Automatic Database&ensp

The Automatic Database Diagnostic Monitor (ADDM) analysis runs every 60 minutes on your database.&...