MySQL Quiz | MySQL Objective Type Questions and Answers

Sports GK Questions and Answers 2024 (Latest Updated)

Awards & Honours GK Questions 2024 (Latest Updated)

Questions
21 The number of attributes in relation is called as its
A Cardinality
B Entity
C Tuples
D Degree

Answer: Degree
22 The term attribute refers to a ___________ of a table.
A Record
B Column
C Tuple
D Key

Answer: Column
Advertisement
Article and Schedule Quiz Start Test!
DOWNLOAD CURRENT AFFAIRS PDF FROM APP
23 Insert into instructor values (10211, 'Smith', 'Biology', 66000); What type of statement is this?
A Query
B DML
C Relational
D DDL

Answer: DML
24 To remove a relation from an SQL database, we use the ______ command.
A Delete
B Purge
C Remove
D Drop table

Answer: 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

Answer: Candidate key
26 The primary key is selected from the:
A composite keys.
B determinants
C foreign keys
D candidate keys

Answer: candidate keys
27 In SQL, __________ is an Aggregate function.
A SELECT
B CREATE
C AVG
D MODIFY

Answer: AVG
28 Drop table structure is
A DML Statement
B DDL Statement
C Query Statement
D None of the above

Answer: DDL Statement
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

Answer: cannot be null
31 A table that displays data redundancies yields ________ anomalies
A Insertion
B Deletion
C Update
D All of the above

Answer: 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

Answer: DDL
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

Answer: Table
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

Answer: Primary
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

Answer: Key
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

Answer: Super 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

Answer: Right outer join
Assam Direct Recruitment Test Series

Teacher Eligibility Test

Assam Direct Recruitment Test Series