0

databases Online Quiz - 191

Description: databases Online Quiz - 191
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. Control Center

  2. SQL Assist

  3. Configuration Assistant

  4. Command Line Processor


Correct Option: B

Which type of key is defined on the child table to implement a referential constraint?

  1. Primary key

  2. Unique key

  3. Foreign key

  4. Composite key


Correct Option: A

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

  1. INT

  2. CHAR

  3. XML

  4. DOUBLE


Correct Option: C

Which of the following DB2 data types can be used to store 1000MB of single-byte character data?

  1. BLOB

  2. CLOB

  3. DBCLOB

  4. GRAPHIC


Correct Option: B
  1. Uncommitted Read

  2. Cursor Stability

  3. Read Stability

  4. Repeatable Read


Correct Option: D

Q1

  1. Enterprise reverse planning

  2. Enterprise revenue Planning

  3. Effective resource planning

  4. Enterprise resource planning


Correct Option: D

Q2

  1. It is a KeyFlex field used to store different segment values.

  2. It will store attribute values that will be used to track future requirements.

  3. knowledge Flex Field

  4. It is containing of one segment


Correct Option: A

Q6

  1. True

  2. False


Correct Option: B

Q4

  1. True

  2. False


Correct Option: B

Q8

  1. List of Values with validation.

  2. Storing varchar Data.

  3. Storing number Data.

  4. List of Value.


Correct Option: A

Q9

  1. Explicity fired.

  2. Not taking space in database.

  3. Only DML triggers are there.

  4. Trigger timing is mandatory.


Correct Option: D

Q10

  1. To insert in a view.

  2. To insert in a view which is created with more than one table.

  3. To insert into read only view.

  4. None.


Correct Option: B
  1. IN,OUT

  2. OUT,OUT

  3. IN ,IN

  4. OUT,IN


Correct Option: B
  1. Descriptive Flow Field.

  2. Descriptive Flex Field.

  3. Descriptive Flow File.

  4. Descriptive Flex File.


Correct Option: B
  1. Form->Function->User->Menu->Responsibility

  2. Form->Menu->Function->Responsibility->User

  3. Form->Function->Menu->Responsibilty->User

  4. Form->Function->User->Menu->Responsibilty


Correct Option: C
  1. It is a KeyFlex field used to store different segment values.

  2. It will store attribute values that will be used to track future requirements.

  3. knowledge Flex Field

  4. It is containing of one segment


Correct Option: A

Which two statements accurately describe a role? (Choose two.)

  1. A role can be given to a maximum of 1000 users

  2. A user can have access to a maximum of 10 roles

  3. A role can have a maximum of 100 privileges contained in it.

  4. Privileges are given to a role by using the CREATE ROLE statement

  5. A role is a named group of related privileges that can be granted to the user

  6. A user can have access to several roles, and several users can be assigned the same role


Correct Option: E,F
  1. The underlying tables must have data

  2. You need SELECT privileges on the view

  3. The underlying tables must be in the same schema

  4. You need SELECT privileges only on the underlying tables


Correct Option: B

Evaluate these two SQL statements: SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY salary DESC; SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY 2 DESC; What is true about them

  1. The two statements produce identical results.

  2. The second statement returns a syntax error

  3. There is no need to specify DESC because the results are sorted in descending order by default

  4. The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.


Correct Option: A
  1. SELECT TO_DATE(SYSDATE, 'FMDAY, DD Month, YYYY') FROM dual;

  2. SELECT TO_CHAR(SYSDATE, 'FMDD, DY Month, 'YYYY') FROM dual;

  3. SELECT TO_CHAR(SYSDATE, 'FMDay, DD Month, YYYY') FROM dual;

  4. SELECT TO_CHAR(SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;

  5. SELECT TO_DATE(SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;


Correct Option: C
- Hide questions