Computer Science

RDBMS MCQs

Total Questions : 32

Page 1 of 4 pages
Question 1. Which of the following is not a definition of NULL Value?
  1.    NULL is not the same as zero or a blank space
  2.    Arithmetic operations on a NULL value does not always return a NULL Value
  3.    NULL Value is the absence of any character,zero,blank space
  4.    none of the above
 Discuss Question
Answer is Option B. -> Arithmetic operations on a NULL value does not always return a NULL Value
Question 2. The restrictions or conditions applied on data are known as ______________
  1.    Constraints
  2.    data models
  3.    relations
  4.    none of the above
 Discuss Question
Answer is Option A. -> Constraints
Question 3. The Oracle environment of database is called as ___________
  1.    Database Schema
  2.    Database Instances
  3.    Data Structure
  4.    All of the Mentioned
 Discuss Question
Answer is Option A. -> Database Schema
Question 4. Which of the following SQL clauses is used to DELETE tuples from a database table?
  1.    DELETE
  2.    REMOVE
  3.    DROP
  4.    CLEAR
 Discuss Question
Answer is Option A. -> DELETE
Question 5. An attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation
  1.    Candidate
  2.    Primary
  3.    Super
  4.    Sub
 Discuss Question
Answer is Option B. -> Primary
Question 6. The HAVING clause does which of the following?
  1.    Acts like a WHERE clause but is used for groups rather than columns.
  2.    Acts like a WHERE clause but is used for rows rather than columns.
  3.    Acts like a WHERE clause but is used for columns rather than groups.
  4.    Acts like a WHERE clause but is used for groups rather than rows.
 Discuss Question
Answer is Option A. -> Acts like a WHERE clause but is used for groups rather than columns.
Question 7. The term attribute refers to a ___________ of a table
  1.    Record
  2.    Tuple
  3.    Column
  4.    Key
 Discuss Question
Answer is Option C. -> Column
Question 8. Which one of the following is used to define the structure of the relation, deleting relations and relating schemas?
  1.    DML(Data Manipulation Langauge)
  2.    DDL(Data Definition Langauge)
  3.    Query
  4.    Relational Schema
 Discuss Question
Answer is Option B. -> DDL(Data Definition Langauge)
Question 9. Logical design of database, is known to be
  1.    Database relation
  2.    Database instance
  3.    Database entity
  4.    Database Schema
 Discuss Question
Answer is Option D. -> Database Schema
Question 10. The set of all possible values that an attribute may contain is called the ___________ of an attribute
  1.    Domain
  2.    Relation
  3.    Set
  4.    Schema
 Discuss Question
Answer is Option A. -> Domain