PPSC FPSC KPPSC BPSC SPSC Lecturer Computer Science Test 49

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

1 / 25

Each tablespace in an Oracle database consists of one or more files called:

Files

name space

datafiles

PFILE

2 / 25

Suppose the user finds the usage of room number and phone number in a relational schema there is confusion. This is reduced by:

Unique-role assumption

Unique-key assignment

Role intergral assignment

None of the mentioned

3 / 25

Representations such as the in the dept year relation, with one column for each value of an attribute, are called _______; they are widely used in spreadsheets and reports and in data analysis tools.

Cross-tabs

Snapshot

Both a and b

All of these

4 / 25

Relation dept year(dept name, total inst 2007, total inst 2008, total inst 2009) .Here the only functional dependencies are from dept name to the other attributes .This relation is in:

Fourth NF

BCNF

Third NF

Second NF

5 / 25

Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set.

A many-to-many relationship set

A multivalued attribute of an entity set

A one-to-many relationship set

Both a and b

6 / 25

In which of the following , a separate schema is created consisting of that attribute and the primary key of the entity set.

A many-to-many relationship set

A multivalued attribute of an entity set

A one-to-many relationship set

Both a and b

7 / 25

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

2NF

3NF

4NF

5NF

8 / 25

The normal form which satisfies multivalued dependencies and which is in BCNF is

Zero4 NF

3 NF

2 NF

All of these

9 / 25

Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set?

A many-to-many relationship set

A multivalued attribute of an entity set

A one-to-many relationship set

Both a and b

10 / 25

If a multivalued dependency holds and is not implied by the corresponding functional dependency, it usually arises from one of the following sources.

A many-to-many relationship set

A multivalued attribute of an entity set

A one-to-many relationship set

Both a and b

11 / 25

Which of the normal form is based on multivalued dependencies ?

First

Second

Third

Fourth

12 / 25

If a multivalued dependency holds and is not implied by the corresponding functional dependency, it usually arises from one of the following sources.

A many-to-many relationship set

A multivalued attribute of an entity set

A one-to-many relationship set

Both a and b

13 / 25

Fifth Normal form is concerned with:

Functional dependency

Multivalued dependency

Join dependency

Domain-key

14 / 25

The main task carried out in the ______ is to remove repeating attributes to separate tables.

First Normal Form

Second Normal Form

Third Normal Form

Fourth Normal Form

15 / 25

The file organization which allows us to read records that would satisfy the join condition by using one block read is:

Heap file organization

Sequential file organization

Clustering file organization

Hash file organization

16 / 25

In the schema (dept name, size) we have relations total inst 2007, total inst 2008 . Which dependency have lead to this relation ?

Dept name, year->size

Year->size

Dept name->size

Size->year

17 / 25

..............can help us detect poor E-R design.

Database Design Process

E-R Design Process

Relational scheme

Functional dependencies

18 / 25

Which of the following is a tuple-generating dependencies ?

Functional dependency

Equality-generating dependencies

Multivalued dependencies

Non-functional dependency

19 / 25

Thus a _______ of course data gives the values of all attributes, such as title and department, of all courses at a particular point in time.

Instance

Snapshot

Both a and b

All of these

20 / 25

In which of the following , a separate schema is created consisting of that attribute and the primary key of the entity set.

A many-to-many relationship set

A multivalued attribute of an entity set

A one-to-many relationship set

Both a and b

21 / 25

Designers use which of the following to tune performance of systems to support time-critical operations?

Denormalization

Redundant optimization

Optimization

Realization

22 / 25

What is the best way to represent the attributes in a large database?

Relational-and

Concatenation

Dot representation

All of the above

23 / 25

A unit of storage that can store one or more records in a hash file organization is denoted as:

Buckets

Disk pages

Blocks

Nodes

24 / 25

What are the correct features of a distributed database?

Is always connected to the internet

Always requires more than three machines

Users see the data in one global schema.

Have to specify the physical location of the data when an update is done

25 / 25

Which level of RAID refers to disk mirroring with block striping?

RAID level 1

RAID level 2

RAID level 0

RAID level 3

Your score is

The average score is 0%

Share this: