Question 6
SMD is a smallfile locally managed tablespace with manual segment space management.
The SH user receives the following error while inserting data into the sales table:
Which three actions can be taken to enable the user to insert data? (Choose three.)
The SH user receives the following error while inserting data into the sales table:
Which three actions can be taken to enable the user to insert data? (Choose three.)
Question 7
Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance.
What should you use to achieve this?
What should you use to achieve this?
Question 8
You plan to implement the distributed database system in your company. You invoke
Database Configuration Assistant (DBCA) to create a database on the server. During the installation, DBCA prompts you to specify the Global Database Name.
What must this name be made up of?
Database Configuration Assistant (DBCA) to create a database on the server. During the installation, DBCA prompts you to specify the Global Database Name.
What must this name be made up of?
Question 9
You are required to migrate your 11.2.0.3 database as a pluggable database (PDB) to a multitenant container database
(CDB).
The following are the possible steps to accomplish this task:
1. Place all the user-defined tablespace in read-only mode on the source database.
2. Upgrade the source database to a 12c version.
3. Create a new PDB in the target container database.
4. Perform a full transportable export on the source database with the VERSION parameter set to 12 using the expdp
utility.
5. Copy the associated data files and export the dump file to the desired location in the target database.
6. Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE
role and specify the full transportable import options.
7. Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function.
Identify the correct order of the required steps.
(CDB).
The following are the possible steps to accomplish this task:
1. Place all the user-defined tablespace in read-only mode on the source database.
2. Upgrade the source database to a 12c version.
3. Create a new PDB in the target container database.
4. Perform a full transportable export on the source database with the VERSION parameter set to 12 using the expdp
utility.
5. Copy the associated data files and export the dump file to the desired location in the target database.
6. Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE
role and specify the full transportable import options.
7. Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function.
Identify the correct order of the required steps.
Question 10
The HR.DEPARTMENTS table is the parent of the HR.EMPLOYEES table. The
EMPLOYEES.DEPARTMENT_ID column has a foreign key constraint with the ON DELETE CASCADEoption
that refers to the DEPARTMENTS.DEPARTMENT_ID column. An index exists on the
DEPARTMENTS.DEPARTMENT_ID column. A transaction deletes a primary key in the DEPARTMENTStable,
which has child rows in the EMPLOYEEStable.
Which statement is true?
EMPLOYEES.DEPARTMENT_ID column has a foreign key constraint with the ON DELETE CASCADEoption
that refers to the DEPARTMENTS.DEPARTMENT_ID column. An index exists on the
DEPARTMENTS.DEPARTMENT_ID column. A transaction deletes a primary key in the DEPARTMENTStable,
which has child rows in the EMPLOYEEStable.
Which statement is true?