Mysql Multiple Choice Questions

  1. Which join refers to join records from the write table that have no matching key in the left table are include in the result set:
    1. Left outer join
    2. Full outer join
    3. Right outer join
    4. Half outer join
Answer :
C
Explanation:
Added By : Prachi Gupta

  1. Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?
    1. Candidate key
    2. Sub key
    3. Super key
    4. Foreign key
Answer :
C
Explanation:
Added By : Prachi Gupta


  1. A _____ is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.
    1. Rows
    2. Key
    3. Attribute
    4. Fields
Answer :
B
Explanation:
Added By : Prachi Gupta

  1. A 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
Answer :
B
Explanation:
Added By : Prachi Gupta

  1. Which of the following statements creates a new table temp instructor that has the same schema as instructor.
    1. create table temp_instructor;
    2. Create table temp_instructor like instructor;
    3. Create Table as temp_instructor;
    4. Create table like temp_instructor;
Answer :
B
Explanation:
Added By : Prachi Gupta

  1. A relational database consists of a collection of
    1. Table
    2. Fields
    3. Records
    4. Keys
Answer :
A
Explanation:
Added By : Prachi Gupta


  1. Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database ?
    1. DML(Data Manipulation Langauge)
    2. DDL(Data Definition Langauge)
    3. Query
    4. Relational Schema
Answer :
A
Explanation:
Added By : Prachi Gupta

  1. Create table employee (name varchar ,id integer) What type of statement is this ?
    1. DML
    2. View
    3. DDL
    4. Integrity constraint
Answer :
C
Explanation:
Added By : Prachi Gupta

Social Sharing
Search