PPSC FPSC KPPSC BPSC SPSC Lecturer Computer Science Test 47

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

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

2 / 25

Identify the composite attributes:

Salary

Credits

Section_id

None of these

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

4 / 25

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

Atomic

Subatomic

Substructure

Subset

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

6 / 25

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

Local Key

Primary Key

Composite Key

Foreign Key

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

Weak entity set is represented as:

Underline

Double line

Double diamond

Double rectangle

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

10 / 25

Which one is based on multi-valued dependency:

First

Second

Third

Fourth

11 / 25

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

Double diamonds

Undivided rectangles

Dashed lines

Diamond

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

13 / 25

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

Secondary Key

Primary key

Foreign key

Composite key

14 / 25

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

Relation

Entity

Instance

Attribute

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

16 / 25

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

Data dictionary

data repository

Index data

Metadata

17 / 25

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

1 NF

2 NF

3 NF

All of these

18 / 25

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

Constraints

Stored Procedure

Triggers

Cursors

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

20 / 25

The Rectangles divided into two parts represents:

Entity set

Relationship set

Attributes of a relationship set

Primary key

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

22 / 25

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

Entity-relationship diagram

Entity diagram

Database diagram

Architectural representation

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

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

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

Your score is

The average score is 0%

Popular Posts

Leave a Comment Cancel Reply