0

databases Online Quiz - 193

Description: databases Online Quiz - 193
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

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

  1. 43

  2. 53

  3. 63

  4. 73


Correct Option: C

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

  1. Database Management System

  2. Data Management System

  3. Data Maintenance System

  4. Database Manipulation System


Correct Option: C

DMS is what kind of database system?

  1. Network

  2. Hierarchical

  3. Relational

  4. None of These


Correct Option: A

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

  1. Invoke

  2. Impart

  3. Get

  4. Open


Correct Option: B

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

  1. Depart

  2. Impart

  3. Close

  4. Put


Correct Option: A

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

  1. Retrival

  2. Update

  3. Both

  4. None


Correct Option: A

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

  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


Correct Option: A

What is the maximum number of areas you can open with a single OPEN statement?

  1. 25

  2. 35

  3. 47

  4. 57


Correct Option: C

Fetch = ?

  1. get+find

  2. find

  3. find+get

  4. none of the above


Correct Option: C

What type of Database is IDMS?

  1. Relational

  2. Hierarchial

  3. Network

  4. None of the above


Correct Option: C

There is a chance for Currency loss while doing AREA Sweep

  1. True

  2. False


Correct Option: A

What does 1205 Error code represnts in IDMS?

  1. Error while disconnecting a record from its set

  2. Error while storing duplicates

  3. Error while connecting a record to a set

  4. Error while erasing a record


Correct Option: B

AI Explanation

To answer this question, you need to understand the IDMS (Integrated Database Management System) error codes.

The 1205 error code in IDMS represents an error while storing duplicates.

Let's go through each option to understand why it is correct or incorrect:

Option A) Error while disconnecting a record from its set - This option is incorrect. The error code 1205 does not represent an error related to disconnecting a record from its set.

Option B) Error while storing duplicates - This option is correct. The error code 1205 in IDMS indicates an error while storing duplicates. This means that there was an attempt to store a duplicate record in the database, which is not allowed.

Option C) Error while connecting a record to a set - This option is incorrect. The error code 1205 does not represent an error related to connecting a record to a set.

Option D) Error while erasing a record - This option is incorrect. The error code 1205 does not represent an error related to erasing a record.

The correct answer is B) Error while storing duplicates. This option is correct because the error code 1205 in IDMS indicates an error while storing duplicates.

select substr('DECCANPARK',3,-1) FROM DUAL would results in?

  1. ARK

  2. CED

  3. DEC

  4. NULL


Correct Option: D

select trunc(10,-1) from dual would results in?

  1. 10

  2. 9

  3. ERROR

  4. 1


Correct Option: A

let sysdate='19-SEP-2009' select round(sysdate,'YEAR'),round(sysdate,'MONTH') from dual would results in?

  1. 09,SEP

  2. 1/1/2010,1/10/2009

  3. 1/1/2009,1/1/2009

  4. 2009,SEPTEMBER


Correct Option: B

which of the following are true about natural join?

  1. No advantage

  2. eliminates aliases

  3. Natural join doesnot exist in oracle

  4. eliminates join comparision


Correct Option: B,D

State true or false All the columns in the column clause of select statment that are not in a group function must be listed in the group by clause.However,a column listed in group by clause needn't appear in column clause

  1. True

  2. False


Correct Option: A
  1. syntax error and 09/26/2009,

  2. 09/25/2009 and 09/25/2009

  3. 09/25/2009 and syntax error

  4. 09/25/2009,09/26/2009


Correct Option: D

which of the following comes under General Functions category in Single Row Functions

  1. COALESCE()

  2. NVL()

  3. NVL2()

  4. CASE


Correct Option: A,B,C,D
- Hide questions