The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this? ()
The user SCOTT who is the owner of ORDERS and ORDERJTEMS tables issues the following GRANT command: GRANT ALL ON orders, order_items TO PUBLIC; What correction needs to be done to the above statement? ()
You want to check the EMP table in the user, Scott’s schema for block corruption. You also want to fix the corrupted blocks, if any. How will you accomplish the required task?()
You executed the following command to drop a user: DROP USER scott CASCADE; Which two statements regarding the above command are correct?()
You executed the following command to drop a user: DROP USER scott CASCADE; Which two statements regarding the above command are correct?()
You want to move all objects of the APPS user in the test database to the DB_USER schema of theproduction database. Which option of IMPDP would you use to accomplish this task()
An administrator received a call from a user whose PC crashed while using vi to edit a file. The user wants the edited file back. Where should the administrator look for the file()
Which attribute is used to pass the user role back to the Nexus when remote AAA is enabled?()
You want to move all the objects of the APPS user in the test database to the DB_USER schema of the production database. Which option of IMPDP would you use to accomplish this task?()
You are performing the shrink operation on the SCOTT.EMP table. You want to perform the same operation on all dependent objects of the SCOTT.EMP table. What is NOT a prerequisite for the operation?()
A user wants to be permanently added to the dba group. Which of the following commands or processes can be used to accomplish this()
You want users to log on to Active Directory by using a new User Principal Name (UPN). You need to modify the UPN suffix for all user accounts. Which tool should you use()
User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions?()
User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions?()
Which substitution variable would you use if you want to reuse the variable without prompting the user each time? ()
You want to use Windows 2000 backup to perform a weekly backup of the user data on a Windows 2000 Professional computer. You want to ensure that the registry, boot files and COM plus objects are also backed up. What should you do?()
You want users to log on to Active Directory by using a new User Principal Name (UPN). You need to modify the UPN suffix for all user accounts. Which tool should you use()
User Scott has updated the salary of one of the employees in the EMPLOYEES table and has not committed the transaction. What are the two types of locks that this scenario would lead to?()
You want to move all objects of the APPS user in the test database to the DB_USER schema of the productiondatabase. Which option of IMPDP would you use to accomplish this task()
Which two applications can be used by a user to report emergency work, if the user at least wants to report downtime, classify the request, and report actuals?()
Mike wants to go back to the computer business.
If you want him to ________ you the money, you have to prove that you will be able to give it back.
You want to get your book back, ______ ?
If the guest wants to get back his deposited bag in your cloakroom what would you like to do ?