PPSC FPSC KPPSC BPSC SPSC Lecturer Computer Science Test 46

Leave a Comment / By Hassan / December 19, 2021

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 45
Test Type	MCQs
Total Questions	25
Total Time	20 Minutes
Total Marks	100

You have 20 minutes to pass to the quiz.

Lecturer Computer Science Online Test No. 46

1 / 25

Entity is a:

Object of relation

Present working model

Thing in real world

Model of relation

2 / 25

The attribute AGE is calculated from DATE_OF_BIRTH . The attribute AGE is

Single valued

Multi valued

Composite

Derived

3 / 25

Which of the following can be a multivalued attribute?

Phone_number

Name

Date_of_birth

All of these

4 / 25

Which of the following is not outer join?

Left outer join

Right outer join

Full outer join

All of these

5 / 25

In precedence of set operators the expression is evaluated from

Left to left

Left to right

Right to left

From user specification

6 / 25

Which is a unary operation:

Selection operation

Primitive operation

Projection operation

Generalized selection

7 / 25

Relational Algebra is a .............query language that takes two relation as input and produces another relation as output of the query.

Relational

Structural

Procedural

Fundamental

8 / 25

An entity in A is associated with at most one entity in B, and an entity in B is associated with at most one entity in A. This is called as

One-to-many

One-to-one

Many-to-many

Many-to-one

9 / 25

The descriptive property possessed by each entity set is

Entity

Attribute

Relation

Model

10 / 25

The attribute name could be structured as a attribute consisting of first name, middle initial, and last name . This type of attribute is called

Simple attribute

Composite attribute

Multivalued attribute

Derived attribute

11 / 25

The function that an entity plays in a relationship is called that entity‘s..........

Participation

Position

Role

Instance

12 / 25

Which of the following statements creates a new table temp instructor that has the same schema as instructor.

create table temp_instructor;

Create table temp_instructor like instructor;

Create Table as temp_instructor;

Create table like temp_instructor;

13 / 25

Not applicable condition can be represented in relation entry as:

NULL

Blank Space

14 / 25

For select operation the ________ appear in the subscript and the ___________ argument appears in the parenthesis after the sigma.

Predicates, relation

Relation, Predicates

Operation, Predicates

Relation, Operation

15 / 25

..................., express the number of entities to which another entity can be associated via a relationship set.

Mapping Cardinality

Relational Cardinality

Participation Constraints

None of these

16 / 25

An ________ is a set of entities of the same type that share the same properties, or attributes .

Entity set

Attribute set

Relation set

Entity model

17 / 25

In a relation between the entities the type and condition of the relation should be specified. That is called as______attribute

Descriptive

Derived

Recursive

Relative

18 / 25

Which is a join condition contains an equality operator:

Equijoins

Cartesian

Natural

Left

19 / 25

The assignment operator is denoted by

20 / 25

In contemporary databases the top level of the hierarchy consists of ______, each of which can contain _____.

Catalogs, schemas

Schemas, catalogs

Environment, schemas

Schemas, Environment

21 / 25

An entity in A is associated with at most one entity in B. An entity in B, however, can be associated with any number (zero or more) of entities in A.

One-to-many

One-to-one

Many-to-many

Many-to-one

22 / 25

Which of the following is used to denote the selection operation in relational algebra?

Pi (Greek)

Sigma (Greek)

Lambda (Greek)

Omega (Greek)

23 / 25

Which of the following is a fundamental operation in relational algebra?

Set intersection

Natural join

Assignment

None of these

24 / 25

Which of the following is a single valued attribute

Register_number

Address

SUBJECT_TAKEN

Reference

25 / 25

The ___________ operation, denoted by −, allows us to find tuples that are in one relation but are not in another.

Union

Set-difference

Difference

Intersection

Your score is

The average score is 0%

PPSC FPSC KPPSC BPSC SPSC Lecturer Computer Science Test 46

Related

Leave a Comment Cancel Reply

Related

Popular Posts

Leave a Comment Cancel Reply