Technical Papers Database Questions: Oracle DBA Questions

Get top class preparation for competitive exams right from your home: get questions, notes, tests, video lectures and more- for all subjects of your exam.

SNAPSHOT is used for [DBA]

We can create SNAPSHOTLOG for [DBA]

Transactions per rollback segment is derived from [DBA]

ENQUEUE resources parameter information is derived from [DBA]

LGWR process writes information into

SET TRANSACTION USE ROLLBACK SEGMENT is used to create user objects in a particular Tablespace

Databases overall structure is maintained in a file called

These following parameters are optional in init. Ora parameter file DB_BLOCK_SIZE, PROCESSES

Constraints cannot be exported through EXPORT command

It is very difficult to grant and manage common privileges needed by different groups of database users using the roles

What is difference between a DIALOG WINDOW and a DOCUMENT WINDOW regarding moving the window with respect to the application window

What is the difference between a MESSAGEBOX and an ALERT

A messagebox can be used only by the system and cannot be used in user application while an alert can be used in user application also.

A alert can be used only by the system and cannot be use din user application while an messagebox can be used in user application also.

An alert requires an response from the userwhile a messagebox just flashes a message

and only requires an acknowledment from the user

An message box requires an response from the userwhile a alert just flashes a message an only

requires an acknowledment from the user

Which of the following is not an reason for the fact that most of the processing is done at the server?

Can a DIALOG WINDOW have scroll bar attached to it?

Which of the following is not an advantage of GUI systems?

What is the difference between a LIST BOX and a COMBO BOX?

In a CLIENT/SERVER environment, which of the following would not be done at the client?

a User interface part, b Data validation at entry line, c Responding to user events.

d None of the above

Why is it better to use an INTEGRITY CONSTRAINT to validate data in a table than to use a STORED

PROCEDURE?

Which of the following is not an advantage of a client/server model?

What does DLL stands for?

POST-BLOCK trigger is a

The system variable that records the select statement that SQL ⚹ FORMS most recently used

to populate a block is

Which of the following is TRUE for the ENFORCE KEY field

Choice a: ENFORCE KEY field characterstic indicates the source of the value that SQL ⚹ FORMS uses to populate the field

Choice b: A field with the ENFORCE KEY characterstic should have the INPUT ALLOWED charaterstic turned off

What is the maximum size of the page?

A FORM is madeup of which of the following objects

For the following statements which is true

1 Page is an object owned by a form

2 Pages are a collection of display information such as constant text and graphics.

The packaged procedure that makes data in form permanent in the Database is

Which of the following is TRUE for the SYSTEM VARIABLE $ $ date $ $

Which of the following packaged procedure is UNRESTRICTED?

Identify the RESTRICTED packaged procedure from the following

What is SQL ⚹ FORMS

Name the two files that are created when you generate a form using Forms 3.0

What is a trigger

Which of the folowing is TRUE for a ERASE packaged procedure

All datafiles related to a Tablespace are removed when the Tablespace is dropped

Size of Tablespace can be increased by

Multiple Tablespaces can share a single datafile

A set of Dictionary tables are created

Datadictionary can span across multiple Tablespaces

What is a DATABLOCK

Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint

A column defined as PRIMARY KEY can have NULL՚s

A Transaction ends

A Database Procedure is stored in the Database

A database trigger doesnot apply to data loaded before the definition of the trigger

Dedicated server configuration is

Which of the following does not affect the size of the SGA

What does a COMMIT statement do to a CURSOR

Which of the following is TRUE

1 Host variables are declared anywhere in the program

2 Host variables are declared in the DECLARE section

Which of the following is NOT VALID is PL/SQL

Declare

fvar number:= null; svar number:= 5

Begin

goto ≪ fproc ≫

if fvar is null then

≪ fproc ≫

svar:= svar + 5

end if.

End.

What will be the value of svar after the execution?

Which of the following is not correct about an Exception?

Which of the following is not correct about User_Defined Exceptions?

A Stored Procedure is a

Which of the following statement is false

Is it possible to open a cursor which is in a Package in another procedure?

Is it possible to use Transactional control statements in Database Triggers?

Is it possible to Enable or Disable a Database trigger?

PL/SQL supports datatype (s)

Find the ODD datatype out

Which of the following is not correct about the “TABLE” datatype?

Find the ODD one out of the following

Which of the following is not correct about Cursor?

Which of the following is NOT VALID in PL/SQL?

What is the Result of the following ‘VIK’ NULL ‘RAM’

Declare

a number:= 5; b number:= null; c number:= 10.

Begin

if a > b AND a < c then

a:= c ⚹ a.

end if.

