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, like many of your classmates, probably have been in such a situation where you are asked to do something to help a foreign friend. (翻译)
第2题:
A. resolve
B. indirect
C. next-hop
D. recursive
第3题:
(b) As a newly-qualified Chartered Certified Accountant in Boleyn & Co, you have been assigned to assist the ethics
partner in developing ethical guidance for the firm. In particular, you have been asked to draft guidance on the
following frequently asked questions (‘FAQs’) that will be circulated to all staff through Boleyn & Co’s intranet:
(i) What Information Technology services can we offer to audit clients? (5 marks)
Required:
For EACH of the three FAQs, explain the threats to objectivity that may arise and the safeguards that should
be available to manage them to an acceptable level.
NOTE: The mark allocation is shown against each of the three questions.
第4题:
You have been asked to use a 28 bit subnet mask to segment the following network block: 108.12.5.0. How many usable hosts per sub-net could you create?()
第5题:
You have been asked to configure a login class which will permit its users to view and edit the configuration. The class should only allow the configuration of the interfaces and firewall heirarchies. Which configuration correctly accomplishes this?()
A.A
B.B
C.C
D.D
第6题:
A. It will permit the use of uppercase passwords for database users who have been granted the SYSOPER role.
B. It contains username and passwords of database users who are members of the OSOPER operating system group.
C. It contains usernames and passwords of database users who are members of the OSDBA operating system group.
D. It will permit the use of lowercase passwords for database users who have granted the SYSDBA role.
E. It will not permit the use of mixed case passwords for the database users who have been granted the SYSDBA role.
第7题:
A.10 hosts
B.14 hosts
C.12 hosts
D.16 hosts
第8题:
(b) As a newly-qualified Chartered Certified Accountant, you have been asked to write an ‘ethics column’ for a trainee
accountant magazine. In particular, you have been asked to draft guidance on the following questions addressed
to the magazine’s helpline:
(i) What gifts or hospitality are acceptable and when do they become an inducement? (5 marks)
Required:
For each of the three questions, explain the threats to objectivity that may arise and the safeguards that
should be available to manage them to an acceptable level.
NOTE: The mark allocation is shown against each of the three questions above.
第9题:
While designing your database, you have created the EMPLOYEES table as an index/x7forganized table (IOT). You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index?()
第10题:
You are designing an application for a telecom company and you have been asked to design a database table to facilitate monthly bill generation. The bill would include details of customer calls, listed in chronological order. Which method would you follow to achieve this objective without increasing the overhead of sorting the rows?()