Data Base Management System (DBMS)/Data Base Management System (DBMS) Mcq set 2 Sample Test,Sample questions

  1. Home
  2. Back

Question: 
 A ________ provides a systematic way of storing information into the database.

1.Report

2.Query

3.Formic

4.None of the above

Posted Date:-2021-12-06 13:28:31

Question: 
 select * from Stud order by “Rollno” ASC;

1.display all the records of table.

2.display records in increasing order of roll number.

3.both of the above

4.None of the above

Posted Date:-2021-12-06 13:21:15

Question: 
A foreign key is a reference of the ________ key in another table.

1.Alternate

2.Primary

3.Candidate

4.None of the above

Posted Date:-2021-12-06 13:41:22

Question: 
A key which is referring to the primary key of another table is called __

1.Common

2.Same

3.Unique

4.None of the above

Posted Date:-2021-12-06 11:56:37

Question: 
A _______ helps to collect specific information from the pool of data.

1.Query

2.Report

3.Form

4.None of the above

Posted Date:-2021-12-06 13:36:21

Question: 
All the values in ________ are of same type.

1.Records

2.Table

3.Database

4.Fields

Posted Date:-2021-12-06 12:01:56

Question: 
Auto Value is a property of __ data type .

1.Numeric

2.Character

3.Binary

4.Date

Posted Date:-2021-12-06 12:25:29

Question: 
By default data is arranged in _____ order using order by clause.

1.Ascending

2.Descending

3. Primary Key

4.None of the above

Posted Date:-2021-12-06 13:24:33

Question: 
By default data type of fields is.

1.Text[Varchar]

2.Text[Char]

3. Int

4.Long

Posted Date:-2021-12-06 12:11:02

Question: 
By default the length of the Integer data type is ______________

1.10

2.15

3.20

4.25

Posted Date:-2021-12-06 12:28:07

Question: 
By default the length of Varchar data type is __

1.20

2.30

3.40

4.50

Posted Date:-2021-12-06 12:12:49

Question: 
By default the name of the table is ______

1.Tab 1

2.Table 1

3.First Table

4.Untitled 1

Posted Date:-2021-12-06 12:14:45

Question: 
Char is a ______ length data type and varchar is a ______ length data type.

1.Fixed, Variable

2.Variable, Fixed

3.Variable, Variable

4.Fixed, Fixed

Posted Date:-2021-12-06 12:24:06

Question: 
Command to display all the data in the table “emp” is.

1.Select * from emp

2.Select * from emp;

3.Select all from emp

4.Select all from emp;

Posted Date:-2021-12-06 12:50:36

Question: 
Command to display all the data in the table “emp” is.
a.

1.Select * from emp

2.Select * from emp;

3.Select all from emp

4.Select all from emp;

Posted Date:-2021-12-06 12:49:29

Question: 
Command to increase the salary of all employees by 15000.(table name emp and column name sal)

1.update emp set sal = sal + 15000;

2.update emp set sal = 15000;

3.update set sal = sal + 15000;

4.None of the above

Posted Date:-2021-12-06 13:22:22

Question: 
DML stands for ____________

1.Data Manipulation Language

2.Database Manipulation Language

3.Data Modify Language

4.All the above

Posted Date:-2021-12-06 12:46:11

Question: 
Identify the Foreign Key from table “Sales”
Table Client:
ClientID (primary Key)
clientname
clientphone

Table : Sales
SalesID (Primary Key)
ClientID
Profit

1.SalesID

2.Profit

3.Clientphone

4.ClientID

Posted Date:-2021-12-06 11:58:36

Question: 
In a table we can have only ______ primary key.

1.1

2.2

3.3

4.more than 3

Posted Date:-2021-12-06 13:42:44

Question: 
In Base data can be linked between two or more tables with the help of _________________

1.primary key

2.foreign key

3.primary and foreign key

4.None of the above

Posted Date:-2021-12-06 12:37:41

Question: 
In RDBMS, data is organized in the form of __________________

1.Table

2.Record

3.Field

4.None of the above

Posted Date:-2021-12-06 12:00:30

Question: 
In which mode we can change the structure of table?

1.Datasheet view

