% Search

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:

If there are 17 randomly placed dots on a circle,how many lines can you form using any 2 dots?

A) 126	B) 130
C) 136	D) 120

Answer & Explanation Answer: C) 136

Explanation:

17C2 = 136 (combination)

Report Error

View Answer Report Error Discuss

Filed Under: Quantitative Aptitude - Arithmetic Ability

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:

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

Searching for "%"

Quick Links