單項選擇題

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

你可能感興趣的試題

單項選擇題

You want to be notified when the space usage of an existing critical tablespace has reached 75% of the allocated space. Which option would you use to achieve this？（）

A.run a procedure to check the tablespace space usage
B.define the warning threshold for the tablespace at 75% in Database Control
C.create a trigger to be executed when tablespace space usage reaches 75%
D.submit a job by using DBMS_JOB package to check the free space in the tablespace at regular intervals
E.define the warning threshold to be 75% for the tablespace by ALTER TABLESPACE .. ADD THRESHOLD command

單項選擇題

You observe that in your PROD database， customer information is being modified by some unauthorized users. You want to keep track of all of the transactions happening on the table using PL/SQL. Which type of PL/SQL subprogram or construct would you use to accomplish this task？（）

A.functions
B.packages
C.procedures
D.database triggers
E.anonymous PL/SQL block

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区 狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久

你可能感興趣的試題

You want to be notified when the space usage of an existing critical tablespace has reached 75% of the allocated space. Which option would you use to achieve this？（）

You observe that in your PROD database， customer information is being modified by some unauthorized users. You want to keep track of all of the transactions happening on the table using PL/SQL. Which type of PL/SQL subprogram or construct would you use to accomplish this task？（）

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久

You want to be notified when the space usage of an existing critical tablespace has reached 75% of the allocated space. Which option would you use to achieve this？（）

You observe that in your PROD database， customer information is being modified by some unauthorized users. You want to keep track of all of the transactions happening on the table using PL/SQL. Which type of PL/SQL subprogram or construct would you use to accomplish this task？（）