B Search

Q:

What is the difference between oracle,sql and sql server?

Answer

Oracle is based on RDBMS.

SQL is Structured Query Language.

SQL Server is another tool for RDBMS provided by MicroSoft

Workspace

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle Certification
Job Role: Database Administration

Q:

Which among the following keys are used to identify each row of the table uniquely?

A) Primary key	B) Unique key
C) Partial key	D) None of the above

Answer & Explanation Answer: A) Primary key

Explanation:

Primary key helps us to identify a row uniquely in a relation

Report Error

View Answer Report Error Discuss

Filed Under: Oracle Certification
Job Role: Database Administration

Q:

A school committee of 5 is to be formed from 12 students.How many committees can be formed if John must be on the committee?

A) 11P4	B) 11C4
C) 11P5	D) 11C5

Answer & Explanation Answer: B) 11C4

Explanation:

If John must be on the committee,we have 11 students remaining,out of which we choose 4. So, $11 C_{4}$

Report Error

View Answer Report Error Discuss

Filed Under: Permutations and Combinations

Q:

How many ways can you select 17 songs for mix CD out of possible 38 songs?

A) 2878	B) 2878 x 10^2
C) 290183753	D) 2878 x 10^10

Answer & Explanation Answer: D) 2878 x 10^10

Explanation:

since it is a combination = $38 C_{17}$ = 2878 x 10^10

Report Error

View Answer Report Error Discuss

Filed Under: Permutations and Combinations

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:

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

Searching for "B"

Quick Links