All the database users are presently connected to the databa

题目
单选题
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 ()
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

参考答案和解析
正确答案: A
解析: 暂无解析
如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

You are the administrator of a database that contains 64 lookup tables. These tables store static data that should not change. However, users report that some of this data is being changed. You need to prevent users from modifying the data.

You want to minimize changes to your security model and to your database applications. How should you modify the database?

A.Create a filegroup named LOOKUP. Move the lookup tables to this filegroup. Select the read only check box for the filegroup.

B.Create a database role named datamodifier. Grant SELECT permissions to the datamodifier role. Add all users to the role.

C.Deny INSERT, UPDATE, and DELETE permissions for all users. Create stored procedures that modify data in all tables except lookup tables. Require users to modify data through these stored procedures.

D.Create a view of the lookup tables. Use the view to allow users access to the lookup tables.


正确答案:A
解析:Explanation:SQLServer2000allowsfilegroupsotherthantheprimaryfilegrouptobemarkedasreadonly.Afilegroupthatismarkedread-onlycannotbemodified.Tablesthatmustnotbemodifiedcanbeplacedonafilegroupthatcanthenbemarkasread-only.Thiswillpreventsaccidentalupdates.IncorrectAnswers:B:Thissolutioneffectivelypermitsalluserstomodifyanytableinthedatabase,astheywouldallhaveSELECTpermissionstothedatabase.C:ThissolutionwilleffectivelypreventallusersfrombeingabletoperformingthesetasksonalltablesinthedatabaseastheyaredeniedpermissionstorunINSERT,UPDATE,orDELETEstatementsagainstthedatabase.Abettersolutionwouldbetoapplythedenypermissionsatthetablelevelofthelookuptables.Thiswould,however,requireunnecessaryadministrativetime.D:Viewsarevirtualtablesthatareusedtofiltertablesorrowsthattheusersshouldnothaveaccessto,however,iftheusershaveaccesstothebasetables,theycanstillrunINSERT,UPDATE,andDELETEstatementsagainstthebasetable.

第2题:

You executed the following command in the lsnrctl utility to stop the listener: lsnrctl> STOP L1  What is the effect of this command if L1 is the only listener configured for your database?()

  • A、It terminates all user sessions.
  • B、It prevents users from logging in to the database remotely.
  • C、It halts the server until all user transactions are completed.
  • D、The server hangs, so users will receive an error asking them to login again.
  • E、Connected users would get an error with the message "End of communication channel".

正确答案:B

第3题:

Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER byissuing the following command:lsnrctl >STOPWhat happens to the sessions that are presently connected to the database Instance?()

A. They are able to perform only queries.

B. They are not affected and continue to function normally.

C. They are terminated and the active transactions are rolled back.

D. They are not allowed to perform any operations until the listener LISTENER is started


参考答案:B

第4题:

Your database is open and users are connected using the LISTENER listener. The new DBA of the system stops the listener by using the following command:  LSNRCTL> STOP  What would happen to the sessions that are presently connected to the database instance?()

  • A、The sessions are able to perform only queries.
  • B、The sessions are not affected and continue to function normally.
  • C、The active transactions are rolled back and the sessions get terminated.
  • D、The sessions are not allowed to perform any operations till the listener is started.

正确答案:B

第5题:

A system administrator wants to configure a system so that all new users will be put into the database group by default. How would this be accomplished?()

  • A、remove all other groups from the system
  • B、run the command mkuser -default "GROUP=database"
  • C、change the default group in /usr/lib/security/mkuser.default
  • D、edit /etc/security/group to move all users to the database stanza

正确答案:C

第6题:

The database users are connecting to the PROD database from different  applications, thereby degrading the database performance. The senior database administrator suspects the large number of concurrent connections to be the reason for low performance and asks you to restrict the number concurrent connections per database user to one.  Which action would you take to achieve this objective?()

  • A、set the SESSIONS to 1 in the parameter file
  • B、grant SINGLE SESSION privilege to all of the users
  • C、set the SESSIONS_PER_USER to 1 in the users’ profile
  • D、grant RESTRICTED SESSION privilege to all of the database users
  • E、create a role with SINGLE SESSION privilege and assign the role to the users

正确答案:C

第7题:

You need to design a configuration for Exchange Server storage that meets the business and technical requirements. What should you do?()

  • A、Create a single storage group. Create one database for all users
  • B、Create two storage groups. In each storage group, create one database. Place mailboxes for remote users in one storage group database, and place all other mailboxes in the other storage group database
  • C、Create two storage groups. In each storage group, create one database. Place executive mailboxes in one storage group database, and place all other mailboxes in the other storage group database
  • D、Create two storage groups. In one storage group, create a database, and place all mailboxes for remote users and executives in the database. In the other storage group, create a database for all other mailboxes

正确答案:C

第8题:

You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.You issue the following statements:SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM;SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;For which database users is the audit policy now active?()

A. All users except SYS

B. All users except SCOTT

C. All users except sys and SCOTT

D. All users except sys, system, and SCOTT


参考答案:B

第9题:

A customer has a database application that is accessed by a large number of people through a web interface from multiple remote locations.  Which of the following questions will provide the information necessary to design the best performing storage solution?()

  • A、How many web servers will be connected to the database?
  • B、Will the database be run on a Windows solution?
  • C、How many concurrent users will be accessing the database?
  • D、What are the types of transactions run against the database?

正确答案:D

第10题:

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

正确答案:C

更多相关问题