DBMS-Relational Algebra and Calculus

DBMS-Relational Algebra and Calculus
61. If HAVING is specified , ORDER BY clause must also be specified
  • TRUE
  • FALSE
Show Answer
62. ALTER TABLE command enables us to delete column from a table.
  • TRUE
  • FALSE
Show Answer
63. The SQL data definition language provides commands for defining relation schemas, deleting relations and modifying relation schemas
  • TRUE
  • FALSE
Show Answer
64. In SQL, it is not possible to create local or global temporary tables within a transaction.
  • TRUE
  • FALSE
Show Answer
65. All tasks related to relational data management cannot be done using SQL alone.
  • TRUE
  • FALSE
Show Answer
66. All tasks related to relational data management cannot be done using SQL alone.
  • TRUE
  • FALSE
Show Answer
67. DML consists of commands that control the user access to the database objects
  • TRUE
  • FALSE
Show Answer
68. If nothing is specified, the result set is stored in descending order, which is the default.
  • TRUE
  • FALSE
Show Answer
69. '*' is used to get all the columns of a particular table.
  • TRUE
  • FALSE
Show Answer
70. The CREATIVE TABLE statement creates new base table.
  • TRUE
  • FALSE
Show Answer
Database
Questions and Answers for Competitive Exams Various Entrance Test