End.

What will be the value of ‘a’ after execution?

Does the Database trigger will fire when the table is TRUNCATED?

SUBSTR (SQUARE ANS ALWAYS WORK HARD, 14,6) will return

REPLACE ( ‘JACK AND JUE’ ‘J’ ‘BL’ ) will return

TRANSLATE ( ‘333SQD234’ ‘0123456789ABCDPQRST’ ‘9’ ) will return

EMPNO ENAME SAL

A822 RAMASWAMY 3500

A812 NARAYAN 5000

A973 UMESH 2850

A500 BALAJI 5750

Use these data for the following Questions

Select SAL from EMP E1 where 3 > (Select count (⚹) from Emp E2 where E1. SAL > E2. SAL) will retrieve

Is it possible to modify a Datatype of a column when column contains data?

Which of the following is not correct about a View?

Which is not part of the Data Definiton Language?

The Data Manipulation Language statements are

EMPNO ENAME SAL

A822 RAMASWAMY 3500

A812 NARAYAN 5000

A973 UMESH

A500 BALAJI 5750

Using the above data

Select count (sal) from Emp will retrieve

If an UNIQUE KEY constraint on DATE column is created, will it accept the rows that are inserted with

SYSDATE?

What are the different events in Triggers?

Can we pass RECORD GROUP between FORMS?

SHOW_ALERT function returns

What SYSTEM VARIABLE is used to refer DATABASE TIME?

SYSTEM. EFFECTIVE. DATE varaible is

How can you CALL Reports from Forms4.0?

When do you get a. PLL extension?

What is built_in Subprogram?

GET_BLOCK property is a

A CONTROL BLOCK can sometimes refer to a BASETABLE?

What do you mean by CHECK BOX?

List of Values (LOV) supports

Choice a: Single column

Choice b: Multi column

Choice c: Single or Multi column

Choice d: None of the above

Answer: c

What is Library in Forms 4.0?

Choice a: Collection of External field

Choice b: Collection of built_in packages

Choice c: Collection of PL/SQl functions, procedures and packages

Choice d: Collection of PL/SQL procedures & triggers

Answer: c

Can we use a RESTRICTED packaged procedure in WHEN_TEXT_ITEM trigger?

Choice a: Yes

Choice b: No

Answer: b

Can we use GO_BLOCK package in a PRE_TEXT_ITEM trigger?

Choice a: Yes

Choice b: No

Answer: b

What type of file is used for porting Forms 4.5 applications to various platforms?

Choice a: FMB file

Choice b: FMX file

Choice c: FMT file

Choice d: EXE file

Answer: c

What built_in procedure is used to get IMAGES in Forms 4.5?

Choice a: READ_IMAGE_FILE

Choice b: GET_IMAGE_FILE

Choice c: READ_FILE

Choice d: GET_FILE

Ans A

When a form is invoked with CALL_FORM does Oracle forms issues SAVEPOINT?

Choice a: Yes

Choice b: No

Answer: a

Can we attach the same LOV to different fields in Design time?

Choice a: Yes

Choice b: No

Answer: a

How do you pass values from one form to another form?

Choice a: LOV

Choice b: Parameters

Choice c: Local variables

Choice d: None of the above

Answer: b

Can you copy the PROGRAM UNIT into an Object group?

Can MULTIPLE DOCUMENT INTERFACE (MDI) be used in Forms 4.5?

Choice a: Yes

Choice b: No

Answer: a

When is a. FMB file extension is created in Forms 4.5?

Choice a: Generating form

Choice b: Executing form

Choice c: Save form

Choice d: Run form

Answer: c

What is a Built_in subprogram?

Choice a: Library

Choice b: Stored procedure & Function

Choice c: Collection of Subprograms

Choice d: None of the above

Answer: d

What is a RADIO GROUP?

a Mutually exclusive

b Select more than one column

c Above all TRUE

d Above all FALSE

Answer: a

Identify the Odd one of the following statements?

Choice a: Poplist

Choice b: Tlist

Choice c: List of values

Choice d: Combo box

Answer: c

What is an ALERT?

Choice a: Modeless window

Choice b: Modal window

Choice c: Both are TRUE

Choice d: None of the above

Answer: b

Can an Alert message be changed at runtime?

Choice a: Yes

Choice b: No

Answer: a

Can we create an LOV without an RECORD GROUP?

Choice a: Yes

Choice b: No

Answer: b

How many no of columns can a RECORD GROUP have?

Choice a: 10

Choice b: 20

Choice c: 50

Choice d: None of the above

Answer: d

Oracle precompiler translates the EMBEDDED SQL statemens into

