Question 1

In which sceneria would you use the ROLLUP operator for expresiion or column with in a GROUPBY clause?

technology databases

To find the groups forming the subtotal in a row
To create group-wise totals for the groups specified within a GROUPBY clause
To create grouping for expressions or columns specified within a GROUPBY clause in one direction,from right to left for calculating the subtotals.
To create grouping for expressions or columns specified within a GROUPBY clause in all possible direction,which is cross-tabular report for calculating the subtotals

Answer

Correct Option: C

Question 2

Which statement best describes the GROUPING function?

technology databases

used to set the order for the groups to be used for calculating the grand totals and subtotals
used to form various groups to caculate totals and subtotals created using ROLLUP and CUBE operators
used to specify if the NULLL value in an expresion is a stored NULL value or created by ROLLUP and CUBE
used to specify the concatenated groups expressions to be used for calculating the grand totals and subtotals

Answer

Correct Option: C

Question 3

Given below is the SQL statements executed in a user session: CREATE TABLE product (pcode NUMBER(2) ,pname VARCHAR2(10)); INSERT INTO product VALUES (1,'PEN'); INSERT INTO product VALUES (2,'PENCIL'); SAVEPOINT A; UPDATE product SET pcode=10 where pcode=1; SAVEPOINT B; DELETE FROM product where pcode=2; COMMIT; DELETE FROM product where pcode=10; ROLLBACK TO SAVEPOINT a; which statement describes the consequences?

technology databases

both the DELETE statements would be rolledback
No SQL statements would be rolledback
only the second DELETE statements would be rolledback
both the DELETE statements and the update statements would be rolledback

Answer

Correct Option: B

Question 4

which madatory clause has to be added to the following statements successfully create an external table called EMPDET? CREATE TABLE EMPDET( empno CHAR(2) ,ename CHAR(5) ,deptno N?UMBER(4)) ORGANIZATION EXTERNAL ( LOCATION('emp.dat'));

technology databases

TYPE
REJECT LIMIT
ACESS PARAMETERS
DEFAULT DIRECTORY

Answer

Correct Option: D

Question 5

which two statements are true about the GROUPING function ?

technology databases

used to find the groups forming the subtotal in a row
used to identify the NULL value in the aggregate function.
use to form the group sets involved in generating the totals and subtotals
only be used with ROLLUP and CUBE operators specified in the GROUP BY clause

Answer

Correct Option: A,D

Question 6

the following are the steps for a correlated subquery ,listed in a random order: 1)the where clause of the outer query is evaluted 2)The candiadate row is fetched from the table specified in the outer query 3) The procedure is repeated for the subsequent rows of the table,till all the rows are processed. 4)Rows are returned by the inner query ,after being evaluted with the value from the candiadate row in the outer query. Identify the option that contains the steps in the correct sequences in which the oracle server evalutes a correlated subquery ?

technology databases

4,2,1,3
4,1,2,3
2,4,1,3
2,1,4,3

Answer

Correct Option: C

Question 7

How to prevent ROW MIGRATION?

technology databases

specify large pct free
specify large pct used
specify large initial & next sizes
specify small initrans

Answer

Correct Option: A

Question 8

Which NLS parameter can be specified only as an environment variable?

technology databases

NLS_Language
NLS_Lang
NLS_Sort
NLS_Territory

Answer

Correct Option: B

Question 9

How many maximum number of multiplex control files can present in a database?

technology databases

4
8
12
16

Answer

Correct Option: B

Question 10

Multiple WHAT can be share an SGA?

technology databases

SERVER PROCESSES
INSTANCES
TABLESPACES
DATABASES

Answer

Correct Option: B

Question 11

wHICH SCRIPT CREATE THE DATA DICTIONARY TABLES?

technology databases

catalog.sql
sql.bsq
catproc.sql
dictionary.sql

Answer

Correct Option: B

Question 12

which can not be possible?

technology databases

move index to a new tablespace
change the initial extent size of the index
collect statistics on the index
specify a new name for the index

Answer

Correct Option: D

Question 13

Which file can be multiplexed?

technology databases

parameter file
data files
redo log files
alert.log file

Answer

Correct Option: C

Question 14

WHY DO THE FLAT FILES ARE USED AS SOURCES OR TARGETS ?

technology databases

ITS A DUMMY RULE
TO BALANCE THE EXTRACTION AND LOADING PROCESS
EASY TO MAINTAIN
TO RESOLVE THE PERFORMANCE ISSUES

Answer

Correct Option: B,D

Question 15

A UNIX VERSIONED OS SHOULD BE AVAILABLE INORDER TO INSTALL INFORMATICA

technology databases

True
False

Answer

Correct Option: B

Question 16

Which of the following will delete all the rows from the table T1

technology databases

Delete * from table T1
Delete all from T1
Delete * from T1
Delete From T1

Answer

Correct Option: D

Question 17

An Alias can be alter name forhich DB2 object

technology databases

Sequence
Trigger
Schema
View

Answer

Correct Option: D

Question 18

Which of the following action may cause a trigger to be fired?

technology databases

Drop
Alter
Delete
Rollback

Answer

Correct Option: C

Question 19

Which of the following DB2 data types does NOT have a fixed length?

technology databases

XML
INT
CHAR
Double

Answer

Correct Option: A

Question 20

To which of the following resources can a lock NOT be applied?

technology databases

Table Space
Bufferpools
Table
Rows

Answer

Correct Option: B

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

databases Online Quiz - 68

Find more quizzes from top tags