........................... is the most common DML command.

All the values in ........................ are of same type.

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

Only numeric fields can act as a primary key in a table.

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

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

Which of the following is not valid field in table “Student”?

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

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

Relationship between tables can be created from .............................. menu.

Which command is used to display the salary of all the employees after incrementing by 1000?

Relationship can be created between

select * from Stud order by “Rollno” ASC;

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

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

In which view data can be entered in table?

By default, the length of the Integer data type is ............................

Which of the following is DML commands?

Which of the following will help to maintain unique record in the table?

A foreign key is a primary key in another table.

We cannot delete the data using queries.

Duplicate values can be entered in Foreign key.

SQL stands for ..........................

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

We can ....................... data in table.

By default, the name of the table is ...........................

A field which is ............................ for each and every record is called Primary key.

Which of the following software is appropriate to store data about school students?

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

Which of the following clause return specific rows?

Every row in a table has the same structure.

Shortcut to execute query in Create Query in SQL View is ........................

Base automatically adds the column as Primary Key if we don’t add it.

Primary key increases data redundancy.

By default, data type of fields is.

Sorting means to arrange data in ............................. order.

Which of the following is not the binary data types?

In Base data can be linked between two or more tables with the help of ......................

Referential Integrity is used to maintain accuracy and consistency of data in a relationship.

Which of the following clause return records in ascending order?

In RDBMS, data is organized in the form of ..........................

......................... are the basic building blocks of a database.

After inserting records in table, we can not modify the structure of table.

A database can have only one table.

Which command is used to create table?

There can be multiple primary keys in a table.

Which of the following is not a database program?

.......................... represent a single data item in a table.

Which of the following is to be created first?

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

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

Update statement is used to modify data in a table.

Duplicate values can be entered in primary key.

Which field is suitable for storing records of employees?

Duplication of data is called ............................ .

A key which is referring to the primary key of another table is called ..........................

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

By default, the length of Varchar data type is ...........................

Which of the following is not an advantage of database?

In tables, data is organized in the form of rows and columns.

A ........................... helps to display the data in a summarized data.

To get details about the list of students whose favourite colour is blue. Query for this is:

Which command is used to delete data from table?

A record in table is also known as Attribute.

In primary key we can enter NULL values.

Which of the following data types cannot store decimal values?

.......................... tables can be created in a database.

SQL stands for .............................

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

We can create table:

........................ are dedicated computers that hold the actual databases and run only DBMS and related Software.

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

........................ store data in Single table.

Open Office base is not an open-source software.

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

Which of the following is not a numeric data type?

In which mode we can change the structure of table?

Select “salary” from emp;

DML stands for .........................

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

........................ data types are used for storing photos, music files etc

Which language help to extract/fetch data from table?

In a table we can have only ........................... primary key.

............................. statement is used to retrieve data from table.

A table is a collection of logically related data.

Which of the following field of table “Book” can act as primary key?

Which of the following property helps to set the number of characters in Varchar type?

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

We can create query (in Open Office Base) in ......................... .

Which property ensures that field cannot be left blank?

Which command is used to modify data in table?

Auto Value is a property of ........................... data type.

Which data type will be appropriate to store information as Salary, Fees, Price etc?

A database is an organized collection of ............................... .

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

By default, data is arranged in .............................. order using order by clause.

GUI act as front end and database server act as .......................

Data Integrity means that data is accurate and consistent in the database.

Queries are commands that are used to define the structure and modify the data in a table.

Char is a ....................... length data type and varchar is a ........................... length data type.