0

databases Online Quiz - 68

Description: databases Online Quiz - 68
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. To find the groups forming the subtotal in a row

  2. To create group-wise totals for the groups specified within a GROUPBY clause

  3. To create grouping for expressions or columns specified within a GROUPBY clause in one direction,from right to left for calculating the subtotals.

  4. 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


Correct Option: C
  1. used to set the order for the groups to be used for calculating the grand totals and subtotals

  2. used to form various groups to caculate totals and subtotals created using ROLLUP and CUBE operators

  3. used to specify if the NULLL value in an expresion is a stored NULL value or created by ROLLUP and CUBE

  4. used to specify the concatenated groups expressions to be used for calculating the grand totals and subtotals


Correct Option: C

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?

  1. both the DELETE statements would be rolledback

  2. No SQL statements would be rolledback

  3. only the second DELETE statements would be rolledback

  4. both the DELETE statements and the update statements would be rolledback


Correct Option: B
  1. used to find the groups forming the subtotal in a row

  2. used to identify the NULL value in the aggregate function.

  3. use to form the group sets involved in generating the totals and subtotals

  4. only be used with ROLLUP and CUBE operators specified in the GROUP BY clause


Correct Option: A,D

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 ?

  1. 4,2,1,3

  2. 4,1,2,3

  3. 2,4,1,3

  4. 2,1,4,3


Correct Option: C

How to prevent ROW MIGRATION?

  1. specify large pct free

  2. specify large pct used

  3. specify large initial & next sizes

  4. specify small initrans


Correct Option: A
  1. SERVER PROCESSES

  2. INSTANCES

  3. TABLESPACES

  4. DATABASES


Correct Option: B

wHICH SCRIPT CREATE THE DATA DICTIONARY TABLES?

  1. catalog.sql

  2. sql.bsq

  3. catproc.sql

  4. dictionary.sql


Correct Option: B

which can not be possible?

  1. move index to a new tablespace

  2. change the initial extent size of the index

  3. collect statistics on the index

  4. specify a new name for the index


Correct Option: D
  1. parameter file

  2. data files

  3. redo log files

  4. alert.log file


Correct Option: C

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

  1. ITS A DUMMY RULE

  2. TO BALANCE THE EXTRACTION AND LOADING PROCESS

  3. EASY TO MAINTAIN

  4. TO RESOLVE THE PERFORMANCE ISSUES


Correct Option: B,D

A UNIX VERSIONED OS SHOULD BE AVAILABLE INORDER TO INSTALL INFORMATICA

  1. True

  2. False


Correct Option: B
  1. Delete * from table T1

  2. Delete all from T1

  3. Delete * from T1

  4. Delete From T1


Correct Option: D

An Alias can be alter name forhich DB2 object

  1. Sequence

  2. Trigger

  3. Schema

  4. View


Correct Option: D

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

  1. Drop

  2. Alter

  3. Delete

  4. Rollback


Correct Option: C

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

  1. XML

  2. INT

  3. CHAR

  4. Double


Correct Option: A

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

  1. Table Space

  2. Bufferpools

  3. Table

  4. Rows


Correct Option: B
- Hide questions