Tag Archives: Columns

The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE. You

The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE.You want to display the date of the first Monday after the completion of six months since hiring.The NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day on the wee.Which query can be used? A. SELECT… Read More »

Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY. Only the EMPLOYEE_ID column

Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY.Only the EMPLOYEE_ID column is indexed.Rows exist for employees 100 and 200.Examine this statement:Which two statements are true? (Choose two.) A. Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200 B. Employee 200 will have SALARY set to the same value as the… Read More »

Table ORDER_ITEMScontains columns ORDER_ID, UNIT_PRICEand QUANTITY, of data type NUMBER. Examine these

Table ORDER_ITEMScontains columns ORDER_ID, UNIT_PRICEand QUANTITY, of data type NUMBER.Examine these SQL statements:Statement 1:SELECT MAX(unit_price * quantity) “Maximum Order”FROM order_items;Statement 2:SELECT MAX(unit_price * quantity) “Maximum Order”FROM order_itemsGROUP BY order_id;Which two statements are true? A. Statement 2 returns only one row of output. B. Statement 2 may return multiple rows of output. C. Both the statements give the same… Read More »

You have been tasked to create a table for a banking application. One of the columns must meet three

You have been tasked to create a table for a banking application.One of the columns must meet three requirements:1. Be stored in a format supporting date arithmetic without using conversion functions2. Store a loan period of up to 10 years3. Be used for calculating interest for the number of days the loan remains unpaid Which data type should… Read More »

You have been tasked to create a table for a banking application. One of the columns must meet three

You have been tasked to create a table for a banking application.One of the columns must meet three requirements:1. Be stored in a format supporting date arithmetic without usingconversion functions2. Store a loan period of up to 10 years3. Be used for calculating interest for the number of days the loanremains unpaidWhich data type should you use? A.… Read More »

Which three statements are true about dropping and unused columns in an Oracle database? (Choose three.)

Which three statements are true about dropping and unused columns in an Oracle database? (Choose three.) A. A DROP COLUMN command can be rolled back B. A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option. C. A column that is set to UNUSED still counts towards the… Read More »

Table ORDER_ITEMS contains columns ORDER_ID, UNIT_PRICE and QUANTITY, of data type NUMBER. Examine these

Table ORDER_ITEMS contains columns ORDER_ID, UNIT_PRICE and QUANTITY, of data type NUMBER.Examine these SQL statements:Statement 1:SELECT MAX(unit_price * quantity) “Maximum Order”FROM order_items;Statement 2:SELECT MAX(unit_price * quantity) “Maximum Order”FROM order_itemsGROUP BY order_id;Which two statements are true? A. Statement 1 returns only one row of output. B. Statement 2 returns only one row of output. C. Both statements will return… Read More »

Table ORDER_ITEMScontains columns ORDER_ID, UNIT_PRICEand QUANTITY, of data type NUMBER. Examine these

Table ORDER_ITEMScontains columns ORDER_ID, UNIT_PRICEand QUANTITY, of data type NUMBER.Examine these SQL statements:Statement 1:SELECT MAX(unit_price * quantity) “Maximum Order”FROM order_items;Statement 2:SELECT MAX(unit_price * quantity) “Maximum Order”FROM order_itemsGROUP BY order_id;Which two statements are true? A. Both the statements give the same output. B. Statement 1 returns only one row of output. C. Statement 2 returns only one row of… Read More »

Which three statements are true about dropping and unused columns in an Oracle database? (Choose three.)

Which three statements are true about dropping and unused columns in an Oracle database? (Choose three.) A. A DROP COLUMN command can be rolled back B. A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option. C. Partition key columns cannot be dropped. D. An UNUSED column’s space… Read More »

The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE. You

The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE.You want to display the date of the first Monday after the completion of six months since hiring.The NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day on the week.Which query can be used? A. SELECT… Read More »