Lecturer Computer Science Test 32 Online Preparation MCQs

Leave a Comment / By Hassan / October 25, 2020

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

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

Where

From

Distinct

Select

2 / 25

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

Update

Multiple queries

Sub queries

Scalar subqueries

3 / 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:

Both a and c

Delete from instructor where dept_name in ‗Watson‘;

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

Delete from department where building=‘Watson‘;

4 / 25

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

Where, from

From, select

Select, from

From, where

5 / 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

6 / 25

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

String

Trim

Lower

Upper

7 / 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 teaches,instructor where instructor_id=course_id;

Select name, course_id from instructor natural join teaches;

Select name ,course_id from instructor;

Select course_id from instructor join teaches;

8 / 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

Descending, Ascending

Desc, Asc

Asc, Desc

9 / 25

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

All , Exactly

Atleast, All

Atleast, Exactly

Exactly, Atleast

10 / 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 r where P;

Delete from instructor where salary between 13000 and 15000;

11 / 25

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

Employee

"Com Sci"

Dept_name

From

12 / 25

Which of the following statements contains an error?

Select empid from emp where empid = 10006;

Select * from emp where empid = 10003;

Select empid from emp;

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

13 / 25

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

Employee

Salary

Salary, dept_id

All the field of employee relation

14 / 25

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

All

Distinct

Name

From

15 / 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 employee where salary between 90000 and 100000;

Select name from instructor where salary between 100000 and 90000;

Select name from instructor where salary between 90000 and 100000;

16 / 25

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

Null

Several

Two

One

17 / 25

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

Any

Descending

Ascending

Same

18 / 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?

Salary*1.1

From

Instructor

19 / 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

All attributes of instructor and teaches are selected

All attributes of instructor are selected on the given condition

Only the some attributes from instructed and teaches are selected

20 / 25

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

Table

Values

Relation

Field

21 / 25

operator is used for appending two strings:

22 / 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 ?

23 / 25

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

Where

Set

Select

24 / 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 ?

From

Rename

Join

25 / 25

Delete from r where P; The above command:

All of the mentioned

Clears all entries from the relation

Deletes the relation

Deletes a particular tuple from the relation

Your score is

The average score is 39%

Lecturer Computer Science Test 32 Online Preparation MCQs

Related

Leave a Comment Cancel Reply

Related

Popular Posts

Leave a Comment Cancel Reply