PPSC FPSC KPPSC BPSC SPSC Lecturer Computer Science Test 45

Online Free Taleem is free online MCQ’s test related to Lecturer Computer Science. All the individuals who are going to appear in Lecturer Computer Science written test can attempt these tests in order to prepare for it in best possible way. Our tests of Lecturer of Computer Science include all the important questions and Past Paper of  Lecturer Computer Science, that have extremely high amount of chances for been included in the actual exam which make our test undoubtedly the best source of preparation.


There will be 25 multiple choice question in the test.
Answer of the questions will change randomly each time you start this test.
Practice this test at least 5 times if you want to secure High Marks.
At the End of the Test you can see your Test score and Rating.
If you found any incorrect answer in Quiz. Simply click on the quiz title and comment below on that MCQ. So that I can update the incorrect answer on time.

Please Click Below START  Button to Take this Computer Science Test Online.

Test Instructions:-
Test NameLecturer Computer Science 
SubjectComputer Science Test 45
Test TypeMCQs
Total Questions25
Total Time20 Minutes
Total Marks100

You have 20 minutes to pass to the quiz.

Lecturer Computer Science Online Test No. 45

1 / 25

Which of the following can be addressed by enforcing a referential integrity constraint?

2 / 25

SQL view is said to be updatable (that is, inserts, updates or deletes can be applied on the view) if which of the following conditions are satisfied by the query defining the view?

3 / 25

Data integrity constraints are used to:

4 / 25

Create table Manager(ID numeric,Name varchar(20),budget numeric,Details varchar(30)); Inorder to ensure that the value of budget is non-negative which of the following should be used?

5 / 25

Which of the following is used to create view for these relations together?

6 / 25

Which of the following closely resembles Create view ?

7 / 25

Create domain YearlySalary numeric(8,2) constraint salary value test __________; In order to ensure that an instructor‘s salary domain allows only values greater than a specified value use:

8 / 25

Domain constraints, functional dependency and referential integrity are special forms of ......

9 / 25

Which of the following is the syntax for views where v is view name?

10 / 25

Updating the value of the view:

11 / 25

Which of the following is not an integrity constraint?

12 / 25

Create index studentID_index on


Here which one denotes the relation for

which index is created ?

13 / 25

Which of the following is used to store movie and image files?

14 / 25

Foreign key is the one in which the ________ of one relation is referenced in another relation.

15 / 25

Select course_id

from physics_fall_2009

where building= ‘Watson‘;

Here the tuples are selected from the view.

Which one denotes the view.

16 / 25

Which of the following is used at the end of the view to reject the tuples which do not satisfy the condition in where clause ?

17 / 25

The user defined data type can be created using

18 / 25

An ________ on an attribute of a relation is a data structure that allows the database system to find those tuples in the relation that have a specified value for that attribute efficiently, without scanning through all the tuples of the relation.

19 / 25

Create table course

( . . .

foreign key (dept name) references


. . . );

Which of the following is used to delete the entries in the referenced table when the tuple is deleted in course table?

20 / 25

To include integrity constraint in an existing relation use :

21 / 25

Materialised views make sure that:

22 / 25

Which of the following creates a virtual relation for storing the query?

23 / 25

Values of one type can be converted to another domain using which of the following?

24 / 25

Dates must be specified in the format

25 / 25

Create view faculty as Select ID, name, dept name from instructor; Find the error in this query .

Your score is

The average score is 0%


Leave a comment

Your email address will not be published.