Rdbms(Computer Science ) Questions and Answers

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
Explanation:-
Answer: 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
Explanation:-
Answer: 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
Explanation:-
Answer: 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
Explanation:-
Answer: 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
Explanation:-
Answer: 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.
Explanation:-
Answer: 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
Explanation:-
Answer: 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
Explanation:-
Answer: 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
Explanation:-
Answer: 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
Explanation:-
Answer: Option A. -> Domain
© Lakshya_Education.com, All Right Reserved.
Contact Us services