Sahyog College of Management Studies                                    
                                                                             Online Examination
                                                                    Course: SY BCA Semester IV
                                                                                   (Class Test)

                                                                         RDBMS with Oracle(3IBCA402)

                                                               Time: 45 Minutes         Max Marks: 30                              
                                                               Date: 08/06/2021        Min Marks:  10
     
Instructions:
1. All the questions are compulsory
2. Each question carries 1 mark                                                

Email *
Student Name *
Class *
Required
 To alter date format ________________ parameter is used. *
In _______ datatype column cannot be sent as argument in an function or procedure. *
CLOB is used for ____________. *
Not null is ____________ level constraint. *
 In primary key maximum ______ columns can be grouped together. *
Primary key (<column_name1>,<column_name2>…..<column_namen>) is the syntax of  __________ level primary key. *
Unique constraint does not accept null value. *
Like predicate is ________ operator. *
The ____ operator is used to compare only one value in a conditional expression. *
Can we rename table using alter statement? *
 The function that are applied on a set of values are called_____________. *
____________function return largest number from the given list. *
This function return the highest or the equivalent integer that comes before the given number. *
This function return the position of the substring in a given string. *
In ____________ function if charset not used then blank spaces will be removed. *
Default format of date type in oracle is_____________ *
Sql subquery is used to fetch data from two or more tables which is joined to appear as signle  set of data. *
 ________ is a subquery which uses value from outer query. *
View in SQL are kind of virtual database *
Privileges like create table,create user etc. are granted by DBA to user , are known as  _____________ *
___________ option further permits the privilege holder to grant acquired privileges to other  user. *
_______ function returns the identification number of the user. *
 Indexes created on only one column of table are called as ___________. *
 Indexes based on more than one column of table called______________. *
The technique of storing low cardinality rows in form of bits are called__________. *
Group by clause if often used with______________. *
Having clause is used to specify the condition after order by clause . *
 __________ is a join in which a table is joined with itself. *
 _________ function is applied on table rather than column. *
In number datatype maximum precision is________. *
Submit
Clear form
This content is neither created nor endorsed by Google. Report Abuse - Terms of Service - Privacy Policy
Google Forms