Sawaal
  • Home/
  • Job Roles Preparation

Job Roles

Popular Latest Rated
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

2 3650
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

Report Error

View Answer Workspace Report Error Discuss

Subject: Oracle Certification
Job Role: Database Administration

1 4158
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.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle Certification
Job Role: Database Administration

3 2764
Q:

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

Answer

Alter database backup control file to trace

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle Certification
Job Role: Database Administration

3 2495
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

7 5602
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

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology
Job Role: Database Administration

0 1946
Q:

Does the minimum spanning tree of a graph give the shortest distance between any 2 specified nodes?

A) Yes B) No
C) May be Yes or No D) None
 
Answer & Explanation Answer: B) No

Explanation:

No.Minimal spanning tree assures that the total weight of the tree is kept at its minimum. But it doesn’t mean that the distance between any two nodes involved in the minimum-spanning tree is minimum.

Report Error

View Answer Report Error Discuss

Filed Under: Database
Job Role: Database Administration

1 3411
Q:

What are the notations used in Evaluation of Arithmetic Expressions using prefix and postfix forms?

A) Polish B) Reverse Polish
C) Both A and B D) None of the above
 
Answer & Explanation Answer: C) Both A and B

Explanation:

Polish and Reverse Polish are the notations used in Evaluation of Arithmetic Expressions using prefix and postfix forms

Report Error

View Answer Report Error Discuss

Filed Under: Database
Job Role: Database Administration

10 13059