Examine the command:
SQL> CREATE TABLESPACE test1
DATAFILE '/u01/app/oracle/oradata/orc1/test01.dbf' SIZE 5M
AUTOEXTEND ON UNIFORM;
Which statement is true?
Examine the details of the uncompressed, non-partitioned heap table CITIES.
Examine the command:
SQL> ALTER TABLE cities SHRINK SPACE COMPACT;
What must you do before executing it?
Which two tasks must you perform before you begin the upgrade process to Oracle Database 12c? (Choose two.)
You want to create a database and you have the following:
- Oracle Grid Infrastructure is installed and configured.
- Oracle Database Vault is installed in ORACLE_HOME to be used for this database.
- Oracle Enterprise Manager Cloud Control is available and an agent is deployed on the database server.
Examine the requirements:
1. configuring the database instance to support shared server mode
2. using Automatic Storage Management (ASM) for storing database files.
3. configuring a naming method to help a remote user connect to a database instance
4. configuring the Fast Recovery Area
5. configuring Database Vault
6. configuring Enterprise Manager (EM) Database Express
7. registering with EM Cloud Control
8. configuring remote log archive destinations
9. enabling daily incremental backups
10. configuring a nondefault block size for nondefault block size tablespaces
Which of these requirements can be met while creating a database by using the Database Configuration Assistant (DBCA)?