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

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;

  6. F. SELECT TO CHAR(8000,’$N,NNN.NN’) 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)

  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

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

  1. USER_TAB_PRIVS_MADE

  2. USER_TAB_PRIVS

  3. USER_COL_PRIVS_MADE

  4. USER_COL_PRIVS


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