Question 1

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

technology databases

(a) AVG
(b) COUNT
(c) STDEV
(d) COUNT_BIG

Answer

Correct Option: B

Question 2

Which Joins allows to bring non matching data in TSQL

technology databases

(a) Full outer join
(b) Inner join
(c) Right outer join
(d) Left outer join

Answer

Correct Option: A,C,D

Question 3

Which will allow us to create a column alias?

technology databases

(a) AS
(b) STR
(c) FROM
(d) COLUMN

Answer

Correct Option: A

Question 4

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

technology databases

A. SELECT TO CHAR(8000,’$#,###.##’) FROM DUAL;
B. SELECT TO CHAR(8000,’$0,000.00’) FROM DUAL;
C. SELECT TO CHAR(8000,’$9,999.00’) FROM DUAL;
D. SELECT TO CHAR(8000,’$9,999.99’) FROM DUAL;
E. SELECT TO CHAR(8000,’$8,000.00’) FROM DUAL;
F. SELECT TO CHAR(8000,’$N,NNN.NN’) FROM DUAL;

Answer

Correct Option: B,C,D

Question 5

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?

technology databases

At the beginning of the list
At the end of the list
In the middle of the list
At the same location they are listed in the unordered table

Answer

Correct Option: A

Question 6

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?

technology databases

The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist
The ROLLBACK statement frees the storage space occupies by the DEPT table
The DESCRIBE DEPT statement displays the structure of the DEPT table
The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement

Answer

Correct Option: C

Question 7

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

technology databases

TIMESTAMP
INTERVAL MONTH TO DAY
TIMESTAMP WITH DATABASE TIMEZONE
INTERVAL YEAR TO MONTH
INTERVAL DAY TO SECOND

Answer

Correct Option: A,D,E

Question 8

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

technology databases

USER_TAB_PRIVS_MADE
USER_TAB_PRIVS
USER_COL_PRIVS_MADE
USER_COL_PRIVS

Answer

Correct Option: D

Question 9

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?

technology databases

The SQL statement displays the desired results
The operator in the WHERE clause should be changed to display the desired results
The WHERE clause should be changed to use an outer join to display the desired results
The column in the WHERE clause should be changed to display the desired results

Answer

Correct Option: B

Question 10

ISN number is unique across

technology databases

Database
Each File
Both a & b
None

Answer

Correct Option: B

Question 11

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

technology databases

True
False

Answer

Correct Option: B

Question 12

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

technology databases

ASCII files
comma separated list
excel spreadsheet
All the above

Answer

Correct Option: D

Question 13

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

technology databases

.XFR
.TXT
.DML
None of the above

Answer

Correct Option: C

Question 14

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

technology databases

Ramp
Limit
Check-sort
Reject - Threshold

Answer

Correct Option: A

Question 15

The keep parameter in dedup sort is optional

technology databases

True
False

Answer

Correct Option: B

Question 16

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

technology databases

10
20
15
5

Answer

Correct Option: B

Question 17

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

technology databases

Implicit
Explicit
inner join
Outer join

Answer

Correct Option: B

Question 18

The default value of max-memory in join component is

technology databases

8388806
3866086
8388608
None of the above

Answer

Correct Option: C

Question 19

If input_select returns NULL for a particular record, Normalize-

technology databases

Writes the record to the reject port
Writes a descriptive error message to the error port
Discards the information if you do not connect flows to the reject or error ports
Processes all records

Answer

Correct Option: A,B,C

Question 20

Limit = 1 Ramp = 0.01 Justifies:

technology databases

Abort on any error
Abort after 50 errors
Abort if more than 2 in 100
Abort if more than 1 in 100

Answer

Correct Option: C

Description: databases Online Quiz - 125
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 125

Find more quizzes from top tags