You are working on the Certkiller database. What is the default name of the alert log file in this database?()
For which database operation would you need the database to be in the MOUNT state()
While troubleshooting some connectivity issues,you issue the “show ip ospf database”in order to ex amine the link state database. Which three of the statements below are true regarding the OSPF link state database()
You need to design the database permissions for access from the terminals to the database server. Which action or actions should you perform?()
You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option? ()
You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option? ()
A junior level Database Administrator erroneously deleted the database alert log while users were accessing the database. Which action should you take to recover the alert log?()
You are managing an Oracle Database 10g database that uses Oracle Managed Files (OMF). You enabled the block change tracking feature for the database. Which statement regarding the change tracking file is true?()
The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database?()
You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state?()
What is the correct order of steps to perform an online database backup?() a. alter database begin backup b. alter database end backup c. Back up the database datafiles d. Back up the archive log files e. alter system switch logfile
You are managing an Oracle Database 11g instance.You want to create a duplicate database for testing purpose. What are the prerequisites for performing the active database duplication?()
After performing a clean shut down of the database instance for maintenance, you mount the database andthen execute a command to open the database:SQL> ALTER DATABASE OPEN; Which two statements are true()
Which background process sequentially writes Flashback Database data from the flashback buffer to the Flashback Database logs?()
You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?()
Your Oracle Database 10g is online when you execute the following statement: SQL>ALTER TABLESPACE MY_TABLESPACE FLASHBACK OFF; What is the result of executing this statement if the Flashback Database feature is already enabled in the database?()
You are using the Database Configuration Assistant to configure your Oracle database. Which of the following terms pertains to the creation of an object from which creation of the other database can be based? ()
What type of protection is implemented when the DBA issues the ALTER DATABASE SET STANDBY DATABASE PROTECTED; command?()
Which of the following commands will perform an active database duplication of the ORCL database to the ORCL2 database?()https://assets.asklib.com/images/image2/2018080209255740630.jpg
While troubleshooting some connectivity issues, you issue the "show ip ospf database" in order toexamine the link state database. Which three of the statements below are true regarding theOSPF link state database?()
What is the maximum database block size supported for the Oracle9i database?()
You are managing an Oracle Database 11g database. You want to ensure the recovery of the database to thepoint of failure. Which configuration will you do to accomplish the task()
You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option?()
While creating a database using Database Configuration Assistant tool, you created a database default temporary tablespace. Which activity would cause the default temporary tablespace of the database to be used?()