THE quitz

1. DBMS –

a. Direct base management system

b. Database management system

c. Dualbase management system

d. Databoth management system

2. Database means –

a. A collection of interrelated data

b. A collection of unterrelated data

c. A collection of updated data

d. A collection of any types of data

3. RDBMS –

a. Relational direct base management system

b. Relational database management system

c. Related dual base management system

d. Related database management system

4. SQL –

a. Structured query language

b. Stack query language

c. Structure query language

d. Structurebased query language

5. DCL –

a. Data control language

b. Database control language

c. Direct control language

d. Defined control language

6. An example of DCL –

a. Alter

b. Update

c. Grant

d. Insert

7. An example of DDL –

a. Alter

b. Update

c. Grant

d. Insert

8. An example of DML –

a. Alter

b. Update

c. Grant

d. Insert

9. An example of DML –

a. Alter

b. Update

c. Grant

d. Insert

10. An example of DML –

a. Alter

b. Update

c. Grant

d. Insert

11. Create table is an example of –

a. DDL

b. DML

c. DCL

d. DMA

12. Create View is an example of –

a. DDL

b. DML

c. DCL

d. DMA

13. Create user is an example of –

a. DDL

b. DML

c. DCL

d. DMA

14. Grant privilege is an example of –

a. DDl

b. DML

c. DCL

d. DMA

15. Select is an example of –

a. DDL

b. DML

c. DCL

d. DMA

16. Which of the following query will be execute properly:

a. create table class (roll number, name varchar (30));

b. creat table class (roll number, name varchar (30));

c. create class table (roll number, name varchar (30));

d. create table class (roll, name varchar(30));

17. Which of the following query will be execute properly on the table class(roll, name):

a. inset values into class (23, arif);

b. insets into class values (23, arif);

c. inset into class values (23, arif);

d. insert into class values (23, arif);

18. To show all rows and all columns of any table the query will be –

a. select * from table tablename;

b. select * from tablename;

c. select * from table tablename

d. dese tablename;

19. To show the structure of a table the query will be –

a. select * from table tablename;

b. select * from tablename;

c. Dese tablename

d. Describe tablename;

20. What will be the data type of data “c2307” –

a. Data

b. Varchar

c. Number

d. Raw

21. A SQL statements always start with:

a. adverb

b. verd

c. noun

d. adjective

22. A ___ used to seperates parameters within a clause of a SQL statement:

a. comma

b. semicolon

c. space

d. ()

23. A ___ used to terminates a SQL statement –

a. comma

b. semicolon

c. space

d. ()

24. Alter table instruction can do the following function:

a. change the name of a table

b. increase the coloumn size

c. change the coloumn name

d. decrease the coloumn size

25. ____ oldtablename to newtablename:

a. Name

b. Rename

c. Update

d. Alter

26. Using Commit statement, the change of current transaction is make permanent on database:

a. false

b. true

c. not mentioned

d. none

27. Using Rollback statement, the change during transaction is undo on database

a. false

b. true

c. not mentioned

d. none

28. A primary key must be:

a. unique & null

b. unique & not null

c. unique

d. not null

29. A multicoloumn primary key is called:

a. primary key

b. composite pimary key

c. super key

d. candidate key

30. PL /SQL:

a. Procedural language / structured query language

b. Prduced language / structured query language

c. Proccessed language / structured query language

d. Procedure language / structured query language

31. ___ is used for error trapping in PL / SQL blocks:

a. exception section

b. declare section

c. begin section

d. both b & c

32. Record cannot be ___ into detail table if corresponding records in the master table do not exist:

a. inserted

b. deleted

c. selected

d. none

33. Record cannot be ___ from the master table if corresponding records in the detail table exist:

a. inserted

b. deleted

c. selected

d. none

34. Foreign key represents ___ between table:

a. relationship

b. uniqueness

c. duality

d. none

35. What is the sequence of PL / SQL block declaration:

a. Declare, Begin, Execution, End

b. Begin, Declare, Execution, End

c. Declare, Begin, End, Execution

d. None

36. select name from student wherename like ‘ja%’;

a. sajal

b. jamal

c. suja

d. none

37. DUAL is a small –

a. oracle worktable

b. developer worktable

c. access worktable

d. VB worktable

38. Attributes presents in:

a. coloumns

b. rows

c. none

d. both

39. the following is a back end tool:

a. developer

b. visual basic

c. MS Access

d. MS Excel

40. Blocks are logical containers that have no physical representation.

a. true

b. false

c. not mentioned

d. both

41. A single block can be connected to multiple database objects like a table, view or synonym.

a. true

b. false

c. not mentioned

d. both

42. when a frame is associated with a block, the items in the block are automatically arranged within the frame.

a. true

b. false

c. not mentioned

d. both

43. scroll bar for a block can be attached to a block only at the time of block creation.

a. true

b. false

c. not mentioned

d. both

44. a window is connected to a block

a. true

b. false

c. not mentioned

d. both

45. Every forms contains at least one block, one window, one canvas and one or more items.

a. true

b. false

c. not mentioned

d. both

46. GUI stands for –

a. Graphical User Interface

b. Graphices Users Interface

c. Graph User Interface

d. Graphically Used Interface

47. The ___ item can be used only to show information that must be feathed or assigned programmatically.

a. display

b. text

c. button

d. none

48. forms builder provides the user with the ___ editor to write appropriate cade blocks.

a. SQL

b. PL / SQL

c. PL

d. None

49. The ___ at the bottom of the screen displays oracle messages to the user

a. status bar

b. scroll bar

c. tool bar

d. menu bar

50. If an item is connected to the base table column, the name of the item and the name of the base table column must be:

a. same

b. can be different

c. double

d. none

51. New_Record procedure creates a new record at runtime.

a. true

b. false

c. not mentioned

d. both

52. Execute_query retrieves row from the table and displays first record on the form.

a. true

b. false

c. not mentioned

d. both

53. Developer / VB is the tool of

a. back end

b. front end

c. middle

d. none

54. When_button_pressed is the trigger name of:

a. display item

b. text item

c. push button