UNIT – I
1) RDBMS Stands for ______
a) Relational Data Base Management System b) Relational Data Base Managing System
c) Relational Data Base Manager System d) None
2) Attribute means _______
a) Columns b) Rows c) Table d) None
3) Relation means _____________
a) Columns b) Rows c) Table d) None
4) Tupple means ________
a) Columns b) Rows c) Table d) None
5) ANSI stands for _______
a) American National Standards Institute b) American National Standards Information
c) American National Structured Institute. d) None
6) SQL Stands for ____________
a) Structured Query Language b) Structured Quality Language
c) Structured Quantity Language d) None
7) Oracle is a ________
a) Language b) Package c) Group of tools d) None
8) Alerts are ___________
a) Procedure b) Functions c) Critical error Messages d) None
9) DBA Stands for ________
a) Data Base Access b) Data Base Administrator c) Data Base Alternator d) none
10) Server is referred as __________
a) Back end b) Front end c) Table d) None
11) Client is referred as __________
a) Back end b) Front end c) Table d) None
12) SGA stands for _________
a) Structured Global Area b) System Global Area c) System Global Access d) None
13) Oracle support ________ operating systems.
a) many b) single c) two d) None
14) Triggers are written by user for _____________
a) Specific Table b) for Multiple Tables c) for Columns d) None
15) Client and Server can communicate by using __________
a) PL/SQL b) PROC c) SQLNet d) None
16) DDL stands for _____________
a) Data Definition Language b) Data Dictionary Language c) Data Definition Load d) None
17) DML Stands for _____________
a) Data Mathematical Language b) Data Multiple Language
c) Data Manipulation Language d) None
18) DCL Stands for ______
a) Data Connect Language b) Data Control Language c) Data Combine Language d) None
19) UPDATE command is using for ___________
a) add new rows b) change the column values c) delete the rows d) None
20) DELETE command is using for ___________
a) delete the columns b) change the column values c) delete the rows d) None
21) Character values are types within _______ .
a) Single quotes b) Double Quotes c) Exclamatory d) None
22) If WHERE condition is not given, then ______ rows in the table will be updated.
a) All b) Only One c) No d) None
23) For Date Type of data, width _______ specified.
a) must not be b ) must be c) 8 d) None
24) ________ symbol is the concatenation operator.
a) “ b) & c) | | d) none
25) By default , data is sorted in _______ order.
a) Descending b) Random c) Ascending d) None
26) _________ is the command to change the table name.
a) Update b) Insert c) Rename d) None
27) _______ property that guarantees that values from one column depend on values in another column.
a) Referential Integrity b) Foreign Key c) Primary key d) None
28) Column in the child table, which reference a primary key on the parent table is referred as _____.
a) Transaction Key b) Null key c) Foreign key d) None
29) _________ referential integrity rule which allows the user to delete rows from the master and at the same time delete the dependent rows in the child table.
a) On update b) On Insert c) On delete cascade d) None
30) Join means to across rows from _______ tables
a) only one b) two only c0 two or more d) None
31) When matching records only are displayed from both the tables. It is called ______ join.
a) Equi Join b) Non-equi c) Outer join d) None
32) _________ command is used to release the formatting.
a) column cleared b) column off c) clear column d) None
33) _______ function is used to substitute any NULL value with a user specified value.
a) ABS() b) NVL() c) MAX() d) None
34) _________ function can be used to expand any abbreviations used in the table.
a) NVL b) MIN c) DECODE d) None
35) __________ function is convert a string into an oracle date.
a) Months_Between b) To_Date() c) NVL d) None
36) _______ columns are like table columns, but not actually stored in thee table.
a) User b) Built-in c) Pseudo d) None
37) In SQL, the _____ statement is used to query at a table in different ways.
a) SELECT b) UPDATE c) INSERT d) None
38) _____language is used to store and retrieve data from a database.
a) Database b) Table c) SQL d) None
39) ________ function can be used to convert a date or number to a character string.
a) T0_CHAR() b) TO_NUMBER() c) CONVERT() d) None
40) ________ function is display the greatest value from a group of values or expressions.
a) MAX() b) GREATEST() c) BIG() d) None
2 Mark Questions
1) Many tables can be _____ and _________ to each other.
a) created , related b) created, used c) related, Created d) None
2) Network is communication between ________ & ____________.
a) Data & Information b) Server & Client c) Table & Columns d) None
3) Example of DDL Commands are ________ and __________.
a) CREATE & ALTER b) INSERT & DELETE c) GRANT & REVOKE d) None
4) Example of DML Commands are ________ and __________.
a) CREATE & ALTER b) INSERT & DELETE c) GRANT & REVOKE d) None
5) Example of DCL Commands are ________ and __________.
a) CREATE & ALTER b) INSERT & DELETE c) GRANT & REVOKE d) None
6) Maximum table name is ______ and Maximum database name is ________.
a) 30 , 8 b) 8,30 c) No limit d) None
7) Delete from _____ where _______.
a) Condition , Table Name b) Table Name, Condition c) Table Name, value d) None
8) Select _______ from ____________;
a) Column Name, Table Name b) Table Name, Column Name
c) Table Name, Value d) None
9) Transaction commands are ______ & __________.
a) SELECT, DELETE b) UPDATE , COMMIT c) ROLLBACK, COMMIT d) None
10) _________ table will contain only one record and _______ table will contain record.
a) Transaction, Master b) Master, Transaction c) Master, Master d) None
11) Maximum size of Char data type is ______ and varchar2(w) maximum width is ______ bytes.
a) 255 & 2000 b) 2000 & 255 c) 255 & 1 d) None
4 Mark Questions
1) Match the following
1. Relation a) Columns
2. Attributes b) Rows
3. Tuples c) Table
a) 1-a 2-b 3-c b) 1-c 2-a 3-b c) 1-a 2-c 3-b d) None
2) Find out the technical names in the place of Question Mark symbols
STUDENT 1
RNO NAME FEE 2
101 3 AAA 3400
a) 1-Table 2-Columns 3-value b) 1-Columns 2-Table 3-value
c) 1-value 2-Columns 3-table d) None
3) Oracle tools are ______ , ____________ , __________ and ___________.
a) SQL PLUS, SQL Reprot Writer , SQL Forms , Pro c
b ) SQL , MS-ACCESS, PL/SQL , Dbase
c) C, JAVA, ORACLE, SAP
d) SQL PLUS , SQLReport Writer , SQL Forms, PROC
4) Match the following
1) DBWR a) Managing various process with the database
2) LGWR b) Managing the user process connected to the database
3) PMON c) Responsible for writing data from buffer to secondary storage
4) SMON d) Write data in the Redo buffers to Redo log files
a) 1-d 2-b 3-c 4-a b)1-c 2-d 3-b 4-a c) 1-a 2-b 3-c 4-d d) None
5) Data Constraints are ________ , __________ and ___________.
a) Primary Key, Not Null, Check b) Insert, Delete , Update
c) Create , Alter , Drop d) None
6) Update ____ set ____= ___________.
a) Table Name , Column Name, Value b) Column Name, Value, Table name
c) Value, Column Name, Table Name d) None
7) Match the following
1) MAX a) Display the greatest value from group of expressions
2) MIN b) Display the least value from a group of expressions.
3) GREATEST c) Maximum value of entire column
4) LEAST d) Minimum value of entire column
a) 1-c, 2-d, 3-a, 4-b b) 1-a , 2-b , 3-c, 4-d c) 1-c,2-a,3-b,4-d d) None
8) Match the following :
1) CURRVAL a) Row Number
2) NEXTVAL b) Row Identification
3) ROWID c) Current value
4) ROWNUM d) Next Value
a) 1-a 2-b 3-c 4-d b) 1-c 2-d 3-b 4-a c) 1-d 2-a 3-b 4-c d) None
9) Match the following:
1) MOD a) returns remainder value
2) POWER b) returns the data raised to the power of value
3) ROUND c) n number of decimal places , data is rounded
4) SQRT d) returns the square root of data
a) 1-a 2-b 3-c 4-d b) 1-c 2-d 3-b 4-a c) 1-d 2-a 3-b 4-c d) None
----
ORACLE KEY (UNIT-1)
1-MARK QUESTION
1 A 2 A 3 C 4 B 5 A
6 A 7 C 8 C 9 B 10 A
11 B 12 A 13 A 14 A 15 C
16 A 17 C 18 B 19 B 20 C
21 A 22 A 23 A 24 C 25 C
26 C 27 A 28 C 29 C 30 C
31 A 32 C 33 B 34 C 35 B
36 C 37 A 38 C 39 A 40 B
2-MARKS QUESTIONS
1 A 2 B 3 A 4 B 5 C
6 A 7 B 8 A 9 C 10 B
11 A
4-MARKS QUESTIONS
1 B 2 A 3 D 4 B 5 A
6 A 7 A 8 B 9 A
---
