A user receives the following error while executing a query: ORA01555:snapshot too old Which two options can be the solutions to avoid such errors in future?()
A user issues a SELECT command against the Oracle database. Which of the following choices describes a step that Oracle will execute in support of this statement?()
View the Exhibit. https://assets.asklib.com/images/image2/2018080210301383494.jpg 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? ()
You have a share on your local computer. This share contains some sensitive applications in theform of .exe files. You want to audit the users who are trying to execute these programs. What should you do?()
You executed the following command to drop a user: DROP USER scott CASCADE; Which two statements regarding the above command are correct?()
User A issues the command: LOCK TABLES pets READ; Which command can User B execute against the pets table?()
Examine the command: SQL> ALTER USER skd ACCOUNT LOCK; Which two statements are true after the command is executed()
User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, whichcommands must you execute to enable SCOTT to flash back the transactions? ()(Choose four.)
The user is trying to execute a SELECT statement. Which of the following background processes will obtain data from a disk for the user?()
What is used to execute a task at a particular time against any application on a user-defined schedule with user-defined parameters? ()
View the Exhibit. https://assets.asklib.com/images/image2/2018080210291676439.jpg 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 executed the following command to drop a user: DROP USER scott CASCADE; Which two statements regarding the above command are correct?()
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?()
You are ready to implement RMAN in the backup and recover strategy for your company. Which system privilege must the RMAN user have to be able to connect and execute RMAN commands on a target database?()
Examine the command: SQL> ALTER USER skd ACCOUNT LOCK; Which two statements are true after the command is executed()
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? ()
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?()
The ORDERS table belongs to the user OE. OE has granted the SELECT privilege on the ORDERS table to the user HR.Which statement would create a synonym ORD so that HR can execute the following query successfully?()
A user executes the statement; PURGE BINARY LOGS TO 'mysql-bin.010'; What is the result?()
Which file contains the attributes used to setup a new user account when executing ’mkuser’ without any flags?()
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?()
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create a Windows Presentation Foundation (WPF) application.You plan to use a PresentationTraceSources object when the application is executed by users.When the application is executed in a test environment, all debug information is successfully captured.You need to be able to capture debug information when the application is deployed.What should you do?()
The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema.What happens when you execute this query?()