PPSC FPSC KPPSC BPSC SPSC Lecturer Computer Science Test 47

Leave a Comment / By Hassan / December 25, 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 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

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

2 / 25

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

Entity-relationship diagram

Entity diagram

Database diagram

Architectural representation

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

4 / 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‘)

5 / 25

Identify the composite attributes:

Salary

Credits

Section_id

None of these

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

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

8 / 25

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

Diamond , diamond

Rectangle, diamond

Rectangle, rectangle

Diamond, rectangle

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

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

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

12 / 25

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

Constraints

Stored Procedure

Triggers

Cursors

13 / 25

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

Atomic

Subatomic

Substructure

Subset

14 / 25

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

Secondary Key

Primary key

Foreign key

Composite key

15 / 25

Weak entity set is represented as:

Underline

Double line

Double diamond

Double rectangle

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

17 / 25

The Rectangles divided into two parts represents:

Entity set

Relationship set

Attributes of a relationship set

Primary key

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

19 / 25

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

Data dictionary

data repository

Index data

Metadata

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

21 / 25

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

Double diamonds

Undivided rectangles

Dashed lines

Diamond

22 / 25

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

1 NF

2 NF

3 NF

All of these

23 / 25

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

Relation

Entity

Instance

Attribute

24 / 25

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

Local Key

Primary Key

Composite Key

Foreign Key

25 / 25

Which one is based on multi-valued dependency:

First

Second

Third

Fourth

Your score is

The average score is 0%

Popular Posts

Leave a Comment Cancel Reply