Subject Specialist Computer Science

PPSC FPSC KPPSC BPSC SPSC Lecturer Computer Science Test 47

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 47
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. 47

1 / 25

If every non-key attribute is functionally dependent primary key, then the relation will be in:

First normal form

Second normal form

Third form

Fourth normal form

2 / 25

Which is the main relation which is used in the university database which is referenced by all other relation of the university.

Teaches

Course

Department

Section

3 / 25

.............is preferred method for enforcing data integrity:

Constraints

Stored Procedure

Triggers

Cursors

4 / 25

Which of the following gives a logical structure of the database graphically?

Entity-relationship diagram

Entity diagram

Database diagram

Architectural representation

5 / 25

An entity set that does not have sufficient attributes to form a primary key is termed a..........

Strong entity set

Variant set

Weak entity set

Variable set

6 / 25

Data integrity constraints are used to:

Control who is allowed access to the data

Ensure that duplicate records are not entered into the table

Improve the quality of data entered for a specific property

Prevent users from changing the values stored in the table

7 / 25

Consider a directed line(->) from the relationship set advisor to both entity sets instructor and student. This indicates ................... cardinality:

One to many

One to one

Many to many

Many to one

8 / 25

Which one is based on multi-valued dependency:

First

Second

Third

Fourth

9 / 25

If an attribute of a composite key is dependent on an attribute of the other composite key, a normalization called _____ is needed.

DKNF

BCNF

Fourth

Third

10 / 25

Which one of the following uniquely identifies the elements in the relation?

Secondary Key

Primary key

Foreign key

Composite key

11 / 25

Weak entity set is represented as:

Underline

Double line

Double diamond

Double rectangle

12 / 25

What term is used to refer to a specific record in your music database; for instance; information stored about a specific album?

Relation

Instance

Table

Column

13 / 25

A domain is ______ if elements of the domain are considered to be indivisible units.

Atomic

Subatomic

Substructure

Subset

14 / 25

The term for information that describes what type of data is available in a database is:

Data dictionary

data repository

Index data

Metadata

15 / 25

.................is a special type of integrity constraint that relates two relations & maintains consistency across the relations.

Entity Integrity Constraints

Referential Integrity Constraints

Domain Integrity Constraints

Domain Constraints

16 / 25

If you were collecting and storing information about your music collection, an album would be considered a(n):

Relation

Entity

Instance

Attribute

17 / 25

The entity relationship set is represented in E-R diagram as:

Double diamonds

Undivided rectangles

Dashed lines

Diamond

18 / 25

The Rectangles divided into two parts represents:

Entity set

Relationship set

Attributes of a relationship set

Primary key

19 / 25

Drop Table cannot be used to drop a table referenced by a _________ constraint.

Local Key

Primary Key

Composite Key

Foreign Key

20 / 25

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

All phone numbers must include the area code

Certain fields are required (such as the email address, or phone number) before the record is accepted

Information on the customer must be known before anything can be sold to that customer

Then entering an order quantity, the user must input a number and not some text (i.e., 12 rather than ‗a dozen‘)

21 / 25

Establishing limits on allowable property values, and specifying a set of acceptable predefined options that can be assigned to a property are examples of:

Attributes

Data integrity constraints

Method constraints

Referential integrity constraints

22 / 25

For a weak entity set to be meaningful, it must be associated with another entity set, called the:

Identifying set

Owner set

Neighbour set

Strong entity set

23 / 25

Identify the composite attributes:

Salary

Credits

Section_id

None of these

24 / 25

We indicate roles in E-R diagrams by labeling the lines that connect ................... to..............

Diamond , diamond

Rectangle, diamond

Rectangle, rectangle

Diamond, rectangle

25 / 25

If a relation is in BCNF, then it is also in:

1 NF

2 NF

3 NF

All of these

Your score is

The average score is 0%

PPSC FPSC KPPSC BPSC SPSC Lecturer Computer Science Test 47 Read More »