#341. You want to create a database that uses the Oracle Managed Files (OMF) feature for your database. You specified the following parameters in the initialization parameter file to achieve this: DB_CREATE_ONLINE_LOG_DEST_1 = ‘/u02/oradata/techdb’ DB_CREATE_ONLINE_LOG_DEST_2 = ‘/u03/oradata/techdb’ The DB_CREATE_ONLINE_DEST parameter is not specified. Which statement in this scenario is correct?
#342. Which three statements define the properties of a column that has the UNIQUE constraint that is enforced using ENABLE and VALIDATE clause? (Choose three.)
#347. In your database, customer information is stored in the CUSTOMERS table. While creating the ORDERS table, you need to enforce the following business rules forthe table: 1 The SHIPPED_DATE value must be greater than or equal to the ORDERED_DATE value. 2 The ORDER_VALUE must not exceed 1000000. 3 The CUSTOMER_ID column must have a valid customer ID. Which types of constraints would you use while creating the table? (Choose all that apply.)
#349. Examine the list of steps to create a database manually and make it functional. The steps are arranged in random order. 1. Start the instance in the NOMOUNT state. 2. Create the initialization parameter file. 3. Run catalog.sql and catproc.sql scripts. 4. Create and execute the CREATE DATABASE command. What is the correct order for the steps?
gen. 0.061
Forum
Master braindump