Database Questions

Q:

Which of the following is not true about cloud computing?

which_of_the_following_is_not_true_about_cloud_computing1539240737.jpg image

A) Cloud-based management platforms cannot support internally hosted server platforms B) Cloud-based management platforms can support multiple cloud-virtual server vendors
C) Cloud-based management platforms can support multiple cloud-virtual server operating systems D) Cloud-based management platforms can support change management methodologies
 
Answer & Explanation Answer: A) Cloud-based management platforms cannot support internally hosted server platforms

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database
Job Role: IT Trainer , Database Administration , Analyst

6 14964
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 13058
Q:

When mapping a supertype/subtype relationship which of the following is true?

A) The supertype primary key is assigned to each subtype. B) The subtype primary key is assigned to each supertype.
C) There is no link between the supertype/subtype entities. D) There is no primary key/foreign key relationship between a supertype/subtype.
 
Answer & Explanation Answer: A) The supertype primary key is assigned to each subtype.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

4 12187
Q:

With this type of SQL Server cursor concurrency no lock is obtained until the user updates the data.

A) READ_ONLY B) SCROLL_LOCK
C) OPTIMISTIC D) PESSIMISTIC
 
Answer & Explanation Answer: C) OPTIMISTIC

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

3 11607
Q:

Parenthesis is never required in Postfix or Prefix expressions

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

Explanation:

Parenthesis is not required because the order of the operators in the postfix /prefix expressions determines the actual order of operations in evaluating the expression

Report Error

View Answer Workspace Report Error Discuss

Subject: Database
Job Role: Database Administration

3 9394
Q:

 The HAVING clause does which of the following?

A) Acts like a WHERE clause but is used for groups rather than rows. B) Acts like a WHERE clause but is used for rows rather than columns.
C) Acts like a WHERE clause but is used for columns rather than groups. D) Acts EXACTLY like a WHERE clause.
 
Answer & Explanation Answer: A) Acts like a WHERE clause but is used for groups rather than rows.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

3 9164
Q:

 The different classes of relations created by the technique for preventing modification anomalies are called:

A) normal forms. B) functional dependencies.
C) referential integrity constraints. D) None of the above is correct.
 
Answer & Explanation Answer: A) normal forms.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

9 9137
Q:

Which of the following is true about cloud computing?

A) Cloud computing has brought about a drop in hardware and software sales, while augmenting service revenues B) You can access your data from any computer in the world, as long as you have an Internet connection.
C) Both A & B D) It's always going to be less expensive and more secure than local computing.
 
Answer & Explanation Answer: C) Both A & B

Explanation:
Report Error

View Answer Report Error Discuss

2 8425