Tag: databases

Questions Related to databases

Multiple WHAT can be share an SGA?
technology databases

  1. SERVER PROCESSES

  2. INSTANCES

  3. TABLESPACES

  4. DATABASES

Show answer
Correct Option: B

wHICH SCRIPT CREATE THE DATA DICTIONARY TABLES?
technology databases

  1. catalog.sql

  2. sql.bsq

  3. catproc.sql

  4. dictionary.sql

Show answer
Correct Option: B

which can not be possible?
technology databases

  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

Show answer
Correct Option: D

Which file can be multiplexed?
technology databases

  1. parameter file

  2. data files

  3. redo log files

  4. alert.log file

Show answer
Correct Option: C

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

  1. ITS A DUMMY RULE

  2. TO BALANCE THE EXTRACTION AND LOADING PROCESS

  3. EASY TO MAINTAIN

  4. TO RESOLVE THE PERFORMANCE ISSUES

Show answer
Correct Option: B,D

A UNIX VERSIONED OS SHOULD BE AVAILABLE INORDER TO INSTALL INFORMATICA
technology databases

  1. True

  2. False

Show answer
Correct Option: B

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

  1. Delete * from table T1

  2. Delete all from T1

  3. Delete * from T1

  4. Delete From T1

Show answer
Correct Option: D

An Alias can be alter name forhich DB2 object
technology databases

  1. Sequence

  2. Trigger

  3. Schema

  4. View

Show answer
Correct Option: D

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

  1. Drop

  2. Alter

  3. Delete

  4. Rollback

Show answer
Correct Option: C

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

technology databases

  1. XML

  2. INT

  3. CHAR

  4. Double

Show answer
Correct Option: A

AI Explanation

To answer this question, let's go through each option to understand why it is correct or incorrect:

Option A) XML - This option is correct. XML data type in DB2 does not have a fixed length. It is a variable-length data type that can store XML data of varying lengths.

Option B) INT - This option is incorrect. INT data type in DB2 does have a fixed length. It represents a signed integer and has a fixed length of 4 bytes.

Option C) CHAR - This option is incorrect. CHAR data type in DB2 does have a fixed length. It is used to store fixed-length character strings and requires you to specify the length of the string.

Option D) Double - This option is incorrect. Double data type in DB2 does have a fixed length. It represents a double-precision floating-point number and has a fixed length of 8 bytes.

The correct answer is A) XML. This option is correct because the XML data type in DB2 does not have a fixed length.