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 Joins allows to bring non matching data in TSQL
Which will allow us to create a column alias?
Which three SELECT Statements displays 8000 in the format “$8,000.00”?(Choose three)
You are sorting data in a table in you SELECT statement in descending order. The column you are sorting on contains NULL records, where will the NULL record appears?
Evaluate the set of SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCNAR2(14), loc VARCNAR2(13)); ROLLBACK; DESCRIBE DEPT What is true about the set?
Which three are DATETIME data types that can be used when specifying column definitions? (Choose three)
Which data dictionary table should you query to view the object privileges granted to the user on specific columns?
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 number is unique across
ISN value differs for each row if the rows has PE fields
1.List some of the flat file types used in Ab Initio:
Metadata can be embedded within a component or can be stored external to the graph in a file with a :
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 :
'record-required n' parameter is available only when the join-type parameter is set to:
The default value of max-memory in join component is
If input_select returns NULL for a particular record, Normalize-
Limit = 1 Ramp = 0.01 Justifies: