Oracle Mcqs Set-1

  1. The “g” in Oracle 10g or 11g stands for _________
  • Gird
  • Gateway
  • Guide

2.The person who is having central control over data and programs accessing that data__________

  • Developer
  • DBA
  • Programmer

3.All but which of the following are physical objects:

  • Buttons
  • Canvases
  • Items
  • Blocks

4.The “i” in Oracle 8i stands for “improved”

  • False
  • True

5.How is an alert displayed to the user?

  • As a multi-line message on the canvas
  • As a single line of text on the hint line
  • As a separate modal window in the middle of the screen
  • As another forms module

6. RDF extension of _____________

  • Report developer
  • Form Developer
  • Graph developer

7. The process of converting complex data structures into simple, stable data structures is referred to as:

  • Normalization
  • De Normalization
  • process modeling

8. When Button Pressed is type of ______________

  • Trigger
  • Alert
  • Message 

9. Which SQL statement is used to update data in a database? 

  • A. SAVE
  • B. MODIFY
  • C. UPDATE

10. Which SQL statement is used to delete data from a database? 

  • DELETE 
  • TRUNCATE
  • REMOVE

11. Executable file of oracle form developer is ______________

  • .sql
  • .fmb
  • .fmx
  • None of above

12. Executable file of oracle form developer is ______________

  • .sql
  • .fmb
  • .fmx
  • None of above

13. ________ is heart of any software

  • Reports
  • Layout
  • Graph

14. Display item of form developer object is used for _______________

  • Input purpose
  • Selection Purpose
  • Only show value

15. With SQL, how do you select all the columns from a table named “Student”?

  • SELECT [all] FROM Student
  • SELECT Student
  • SELECT * FROM Student

 

16. Which SQL keyword is used to sort the result-set?

  • ORDER
  • SORT
  • SORT BY
  • ORDER BY

17 Oralce is ______________ types of language

  • RDBMS
  • DBMS
  • Oracle is not database

18. A tuple is also known as a(n) ___________________________ .

  • Column
  • Row
  • Table

19. PL stands for ______________________

  • Procedure Language
  • Programming Language
  • None of these

20. Which command is used to create new user?

  • Alter user
  • Create User
  • Identified by user

21. The name of a table can be changed with Alter command.

  • True
  • False

22. Which of the following is not a type of item?

  • Check boxes
  • Text items
  • Java Beans
  • Frames
  • Buttons

23. What operator performs pattern matching?

  • LIKE operator
  • 2) Plus Operator
  • Greater Operator

24. Which command is used to store or save the query?

  • Save
  • Store
  • Get

25. The common SQL*Plus command which causes the results of PL/SQL statements to be displayed is

  • Set serveroutput on
  • Severouput enable
  • Set serveroutput off

26. Which command displays the SQL command in the SQL buffer, and then executes it?

  • Get
  • Run
  • Save

27. PL/SQL blocks contain __________________sections

  • One
  • Two
  • Three

28. _____________section is the first section of the PL/SQL block.

  • Declare
  • Begin
  • End;

29. PB is prefix of __________ object

  • Push Button
  • Combo box
  • Display Item

30. Alert box show the ______________ on screen

  • Message
  • Error
  • None of above

31. Which Statement is used to show structure of specific table?

  • Describe Statement
  • Clear screen Statement
  • Select Statement

32. Contacting (||) Operator is used to combine ___________ value in a single value.

  • String
  • Numeric
  • Picture

33. Extension of Menu file is ____________

  • .MMB
  • FMX
  • RDF

34. Which SQL statement is used to extract data from a database? 

  • SELECT 
  • GEt
  • OPEN
  • EXTRACT

Leave a Reply

Your email address will not be published. Required fields are marked *