sql interview questions and answers

MCQsQuestion.com has 5 Question/Answers about Topic sql interview questions and answers

We can choose tuples to be updated by using a query, as we could for

We can choose tuples to be updated by using a query, as we could for
  • A. Insert
  • B. Delete
  • C. Both A and B
  • D. Retrieval
  • Correct Answer: Option C

Instead of specifying a set of tuples, we can also use the

Instead of specifying a set of tuples, we can also use the
  • A. Select
  • B. Group by
  • C. Having
  • D. Like
  • Correct Answer: Option A

“Bulk loader” utilities allow data to be read from

“Bulk loader” utilities allow data to be read from
  • A. Rewritable text files
  • B. Non-readable text files
  • C. Formatted text files
  • D. Extracted text files
  • Correct Answer: Option C

Command that all instructors with salary over $100,000 receive a 3 percent raise, would be written as

Command that all instructors with salary over $100,000 receive a 3 percent raise, would be written as
  • A. None
  • B. None
  • C. None
  • D. None
  • Correct Answer: Option A

Simplest insert statement is a request to insert

Simplest insert statement is a request to insert
  • A. One attribute
  • B. One tuple
  • C. One variable
  • D. One instance
  • Correct Answer: Option B