 Circle the correct option
 There are 50 Multiple Choice Questions. Each question has one correct answer. Circle your answers clearly on the MCQ.
 Each correct answer will earn you one mark. No penalty will be given for incorrect answers.
 Do not write any other thing only circle the correct MCQ answer.
SECTION ONE
1. The “g” in Oracle 10g or 11g stands for _________
a. Gird
b. Gateway
c. Guide
2. .RDF extension of _____________
a. Report developer
b. Form Developer
c. Graph developer
3. The process of converting complex data structures into simple, stable data structures is referred to as:
a. Normalization
b. De Normalization
c. process modeling
4. When Button Pressed is type of ______________
a. Trigger
b. Alert
c. Message
5. Which SQL statement is used to extract data from a database?
a. SELECT
b. GET
c. OPEN
d. EXTRACT
6. Which SQL statement is used to update data in a database?
a. SAVE
b. MODIFY
c. UPDATE
d. SAVE AS
7. Display item of form developer object is used for _______________
a. Input purpose
b. Selection Purpose
c. Only show value
8. Which SQL statement is used to delete data from a database?
a. DELETE
b. TRUNCATE
c. REMOVE
9. Which SQL statement is used to insert new data in a database?
a. ADD RECORD
b. ADD NEW
c. INSERT
d. INSERT NEW
10. ________ is heart of any software
a. Reports
b. Layout
c. Graph
11. With SQL, how do you select a column named "ename" from a table named "EMP"?
a. SELECT Emp.ename
b. EXTRACT ename FROM Emp
c. SELECT ename FROM ename
12. With SQL, how do you select all the columns from a table named "Student"?
a. SELECT [all] FROM Student
b. SELECT Student
c. SELECT * FROM Student
13. Executable file of oracle form developer is ______________
a. .sql
b. .fmb
c. .fmx
d. None of above
14. With SQL, how do you select all the records from a table named "Student" where the value of the column "FirstName" starts with an "a"?
a. SELECT * FROM Student WHERE FirstName LIKE '%a'
b. SELECT * FROM Student WHERE FirstName='a'
c. SELECT * FROM Student WHERE FirstName LIKE 'a%'
15. Lov stands for __________
a. List of values
b. Link of values
c. None of above
16. The process of combining two tables in a relational database is known as a --------------
a. Join
b. Combine
c. Relate
17. There are four major component of form developer.
a) True
b) False
18. DCL stands for ____________________
a. Data computer language
b. Data control language
c. Disk control language
19. The UNIQUE and FOREIGN keys cannot have NULL values (False)
a. Ture
b. False
20. Which SQL keyword is used to sort the result-set?
a. ORDER
b. SORT
c. SORT BY
d. ORDER BY
21. <=,>=,<> are example of _____________ of Operator
a. Arithmetic Operator
b. Relational Operator
c. Logical Operator
22. With SQL, how can you insert a new record into the "Student" table?
a. INSERT ('Saleem', 'Ali') INTO Student
b. INSERT VALUES ('Saleem', 'Ali') INTO Student
c. INSERT INTO Persons VALUES ('Saleem', 'Ali')
23. Oralce is ______________ types of language
a. RDBMS
b. DBMS
c. Oracle is not database
24. The person who is having central control over data and programs accessing that data__________
a. Developer
b. DBA
c. Programmer
25. A tuple is also known as a(n) ___________________________ .
a. Column
b. Row
c. Table
26. A table can have more than one primary key.
a. True
b. False
27. A foreign key must :
a. Be defined in all tables in the database.
b. Be numeric.
c. Match the field value of a primary key in a related table.
d. Be unique.
28. PL stands for ______________________
a) Procedure Language
b) Programming Language
c) None of these
29. Which SQL command would you use to define the primary key for a new table called 'Employee' with the primary column to be 'empid'?
a. ADD TABLE Employee ADD PRIMARY KEY (empid)
b. ATTACH TABLE Employee ADD PRIMARY KEY (empid)
c. ADD TABLE Employee ATTACH PRIMARY KEY (empid)
d. ALTER TABLE Employee ADD PRIMARY KEY (empid)
30. Which command is used to create new user?
a. Alter user
b. Create User
c. Identified by user
31. The name of a table can be changed with Alter command.
a. True
b. False
32. Only one------------------------Key can be created for an each table
a. Primary key
b. Foreign key
c. Unique
33. Three DDL commands:
a) CREATE, ALTER, DELETE
b) INSERT, UPDATE, DELETE
c) CREATE, UPDATE, DROP
d) CREATE, ALTER, DROP
34. A table once created can be dropped.
a. True
b. False
35. Which command displays the SQL command in the SQL buffer, and then executes it?
a) Get
b) Run
c) Save
36. What operator performs pattern matching?
a) LIKE operator
b) 2) Plus Operator
c) Greater Operator
37. Which command is used to store or save the query?
a) Save
b) Store
c) Get
38. What command is used to create a table?
a) Create Table
b) Create Database Table
c) Table Create
39. Loops and branching in PL/SQL include three variations. Which one is not legal?
a. Loop
b. Do Loop
c. For Loop
d. While Loop
40. The common SQL*Plus command which causes the results of PL/SQL statements to be displayed is
a. Set serveroutput on
b. Severouput enable
c. Set serveroutput off
41. Foreign key get the references from_____________
a. Unique Key
b. Not Null
c. Primary key
42. PL/SQL blocks contain __________________sections
a. One
b. Two
c. Three
43. _____________section is the first section of the PL/SQL block.
a. Declare
b. Begin
c. End;
44. The “i” in Oracle 8i stands for “improved”
a. False
b. True
45. PB is prefix of __________ object
a. Bush Button
b. Combo box
c. Display Item
46. There are _________ types of reports provide by report builder
a. Four
b. Six
c. None of above
47. Alert box show the ______________ on screen
a. Message
b. Error
c. None of above
48. Which Statement is used to show structure of specific table?
a) Describe Statement
b) Clear screen Statement
c) Select Statement
49. Contacting (||) Operator is used to combine ___________ value in a single value.
a) String
b) Numeric
c) Picture
50. Extension of Menu file is ____________
a. .MMB
b. FMX
c. RDF


SECTION TWO
Q2. Write a program in Pl/Sql print Numbers (1 to 10)
Note: By Using any loop statement.
Q3. Create a table Name ”Student” with column (Roll,Sname,Course,Address)
Note: Add Primary key in Roll, Not null in course)
Q4. Insert record into Student.
Q5. Add new column (Contact) in Student.
Q6. Delete all records from Student table.
Q7. What does following terms stands for:
1. DDL __________________________________________________ _______________________
2. DML_______________________________________________ ___________________________
3. DBMS______________________________________________ ____________________________
4. DCL_______________________________________________ _______________________________
5. RDBMS_____________________________________________ _______________________________
6. Trunc_____________________________________________ ________________________________
7. SQL __________________________________________________ ____________________________
8. ANSI______________________________________________ ________________________________
9. DBA_______________________________________________ ________________________________
10. BBSYDP____________________________________________ ________________________________
Q8. Write the following Quires :
a) Display the names and hiredate of all employees.
b) Write sql query to show those employees that have a name starting with J, K, L, or M.
c) List the employee details whose salary is greater than 2000
d) Show the structure of Department table. And Show all Records.
e) Create a query to display employee name and salary of all employees who earns more than 4000.
f) Select initcap(‘BENAZIR BHUTTO SHAHEED YOUTH DEVELOPMENT PROGRAM”) from dual
g) Show the unique job from employee table.
h) Display all records of employees where the third char of the name is an o.


HAVE A NICE DAY……..