Sample Questions:
What are the three tasks you can perform in the Express database of the database?
See the performance and status of the database instance.
Start of the database.
Turn off the database.
Creating a database structure. Management of users and security.
What two affirmations are true about the B-Tree index?
Blocks of plate in the index linked doubly.
Leaf node stores a bitmap for each key value.
Line with the null value in key columns and records in the index.
The removal of the chain from the table is logically deleted in the sheet index block and the space is available for the new recording sheet.
What two affirmations are true about listeners?
Students use only the TCP / IP protocol.
Several listener processes can be executed simultaneously in a host.
Multiple instances of the database with a single listener can be recorded,
The errors associated with the listener can be traced only at administrative level
Only one instance of a database can be recorded with a single listener at any time.
You want to launch a global service for your database. What are the three conditions should be fulfilled?
The database is open and registered with a global service manager.
The database is open and registered with a global service manager.
The role of the database different from the function of the service attribute.
The replication delay in the database does not exceed the specified maximum for the service.
The service has reached the capacity determined by the number of preferred databases.
No other database in the pool is a better candidate for starting the service.
What should you do with the request to take advantage of the division?
recompile
Rewrite your SQL queries
restart
Remover applications circuits nothing; it's transparent
What three declarations about the general and local roles right?
When the function is given to the user as a privilege restricted to the context of the PDB.
Local roles can be provided only for local users.
General roles can be granted both local and common users.
The user can create the function, if the user has the privilege create function and configure the container for all PDB files
General roles can be created at the root and PDB files.
What statement regarding Oracle's active data protector at 12c is false?
Any application that is compatible with the read database can only be executed in the Oracle active data guard standby mode
It provides a new DML support for global temporary tables, and use sequences in the standby database.
Restores the detected corruption in the primary or waiting database.
It supports several levels of software that change between a main database and a physical standby database for the purposes of the application and verification of the Oracle patches in a roller way.
Supports multiple teachers and bidirectional replication architecture where there are multiple databases that contain the same data, even if they are not synchronized.
