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

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

  1. Update

  2. Retrival

  3. Both

  4. None


Correct Option: B

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 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
  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

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
  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