Tag Archives: data

Which three statements are true about time zones, date data types, and timestamp data types in an Oracle

Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.) A. The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC) B. The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC) C. A TIMESTAMP data type column contains information about year, month,… 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 wee.Which query can be used? A. SELECT… Read More »

Which three statements are true about table data storage in an Oracle Database? (Choose three.)

Which three statements are true about table data storage in an Oracle Database? (Choose three.) A. Data block headers contain their own Data Block Address (DBA) B. A table row piece can be chained across several database blocks C. Multiple row pieces from the same row may be stored in different database blocks D. Multiple row pieces from… Read More »

In your data center, Oracle Managed Files (OMF) is used for all databases. All tablespaces are smallfile

In your data center, Oracle Managed Files (OMF) is used for all databases.All tablespaces are smallfile tablespaces.SALES_Q1 is a permanent user-defined tablespace in the SALES database.Examine this command which is about to be issued by a DBA logged in to the SALES database:ALTER TABLESPACE sales_q1 ADD DATAFILE;Which are two actions, either one of which you could take to… 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 »

Which two statements are true for a two-dimensional array of primitive data type?

Which two statements are true for a two-dimensional array of primitive data type? A. It cannot contain elements of different types. B. The length of each dimension must be the same. C. At the declaration time, the number of elements of the array in each dimension must be specified. D. All methods of the class object may be… Read More »

Given: var data = new ArrayList<>(); data.add("Peter"); data.add(30); data.add("Market Road");

Given:var data = new ArrayList<>();data.add(“Peter”);data.add(30);data.add(“Market Road”);data.set(1, 25);data.remove(2);data.set(3, 1000L);System.out.print(data);What is the output? A. [Market Road, 1000] B. [Peter, 30, Market Road] C. [Peter, 25, null, 1000] D. An exception is thrown at run time. Correct Answer: D

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 »

In your data center, Oracle Managed Files (OMF) is used for all databases. All tablespaces are smallfile

The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of data type DATE.

The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of data type DATE.NLS_DATE_FORMAT is set to DD-MON-RR.Which two are true about data type conversions involving these columns in query expressions? (Choose two.) A. invoice_date=”15-march-2019″ : uses implicit conversion B. qty_sold = ‘0554982’ uses implicit conversion C. CONCAT (qty_sold, invoice_date) : requires explicit… Read More »

Last »