MCQ's on Database Management System (DMBS)

You will find the correct answer of all the questions after you will submit the quiz. You will also get a report of your performance after you will submit the quiz.
Unlimited attempts possible to practice. On each attempts you will get a set of 25 questions.

Enter Your Name

MCQ 1:
Which of the field has width 8 bytes?

MCQ 2:
What is the size of Yes, No field?

MCQ 3:
Which key is uniquely identifies each record?

MCQ 4:
When you create or open the MS Access database file, command center of access file that appears

MCQ 5:
A database language concerned with the definition of the whole database structure and schema is ______________.

MCQ 6:
How to create a relationship between two tables in database.

MCQ 7:
If your entering all fields required for a table, if you realize that the third field is not needed, how will you remove?

MCQ 8:
To duplicate a controls formatting you can use ________________.

MCQ 9:
Which field type will you select when creating a new table if you require to enter long text in that field?

MCQ 10:
In table design view, what are the first column of buttons used for?

MCQ 11:
What does the show check box in query design window indicate?

MCQ 12:
Which of the following is not a type of relationship that can be applied in access database.

MCQ 13:
A ________________ name must be unique within a database.

MCQ 14:
This option allows you to build a new table by entering data directly into the datasheet.

MCQ 15:
To create queries in Access, what steps you do.

MCQ 16:
Which of the given is not a database model.

MCQ 17:
In table design view, which key can be used to switch between the field names and properties panels?

MCQ 18:
Which of the following is NOT a type of Microsoft Access database object?

MCQ 19:
Which is not a view to display a table in Access?

MCQ 20:
Which of the following database object hold data?

MCQ 21:
The _______________ button on the tool box display data from a related table.

MCQ 22:
The expression builder is an access tool that controls an expression ______________ for entering an expression.

MCQ 23:
A __________ enables you to view data from a table based on a specific criterion.

MCQ 24:
Which of the following database object produces the final result to present?

MCQ 25:
It is an association established between common fields of two tables.

MCQ 26:
Which of the following is not a field type in Access?

MCQ 27:
When entering field name, how many characters you can type in maximum?

MCQ 28:
It is a database object to view, change, and analyze data in different ways.

MCQ 29:
Which of the following creates a drop down list of values to choose from a list?

MCQ 30:
How to achieve AND effect when you are entering criteria in a query design window.

MCQ 31:
A search value can be an exact value or it can be.

MCQ 32:
What are the columns in a Microsoft Access table called?

MCQ 33:
What is a form in MS Access?

MCQ 34:
Every table in relational database contain a field or combination of fields that can uniquely identify each records, it is called.

MCQ 35:
You can automatically include all of the field in a table in a query by ______________ a strike that appear list box in query design view.

MCQ 36:
It is a sign or symbol that specifies, operator, and values that produce a result is an __________________.

MCQ 37:
What is the maximum length a text field can be?

MCQ 38:
Which control types is most often associated with a bound control?

MCQ 39:
Which of the following statement is true?

MCQ 40:
Microsoft Access is an

MCQ 41:
If you need to edit a relationship, you can do.

MCQ 42:
DCL (Data Control Language) provides commands to perform actions like.

MCQ 43:
Which of the following store command to retrieve data from database?

MCQ 44:
Both conditions display on the same row in the design grid when _________________ operator is in use.

MCQ 45:
If you write criteria values vertically (one in a row) it will mean.

MCQ 46:
The key uniquely identifies each record in a table.

MCQ 47:
What do you mean by one to many relationship between Student and Class table?

MCQ 48:
A part of database that stores only one type of data is

MCQ 49:
Which of the following may not be a database?

MCQ 50:
A database can be best described as

MCQ 51:
Which of the following term is least related to database?

MCQ 52:
Collection of related records in a database is known as

MCQ 53:
The task of arranging data in order is called

MCQ 54:
Each record is constituted by a number of individual data items which are called

MCQ 55:
Which of the following is not a database object in MS Access?

MCQ 56:
A database object in MS Access that stores a question about the data in database?

MCQ 57:
The complete information about an entity in a database is called

MCQ 58:
Database Management Systems are featured with

MCQ 59:
Which of the following can be an example of a database?

MCQ 60:
An Access database object that is used to enter, view or edit records

MCQ 61:
Which of the following expresses correct order?

MCQ 62:
If I create 'Student' field in 'Fees' table to store 'student_id' of 'Students' table, then this 'Student' field in 'Fees' table is called

MCQ 63:
A composite key is

