Download PDF
Free download in PDF MySQL Objective Type Questions and Answers for competitive exams. These short objective type questions with answers are very important for Board exams as well as competitive exams. These short solved questions or quizzes are provided by Gkseries.
(21)
The number of attributes in relation is called as its
[A]
Cardinality
[B]
Entity
[C]
Tuples
[D]
Degree
(22)
The term attribute refers to a ___________ of a table.
[A]
Record
[B]
Column
[C]
Tuple
[D]
Key
(23)
Insert into instructor values (10211, 'Smith', 'Biology', 66000); What type of statement is this?
[A]
Query
[B]
DML
[C]
Relational
[D]
DDL
(24)
To remove a relation from an SQL database, we use the ______ command.
[A]
Delete
[B]
Purge
[C]
Remove
[D]
Drop table
(25)
If there is more than one key for relation schema in DBMS then each key in relation schema is classified as
[A]
Prime key
[B]
Super key
[C]
Candidate key
[D]
Primary key
(26)
The primary key is selected from the:
[A]
composite keys.
[B]
determinants
[C]
foreign keys
[D]
candidate keys
(27)
In SQL, __________ is an Aggregate function.
[A]
SELECT
[B]
CREATE
[C]
AVG
[D]
MODIFY
(28)
Drop table structure is
[A]
DML Statement
[B]
DDL Statement
[C]
Query Statement
[D]
None of the above
(29)
MVD is called as
[A]
Many Value Dependency
[B]
More Value Dependency
[C]
Multi Value Dependency
[D]
all of the above
Answer: Multi Value Dependency
(30)
The value of Primary key
[A]
can be duplicated
[B]
can be null
[C]
cannot be null
[D]
none of these
31
A table that displays data redundancies yields ________ anomalies
[A]
Insertion
[B]
Deletion
[C]
Update
[D]
All of the above
32
Commit command is used for
[A]
To restore the old values
[B]
To save the current table
[C]
To save the current transaction
[D]
To recover the old table
Answer: To save the current transaction
33
Create table employee (name varchar ,id integer) What type of statement is this ?
[A]
DML
[B]
View
[C]
DDL
[D]
Integrity constraint
34
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 ?
[A]
DML(Data Manipulation Langauge)
[B]
DDL(Data Definition Langauge)
[C]
Query
[D]
Relational Schema
Answer: DML(Data Manipulation Langauge)
35
A relational database consists of a collection of
[A]
Table
[B]
Fields
[C]
Records
[D]
Keys
36
Which of the following statements creates a new table temp instructor that has the same schema as instructor.
[A]
create table temp_instructor;
[B]
Create table temp_instructor like instructor;
[C]
Create Table as temp_instructor;
[D]
Create table like temp_instructor;
Answer: Create table temp_instructor like instructor;
37
A attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation .
[A]
Candidate
[B]
Primary
[C]
Super
[D]
Sub
38
A _____ is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.
[A]
Rows
[B]
Key
[C]
Attribute
[D]
Fields
39
Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?
[A]
Candidate key
[B]
Sub key
[C]
Super key
[D]
Foreign key
40
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:
[A]
Left outer join
[B]
Full outer join
[C]
Right outer join
[D]
Half outer join
Take Mock Tests