Searching for "V"

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:

Representation level data models provide the concepts that are close to the way many users perceive data

A) TRUE B) FALSE
Answer & Explanation Answer: B) FALSE

Explanation:

High level data models provide the concepts that are close to the way many users perceive data

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

Q:

How many ways are there to deal a five-card hand consisting of three eight's and two sevens?

A) 36 B) 72
C) 24 D) 16
 
Answer & Explanation Answer: C) 24

Explanation:

If a card hand that consists of four Queens and an Ace is rearranged, nothing has changed.

 

The hand still contains four Queens and an Ace. Thus, use the combination formula for problems with cards.

 

We have 4 eights and 4 sevens.

We want 3 eights and 2 sevens.

C(have 4 eights, want 3 eights) x C(have 4 sevens, want 2 sevens) 

C(4,3) x C(4,2) = 24

 

Therefore there are 24 different ways in which to deal the desired hand.

Report Error

View Answer Report Error Discuss

Q:

A school has scheduled three volleyball games, two soccer games, and four basketball games. You have a ticket allowing you to attend three of the games. In how many ways can you go to two basketball games and one of the other events?

A) 25 B) 30
C) 50 D) 75
 
Answer & Explanation Answer: B) 30

Explanation:

Since order does not matter it is a combination. 

 

The word AND means multiply. 

 

Given 4 basketball, 3 volleyball, 2 soccer. 

 

We want 2 basketball games and 1 other event. There are 5 choices left. 

C(n,r) 

C(How many do you have, How many do you want) 

C(have 4 basketball, want 2 basketball) x C(have 5 choices left, want 1) 

C(4,2) x C(5,1) = (6)(5) = 30

 

Therefore there are 30 different ways in which you can go to two basketball games and one of the other events.

Report Error

View Answer Report Error Discuss

Q:

Determine the total number of five-card hands that can be drawn from a deck of 52 cards.

A) 2589860 B) 2598970
C) 2598960 D) 2430803
 
Answer & Explanation Answer: C) 2598960

Explanation:

When a hand of cards is dealt, the order of the cards does not matter. If you are dealt two kings, it does not matter if the two kings came with the first two cards or the last two cards. Thus cards are combinations. There are 52 cards in a deck and we want to know how many different ways we can put them in groups of five at a time when order does not matter. The combination formula is used.

C(52,5) = 2,598,960

Report Error

View Answer Report Error Discuss

Q:

If repetition of the digits is allowed, then the number of even natural numbers having three digits is :

A) 550 B) 450
C) 500 D) 540
 
Answer & Explanation Answer: B) 450

Explanation:

In a 3 digit number one’s place can be filled in 5 different ways with (0,2,4,6,8)

10’s place can be filled in 10 different ways

100’s place can be filled in 9 different ways

There fore total number of ways = 5X10X9 = 450

Report Error

View Answer Report Error Discuss

Q:

Find the total number of distinct vehicle numbers that can be formed using two letters followed by two numbers. Letters need to be distinct

A) 65000 B) 64000
C) 72000 D) 36000
 
Answer & Explanation Answer: A) 65000

Explanation:

Out of 26 alphabets two distinct letters can be chosen in 26P2 ways. Coming to numbers part, there are 10 ways.(any number from 0 to 9 can be chosen) to choose the first digit and similarly another 10ways to choose the second digit. Hence there are totally 10X10 = 100 ways. 

 

Combined with letters there are 6P2 X 100 ways = 65000 ways to choose vehicle numbers.

Report Error

View Answer Report Error Discuss