0

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
  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
  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;

  6. F. SELECT TO CHAR(8000,’$N,NNN.NN’) FROM DUAL;


Correct Option: B,C,D
  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
  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
  1. TIMESTAMP

  2. INTERVAL MONTH TO DAY

  3. TIMESTAMP WITH DATABASE TIMEZONE

  4. INTERVAL YEAR TO MONTH

  5. INTERVAL DAY TO SECOND


Correct Option: A,D,E

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
  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. ASCII files

  2. comma separated list

  3. excel spreadsheet

  4. All the above


Correct Option: D

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

The default value of max-memory in join component is

  1. 8388806

  2. 3866086

  3. 8388608

  4. None of the above


Correct Option: C
  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
  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