2.Design view

3.Structure view

4.All the above

Posted Date:-2021-12-06 12:35:48

Question: 
In which view data can be entered in table?

1.Datasheet view

2.Design view

3.Both of the above

4.None of the above

Posted Date:-2021-12-06 12:33:59

Question: 
Relationship between tables can be created from _____________________ menu.

1.View

2.Insert

3.Windows

4.Tools

Posted Date:-2021-12-06 12:39:15

Question: 
Relationship can be created between

1.two tables only

2.one table only

3.two or more tables

4.None of the above

Posted Date:-2021-12-06 12:38:27

Question: 
Select “empname”, “salary” * 3 from emp;

1.will increase the salary three times of all employees in table

2.display name and three times salary

3.give error

4.None of the above

Posted Date:-2021-12-06 12:55:42

Question: 
Select “salary” from emp;

1.will display all the records of table emp

2.will display only particular columns of table emp

3.will display only salary column of table emp;

4.None of the above

Posted Date:-2021-12-06 12:54:33

Question: 
Shortcut to execute query in Create Query in SQL View is __

1. F7 Key

2.F5 Key

3.F8 Key

4.F6 Key

Posted Date:-2021-12-06 12:52:25

Question: 
Sorting means to arrange data in _______________ order.

1.increasing

2.decreasing

3.increasing or decreasing

4.All the above

Posted Date:-2021-12-06 12:36:27

Question: 
SQL stands for _________________

1.Structured Queue Language

2.Structured Query Language

3.Structured Query Lang

4.None of the above

Posted Date:-2021-12-06 12:01:14

Question: 
SQL stands for __________________

1.Structural Query Language

2.Structured Query Language

3.Skeletal Query Language

4.None of the above

Posted Date:-2021-12-06 12:42:32

Question: 
There are __________________ types of relationship which can be created between tables.

1.three

2.two

3.four

4.infinite

Posted Date:-2021-12-06 12:40:05

Question: 
To get details about the list of students whose favorite color is blue. Query for this is :

1.select all from Stud where fav_Color=’Blue’;

2.select name from Stud where fav_Color=’Blue’;

3.To get details about the list of students whose favorite color is blue. Query for this is :

4.select all from Stud where fav_Color is ’Blue’;

Posted Date:-2021-12-06 13:16:40

Question: 
We can create query (in Open Office Base) in _______________________

1.In design view

2.Using wizard

3.Both of the above

4.None of the above

Posted Date:-2021-12-06 12:41:41

Question: 
We can create table :

1.in design view

2.use Wizard

3.Both of the above

4.None of the above

Posted Date:-2021-12-06 12:09:02

Question: 
We can ____________________ data in table.

1.modify

2.insert

3.delete

4.All the above

Posted Date:-2021-12-06 12:33:12

Question: 
When data is stored, maintained and retrieved from multiple tables then special database software are required called _

1.DBMS

2.RDBMS

3.Special DBMS

4.All the above

Posted Date:-2021-12-06 11:57:25

Question: 
When primary key is made up of two or more columns then it is called __ primary key.

1.Mixed

2.Reference

3.Composite

4.Compost

Posted Date:-2021-12-06 11:55:53

Question: 
Which command is used to display the salary of all the employees after incrementing by 1000.

1.Select

2.b. Update

3.Modify

4.Change

Posted Date:-2021-12-06 12:53:31

Question: 
Which data type is used to store value of fields like “Date of Birth”?

1.Date Time

2.Varchar

3.Integer

4.Other

Posted Date:-2021-12-06 12:31:56

Question: 
Which data type will be appropriate to store information as Salary, Fees, Price etc
b. Alphanumeric Data types

1.Alphanumeric Data types

2.Numeric Data type

3.Binary Data types

4.Date Time

Posted Date:-2021-12-06 12:17:14

Question: 
Which field is suitable for storing records of employees?

1.EmpNo

2.Empname

3.Salary

4.All the above

Posted Date:-2021-12-06 12:24:48

Question: 
Which language help to extract/fetch data from table?

1.MySQL

2.Python

3.OOBase

4.HTML

Posted Date:-2021-12-06 12:40:51

