Tag: databases

Questions Related to databases

In which case would you use a FULL OUTER JOIN?
technology databases

  1. Both tables have NULL values

  2. You want all unmatched data from one table

  3. You want all matched data from both tables

  4. You want all unmatched data from both tables

  5. One of the tables has more data than the other

  6. You want all matched and unmatched data from only one table

Show answer
Correct Option: D

Which type of record is the fastest to access?
technology databases

  1. Index Sequential

  2. Via Set

  3. Calc

  4. Direct

Show answer
Correct Option: D

In which of the following modes can we open an index area?
technology databases

  1. Update

  2. Retrival

  3. Both

  4. None

Show answer
Correct Option: B

What is the maximum number of record types a set type can have?
technology databases

  1. 43

  2. 53

  3. 63

  4. 73

Show answer
Correct Option: C

What is the full form of DMS? - correct answer is Data Management System - cannot chnage options now.

technology databases

  1. Database Management System

  2. Data Management System

  3. Data Maintenance System

  4. Database Manipulation System

Show answer
Correct Option: C

DMS is what kind of database system?
technology databases

  1. Network

  2. Hierarchical

  3. Relational

  4. None of These

Show answer
Correct Option: A

Which command is used to connect to the DMS database in a COBOL program?
technology databases

  1. Invoke

  2. Impart

  3. Get

  4. Open

Show answer
Correct Option: B

Which command is used to dis-connect from the DMS database in a COBOL program?

technology databases

  1. Depart

  2. Impart

  3. Close

  4. Put

Show answer
Correct Option: A

When we give the command "OPEN AREANAME" in which mode the area is opened?
technology databases

  1. Retrival

  2. Update

  3. Both

  4. None

Show answer
Correct Option: A

What is the syntax to open an area in upadte mode?
technology databases

  1. OPEN AREANAME USAGE-MODE IS UPDATE

  2. OPEN AREANAME USAGE MODE IS UPDATE

  3. OPEN AREANAME USAGE-MODE IS MODIFY

  4. OPEN AREANAME USAGE MODE IS MODIFY

Show answer
Correct Option: A