MCQ 64:
A primary key in any table has the properties

MCQ 65:
To create primary key for a table when in design view

MCQ 66:
How can you link a table with another so that a field in current table will display values in drop down box from another table while entering data

MCQ 67:
An organized collection of logically related data is known as

MCQ 68:
In databases, Locking level is also called as

MCQ 69:
Which of the following is not a database application?

MCQ 70:
HSAM stands for _________________.

MCQ 71:
Which of the following is not a logical database structure?

MCQ 72:
In a datasheet, what does each column represent?

MCQ 73:
In a datasheet, what does each row represent?

MCQ 74:
A ________________ is a unit of information in a ________________.

MCQ 75:
What do you call a primary key field included in another table?

MCQ 76:
Which type of field is incremented automatically?

MCQ 77:
Which object is used to create a form?

MCQ 78:
What determines a table?s sort order?

MCQ 79:
What is an intersection of a row and a column?

MCQ 80:
Which tool do you use to create a query object?

MCQ 81:
Which of the following is not a view for interacting with a form object?

MCQ 82:
What is the purpose of indexing?

MCQ 83:
Which is the valid data type in Access?

MCQ 84:
How many relations may exist between tables in databases?

MCQ 85:
What is the full form of SQL?

MCQ 86:
Which data type is better to use for storing phone number in the following format - 111-2-1234567?

MCQ 87:
What do you call a collection of records matching parameters of a query?

MCQ 88:
Which query do you use for "Which employees earn more than Rs.5000 a month"?

MCQ 89:
Which criteria return only those addresses beginning with the letter "A"?

MCQ 90:
Which criteria do not return the position "Officer" as a match?

MCQ 91:
Which query do you use to answer the question "What is the average salary of the employees"?

MCQ 92:
What is the result of the query "Select * from customer where c_id > 10 and c_id < 100".

MCQ 93:
How to make a date field DOB store the dates format like "2002/10/17".

MCQ 94:
You have field Gender of type Byte Number. How to limit its value to 0 and 1 only?

MCQ 95:
In an application created using the database wizard, the main menu is presented as a:

MCQ 96:
Which leads you through the process of creating a table?

MCQ 97:
Which data type is better to use for storing the price of an item?

MCQ 98:
Which do you click to display the table?s primary key and indexes in a separate window?

MCQ 99:
After right click the field selector button, which do you choose to delete a field in design view?

MCQ 100:
Which tool is used to generate printout of a table's structure?

MCQ 101:
Which of the following is not a legitimate section for form objects?

MCQ 102:
The basic elements of a form or a report are called

MCQ 103:
Which control type do you use to create a calculated control?

MCQ 104:
Which is not a view for displaying a report object?

MCQ 105:
The report footer section is most useful for displaying

MCQ 106:
Which function can not be used for calculated controls in a report?

MCQ 107:
Which of the following is invalid field name?

MCQ 108:
Primary key is

MCQ 109:
Which of the following is use to view or print the data in organized manner?

MCQ 110:
In a table to insert User's Voice, Data field should be

MCQ 111:
After creating the table which of the following is correct?

MCQ 112:
Validation Rule in a field will

MCQ 113:
Query can be use to select data from

MCQ 114:
Which of the following is the DBMS type

MCQ 115:
A collection of related tables is called

MCQ 116:
Relationship can be establish between two tables by

MCQ 117:
Which of the following gives a logical structure of the database graphically?

MCQ 118:
The entity relationship set is represented in E-R diagram as

MCQ 119:
The Rectangles divided into two parts represents

MCQ 120:
Consider a directed line (->) from the relationship set advisor to both entity sets instructor and student. This indicates ________________ cardinality.

MCQ 121:
We indicate roles in E-R diagrams by labeling the lines that connect ________________ to ______________.

MCQ 122:
An entity set that does not have sufficient attributes to form a primary key is termed a _______________.

MCQ 123:
For a weak entity set to be meaningful, it must be associated with another entity set, called the?

MCQ 124:
Weak entity set is represented as

MCQ 125:
If you were collecting and storing information about your music collection, an album would be considered a(n) _______________.

MCQ 126:
What term is used to refer to a specific record in your music database; for instance; information stored about a specific album?

MCQ 127:
Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?

MCQ 128:
Consider attributes ID, CITY and NAME. Which one of this can be considered as a super key?

MCQ 129:
The subset of a super key is a candidate key under what condition?

MCQ 130:
Which one of the following attribute can be taken as a primary key?

