JOIN ADRE 2.0 Telegram Group

MySQL Quiz | MySQL Objective Type Questions and Answers

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

ADRE 2.0 FULL LENGTH MOCK TEST

Take Mock Tests

Missiles Mock Test Start Test!
SSC MTS Mock Test Start Test
IBPS CLERK MOCK TEST Start Test
SSC MTS 2022 JULY 26 Shift 1 (ENGLISH) Start Test!
SSC GD Previous Year Paper 2021 Nov 17 Shift - I (Hindi) Start Test!
SSC CGL Tier - 1 PYP 2022 April 21 Shift- 1 (ENGLISH) Start Test!
MPSC PAPER I MOCK TEST 1 (ENGLISH) Start Test!
IB Security Assistant Mock test 1 (english) Start Test!
UP POLICE CONSTABLE MOCK TEST 1 Start Test!
DELHI POLICE CONSTABLE MOCK TEST 1 (HINDI) Start Test!
Advertisement
Assam Direct Recruitment Test Series