ppsc lecturer Computer science syllabus

Lecturer Computer Science Test 31 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 31
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 31

1 / 25

Which one of the following is a procedural language?

Domain relational calculus

Relational algebra

Query language

Tuple relational calculus

2 / 25

........................integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation:

Referencing

Primary

Referential

Specific

3 / 25

In authorization graph if DBA provides authorization to u1 which inturn gives to u2 which of the following is correct?

If u1 revokes authorization from u2 then u2 authorization is revoked.

If DBA revokes authorization from u1 then u2 authorization is also revoked.

None

Both a and b

4 / 25

.................is a property of the entire relation, rather than of the individual tuples in which each tuple is unique:

Key

Fields

Attribute

Rows

5 / 25

Which one of the following cannot be taken as a primary key?

Street

Dept_id

6 / 25

Using which language can a user request information from a database?

Relational

Compiler

Query

Structural

7 / 25

The most commonly used operation in relational algebra for projecting a set of tuple from a relation is:

Union

Join

Select

Projection

8 / 25

The......................operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple:

Join

Union

Select

Intersection

9 / 25

An attribute in a relation is a foreign key if the ............. key from one relation is used as an attribute in that relation:

Candidate

Sub

Super

Primary

10 / 25

The result which operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match:

Set difference

Cartesian product

Intersection

Join

11 / 25

The database administrator who authorizes all the new users, modifies database and takes grants privilege is:

Operator of operating system

Administrator

All of the mentioned

Super user

12 / 25

Consider attributes ID, CITY and NAME. Which one of this can be considered as a super key?

CITY , ID

NAME

CITY

13 / 25

A ................... is a pictorial depiction of the schema of a database that shows the relations in the database, their attributes, and primary keys and foreign keys:

Relational algebra

Schema flow

Schema diagram

Database diagram

14 / 25

If we wish to grant a privilege and to allow the recipient to pass the privilege on to other users, we append the..........................clause to the appropriate grant command:

Grant pass privilege

Grant user

With grant option

With grant

15 / 25

Student(ID, name, dept name, tot_cred) In this query which attribute form the primary key?

Tot_cred

Dept

Name

16 / 25

The ................. provides a set of operations that take one or more relations as input and return a relation as an output:

Scheme diagram

Relation flow

Relational algebra

Schematic representation

17 / 25

Which one of the following attribute can be taken as a primary key?

Street

Name

Department

18 / 25

The ....................................operation performs a set union of two ―similarly structured‖ tables:

Union

Product

Intersect

Join

19 / 25

The .....................operator takes the results of two queries and returns only rows that appear in both result sets:

Union

Difference

Intersect

Projection

20 / 25

Which of the following is a basic form of grant statement ?

Grant ‗privilege list‘ on ‗relation name or view name‘ to ‗user/role list‘;

Grant ‗privilege list‘ to ‗user/role list‘

Grant ‗privilege list‘ on ‗relation name or view name‘ on ‗user/role list‘;

Grant ‗privilege list‘ on ‗user/role list‘ to ‗relation name or view name‘;

21 / 25

The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as primary key is called:

Referred relation

Referencing relation

Referenced relation

Referential relation

22 / 25

The subset of super key is a candidate key under what condition?

All subsets are super keys

Subset is a super key

Each subset is a super key

No proper subset is a super key

23 / 25

The ................. is the one in which the primary key of one relation is used as a normal attribute in another relation:

Referencing relation

Referential relation

Referenced relation

Referred relation

24 / 25

Which of the following is true regarding views?

The user who creates a view cannot be given update authorization on a view without having update authorization on the relations used to define the view

If a user creates a view on which no authorization can be granted, the system will allow the view creation request

A user who creates a view receives all privileges on that view

25 / 25

Which of the following is used to provide delete authorization to instructor?

All of the mentioned

Create role instructor; grant select on takes to instructor;

Create role instructor; grant delete on takes to instructor;

Create role instructor ; grant delete to instructor;

Your score is

The average score is 52%