A user receives the following error while executing a query： ORA/x7f01555：snapshot too old Which two options can be the solutions to avoid such errors in future？（）

You executed the following command to drop a user：   DROP USER scott CASCADE；   Which two statements regarding the above command are correct？（）

多选题查看答案

In what order would you execute the following steps to create a recovery catalog？（） a.Issue the create catalog command.  b.Create the recovery-catalog database.  c.Create the recovery-catalog user.  d.Grant the recovery_catalog_owner privilege to the recovery-catalog user.  e.Issue the register database command from the target database.

单选题查看答案

View the Exhibit.You executed the following command to perform a backup of the USERS tablespace： RMAN> BACKUP TABLESPACE USERS；  Which three types of files are backed up？ （）

多选题查看答案

A user is running a long update batch file. Many tables are updated and all the  statements are in one transaction. Before the process is finished， the user machine lost power. When the user calls you， what should you do as DBA？（）

单选题查看答案

View the Exhibit. The DBA creates a new user as follows：  SQL> CREATE USER manfus IDENTIFIED BY manfus TEMPORARY TABLESPACE temp；  User manfus creates a table as follows：  SQL> CREATE TABLE material（id NUMBER（3））；  In which tablespace will the material table be created？（）

单选题查看答案

Examine the following steps performed on a database instance： 1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION. 2. The SKD user creates a table. 3. The SKD user grants the CREATE TABLE system privilege to the HR user. 4. The HR user creates a table. 5. The DBA revokes the CREATE TABLE system privilege from SKD.  Which statement is true after step 5 isperformed（）

单选题查看答案

View the Exhibit.  You executed the following command to perform a backup of the USERS tablespace：  RMAN> BACKUP  TABLESPACE USERS;  Which three types of files are backed up？ （）

多选题查看答案

View the Exhibit.  You executed the following command to perform a backup of the USERS tablespace： RMAN> BACKUP TABLESPACE USERS;  Which type of backup would this command perform？（）

单选题查看答案

You created a profile APP_USER and assigned it to the users. After a month， you decide to drop theprofile.Some user sessions are currently connected to the database instance and are using the APP_USERprofile. This command is used to drop the profile： SQL> DROP PROFILE app_user；  Which statement describes the result（）

单选题查看答案

A class games.cards.Poker is correctly defined in the jar file Poker.jar. A user wants to execute the main method of Poker on a UNIX system using the command：java games.cards. Poker What allows the user to do this？（）

单选题查看答案