DBMS-Relational Algebra and Calculus Questions and Answers

Practice Mode
Showing 10 of 81 questions
Q61
If HAVING is specified , ORDER BY clause must also be specified
  • A TRUE
  • B FALSE
Answer: Option B
Q62
ALTER TABLE command enables us to delete column from a table.
  • A TRUE
  • B FALSE
Answer: Option A
Q63
The SQL data definition language provides commands for defining relation schemas, deleting relations and modifying relation schemas
  • A TRUE
  • B FALSE
Answer: Option A
Q64
In SQL, it is not possible to create local or global temporary tables within a transaction.
  • A TRUE
  • B FALSE
Answer: Option B
Q65
All tasks related to relational data management cannot be done using SQL alone.
  • A TRUE
  • B FALSE
Answer: Option B
Q66
All tasks related to relational data management cannot be done using SQL alone.
  • A TRUE
  • B FALSE
Answer: Option B
Q67
DML consists of commands that control the user access to the database objects
  • A TRUE
  • B FALSE
Answer: Option B
Q68
If nothing is specified, the result set is stored in descending order, which is the default.
  • A TRUE
  • B FALSE
Answer: Option B
Q69
'*' is used to get all the columns of a particular table.
  • A TRUE
  • B FALSE
Answer: Option A
Q70
The CREATIVE TABLE statement creates new base table.
  • A TRUE
  • B FALSE
Answer: Option A

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test