1.
A standby database is in mounted state and you are required to perform a failover to the physical standby. Which solution is best suited forthis scenario?
2.
Which three statements are true about a database instance that has mounted a database but has not opened it?
3.
Your customer wants to migrate their production database from Oracle Database 10gon AIX to Oracle Database 12con Solaris, and is concerned about the
downtime. Which Oracle solution would you recommend?
4.
An Oracle instance is a combination of______.
5.
You have two database servers EMP and EXP. A user of the database from the EXP server wants to extract some information from the database in the EMP server for cross-verification. Which schema object enables the user to access the information from the remote database?
6.
Which two are client-side components of Oracle Data Guard Broker?
7.
Your customer needs server availability that provides uninterrupted access to database services, handling any unexpected failure of one or more machines hosting the database server, due to a hardware or software fault. Which product should your customer use?
8.
Your customer has three data centers in three different locations, location A has their production database running on Oracle Database 12c. They want to replicate the data from location A to location B. which is 50 miles away and is used for disaster protection and database rolling upgrades. They also want to create a replica database at location C, which must be open in read-write mode, while synchronizing with the primary database. Which two solutions would you recommend to your customer?
9.
Your database instance is running. db01 is a net service name. You issue a connection request by using the command:
SQL> CONNECT scott/tiger@db01
Which component receives the request and establishes the appropriate connection?
10.
Which statement about Online Move Data file is true?