Searching for "I"

Q:

What is schema?

Answer

The description of a data base is called the database schema , which is specified during database design and is not expected to change frequently . A displayed schema is called schema diagram .We call each object in the schema as schema construct.

Report Error

View answer Workspace Report Error Discuss

Subject: 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

Report Error

View Answer Workspace Report Error Discuss

Subject: 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:

Database is a collection of concepts that can be used to describe the structure of a database

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

Explanation:

Database provides necessary means to achieve this abstraction. By structure of a database we mean the data types, relations, and constraints that should hold on the data.

Report Error

View Answer Workspace Report Error Discuss

Subject: Database
Job Role: Database Administration

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

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

Q:

Find the number of ways to draw a straight, (suit does not matter) beginning with a 4 and ending with a 8?

A) 1024 B) 1296
C) 1094 D) 1200
 
Answer & Explanation Answer: A) 1024

Explanation:

There are 5 slots.

 

                   __ __ __ __ __

 

The first slot must be a four. There are 4 ways to put a four in the first slot.

 

There are 4 ways to put a five in the second slot, and there are 4 ways to put a six in the third slot. etc.

 

(4)(4)(4)(4)(4) = 1024

 

Therefore there are 1024 different ways to produce the desired hand of cards.

Report Error

View Answer Report Error Discuss