databases Online Quiz - 125

Description: databases Online Quiz - 125
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

Which of the following aggregate functions returns a row count as an integer?

  1. (a) AVG

  2. (b) COUNT

  3. (c) STDEV

  4. (d) COUNT_BIG

Correct Option: B

Which Joins allows to bring non matching data in TSQL

  1. (a) Full outer join

  2. (b) Inner join

  3. (c) Right outer join

  4. (d) Left outer join

Correct Option: A,C,D

Which will allow us to create a column alias?

  1. (a) AS

  2. (b) STR

  3. (c) FROM

  4. (d) COLUMN

Correct Option: A

Which three SELECT Statements displays 8000 in the format “$8,000.00”?(Choose three)

  1. A. SELECT TO CHAR(8000,’$#,###.##’) FROM DUAL;

  2. B. SELECT TO CHAR(8000,’$0,000.00’) FROM DUAL;

  3. C. SELECT TO CHAR(8000,’$9,999.00’) FROM DUAL;

  4. D. SELECT TO CHAR(8000,’$9,999.99’) FROM DUAL;

  5. E. SELECT TO CHAR(8000,’$8,000.00’) FROM DUAL;


Correct Option: B,C,D

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?

  1. At the beginning of the list

  2. At the end of the list

  3. In the middle of the list

  4. At the same location they are listed in the unordered table

Correct Option: A

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?

  1. The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist

  2. The ROLLBACK statement frees the storage space occupies by the DEPT table

  3. The DESCRIBE DEPT statement displays the structure of the DEPT table

  4. The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement

Correct Option: C

Which three are DATETIME data types that can be used when specifying column definitions? (Choose three)






Correct Option: A,D,E

Which data dictionary table should you query to view the object privileges granted to the user on specific columns?





Correct Option: D

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?

  1. The SQL statement displays the desired results

  2. The operator in the WHERE clause should be changed to display the desired results

  3. The WHERE clause should be changed to use an outer join to display the desired results

  4. The column in the WHERE clause should be changed to display the desired results

Correct Option: B

ISN number is unique across

  1. Database

  2. Each File

  3. Both a & b

  4. None

Correct Option: B

ISN value differs for each row if the rows has PE fields

  1. True

  2. False

Correct Option: B

1.List some of the flat file types used in Ab Initio:

  1. ASCII files

  2. comma separated list

  3. excel spreadsheet

  4. All the above

Correct Option: D

Metadata can be embedded within a component or can be stored external to the graph in a file with a :

  1. .XFR

  2. .TXT

  3. .DML

  4. None of the above

Correct Option: C

3The Rate of toleration of reject events in the number of records processed in a dedup sort is

  1. Ramp

  2. Limit

  3. Check-sort

  4. Reject - Threshold

Correct Option: A

The keep parameter in dedup sort is optional

  1. True

  2. False

Correct Option: B

The maximum number of input ports a join component can have is :

  1. 10

  2. 20

  3. 15

  4. 5

Correct Option: B

'record-required n' parameter is available only when the join-type parameter is set to:

  1. Implicit

  2. Explicit

  3. inner join

  4. Outer join

Correct Option: B

The default value of max-memory in join component is

  1. 8388806

  2. 3866086

  3. 8388608

  4. None of the above

Correct Option: C

If input_select returns NULL for a particular record, Normalize-

  1. Writes the record to the reject port

  2. Writes a descriptive error message to the error port

  3. Discards the information if you do not connect flows to the reject or error ports

  4. Processes all records

Correct Option: A,B,C

Limit = 1 Ramp = 0.01 Justifies:

  1. Abort on any error

  2. Abort after 50 errors

  3. Abort if more than 2 in 100

  4. Abort if more than 1 in 100

Correct Option: C
- Hide questions