Choice a: Oracle FORMS

Choice b: Oracle REPORTS

Choice c: Oracle LIBRARY

Choice d: None of the above

Answer: d

Kind of COMMENT statements placed within SQL statements?

Choice a: Asterisk (⚹) in column?

Choice b: ANSI SQL style statements (…)

Choice c: C-Style comments (/ ⚹ ________ ⚹ /)

Choice d: All the above

Answer: d

What is TERM?

Choice a: TERM is the terminal definition file that describes the terminal from which you are using R20RUN (Reports run time)

Choice b: TERM is the terminal definition file that describes the terminal from which you are using R20DES (Reports designer)

Choice c: There is no Parameter called TERM in Reports 2.0

Choice d: None of the above

Answer: a

If the maximum records retrieved property of a query is set to 10, then a summary value will

be calculated

Choice a: Only for 10 records

Choice b: For all the records retrieved

Choice c: For all therecords in the referenced table

Choice d: None of the above

Answer: a

With which function of a summary item in the COMPUTE AT optio required?

Choice a: Sum

Choice b: Standard deviation

Choice c: Variance

Choice d:% of Total function

Answer: d

For a field in a repeating frame, can the source come from a column which does not exist in

the datagroup which forms the base of the frame?

Choice a: Yes

Choice b: No

Answer: a

What are the different file extensions that are created by Oracle Reports?

Choice a: RDF file & RPX file

Choice b: RDX file & RDF file

Choice c: REP file & RDF file

Choice d: None of the above

Answer: c

Is it possible to Disable the Parameter form while running the report?

Choice a: Yes

Choice b: No

Answer: a

What are the SQL clauses supported in the link property sheet?

Choice a: WHERE & START WITH

Choice b: WHERE & HAVING

Choice c: START WITH & HAVING

Choice d: WHERE, START WITH & HAVING

Answer: d

What are the types of Calculated columns available?

Choice a: Summary, Place holder & Procedure column

Choice b: Summary, Procedure & Formula columns

Choice c: Procedure, Formula & Place holder columns

Choice d: Summary, Formula & Place holder columns

Answer: d

If two groups are not linked in the data model editor, what is the hierarchy between them?

Choice a: There is no hierarchy between unlinked groups

Choice b: The group that is right ranks higher than the group that is to theleft

Choice c: The group that is above or leftmost ranks higher than the group that is to right or below it

Choice d: None of the above

Answer: c

Sequence of events takes place while starting a Database is

Choice a: Database opened, File mounted, Instance started

Choice b: Instance started, Database mounted & Database opened

Choice c: Database opened, Instance started & file mounted

Choice d: Files mounted, Instance started & Database opened

Answer: b

SYSTEM TABLESPACE can be made off-line

Choice a: Yes

Choice b: No

Answer: b

ENQUEUE_RESOURCES parameter information is derived from

Choice a: PROCESS or DDL_LOCKS & DML_LOCKS

Choice b: LOG BUFFER

Choice c: DB_BLOCK_SIZE

Choice d: DB_BLOCK_BUFFERS

Answer: a

SMON process is used to write into LOG files

Choice a: TRUE

Choice b: FALSE

Answer: b

EXP command is used

Choice a: To take Backup of the Oracle Database

Choice b: To import data from the exported dump file

Choice c: To create Rollback segments

Choice d: None of the above

Answer: a

SNAPSHOTS cannot be refreshed automatically

Choice a: TRUE

Choice b: FALSE

Answer: b

The User can set Archive file name formats

Choice a: TRUE

Choice b: FALSE

Answer: a

The following parameters are optional in init. Ora parameter file DB_BLOCK_SIZE, PROCESS

Choice a: TRUE

Choice b: FALSE

Answer: b

NOARCHIEVELOG parameter is used to enable the database in Archieve mode

Choice a: TRUE

Choice b: FALSE

Answer: b

Constraints cannot be exported through Export command?

Choice a: TRUE

Choice b: FALSE

Answer: b

It is very difficult to grant and manage common priveleges needed by

different groups of database users using roles

Choice a: TRUE

Choice b: FALSE

Answer: b

The status of the Rollback segment can be viewed through

Choice a: DBA_SEGMENTS

Choice b: DBA_ROLES

Choice c: DBA_FREE_SPACES

Choice d: DBA_ROLLBACK_SEG

Answer: d

Explicitly we can assign transaction to a rollback segment

Choice a: TRUE

Choice b: FALSE

Answer: a

What file is read by ODBC to load drivers?

Choice a: ODBC. INI

Choice b: ODBC. DLL

Choice c: ODBCDRV. INI

Choice d: None of the above

Answer: a