or Search

Q:

The capacity to change the conceptual schema without having to change external schemas or application programs is called

A) Physical Data Independence	B) Logical Data Independence
C) Both A and B	D) None

Answer & Explanation Answer: B) Logical Data Independence

Explanation:

LDI is the capacity to change the conceptual schema without having to change external schemas or application programs.

Report Error

View Answer Report Error Discuss

Filed Under: Database
Job Role: Database Administration

Q:

Physical data models describe the details of how data is stored in the computers

A) TRUE

B) FALSE

Answer & Explanation Answer: A) TRUE

Explanation:

They describe the details of how data is stored in the computers

Workspace

Report Error

View Answer Workspace Report Error Discuss

Subject: Database
Job Role: Database Administration

Q:

In how many ways can the letters of the word ABACUS be rearranged such that the vowels always appear together?

A) 4!/2!	B) 3!/2!
C) (4! x 3!) / 2!	D) 36

Answer & Explanation Answer: C) (4! x 3!) / 2!

Explanation:

ABACUS is a 6 letter word with 3 of the letters being vowels.

If the 3 vowels have to appear together, then there will 3 other consonants and a set of 3 vowels together.

These 4 elements can be rearranged in 4! Ways.

The 3 vowels can rearrange amongst themselves in 3!/2! ways as "a" appears twice.

Hence, the total number of rearrangements in which the vowels appear together are (4! x 3!)/2!

Report Error

View Answer Report Error Discuss

Filed Under: Permutations and Combinations

Q:

How many different four letter words can be formed (the words need not be meaningful using the letters of the word "MEDITERRANEAN" such that the first letter is E and the last letter is R?

A) 59	B) 56
C) 64	D) 55

Answer & Explanation Answer: A) 59

Explanation:

The first letter is E and the last one is R.

Therefore, one has to find two more letters from the remaining 11 letters.

Of the 11 letters, there are 2 Ns, 2Es and 2As and one each of the remaining 5 letters.

The second and third positions can either have two different letters or have both the letters to be the same.

Case 1: When the two letters are different. One has to choose two different letters from the 8 available different choices. This can be done in 8 * 7 = 56 ways.

Case 2: When the two letters are same. There are 3 options - the three can be either Ns or Es or As. Therefore, 3 ways.

Total number of possibilities = 56 + 3 = 59

Report Error

View Answer Report Error Discuss

Filed Under: Permutations and Combinations

Q:

A certain marathon had 50 people running for first prize, second, and third prize.How many ways are there to correctly guess the first, second, and third place winners?

A) 2	B) 1
C) 4	D) 3

Answer & Explanation Answer: B) 1

Explanation:

There is 1 way to correctly guess who comes in first, second, and third. There is only one set of first, second and third place winners. You must correctly guess these three people, and there is only one way to do so.

Report Error

View Answer Report Error Discuss

Filed Under: Permutations and Combinations

Q:

Find the number of ways to take 20 objects and arrange them in groups of 5 at a time where order does not matter.?

A) 57090	B) 15540
C) 15504	D) 23670

Answer & Explanation Answer: C) 15504

Explanation:

${}^{20}C_{5}$ = 15504

Report Error

View Answer Report Error Discuss

Filed Under: Permutations and Combinations

Q:

Find the number of ways to take 4 people and place them in groups of 3 at a time where order does not matter?

A) 4	B) 12
C) 36	D) 16

Answer & Explanation Answer: A) 4

Explanation:

Since order does not matter, use the combination formula

${}^{4}C_{3}$ = 24/6 = 4

Report Error

View Answer Report Error Discuss

Filed Under: Permutations and Combinations

Q:

Find the number of ways to arrange 6 items in groups of 4 at a time where order matters?

A) 720	B) 640
C) 740	D) 360

Searching for "or"

Quick Links