Question: 
Which of the following act as an interface to view, enter and change data in database?

1.Report

2.Table

3.Query

4.Form

Posted Date:-2021-12-06 13:35:02

Question: 
Which of the following clause return records in ascending order?

1.Order By

2.Where

3.Order Asc

4.Order Inc

Posted Date:-2021-12-06 12:48:14

Question: 
Which of the following clause return specific rows?

1.Order By

2.Where

3.Having

4.Specific

Posted Date:-2021-12-06 12:47:07

Question: 
Which of the following data types can not store decimal values?

1.Decimal

2.Real

3.Numeric

4.Boolean

Posted Date:-2021-12-06 12:21:44

Question: 
Which of the following field is invalid for storing information of “Library” Table?

b. 

c. 

d.

1.Cost

2.Booknumber

3.Authorname

4.Dateofbirth

Posted Date:-2021-12-06 13:39:03

Question: 
Which of the following is DML commands?

1.Insert

2.Update

3.Delete

4.All the above

Posted Date:-2021-12-06 13:27:38

Question: 
Which of the following is not a numeric data type?

1.Tinyint

2.Smallint

3.Boolean

4.Date

Posted Date:-2021-12-06 12:20:55

Question: 
Which of the following is not the binary data types?

1.Longvarbinary

2.Varbinary

3.Binary

4.Charbinary

Posted Date:-2021-12-06 12:29:54

Question: 
Which of the following is not the date time data types?

1.Date

2.Time

3.Datestamp

4.Timestamp

Posted Date:-2021-12-06 12:31:04

Question: 
Which of the following is not valid field of table “Student”
a. admno

b.name

c. fees

d. salary

1.admno

2.name

3.fees

4.salary

Posted Date:-2021-12-06 11:59:19

Question: 
Which of the following is suitable to act as a primary key in table student?

1.Rollno

2.Name

3.Class

4.Section

Posted Date:-2021-12-06 13:40:24

Question: 
Which of the following is to be created first?

1.Report

2.Query

3.Form

4.Table

Posted Date:-2021-12-06 13:37:21

Question: 
Which of the following property help to set the number of characters in Varchar type.

1.Auto value

2.Required

3.Default Value

4.Length

Posted Date:-2021-12-06 12:26:28

Question: 
Which of the following property to be turned “yes” so that value will be auto incremented?

1.Default

2.Format

3.Auto value

4.Length

Posted Date:-2021-12-06 12:28:56

Question: 
Which of the following will occupy more space in computer memory?

1.Bigint

2.Integer

3.Smallint

4.Boolean

Posted Date:-2021-12-06 12:22:30

Question: 
Which property ensures that field can not be left blank?

1.Entry required

2.Format

3.Required Entry

4.Required

Posted Date:-2021-12-06 12:27:20

Question: 
_ represent a single data item in a table.

1.Tuples

2.Attributes

3.Relation

4.All the above

Posted Date:-2021-12-06 12:04:02

Question: 
__ data types are used for storing photos, music files etc

1.Binary

2.Alphanumeric

3.Numeric

4.Special

Posted Date:-2021-12-06 12:23:14

Question: 
___ are used to identify which type of data we are going to store in the database.

1.Datatype

2.Record

3.Table

4.Attributes

Posted Date:-2021-12-06 12:15:45

Question: 
________ are the basic building blocks of a database.

1.Tables

2.Record

3.Fields

4.All the above

Posted Date:-2021-12-06 12:06:15

Question: 
_________ is the most common DML command.

1.Delete

2.Update

3.Select

4.All the above

Posted Date:-2021-12-06 12:45:19

Question: 
_________ statement is used to retrieve data from table.

1.Delete

2.Update

3.Print

4.Select

Posted Date:-2021-12-06 12:44:24

Posted on by R4R Team

More MCQS

  1. Data Base Management System (DBMS) Mcq set 1
  2. Data Base Management System (DBMS) Mcq set 2
  3. DBMS Multiple Choice Questions and Answers
  4. Basics of Database Management System (DBMS) Set 1
  5. Basics of Database Management System (DBMS) Set 2
  6. Basics of Database Management System (DBMS) Set 3
Search
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!