PPSC FPSC KPPSC BPSC SPSC Lecturer Computer Science Test 48

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 NameLecturer Computer Science 
SubjectComputer Science Test 48
Test TypeMCQs
Total Questions25
Total Time20 Minutes
Total Marks100
0%

You have 20 minutes to pass to the quiz.

You have 20 minutes to pass to the quiz.


Lecturer Computer Science Online Test No. 48

1 / 25

A dependency exist between two columns when:

2 / 25

What are the desirable properties of a decomposition:

3 / 25

R (A,B,C,D) is a relation. Which of the following does not have a lossless join dependency preserving BCNF decomposition.

4 / 25

A data type that creates unique numbers for key columns in Microsoft Access is:

5 / 25

Functional Dependencies are the types of constraints that are based on:

6 / 25

Consider a relation R(A,B,C,D,E) with the following functional dependencies:

ABC -> DE and

D -> AB

The number of superkeys of R is:

7 / 25

A relation is in ____________ if an attribute of a composite key is dependent on an attribute of other composite key.

8 / 25

Inst_dept (ID, name, salary, dept name, building, budget) is decomposed into instructor (ID, name, dept name, salary) department (dept name, building, budget) This comes under:

9 / 25

Which is a bottom-up approach to database design that design by examining the relationship between attributes:

10 / 25

The relation employee(ID,name,street,Credit,street,city,salary) is decomposed into employee1 (ID, name) employee2 (name, street, city, salary) This type of decomposition is called

11 / 25

The algorithm that takes a set of dependencies and adds one schema at a time, instead of decomposing the initial schema repeatedly is:

12 / 25

A table on the many side of a one to many or many to many relationship must:

13 / 25

We can use the following three rules to find logically implied functional dependencies. This collection of rules is called

14 / 25

Which of the following is not a Armstrong‘s Axiom ?

15 / 25

Which forms are based on the concept of functional dependency:

16 / 25

Which normal form is considered adequate for normal relational database design?

17 / 25

Which of the following is not a Armstrong‘s Axiom ?

18 / 25

In the ....................normal form, a composite attribute is converted to individual attributes.

19 / 25

Which forms has a relation that possesses data about an individual entity:

20 / 25

Which forms simplifies and ensures that there is minimal data aggregates and repetitive groups:

21 / 25

Tables in second normal form (2NF):

22 / 25

Suppose relation R(A,B) currently has tuples {(1,2), (1,3), (3,4)} and relation S(B,C) currently has {(2,5), (4,6), (7,8)}.

Then the number of tuples in the result of the SQL query:

Select *

From R Natural Outer Join S; is:

23 / 25

The functional dependency can be tested easily on the materialized view, using the constraints.............

24 / 25

There are two functional dependencies with the same set of attributes on the left side of the arrow:

A->BC

A->B

This can be combined as

25 / 25

We can use the following three rules to find logically implied functional dependencies. This collection of rules is called

Your score is

The average score is 0%

0%

Leave a comment

Your email address will not be published.