⟩ "Lay-up shot" is a term associated with which of the following games ?(1) Volleyball(3) Basketball(2) Throwball(4) Hand BalI
(3) Basketball
(3) Basketball
Explain Which two statements are true regarding single row functions? (Choose two.) A. They accept only a single argument B. They can be nested only to two levels C. Arguments can only be column values or constant D. They always return a single result row for every row of a queried table E. They can return a data type value different from the one that is reference
Explain What is the use of PARALLEL_ADAPTIVE_MULTI_USER initialization parameter?
What is row chaining and row migration?
Explain Which three statements are true regarding the data types in Oracle Database 10g/11g? (Choose two.) A. Only One LONG column can be used per table B. A TIMESTAMP data type column stores only time values with fractional seconds C. The BLOB data type column is used to store binary data in an operating system file D. The minimum column width that can be specified for a VARCHAR2 data type column is one E. The value for a CHAR data type column is blanked-padded to the maximum defined column width
How to use STANDBY_ARCHIVE_DEST parameter and explain its need?
What is the difference between primary key and foreign key
You need to calculate the number of days from 1st Jan 2007 till date Dates are stored in the default format of dd-mm-rr. Which two SQL statements would give the required output? (Choose two.) A. SELECT SYSDATE - 01-JAN-2007 FROM DUAL B. SELECT SYSDATE - TO_DATE(01/JANUARY/2007) FROM DUAL; C. SELECT SYSDATE - TO_DATE(01-JANUARY-2007) FROM DUAL; D. SELECT TO_CHAR(SYSDATE,DD-MON-YYYY)-01-JAN-2007 FROM DUAL; E. SELECT TO_DATE(SYSDATE,DD/MONTH/YYYY)-01/JANUARY/2007 FROM DUAL;
Which three statements are true regarding subqueries? (Choose three.) A. Subqueries can contain GROUP BY and ORDER BY clauses B. Main query and subquery can get data from different tables C. Main query and subquery must get data from the same tables D. Subqueries can contain ORDER BY but not the GROUP BY clause E. Only one column or expression can be compared between the main query and subqeury F. Multiple columns or expressions can be compared between the main query and subquery
What are transportable table spaces and the need to use them?
What will be the output for this query select 1 from dual minus select a from dual;