What does the following statement do?
What does the following statement do?
GRANT REFERENCES (col1, col2) ON TABLE table1 TO user1 WITH
GRANT OPTION
How can this be achieved without interrupting the SEA?
An administrator must add support for a new VLAN to a VIO Server that currently services
multiple VLANs on a single SEA . No additional network ports are available. How can this be
achieved without interrupting the SEA?
which of the following is the best way to remove all privileges user USER1 holds?
User USER1 is the owner of TABLE1. Assuming user USER1 only holds privileges for TABLE1,
which of the following is the best way to remove all privileges user USER1 holds?
Which action will solve the problem at the least cost?
A Power 795 with 2 TB memory is dedicated to LPARs running production applications. The
applications need more memory than is available in the system. All the memory slots are full
and there are spare CPU cycles. Which action will solve the problem at the least cost?
Which of the following statement(s) can be used to accomplish this?
User USER1 has the privileges needed to invoke a stored procedure named GEN_RESUME.
User USER2 needs to be able to call the procedure – user USER1 and all members of the group
PUBLIC should no longer be allowed to call the procedure. Which of the following statement(s)
can be used to accomplish this?
What is the maximum entitled capacity and virtual processors which can be allocated?
A system administrator has a Power 770 with 12 cores.
The following LPARs already exist:
LPAR1 – 9 dedicated cores
LPAR2 – 1 virtual processors with an entitled capacity of 0.2
LPAR3 – 1 virtual processors with an entitled capacity of 0.8
The administrator wants to create a fourth LPAR. What is the maximum entitled capacity and
virtual processors which can be allocated?
Which of the following statements is USER1 authorized to execute?
A view named V.VIEW1 is based on a table named T.TABLE1. A user with DBADM authority
issues the following statement:
GRANT INSERT ON v.view1 TO user1 WITH GRANT OPTION
Which of the following statements is USER1 authorized to execute?
Which of the following situations will prevent proper installation?
A customer is planning to convert vacant office space to a data center that will be populated
with several standard Power 795 systems. During a pre-delivery site inspection, the
customer is told by the Installation Planning Representative that the data center is
inadequately equipped to receive the systems. Which of the following situations will prevent
proper installation?
What does the following statement do?
What does the following statement do?
GRANT ALTER ON SEQUENCE gen_empid TO user1 WITH GRANT OPTION
Which of the following is the most likely cause?
After configuring a Shared Ethernet Adapter (SEA) on a VIO server, a client Linux LPAR has
no network connectivity while client AIX LPARs configured on the same VLAN work fine.
Which of the following is the most likely cause?