ppsc past papers of lecturer Computer science pdf |

Lecturer Computer Science Test 32 Online Preparation MCQs

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.

Note:-

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 Name	Lecturer Computer Science
Subject	Computer Science Test 32
Test Type	MCQs
Total Questions	25
Total Time	20 Minutes
Total Marks	100

You have 20 minutes to pass to the quiz.

PPSC Lecturer of Computer Science Test 32

1 / 25

Select * from instructor order by salary ____, name ___; To display the salary from greater to smaller and name in ascending order which of the following options should be used ?

Ascending, Descending

Asc, Desc

Descending, Ascending

Desc, Asc

2 / 25

operator is used for appending two strings:

3 / 25

Select instructor.* from instructor, teaches where instructor.ID= teaches.ID; This query does which of the following operation?

All attributes of teaches are selected on given condition

Only the some attributes from instructed and teaches are selected

All attributes of instructor are selected on the given condition

All attributes of instructor and teaches are selected

4 / 25

Which of the following deletes all tuples in the instructor relation for those instructors associated with a department located in the Watson building which is in department relation:

Delete from department where building=‘Watson‘;

Delete from instructor where dept_name in ‗Watson‘;

Both a and c

Delete from instructor where dept_name in (select dept name from department where building = ‘Watson‘);

5 / 25

The ............... clause is used to list the attributes desired in the result of a query:

Where

Select

From

Distinct

6 / 25

Select emp_name from department where dept_name like ‘ _____ Computer Science‘; Which one of the following has to be added into the blank to select the dept_name which has Computer Science as its ending string ?

7 / 25

Are useful in SQL update statements, where they can be used in the set clause:

Multiple queries

Sub queries

Scalar subqueries

Update

8 / 25

A Delete command operates on ........................relation:

Null

One

Several

Two

9 / 25

The .................... clause allows us to select only those rows in the result relation of the................... clause that satisfy a specified predicate:

Select, from

From, where

From, select

Where, from

10 / 25

In SQL the spaces at the end of the string are removed by _______ function:

Upper

Trim

String

Lower

11 / 25

Select ID, name, dept name, salary * 1.1 where instructor; The query given below will not give an error. Which one of the following has to be replaced to get the desired output?

Instructor

From

Salary*1.1

12 / 25

Select * from employee where dept_name=‖Comp Sci‖; In the SQL given above there is an error . Identify the error:

From

Employee

"Com Sci"

Dept_name

13 / 25

Insert into employee .................. (1002,Joey,2000); In the given query which of the keyword has to be inserted ?

Values

Relation

Table

Field

14 / 25

‘_ _ _ ‘ matches any string of ______ three characters. ‘_ _ _ %‘ matches any string of at ______ three characters.

Atleast, All

Exactly, Atleast

All , Exactly

Atleast, Exactly

15 / 25

Select name from instructor where dept name = ‘Physics‘ order by name; By default, the order by clause lists items in ______ order:

Ascending

Same

Descending

Any

16 / 25

Select name from instructor where salary <= 100000 and salary >= 90000; This query can be replaced by which of the following ?

Select name from employee where salary <= 90000 and salary>=100000;

Select name from instructor where salary between 100000 and 90000;

Select name from employee where salary between 90000 and 100000;

Select name from instructor where salary between 90000 and 100000;

17 / 25

Delete from r where P; The above command:

All of the mentioned

Deletes a particular tuple from the relation

Deletes the relation

Clears all entries from the relation

18 / 25

Update instructor _____ salary= salary * 1.05; Fill in with correct keyword to update the instructor relation.

Select

Where

Set

19 / 25

Select name ............... instructor name, course id from instructor, teaches where instructor.ID= teaches.ID; Which keyword must be used here to rename the field name ?

Rename

Join

From

20 / 25

Select * from employee where salary>10000 and dept_id=101; Which of the following fields are displayed as output?

Salary

All the field of employee relation

Salary, dept_id

Employee

21 / 25

Which of the following statements contains an error?

Select * from emp where empid = 10003;

Select empid from emp;

Select empid where empid = 1009 and lastname = ‗GELLER‘;

Select empid from emp where empid = 10006;

22 / 25

Which of the following is used to insert a tuple from another relation:

Insert into instructor select ID, name, dept name, 18000 from student where dept name = ‘Music‘ and tot cred > 144;

Insert into course values (‘CS-437‘, ‘Database Systems‘, ‘Comp. Sci.‘, 4);

Insert into course (course id, title, dept name, credits) values (‘CS-437‘, ‘Database Systems‘, ‘Comp. Sci.‘, 4);

Not possible

23 / 25

Which one of the following deletes all the entries but keeps the structure of the relation:

Delete from instructor;

Delete from instructor where dept name= ‘Finance‘;

Delete from instructor where salary between 13000 and 15000;

Delete from r where P;

24 / 25

Select ................ dept_name from instructor; Here which of the following displays the unique values of the column ?

Distinct

From

All

Name

25 / 25

Select name, course_id from instructor, teaches where instructor_ID= teaches_ID; This Query can be replaced by which one of the following?

Select name, course_id from instructor natural join teaches;

Select name ,course_id from instructor;

Select name,course_id from teaches,instructor where instructor_id=course_id;

Select course_id from instructor join teaches;

Your score is

The average score is 32%

Lecturer Computer Science Test 32 Online Preparation MCQs Read More »