MCQ 131:
Which one of the following cannot be taken as a primary key?

MCQ 132:
An attribute in a relation is a foreign key if the _________________ from one relation is used as an attribute in that relation.

MCQ 133:
The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as a primary key is called ___________________.

MCQ 134:
A ________________ consists of a sequence of query and/or update statements.

MCQ 135:
Which of the following makes the transaction permanent in the database?

MCQ 136:
In order to undo the work of transaction after last commit which one should be used?

MCQ 137:
What does Rollback do?

MCQ 138:
In case of any shut down during transaction before commit which of the following statement is done automatically?

MCQ 139:
In order to maintain the consistency during transactions, database provides

MCQ 140:
Transaction processing is associated with everything below except

MCQ 141:
A transaction completes its execution is said to be

MCQ 142:
Which of the following is used to get back all the transactions back after rollback?

MCQ 143:
_____________________ will undo all statements up to commit?

MCQ 144:
A system is in a ___________________ state if there exists a set of transactions such that every transaction in the set is waiting for another transaction in the set.

MCQ 145:
The deadlock state can be changed back to stable state by using _______________ statement.

MCQ 146:
What are the ways of dealing with deadlock?

MCQ 147:
The situation where the lock waits only for a specified amount of time for another lock to be released is

MCQ 148:
The deadlock in a set of a transaction can be determined by

MCQ 149:
A deadlock exists in the system if and only if the wait-for graph contains a ___________

MCQ 150:
Selecting the victim to be rollbacked to the previous state is determined by the minimum cost. The factors determining cost of rollback is

MCQ 151:
__________________ rollback requires the system to maintain additional information about the state of all the running transactions.

MCQ 152:
In the relational model, cardinality is termed as:

MCQ 153:
Relational calculus is a

MCQ 154:
The view of total database content is

MCQ 155:
Cartesian product in relational algebra is

MCQ 156:
DML is provided for

MCQ 157:
in sql query, "AS" clause is used for

MCQ 158:
ODBC stands for

MCQ 159:
Architecture of the database can be viewed as

MCQ 160:
In a relational model, relations are termed as

MCQ 161:
The database schema is written in

MCQ 162:
In the architecture of a database system external level is the

MCQ 163:
An entity set that does not have sufficient attributes to form a primary key is a

MCQ 164:
In Hierarchical model records are organised as

MCQ 165:
In an E-R diagram attributes are represented by

MCQ 166:
In case of entity integrity, the primary key maybe

MCQ 167:
The language used in application programs to request data from the DBMS is referred to as the

MCQ 168:
Related fields in a database are grouped to form a

MCQ 169:
The database environment has all of the following components except:

MCQ 170:
The language which has recently become the defacto standard for interfacing application programs with relational database system is

MCQ 171:
The way a particular application views the data from the database that the application uses is a

MCQ 172:
In an E-R diagram an entity set is represent by a

MCQ 173:
A report generator is used to

MCQ 174:
The DBMS language component which can be embedded in a program is

MCQ 175:
A relational database developer refers to a record as

MCQ 176:
The relational model feature is that there

MCQ 177:
The method in which records are physically stored in a specified order according to a key field in each record is

MCQ 178:
A subschema expresses

MCQ 179:
Count function in SQL returns the number of

MCQ 180:
Which one of the following statements is false?

MCQ 181:
An advantage of the database management approach is

MCQ 182:
A DBMS query language is designed to

MCQ 183:
Transaction processing is associated with everything below except

MCQ 184:
It is possible to define a schema completely using

MCQ 185:
The method of access which uses key transformation is known as

MCQ 186:
The statement in SQL which allows changing the definition of a table is

MCQ 187:
ER model uses this symbol to represent a weak entity set?

MCQ 188:
SET concept is used in

MCQ 189:
Relational Algebra is

MCQ 190:
Key to represent the relationship between tables is called

MCQ 191:
___________________ produces the relation that has attributes of R1 and R2

MCQ 192:
The file organisation that provides very fast access to any arbitrary record of a file is

MCQ 193:
Which of the following is correct.

MCQ 194:
It is better to use files than a DBMS when there are

MCQ 195:
The conceptual model is

MCQ 196:
What is a relationship called when it is maintained between two entities?

MCQ 197:
Which of the following operation is used if we are interested in only certain columns of a table?

MCQ 198:
Which of the following is a valid SQL type?

MCQ 199:
The RDBMS terminology for a row is

MCQ 200:
Which of the following operations need the participating relations to be union compatible?

