Question 1

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

technology databases

Update
Retrival
Both
None

Answer

Correct Option: B

Question 2

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

technology databases

43
53
63
73

Answer

Correct Option: C

Question 3

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

technology databases

Database Management System
Data Management System
Data Maintenance System
Database Manipulation System

Answer

Correct Option: C

Question 4

DMS is what kind of database system?

technology databases

Network
Hierarchical
Relational
None of These

Answer

Correct Option: A

Question 5

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

technology databases

Invoke
Impart
Get
Open

Answer

Correct Option: B

Question 6

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

technology databases

Depart
Impart
Close
Put

Answer

Correct Option: A

Question 7

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

technology databases

Retrival
Update
Both
None

Answer

Correct Option: A

Question 8

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

technology databases

OPEN AREANAME USAGE-MODE IS UPDATE
OPEN AREANAME USAGE MODE IS UPDATE
OPEN AREANAME USAGE-MODE IS MODIFY
OPEN AREANAME USAGE MODE IS MODIFY

Answer

Correct Option: A

Question 9

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

technology databases

25
35
47
57

Answer

Correct Option: C

Question 10

Fetch = ?

technology databases

get+find
find
find+get
none of the above

Answer

Correct Option: C

Question 11

What type of Database is IDMS?

technology databases

Relational
Hierarchial
Network
None of the above

Answer

Correct Option: C

Question 12

There is a chance for Currency loss while doing AREA Sweep

technology databases

True
False

Answer

Correct Option: A

Question 13

What does 1205 Error code represnts in IDMS?

technology databases

Error while disconnecting a record from its set
Error while storing duplicates
Error while connecting a record to a set
Error while erasing a record

Answer

Correct Option: B

Question 14

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

technology databases

ARK
CED
DEC
NULL

Answer

Correct Option: D

Question 15

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

technology databases

10
9
ERROR
1

Answer

Correct Option: A

Question 16

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

technology databases

09,SEP
1/1/2010,1/10/2009
1/1/2009,1/1/2009
2009,SEPTEMBER

Answer

Correct Option: B

Question 17

which of the following are true about natural join?

technology databases

No advantage
eliminates aliases
Natural join doesnot exist in oracle
eliminates join comparision

Answer

Correct Option: B,D

Question 18

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

technology databases

True
False

Answer

Correct Option: A

Question 19

select next_day('19-SEP-09','FRIDAY') from dual and select next_day('19-SEP-09',7) from dual would results in?(answers in mm/dd/yyyy formate)

technology databases

syntax error and 09/26/2009,
09/25/2009 and 09/25/2009
09/25/2009 and syntax error
09/25/2009,09/26/2009

Answer

Correct Option: D

Question 20

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

technology databases

COALESCE()
NVL()
NVL2()
CASE

Answer

Correct Option: A,B,C,D

Description: databases Online Quiz - 193
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 193

Find more quizzes from top tags