單項選擇題

All the database users are presently connected to the database instance and working. The HR user hasopened 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 see theeffect of the UPDATE and DELETE commands（）

A.All sessions of the HR user only
B.All sessions of the HR user and the SYS user
C.The session of the HR user that executed the commands
D.All the sessions for which the database users have access privilege to the PERSONS table

你可能感興趣的試題

多項選擇題

You configured the Flash Recovery Area （FRA） for your database. The database instance is running inARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area.
Which twofiles are removed automatically if the space is required in the FRA as per the retention policy（）

A.Flashback log files
B.Backups that have become obsolete
C.User managed backups of the data files and control files
D.Archived redo log files that have multiple copies in a different archive location and not backed up

單項選擇題

In a new installation of Oracle Database 11g， you perform these activities：
1. Organize software and data on different subdirectories to avoid poor performance.
2. Use consistent naming conventions for database files.
3. Separate administrative information pertaining to the database in different directories.
Which optioncorresponds to the type of activities you performed（）

A.Oracle Managed Files
B.Oracle Grid Architecture
C.Optimal Flexible Architecture
D.Oracle database architecture
E.Automatic Storage Management

99色精品-9色在线-99色在线-99色视频 国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

你可能感興趣的試題

99色精品-9色在线-99色在线-99色视频国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精