You start your database instance in NOMOUNT state.Which two actions are performed?
Which three statements are true about sequences in a single instance Oracle database?
Which three activities are recorded in the database alert log?
Examine the description of the SALES tableName Null type-----------------------------------------------------PRODUCT_ID NOT NULL NUMBER(10)CUSTOMER_ID NOT NULL NUMBER(10)TIME_ID NOT NULL DATECHANNEL_ID NOT NULL NUMBER(5)PROMO_ID NOT NULL NUMBER(5)UANTITY_SOLD NOT NULL NUMBER(10,2)PRICE NUMBER(10,2)AMOUNT_SOLD NOT NULL NUMBER(10,2)The SALES table has 55,000 rowsExamine this statement:CREATE TABLE sales1(prod_id, cust_id, quantity_sold, price)ASSELECT PRODUCT_ID, CUSTOMER_ID, QUANTITY_SOLD, PRICEFROM sales WHERE 1 = 1;
Which two statements are true about User Authentication in an Oracle Database?
Which two statements are true about segment types in an Oracle Database?
Which three tasks are performed by background processes in an Oracle database instance?
Examine these SOL statements which execute successfullyCREATE TABLE emp (emp_no NUMBER(2) CONSTRATINT emp_emp_no_pk PRIMARY KEY, ename varchar2(15), salary number(8,2), mgr_no number(2));ALTER TABLE emp ADD CONSTRATINT emp_mgr_fk FOREIGN KET(mgr_no) REFERENCES emp(emp_no) ON DELETE SET NULL;ALTER TABLE emp DISABLE CONSTRATINT emp_emp_no_pk CASCADE;ALTER TABLE emp ENABLE CONSTRATINT emp_emp_no_pk;Which two statements are true after execution?
Which three statements are true about Private Temporary Tables (PTTs)in an OracleDatabase?
Table ORDER ITEMS contains columns ORDER ID, UNIT PRICE and QUANTITY, ofData type NUMBER.Examine these SQL statementsStatement1:SELECT MAX(unit_price * quantity) "Maximum Order" FROM order_items;Statement2:SELECT MAX(unit_price * quantity) "Maximum Order" FROM order_items GROUP BY order_id;Which two statements are true?
Which two statements are true about the results of using the INRERSECR operator inCompound queries?
Which three statements are true about using SQL*Plus?
Which three statements are true about a self join?
Which two statements are true about a full outer join?
Which two statements are true about the UNLIMITED TABLESPACE system privilege andSpace quotas?