The NOMOUNT state is necessary for database recovery, for changing the AKCHR'ELOG mode, for renaming (moving) data files and for adding, dropping or renaming online redo log files.
A. Incorrect
B. Correct
Which statements are correct? (More than one answers are true)
A. There are just a few predefined database roles in Oracle, the most important of which is DBA.
B. Any number of database roles can be created in an Oracle database.
C. If you assign a database ro e to a database user, the user will be granted all privileges included in the role.
D. Within the database, system and object privileges can be pooled to database roles.
E. The DBA role contains limited privileges necessary for the database administration
RAC overcomes the limitations of traditional failover solutions by providing (More than one answers are true)
A. Fast recovery
B. Load balancing
C. Concurrent processing
D. Fast and reliable detection of a node or network failure
If you don't want to enter the username/password interactively, you can enter the username/password as the first parameter when calling SQLPLUS, for example sqlplus system/manager
A. Incorrect
B. Correct
In the NOMOUNT phase, the parameter file is opened and evaluated, and the database instance is started
A. Incorrect
B. Correct
Oracle does not allows you to set, change, or delete (restore to default) values of some initialization parameters dynamically
A. Incorrect
B. Correct
Which statements are correct for Instance? (More than one answers are true)
A. Using Oracle Real Application Clusters (RAC), one database is served by two or more instances.
B. The combination of Oracle (background) processes and memory buffers is called an Oracle instance
C. Every running Oracle database is associated with an Oracle instance.
D. Every Oracle database needs shared instance.
Which statements are correct? (More than one answers are true)
A. Real Application Clusters also supports all Oracle backup and archiving features that are available in single instance Oracle databases.
B. SAP only supports RAC on systems with a cluster filesystem.
C. Migration to Oracle Real Application Clusters is relatively easy where unloading and loading of data is necessary.
D. While with a standard cluster solution you effectively use just one active database instance, RAC makes it possible to use several instances simultaneously.
When maintaining the user distribution field selection (transaction SCUM), you can choose which of the following options? (3 are correct)
A. Fixed
B. Local
C. Central
D. Redistribution
E. Global
What does índex fragmentation in the Oracle database mean? Note: There are 2 correct answer to this question.
A. The índex root block is fractured.
B. The fragmentation of naíndex specifies how well the space is used in naíndex.
C. The index leaf blocks are spread over several table spaces.
D. Tem smaller the space that is actually used in companson with the total available space, the more fragmented the index.
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only SAP exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your C_TADM51_731 exam preparations and SAP certification application, do not hesitate to visit our Vcedump.com to find your solutions here.