grant CONNECT role to all of the three users
grant RESOURCE role to all of the three users
grant both CONNECT and RESOURCE role to all of the three users
execute ALTER USER .. QUOTA UNLIMITED ON publisher_tbs command for all of the three users
create role with UNLIMITED TABLESPACE system privilege and assign the role to all of the three users
第1题:
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?()
第2题:
You have three temporary tablespace groups named G1, G2, and G3 in your database. You are creating a new temporary tablespace as follows: CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE '/u1/data/temp1.dbf' SIZE 10M TABLESPACE GROUP ''; Which statement regarding the above command is correct?()
第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题:
While creating a database using Database Configuration Assistant tool, you created a database default temporary tablespace. Which activity would cause the default temporary tablespace of the database to be used?()
第5题:
You are creating a recovery catalog for use with RMAN. You have issued these commands: SQL> CREATE TABLESPACE rman_ts DATAFILE ’/DISK1/rman_ts01.dbf’ 2> SIZE 20M 3> DEFAULT STORAGE (initial 100K next 100K pctincrease 0); SQL> CREATE USER rman_db01 IDENTIFIED BY rman_db01 2> DEFAULT TABLESPACE rman_ts 3> QUOTA unlimited ON rman_ts; Which command should you issue next?()
第6题:
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()。
第7题:
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?()
第8题:
You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces arecreated by default in HR_PDB?()
第9题:
Which option is best practice for creating a recovery catalog owner in the catalog database?()
第10题:
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?()