Tag: databases

Questions Related to databases

What is IDMS?
technology databases

  1. Intergrated Data Management System

  2. India Department of Management Studies

  3. International Data Management System

  4. Integrated Data Management Services

Show answer
Correct Option: A

READY command is for _______
technology databases

  1. VOLUME

  2. AREA

  3. RECORD

  4. PAGE

Show answer
Correct Option: B

BIND is for ________
technology databases

  1. AREA

  2. VOLUME

  3. PAGE

  4. RECORD

Show answer
Correct Option: D

READY follows BIND (TRUE/FALSE)

technology databases

  1. True

  2. False

Show answer
Correct Option: A

Which of the following DB2 command can be used to change bob’s password?

technology databases

  1. CHANGE PASSWORD USER bob OLD bobpass NEW newpass

  2. CONNECT TO sample USER bob USING bobpass NEW newpass

  3. CONNECT TO sample USER bob USING bobpass NEW newpass CONFIRM newpass

  4. No DB2 command can be used to change the password of a user ID

Show answer
Correct Option: C

Which of the following privilege is required to create a new package in a database?
technology databases

  1. CONTROL

  2. BIND

  3. EXECUTE

  4. BINDADD

Show answer
Correct Option: D

Which of the following system catalog view contains the grantee information of the REFERENCE privilege on a view?
technology databases

  1. SYSCAT.VIEWS

  2. SYSCAT.TABLES

  3. SYSCAT.TABAUTH

  4. SYSCAT.REFERENCES

Show answer
Correct Option: C

Which of the following statement is true?
technology databases

  1. a table is an ordered set of data records

  2. an index always accesses data in ascending order

  3. a view stores the data on a different tablespace

  4. an index can be used to enforce uniqueness in a table

Show answer
Correct Option: D

CREATE DATABASE command creates some default table spaces. What are they? Choose all that apply.
technology databases

  1. SYSLOGSPACE

  2. TEMPSPACE1

  3. USERSPACE1

  4. SYSCATSPACE

Show answer
Correct Option: B,C,D

What keyword is used to define the number of pages that the database will write to one container before skipping to the next container?
technology databases

  1. SKIPSIZE

  2. PREFETCHSIZE

  3. STRIPSIZE

  4. EXTENTSIZE

Show answer
Correct Option: D