Oracle认证考试
You have been asked to create three users， PUB1， PUB2 and PUB3， for three newly hired employees and to allocate unlimited quota on their default tablespace PUBLISHER_TBS with no other privileges. After creating the users， which method can you use for gran
题目
You have been asked to create three users， PUB1， PUB2 and PUB3， for three newly hired employees and to allocate unlimited quota on their default tablespace PUBLISHER_TBS with no other privileges. After creating the users， which method can you use for granting the required privileges？（）
- A、grant CONNECT role to all of the three users
- B、grant RESOURCE role to all of the three users
- C、grant both CONNECT and RESOURCE role to all of the three users
- D、execute ALTER USER .. QUOTA UNLIMITED ON publisher_tbs command for all of the three users
- E、create role with UNLIMITED TABLESPACE system privilege and assign the role to all of the three users
参考答案和解析
相似问题和答案
第1题：
A.SYSTEM
B.SYSAUX
C.EXAMPLE
D.UNDO
E.TEMP
F.USERS
第2题：
You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces arecreated by default in HR_PDB?（）
- A、SYSTEM
- B、SYSAUX
- C、EXAMPLE
- D、UNDO
- E、TEMP
- F、USERS
正确答案:A,B,E
第3题：
A. Granting UNLIMITED QUOTA on the SYSTEM tablespace to the owner
B. Allocating the SYSTEM tablespace as the default tablespace and granting the SYSDBA privilege to the user
C. Creating a new tablespace, allocating this as the default, and granting UNLIMITED QUOTA on this tablespace to the user
D. Allocating the SYSAUX tablespace as the default tablespace and granting UNLIMITED QUOTA on this tablespace to the user
第4题：
The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use？（）
- A、 the RMAN LIST command
- B、 the DBNEWID utility
- C、 the RMAN REPORT command
- D、 the RMAN BLOCKRECOVER command
- E、 the RMAN CROSSCHECK command
- F、 the ANALYZE command
正确答案:F
第5题：
Your IT director has decided to allow employees to use their laptops at home as well as in the office. You have deployed the Junos Pulse client to allow access to the offices 802.1X-enabled wired network. Your company also has the Junos Pulse Secure Access Service deployed. You want the Junos Pulse client to automatically launch the appropriate access method depending on each users location. Which three are supported to determine the users location?（）
- A、MAC address
- B、DNS server
- C、DHCP server
- D、resolve address
- E、endpoint address
正确答案:B,D,E
第6题：
Your IT director has decided to allow employees to use their laptops at home as well as in the office. You have deployed the Junos Pulse client to allow access to the offices 802.1X-enabled wired network. Your company also has the Junos Pulse Secure Access Service deployed. You want the Junos Pulse client to automatically launch the appropriate access method depending on each users location.Which three are supported to determine the users location?（）
A. MAC address
B. DNS server
C. DHCP server
D. resolve address
E. endpoint address
第7题：
You are the network administrator for Company. You have been assigned the task to create and deploy a standard Windows 2000 Professional image to all 2,500 client computers that today are installed with Windows 98. You log on to a client computer called Company by using a local administrative account called SetupUser and install three Windows 2000 professional compatible software packages on Company. You create an image using third party software. You deploy the image to a test client computer and join the client computer to a domain. You want to create shortcuts on all users' desktops for the software packages you installed. You also want users to have the option to delete the icons. Which profile must you edit?（）
- A、The SetupUser profile
- B、The Default User profile
- C、The Administrator profile
- D、The System profile
- E、The All Users profile
正确答案:B
第8题：
A. identify the segments that you should shrink
B. modify the storage parameters for the tablespace
C. automatically shrink the segments with unused space
D. check the alerts generated for the tablespace that is running low on space
第9题：
You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space. You can use Segment Advisor to（）。
- A、identify the segments that you should shrink
- B、modify the storage parameters for the tablespace
- C、automatically shrink the segments with unused space
- D、check the alerts generated for the tablespace that is running low on space
正确答案:A
第10题：
You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for the RMAN. To accomplish the backup， you issued the following RMAN command： RMAN> BACKUP SECTION SIZE 300M TABLESPACE users； Which two statements are true regarding the execution of the above command？（）
- A、 The RMAN parallelizes the backup although the parallelism is not set for a channel.
- B、 The backup piece size will be limited to 300 MB.
- C、 The operation is accomplished using the default channel available.
- D、 Three channels for the tape drive must be configured by setting the parallelism to three.
正确答案:B,C