I Search

Q:

A pizza can have 3 toppings out of possible 7 toppings.How many different pizza's can be made?

A) 49	B) 35
C) 27	D) 25

Answer & Explanation Answer: B) 35

Explanation:

There are 7 toppings in total,and by selecting 3,we will make different types of pizza.

This question is a combination since having a different order of toppings will not make a different pizza.

So, $7 C_{3}$ =35

Report Error

View Answer Report Error Discuss

Filed Under: Permutations and Combinations

Q:

A column defined as UNIQUE can contain Nulls while a column defined as PRIMARY KEY can't contain Nulls

A) TRUE

B) FALSE

Answer & Explanation Answer: A) TRUE

Explanation:

Because a table can have only one primary key

Workspace

Report Error

View Answer Workspace Report Error Discuss

Subject: Oracle Certification
Job Role: Database Administration

Q:

What is an Oracle index?

Answer

An index is an optional structure associated with a table to have direct access to rows, which can be created to increase the performance of data retrieval. Index can be created on one or more columns of a table.

Workspace

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle Certification
Job Role: Database Administration

Q:

What command would you use to create a backup control file?

Answer

Alter database backup control file to trace

Workspace

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle Certification
Job Role: Database Administration

Q:

A committee of 4 people is to be formed from a group of 9 people.How many possible committees can be formed?

A) 120	B) 162
C) 126	D) 170

Answer & Explanation Answer: C) 126

Explanation:

This question is a combination since order is not important.

Answer = $7 C_{3}$ = 126

Report Error

View Answer Report Error Discuss

Filed Under: Permutations and Combinations

Q:

What is the maximum number of triggers, can apply to a single table?

A) 8	B) 10
C) 12	D) 14

Answer & Explanation Answer: C) 12

Explanation:

Maximim number of triggers that can be applied to a single table is 12

Report Error

View Answer Report Error Discuss

Filed Under: Oracle Certification
Job Role: Database Administration

Q:

What is the difference between Silverlight 1.0 and 2?

Answer

Silverlight 1 is purely AJAX and JavaScript based. All the code has to be written in JavaScript and XAML.

Silverlight 2 supports managed code. When the Silverlight 2 runtime is installed, it installs a limited version of the .NET runtime on the client machine

Workspace

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology
Job Role: Database Administration

Q:

In how many ways a committee, consisting of 5 men and 6 women can be formed from 8 men and 10 women?

A) 53400	B) 17610
C) 11760	D) 45000

Answer & Explanation Answer: C) 11760

Explanation:

Required number of ways = $(8 C_{5} * 10 C_{6})$ = $(8 C_{3} * 10 C_{4})$ = 11760

Report Error

View Answer Report Error Discuss

Filed Under: Permutations and Combinations

Searching for "I"

Quick Links