单选题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 r
题目
all sessions of the HR user only
all sessions of the HR user and the SYS user
the session of the HR user that executed the commands
all the sessions for which the database users have access privilege to the PERSONS table
相似考题
更多“All the database users are presently connected to the databa”相关问题
-
第1题：
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 -
第2题：
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 -
第3题：
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 -
第4题：
Your database is open and the LISTENER listener is running. The new DBA of the system stops the listener byusing the command：LSNRCTL> STOP What happens 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 sessions are terminated and the active transactions are rolled back.
- D、The sessions are not allowed to perform any operations till the listener is started
正确答案:B -
第5题：
If you back up a database without connecting to the recovery catalog， which operations will cause the recovery catalog to be updated？（）
- A、 The next time you back up the database when you are also connected to the recovery catalog and the target database
- B、 The next time you are connected to the target database and the recovery catalog database and issue the resync command
- C、 The next time you connect RMAN to just the recovery catalog
- D、 The next time you connect to the recovery catalog and the target database with RMAN
- E、 Connecting to the recovery catalog and issuing the resync all databases command
正确答案:A,B -
第6题：
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 -
第7题：
单选题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?（）AAll users except SYS
BAll users except SCOTT
CAll users except sys and SCOTT
DAll users except sys, system, and SCOTT
正确答案： B解析： 暂无解析 -
第8题：
单选题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？ （）Aset the SESSIONS to 1 in the parameter file
Bgrant SINGLE SESSION privilege to all of the users
Cset the SESSIONS_PER_USER to 1 in the users’ profile
Dgrant RESTRICTED SESSION privilege to all of the database users
Ecreate a role with SINGLE SESSION privilege and assign the role to the users
正确答案： B解析： 暂无解析 -
第9题：
单选题To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL> ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the USERS tablespace?（）AThe database will open, and the tablespace automatically comes out of the backup mode.
BThe database will be mounted, and recovery must be performed on the USERS tablespace.
CThe database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.
DThe database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.
正确答案： A解析： 暂无解析 -
第10题：
单选题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？（）AThe sessions are able to perform only queries.
BThe sessions are not affected and continue to function normally.
CThe active transactions are rolled back and the sessions get terminated.
DThe sessions are not allowed to perform any operations till the listener is started.
正确答案： B解析： 暂无解析 -
第11题：
多选题You work as a database administrator for Certkiller .com. One of the database users accidentally deleted all the rows of a critical table and committed the delete at 1：30 p.m. You senior database administrator， Certkiller， asks you to retrieve the lost data. Which two actions would you use to ensure that there is no impact on other connected users while retrieving the deleted rows？（）AUse a flashback query to retrieve the rows that were deleted
BUseconventialincremental export and then import the affected object
CShutdown the database inNORMALmode and restart the database instance
DUse DBMS_META package to reconstruct the object using undo segments
EUseTablespacePoint in Time Recovery （TSPITR） method to recover the table and the data
FUse Oracle DataPumptwithflashback_timeoption toentableflashback export and then import the affected object.
正确答案： F,A解析： 暂无解析 -
第12题：
单选题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?（）AThey are able to perform only queries.
BThey are not affected and continue to function normally.
CThey are terminated and the active transactions are rolled back.
DThey are not allowed to perform any operations until the listener LISTENER is started
正确答案： A解析： 暂无解析 -
第13题：
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 -
第14题：
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 -
第15题：
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 -
第16题：
You work as a database administrator for Supportcenter.cn. One of the database users accidentally deleted all the rows of a critical table and committed the delete at 1：30 p.m. You senior database administrator， SupportCenter， asks you to retrieve the lost data. Which two actions would you use to ensure that there is no impact on other connected users while retrieving the deleted rows？（）
- A、Use a flashback query to retrieve the rows that were deleted
- B、Useconventialincremental export and then import the affected object
- C、Shutdown the database inNORMALmode and restart the database instance
- D、Use DBMS_META package to reconstruct the object using undo segments
- E、UseTablespacePoint in Time Recovery （TSPITR） method to recover the table and the data
- F、Use Oracle DataPumptwithflashback_timeoption toentableflashback export and then import the affected object.
正确答案:B,E -
第17题：
To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL> ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the USERS tablespace?（）
- A、The database will open, and the tablespace automatically comes out of the backup mode
- B、The database will be mounted, and recovery must be performed on the USERS tablespace.
- C、The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.
- D、The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.
正确答案:C -
第18题：
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB01 in the instance. The company CIO wants all the application developers can capture traces to troubleshoot the application that uses the database DB1， and they can perform this by using SQL Server Profiler. But they have to be given as little permission as possible. The company CIO assigns this task to you. So what action should you perform to achieve this goal？（）
- A、All the SQL Server logins of the application developers have to be added to a fixed server role.
- B、All the database users of the application developers have to be added to a fixed database role
- C、All SQL Server logins of the application developers should be given the appropriate server-level permissions.
- D、All database users of the application developers should be given the appropriate database-level permissions.
正确答案:C -
第19题：
单选题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？（）Aremove all other groups from the system
Brun the command mkuser -default GROUP=database
Cchange the default group in /usr/lib/security/mkuser.default
Dedit /etc/security/group to move all users to the database stanza
正确答案： B解析： 暂无解析 -
第20题：
多选题If you back up a database without connecting to the recovery catalog， which operations will cause the recovery catalog to be updated？（）AThe next time you back up the database when you are also connected to the recovery catalog and the target database
BThe next time you are connected to the target database and the recovery catalog database and issue the resync command
CThe next time you connect RMAN to just the recovery catalog
DThe next time you connect to the recovery catalog and the target database with RMAN
EConnecting to the recovery catalog and issuing the resync all databases command
正确答案： C,B解析： 暂无解析 -
第21题：
多选题Which three statements are true about the working of system privileges in a multitenant control database(CDB) that has pluggable databases (PDBs)?（）ASystem privileges apply only to the PDB in which they are used.
BLocal users cannot use local system privileges on the schema of a common user.
CThe granter of system privileges must possess the set container privilege.
DCommon users connected to a PDB can exercise privileges across other PDBs.
ESystem privileges with the with grant option container all clause must be granted to a common user before the common user can grant privileges to other users.
正确答案： C,A解析： 暂无解析 -
第22题：
单选题An employee cannot access the company database. You check the connection variables: What is a valid explanation for why one of the users is unable to connect to the database?（）ABob has max_user_connections set to zero, which blocks all his connections
BJoe has exceeded the max_user_connections global limit
CAll users are blocked because max_user_connections is accumulated over the host account information
DKay is already connected elsewhere and attempting to log in again
EConnect_timeout is too small to allow a connection to occur
正确答案： B解析： 暂无解析 -
第23题：
单选题Your database is open and the LISTENER listener is running. The new DBA of the system stops thelistener by using the command： LSNRCTL> STOP What happens to the sessions that are presently connected to the database instance（）AThe sessions are able to perform only queries.
BThe sessions are not affected and continue to function normally.
CThe sessions are terminated and the active transactions are rolled back.
DThe sessions are not allowed to perform any operations till the listener is started.
正确答案： A解析： 暂无解析 -
第24题：
单选题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（）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
正确答案： B解析： 暂无解析