databases Online Quiz - 125
|Description: databases Online Quiz - 125|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
Which of the following aggregate functions returns a row count as an integer?
Which will allow us to create a column alias?
The EMP table contains these columns: LAST NAME VARCHAR2(25) SALARY NUMBER(6,2) DEPARTMENT_ID NUMBER(6) You need to display the employees who have not been assigned to any department. You write the SELECT statement: SELECT LAST_NAME, SALARY, DEPARTMENT_ID FROM EMP WHERE DEPARTMENT_ID = NULL; What is true about this SQL statement?
ISN value differs for each row if the rows has PE fields
3The Rate of toleration of reject events in the number of records processed in a dedup sort is
The keep parameter in dedup sort is optional
The maximum number of input ports a join component can have is :
The default value of max-memory in join component is