5 years ago in Database Management System

Which of the following SQL statements are helpful in database redesign?

[A] Correlated subqueries only
[B] EXISTS/NOT EXISTS expressions only
[C] Both of the above are helpful
[D] None of the above are helpful.
Loading...
Next Question

Overall Stats

Attempted 265
Correct 68
Incorrect 44
Viewed 153

Answers

Guest
Guest
Tsega Asresa Mengistu
Tsega Asresa Mengistu - 1 week ago

Tsega Asresa Mengistu from Dessie, Ethiopia is saying Both of the above are helpful is correct answer

Serkie Mekonnen
Serkie Mekonnen - 1 week ago

Serkie Mekonnen from Dessie, Ethiopia is saying Correlated subqueries only is correct answer

Deep
Deep - 1 month ago

Deep from Kolkata, India is saying Correlated subqueries only is correct answer

Arpita Dhote
Arpita Dhote - 1 month ago

Arpita Dhote from Pune, India is saying Both of the above are helpful is correct answer

indhuja indhuja
indhuja indhuja - 4 months ago

indhuja indhuja from Erode, India is saying Both of the above are helpful is correct answer

Related Questions

Referential integrity controls relationships between :

  • [A] attributes in a table
  • [B] operations of an object
  • [C] instances of a class
  • [D] tables in a database

Which of the following will NOT eliminates the ambiguities of a null value?

  • [A] Define the attribute as required
  • [B] Define subtypes
  • [C] Define each attribute as having an initial value that is recognized as blank
  • [D] Define supertypes

What SQL command can be used to delete columns from a table?

  • [A] MODIFY TABLE TableName DROP COLUMN ColumnName
  • [B] MODIFY TABLE TableName DROP ColumnName
  • [C] ALTER TABLE TableName DROP COLUMN ColumnName
  • [D] ALTER TABLE TableName DROP ColumnName

What is the result of the following SQL statement ?
SELECT A.Employee_Name, B.Spouse_Name
FROM Employee A LEFT OUTER JOIN Spouse B
ON A. Employee_ID = B.Employee_ID

  • [A] A list of employee�??s spouses
  • [B] A list of all employees that have spouses, with spouse names included in the list
  • [C] A list of all employee�??s names, including the name of their spouse if they have one
  • [D] Two lists : One list of employees, the other of spouses