MCQ 201:
The full form of DDL is

MCQ 202:
Which of the following is an advantage of view?

MCQ 203:
Which of the following is a legal expression in SQL?

MCQ 204:
Which database level is closest to the users?

MCQ 205:
Which of the following is a comparison operator in SQL?

MCQ 206:
A set of possible data values is called

MCQ 207:
Which of the operations constitute a basic set of operations for manipulating relational data?

MCQ 208:
Which of the following is another name for the weak entity?

MCQ 209:
Which of the following database object does not physically exist?

MCQ 210:

MCQ 211:
Which of the following is a record based logical model?

MCQ 212:
A data dictionary is a special file that contains:

MCQ 213:
A file manipulation command that extracts some of the records from a file is called

MCQ 214:
A primary key is combined with a foreign key creates

MCQ 215:
In E-R Diagram derived attribute is represented by

MCQ 216:
Cross Product is a

MCQ 217:
The natural join is equal to

MCQ 218:
Which one of the following is not true for a view

MCQ 219:
A primary key, if combined with a foreign key, creates

MCQ 220:
In E-R Diagram relationship type is represented by

MCQ 221:
Hierarchical model is also called

MCQ 222:
To delete a particular column in a relation the command used is

MCQ 223:
The _______________ operator is used to compare a value to a list of literals values that have been specified.

MCQ 224:
A logical schema

MCQ 225:
A B-tree of order m has maximum of _________________ children.

MCQ 226:
________________ function divides one numeric expression by another and returns the remainder.

MCQ 227:
A data manipulation command the combines the records from one or more tables is called

MCQ 228:
In E-R diagram generalisation is represented by

MCQ 229:
_________________ is a virtual table that draws its data from the result of an SQL SELECT statement.

MCQ 230:
The method of access which uses key transformation is known as

MCQ 231:
A table joined with itself is called

MCQ 232:
________________ data type can store unstructured data

MCQ 233:
What is a candidate key?

MCQ 234:
Which of these commands will delete a table called AAAA if you have appropriate authority.

MCQ 235:
Can I define multiple unique constraints on a table?

MCQ 236:
Drop Table cannot be used to drop a table referenced by a ______________ constraint.

MCQ 237:
Insert into instructor values (1001, 'Rajiv Sharma', 'PHP Language', 101); What type of statement is this?

MCQ 238:
If there is more than one key for relation schema in DBMS then each key in relation schema is classified as ________________.

MCQ 239:
__________ is an Aggregate function in SQL.

MCQ 240:
A relational database consists of a collection of

MCQ 241:
Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?

MCQ 242:
Which one is the correct declaration for choosing the character set other than default?

MCQ 243:
SQL Select statement to retrieve unique record from a table is

MCQ 244:
Correct SQL query to delete a column from a table in SQL Server database

MCQ 245:
Which of the following is not a User defined function?

MCQ 246:
With SQL, how do you select all the columns from a table named "Persons"?

MCQ 247:
Which SQL statement is used to extract data from a database?

MCQ 248:
How do you select all the records from a table named "records" where the value of the column "FirstName" is "Rajiv"?

MCQ 249:
Which SQL statement is used to create a table in a database?

MCQ 250:
How can you return the number of records in the "records" table?

MCQ 251:
How can you delete the records where the "FirstName" is "Rajiv" in the records Table?

MCQ 252:
How can you insert a new record into the "records" table?

MCQ 253:
Which SQL statement is used to return only different values?

MCQ 254:
The SQL used by front-end application programs to request data from the DBMS is called ______________

MCQ 255:
The command used to delete a particular column in a relation is ___________________

MCQ 256:
Which of the following is a comparison operator in SQL?

MCQ 257:
The COUNT function in SQL returns the number of ______________.

MCQ 258:
Which data type can store unstructured data in a column?

MCQ 259:
What is the full form of sql?

MCQ 260:
Which of the following is a sql AGGREGATE Function

MCQ 261:
Which of the group functions ignonre null values?

MCQ 262:
The UNION SQL clause can be used with _____________

MCQ 263:
All aggregate functions except __________ ignore null values in their input collection.

MCQ 264:
Which of the following is not Constraint in SQL?

MCQ 265:
Difference between a primary key and a unique key?

MCQ 266:
Which of the following is true for TRUNCATE in SQL?

MCQ 267:
Default size of n in a column which is defined as VARCHAR(n)?

MCQ 268:
Which of the following is not an aggregate function?