Choose two. Which two statements are true about the DUAL table? A) It can display multiple rows and columns. B) It can be accessed...

Choose two The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOTCE_DATE column of data type DATE NLS_DATE_FORMA...

Choose two The PRODUCT_INFORMATION table has a UNIT_PRICE column of data type NUMBER(8, 2). Evaluate this SQL statement: SELECT TO...

choose two In the PROMOTIONS table, the PROMO_BEGTN_DATE columm is of datatype DATE and the default date format is DD-MON-RR. Whic...

Choose two Which two statements are true about transactions in the Oracle Database serve? A) An uncommitted transaction commits au...

Choose two Which two statements are true about transactions in the Oracle Database serve? A) An uncommitted transaction commits au...

Choose three. Which three statements are true about GLOBAL TEMPORARY TABLES? A) A GLOBAL TEMPORARY TABLE cannot have PUBLIC SYNONY...

choose two. ·MANAGER is an existing role with no privileges or roles. ·EMP is an existing role containing the CREATE TABLE privile...

choose two Evalute these conmands which execate sucestully CREATE SEQUENCE ord_seq INCREMENT BY 1 START WITH 1 MAXVALUE 100000 CYC...

Choose two Examine the data in the CUST NAME column of the CUSTOMERS table: CUST_NAME ------------------------------ Renske Ladwig...

choose two The ORDERS table has a column ORDER_DATE of date type DATE The default display format for a date is DD-MON-RR Which two...

Choose three. Which three statements are true about defining relations between tables in a relatonal database? A) Foreign key colu...

Choose three Which three actions can you perfom only with system privileges? A) Truncate a table in another schema. B) Access flat...

Choose two Exanine the desatption of the BOOKS_TRANSACTIONS table Name Null? Type ------------------------------------------------...

Choose two. Which two statements are true about single row functions? A) CONCAT : can be used to combine any number of values B) M...

choose three The ORDERS table has a primary key constraint on the ORDER_ID column. The ORDER_ITEMS table has a foreign key constra...

Choose two Examine this SQL statement: DELETE FROM employees e WHERE EXISTS (SELECT "dummy" FROM emp_history WHERE employee_id = e...

Choose the best answer Examine the description of the PRODUCT_INFORMATION table: Name     NULL?        Type ----------------------...

choose two. You need to calculate the number of days from 1st January 2019 until today. Dates are stored in the default format of ...

Choose three. Which three statements are true about a self join? A) It must be an inner join. B) It can be an outer join. C) The O...