-
question_answer1)
Database is an organised collection of.....................
A)
Data done
clear
B)
Attributes done
clear
C)
Record done
clear
D)
None of the above done
clear
View Solution play_arrow
-
question_answer2)
DBMS stands for.....................
A)
Database Management System done
clear
B)
Database Master System done
clear
C)
Database Management Structure done
clear
D)
None of the above done
clear
View Solution play_arrow
-
question_answer3)
RDBMS stands for
A)
Relation Data Module System done
clear
B)
Right Data Base Management System done
clear
C)
Relational Database Management System done
clear
D)
None of the above done
clear
View Solution play_arrow
-
question_answer4)
A DVD store maintains a customer database. Each new customer is asked to complete a form by providing his or her contact details, including address, phone numbers and email contact. Each time a customer borrows a DVD, the customer is asked to confirm his or her address details only, and updates are made as needed. Which statement about the quality of this data is true?
A)
The data quality is good because the data stored is always up to date. done
clear
B)
The data quality is good because the data stored is constantly revised. done
clear
C)
The data quality is poor because much of the data could be out of date and there is no way of checking. done
clear
D)
The data quality is poor because there are no verification procedures in place to ensure it is accurate. done
clear
View Solution play_arrow
-
question_answer5)
Which of the following is not an example of a database?
A)
Cross n Knot Game done
clear
B)
Employee Payroll Management done
clear
C)
Numeric Calculator done
clear
D)
Customer Management System done
clear
View Solution play_arrow
-
question_answer6)
Out of the following, which one is the most appropriate data field in context of the employee table if only one of these is required?
A)
Age in years done
clear
B)
Date of birth done
clear
C)
Age in days done
clear
D)
Age in months done
clear
View Solution play_arrow
-
question_answer7)
Which is not true for a database file?
A)
Each record may contain several fields done
clear
B)
Fields are organised in columns done
clear
C)
Data types have to be declared in advance done
clear
D)
Each field may contain several records done
clear
View Solution play_arrow
-
question_answer8)
Which of the following describes a relational database?
A)
It provides a relationship between integers. done
clear
B)
It consists of separate tables of related data. done
clear
C)
It retrieves data related to its queries. done
clear
D)
It provides a relationship between floats. done
clear
View Solution play_arrow
-
question_answer9)
Which of these terms refers to a collection of related information?
A)
Database done
clear
B)
List done
clear
C)
Outline done
clear
D)
Record done
clear
View Solution play_arrow
-
question_answer10)
A row in a table is also known as
A)
Record done
clear
B)
Field done
clear
C)
Data type done
clear
D)
Data done
clear
View Solution play_arrow
-
question_answer11)
Which of the following examples would be best stored in database?
A)
Video clip done
clear
B)
Family portrait done
clear
C)
Club membership details done
clear
D)
An article in school magazine done
clear
View Solution play_arrow
-
question_answer12)
Duplication of data is called....................
A)
Inconsistency done
clear
B)
Consistency done
clear
C)
Redundancy done
clear
D)
Foreign Key done
clear
View Solution play_arrow
-
question_answer13)
............... is dedicated computers that hold the actual databases and run only DBMS and related Software.
A)
Main Server done
clear
B)
Web Server done
clear
C)
Database Server done
clear
D)
Non Database Server done
clear
View Solution play_arrow
-
question_answer14)
Which of the following is not the advantage of database?
A)
Sharing of Data done
clear
B)
Reduce Data Redundancy done
clear
C)
Increased Data Inconsistency done
clear
D)
Data Security done
clear
View Solution play_arrow
-
question_answer15)
Which of the following will help to maintain unique record in the table?
A)
Foreign Key done
clear
B)
Primary Key done
clear
C)
Composite Key done
clear
D)
Alternate Key done
clear
View Solution play_arrow
-
question_answer16)
............... key can be a primary key?
A)
Foreign done
clear
B)
Primary done
clear
C)
Candidate done
clear
D)
Composite done
clear
View Solution play_arrow
-
question_answer17)
Which key is used to make relations between two tables?
A)
Foreign done
clear
B)
Primary done
clear
C)
Candidate done
clear
D)
Composite done
clear
View Solution play_arrow
-
question_answer18)
Which of the following field of table Employee can act as a primary key?
A)
Employee Name done
clear
B)
Age done
clear
C)
Salary done
clear
D)
Employee Identification Number done
clear
View Solution play_arrow
-
question_answer19)
When primary key is made up of two or more columns, then it is called a ..............primary key.
A)
Mixed done
clear
B)
Reference done
clear
C)
Composite done
clear
D)
Compost done
clear
View Solution play_arrow
-
question_answer20)
A key which is referring to the primary key of another table is called................
A)
Alternate Key done
clear
B)
Primary Key done
clear
C)
First Primary Key done
clear
D)
Foreign Key done
clear
View Solution play_arrow
-
question_answer21)
Which one of the following attribute can be taken as a primary key?
A)
Name done
clear
B)
Street done
clear
C)
Adhaar Number done
clear
D)
Department done
clear
View Solution play_arrow
-
question_answer22)
.............. is a property of relation that identifies unique value in a relation.
A)
Rows done
clear
B)
Key done
clear
C)
Attribute done
clear
D)
Fields done
clear
View Solution play_arrow
-
question_answer23)
Which of the following is not a Key in database?
A)
Primary done
clear
B)
Foreign done
clear
C)
Alternate done
clear
D)
Secondary done
clear
View Solution play_arrow
-
question_answer24)
A key which is a set of one or more columns that can identify a record uniquely is called?
A)
Natural key done
clear
B)
Candidate key done
clear
C)
Not Null key done
clear
D)
Alternate key done
clear
View Solution play_arrow
-
question_answer25)
When data is stored, maintained and retrieved from multiple tables then special database software are required called...............
A)
DBMS done
clear
B)
RDBMS done
clear
C)
Special DBMS done
clear
D)
All of the above done
clear
View Solution play_arrow
-
question_answer26)
The primary key of a database must always
A)
Be sorted done
clear
B)
Used an auto number data type. done
clear
C)
Have an entry for each record. done
clear
D)
Contain entries that are a combination of text and numbers. done
clear
View Solution play_arrow
-
question_answer27)
What part of a database holds all of the information about one item or subject?
A)
Record done
clear
B)
File done
clear
C)
Query done
clear
D)
Chart done
clear
View Solution play_arrow
-
question_answer28)
Facilities offered by databases are
A)
The ability to store a large amount of data in a structured format, easy update, sort, query, production of reports done
clear
B)
Easy editing, spell check, perform calculations, library of mathematical functions, replication done
clear
C)
The ability to rotate images, copy and paste, fill scale done
clear
D)
None of the above done
clear
View Solution play_arrow
-
question_answer29)
Which of the following fields would not make a suitable primary key?
A)
A date field done
clear
B)
An invoice number done
clear
C)
An Auto Number field done
clear
D)
A customer's social security number done
clear
View Solution play_arrow
-
question_answer30)
Which of the following is not true for a database table?
A)
It may contain multiple records done
clear
B)
It may contain multiple tables done
clear
C)
It may contain multiple columns done
clear
D)
It may contain multiple candidate keys. done
clear
View Solution play_arrow
-
question_answer31)
In RDBMS, data is organised in the form of........................
A)
Table done
clear
B)
Record done
clear
C)
Field done
clear
D)
None of the above done
clear
View Solution play_arrow
-
question_answer32)
A ................ is an object you can use to customise the display of data in a table or query.
A)
Table done
clear
B)
Form done
clear
C)
View done
clear
D)
Relation done
clear
View Solution play_arrow
-
question_answer33)
All the values in ................. are of same type.
A)
Records done
clear
B)
Table done
clear
C)
Database done
clear
D)
Fields done
clear
View Solution play_arrow
-
question_answer34)
.............. represents a single data item in a table.
A)
Tuples done
clear
B)
Attributes done
clear
C)
Relation done
clear
D)
All of the above done
clear
View Solution play_arrow
-
question_answer35)
............. are the basic building blocks of a database.
A)
Tables done
clear
B)
Record done
clear
C)
Fields done
clear
D)
All of the above done
clear
View Solution play_arrow
-
question_answer36)
We can create table in.................
A)
In design view done
clear
B)
Using Wizard done
clear
C)
Both of the above done
clear
D)
None of the above done
clear
View Solution play_arrow
-
question_answer37)
By default data type of fields is
A)
Text[Varchar] done
clear
B)
Text[Char] done
clear
C)
Int done
clear
D)
Long done
clear
View Solution play_arrow
-
question_answer38)
Which of the following best describes a query?
A)
A query enables people to enter or view data in your database easily done
clear
B)
A query summarizes and prints data done
clear
C)
A query retrieves data that satisfies conditions that you set done
clear
D)
Data done
clear
View Solution play_arrow
-
question_answer39)
Which of the following database components can be used to make it easier for you to enter data into a table?
A)
Form done
clear
B)
Query done
clear
C)
Report done
clear
D)
Table done
clear
View Solution play_arrow
-
question_answer40)
A database is made up of all the following components except
A)
Tables done
clear
B)
Queries done
clear
C)
Forms done
clear
D)
Formula bars done
clear
View Solution play_arrow
-
question_answer41)
................ is an object you can use to customise the display of data in a table or query.
A)
Table done
clear
B)
Form done
clear
C)
View done
clear
D)
Relation done
clear
View Solution play_arrow
-
question_answer42)
................... displays specific records from a table that meet a certain criteria.
A)
Form done
clear
B)
Query done
clear
C)
Report done
clear
D)
Table done
clear
View Solution play_arrow
-
question_answer43)
The formatted way of the user that is used to retrieve data from one or more tables of the database and to represent it is called?
A)
Table done
clear
B)
Report done
clear
C)
Form done
clear
D)
Relationship done
clear
View Solution play_arrow
-
question_answer44)
.............. kind of information a field contains whether it is text, number, date/time, or some other type.
A)
Field done
clear
B)
Data type done
clear
C)
Record done
clear
D)
Form done
clear
View Solution play_arrow
-
question_answer45)
Which field type will you select if you need to enter long text in that field?
A)
Text done
clear
B)
Long VarChar done
clear
C)
Currency done
clear
D)
Hyperlink done
clear
View Solution play_arrow
-
question_answer46)
Which Data Type is used to store characters?
A)
Text done
clear
B)
Integer done
clear
C)
Double/Real done
clear
D)
Boolean done
clear
View Solution play_arrow
-
question_answer47)
Which Data Type is used to store whole numbers?
A)
String done
clear
B)
Integer done
clear
C)
Double/Real done
clear
D)
Boolean done
clear
View Solution play_arrow
-
question_answer48)
Which Data Type is used to store data with only two possible answers?
A)
String done
clear
B)
Integer done
clear
C)
Double/Real done
clear
D)
Boolean done
clear
View Solution play_arrow
-
question_answer49)
What can be the maximum length of a char field?
A)
120 done
clear
B)
255 done
clear
C)
265 done
clear
D)
75 done
clear
View Solution play_arrow
-
question_answer50)
Which data type will be appropriate to store information as Salary, Fees, Price etc.?
A)
Alphanumeric Data types done
clear
B)
Numeric Data type done
clear
C)
Binary Data types done
clear
D)
Date Time done
clear
View Solution play_arrow
-
question_answer51)
By default, the length of Varchar data type is............
A)
20 done
clear
B)
30 done
clear
C)
40 done
clear
D)
50 done
clear
View Solution play_arrow
-
question_answer52)
Which of the following is not a numeric data type?
A)
Tinyint done
clear
B)
Smallint done
clear
C)
Boolean done
clear
D)
Date done
clear
View Solution play_arrow
-
question_answer53)
Which of the following data types can-not store decimal values?
A)
Decimal done
clear
B)
Real done
clear
C)
Numeric done
clear
D)
Boolean done
clear
View Solution play_arrow
-
question_answer54)
Which of the following will occupy more space in computer memory?
A)
Bigint done
clear
B)
Integer done
clear
C)
Smallint done
clear
D)
Boolean done
clear
View Solution play_arrow
-
question_answer55)
.................... data types are used for storing photos, music files etc.
A)
Binary done
clear
B)
Alphanumeric done
clear
C)
Numeric done
clear
D)
Special done
clear
View Solution play_arrow
-
question_answer56)
Char is a................ length data type and varchar is a .............. length data type.
A)
Fixed, Variable done
clear
B)
Variable, Fixed done
clear
C)
Variable, Variable done
clear
D)
Fixed, Fixed done
clear
View Solution play_arrow
-
question_answer57)
By default the length of the Integer data type is..................
A)
25 done
clear
B)
15 done
clear
C)
12 done
clear
D)
10 done
clear
View Solution play_arrow
-
question_answer58)
What data type should you choose for a zip code field in a table?
A)
Text done
clear
B)
Number done
clear
C)
Real done
clear
D)
All of the above done
clear
View Solution play_arrow
-
question_answer59)
Which of the following is not a data type?
A)
Picture done
clear
B)
Date/time done
clear
C)
Text done
clear
D)
Number done
clear
View Solution play_arrow
-
question_answer60)
Which property ensures that field cannot be left blank?
A)
Format done
clear
B)
Required Entry done
clear
C)
Entry required done
clear
D)
Required done
clear
View Solution play_arrow
-
question_answer61)
SQL stands for....................
A)
Structured Queue Language done
clear
B)
Structured Query Language done
clear
C)
Structured Query Lang done
clear
D)
None of the above done
clear
View Solution play_arrow
-
question_answer62)
What is the purpose of description column in Table Design view?
A)
To describe the data that should be entered in each field done
clear
B)
To define the data type applied to each field within the table done
clear
C)
To enter lookup data that the field should refer to done
clear
D)
None of the above done
clear
View Solution play_arrow
-
question_answer63)
The language used application programs to request data from the DBMS is referred to as...............
A)
DML done
clear
B)
DDL done
clear
C)
Query language done
clear
D)
All of the above done
clear
View Solution play_arrow
-
question_answer64)
Which of the following is not a type of SQL statement?
A)
Data Manipulation Language (DML) done
clear
B)
Data Definition Language (DDL) done
clear
C)
Data Control Language (DCL) done
clear
D)
Data Communication Language (DCL) done
clear
View Solution play_arrow
-
question_answer65)
The three language components of a database management system (DBMS) like DDL, DCL, DML. Two different types of people (users and practitioners) are concerned with them. Which of them do users of a database use the most?
A)
DDL done
clear
B)
DML done
clear
C)
DDL and DCL done
clear
D)
DCL and DML done
clear
View Solution play_arrow
-
question_answer66)
Which of the following are the DDL statements?
A)
Create done
clear
B)
Drop done
clear
C)
Alter done
clear
D)
All of the above done
clear
View Solution play_arrow
-
question_answer67)
In SQL, which of the following is not a Data Manipulation Language Commands?
A)
Delete done
clear
B)
Truncate done
clear
C)
Update done
clear
D)
Create done
clear
View Solution play_arrow
-
question_answer68)
Which of the following is not included in DML?
A)
INSERT done
clear
B)
UPDATE done
clear
C)
DELETE done
clear
D)
CREATE done
clear
View Solution play_arrow
-
question_answer69)
In SQL, which command is used to add new rows to a table?
A)
Alter Table done
clear
B)
Add row done
clear
C)
Insert done
clear
D)
Append done
clear
View Solution play_arrow
-
question_answer70)
Which command is used for removing a table and all its data from the database?
A)
Create command done
clear
B)
Drop table command done
clear
C)
Alter table command done
clear
D)
All of the mentioned above done
clear
View Solution play_arrow
-
question_answer71)
We can..................... data in table.
A)
Modify done
clear
B)
Insert done
clear
C)
Delete done
clear
D)
All of the above done
clear
View Solution play_arrow
-
question_answer72)
Which of the following would be the most appropriate data type for a variable called Item Cost that will hold the value of an item (e.g. ` 2.50)?
A)
Integer done
clear
B)
Single done
clear
C)
Text done
clear
D)
Currency done
clear
View Solution play_arrow
-
question_answer73)
You are setting up a database to show information of several countries. You need to be able to sort it by population size. Which data type should you use for 'Population' field?
A)
Text done
clear
B)
Number done
clear
C)
Auto number done
clear
D)
Yes/No done
clear
View Solution play_arrow
-
question_answer74)
The table wizard
A)
Quickly creates a default report done
clear
B)
Displays a subset of the data in a database done
clear
C)
Contains sample tables and fields you can use to create a table done
clear
D)
Automatically edits your data as you enter it done
clear
View Solution play_arrow
-
question_answer75)
In which view data can be entered in table?
A)
Datasheet view done
clear
B)
Design view done
clear
C)
Both of the above done
clear
D)
None of the above done
clear
View Solution play_arrow
-
question_answer76)
In which mode we can change the structure of table?
A)
Datasheet view done
clear
B)
Design view done
clear
C)
Structure view done
clear
D)
All of the above done
clear
View Solution play_arrow
-
question_answer77)
.................. statement is used to retrieve records in a database.
A)
Alter done
clear
B)
Update done
clear
C)
Select done
clear
D)
Create done
clear
View Solution play_arrow
-
question_answer78)
Sorting means to arrange data in .................order.
A)
Increasing done
clear
B)
Decreasing done
clear
C)
Increasing or decreasing done
clear
D)
None of the above done
clear
View Solution play_arrow
-
question_answer79)
.............. SQL command changes one or more record in a table?
A)
Modify done
clear
B)
Update done
clear
C)
Lookup done
clear
D)
Insert done
clear
View Solution play_arrow
-
question_answer80)
.................... symbol is used to display every column of the table.
A)
+ done
clear
B)
- done
clear
C)
* done
clear
D)
/ done
clear
View Solution play_arrow
-
question_answer81)
With the following syntax |
INSERT INTO Table_Name |
(Field1, Field2,....) |
Values (Value1, Value2,.....); |
Using the above statements, you can |
A)
Insert one row at a time done
clear
B)
Insert multiple rows at a time done
clear
C)
Insert one column at a time done
clear
D)
Insert multiple columns at a time done
clear
View Solution play_arrow
-
question_answer82)
In Base data can be linked between two or more tables with the help of...............
A)
Primary key done
clear
B)
Foreign key done
clear
C)
Primary and foreign key done
clear
D)
None of the above done
clear
View Solution play_arrow
-
question_answer83)
Relationship can be created between
A)
Two tables only done
clear
B)
One table only done
clear
C)
Two or more tables done
clear
D)
None of the above done
clear
View Solution play_arrow
-
question_answer84)
Relationship between tables can be created from .................. menu.
A)
View done
clear
B)
Insert done
clear
C)
Windows done
clear
D)
Tools done
clear
View Solution play_arrow
-
question_answer85)
There are ................... types of relationship which can be created between tables.
A)
three done
clear
B)
two done
clear
C)
four done
clear
D)
infinite done
clear
View Solution play_arrow
-
question_answer86)
The database has been sorted
|
|
Which field has been used to sort the data?
|
A)
Shape done
clear
B)
Faces done
clear
C)
Edges done
clear
D)
Vertices done
clear
View Solution play_arrow
-
question_answer87)
The screen shows a database of staff members
|
|
What action does the button marked X indicate?
|
A)
Go to first record done
clear
B)
Go to last record done
clear
C)
Go to 2nd record done
clear
D)
Go to 3rd record done
clear
View Solution play_arrow
-
question_answer88)
Use the following view of Student database to answer the given question.
|
|
How many fields are there in database?
|
A)
6 done
clear
B)
4 done
clear
C)
5 done
clear
D)
0 done
clear
View Solution play_arrow
-
question_answer89)
The student database is shown below. What is the data type of field EMAIL ID
|
|
A)
Decimal done
clear
B)
Real done
clear
C)
Numeric done
clear
D)
Boolean done
clear
View Solution play_arrow
-
question_answer90)
In the figure shown below, if the database is to be sorted by name in ascending order, which record will appear first?
|
|
A)
Sugam done
clear
B)
Rabat done
clear
C)
Danish done
clear
D)
Ojas done
clear
View Solution play_arrow
-
question_answer91)
Which table view shows the correct data type for each field?
Book Title |
Pages |
Price |
FIT |
350 |
Rs. 150 |
A)
B)
C)
D)
View Solution play_arrow
-
question_answer92)
Consider the following database
|
|
How has this database been sorted?
|
A)
Name, ascending done
clear
B)
Name, descending done
clear
C)
City, ascending done
clear
D)
City, descending done
clear
View Solution play_arrow
-
question_answer93)
Three components of a database are labeled.
|
|
In order, what do the labels 1, 2 and 3 identify?
|
A)
Field, Name, Record done
clear
B)
Row, Field Name, Field done
clear
C)
Field Name, Row, Field done
clear
D)
Record, Field Name, Field done
clear
View Solution play_arrow
-
question_answer94)
Use the following database extract to answer the following questions.
|
|
(i) What data structure has been highlighted above?
|
A)
Field done
clear
B)
Query done
clear
C)
Record done
clear
D)
Table done
clear
View Solution play_arrow
-
question_answer95)
(ii) How has the data in the table been sorted?
A)
Ascending, Salary done
clear
B)
Ascending, Name done
clear
C)
Descending, City done
clear
D)
Descending, Salary done
clear
View Solution play_arrow
-
question_answer96)
Which of the following clause return specific rows?
A)
Order By done
clear
B)
Where done
clear
C)
Having done
clear
D)
Specific done
clear
View Solution play_arrow
-
question_answer97)
Which of the following clause return records in ascending order?
A)
Order By done
clear
B)
Where done
clear
C)
Order Asc done
clear
D)
Order Inc done
clear
View Solution play_arrow
-
question_answer98)
SQL statement to display all the data from the table Student is..................
A)
Select + from student done
clear
B)
Select * from student done
clear
C)
Select all from student done
clear
D)
Select all from student list done
clear
View Solution play_arrow
-
question_answer99)
Which command is used to create table?
A)
Select done
clear
B)
Create done
clear
C)
Open done
clear
D)
New done
clear
View Solution play_arrow
-
question_answer100)
Which command is used to delete data from table?
A)
Select done
clear
B)
Delete done
clear
C)
Insert done
clear
D)
Remove done
clear
View Solution play_arrow
-
question_answer101)
Command to increase the salary of all employees by 15000.(table name emp and column name sal)
A)
update emp set sal = sal + 15000; done
clear
B)
update emp set sal = 15000 done
clear
C)
update set sal = sal + 15000 done
clear
D)
None of the above done
clear
View Solution play_arrow
-
question_answer102)
A ................ helps to collect specific information from the pool of data.
A)
Query done
clear
B)
Report done
clear
C)
Form done
clear
D)
None of the above done
clear
View Solution play_arrow
-
question_answer103)
Which of the following is to be created first?
A)
Report done
clear
B)
Query done
clear
C)
Form done
clear
D)
Table done
clear
View Solution play_arrow
-
question_answer104)
This screen below shows part of a database
|
|
Which query would find the records for Player 02 and Player 03 only?
|
A)
Storage Capacity (GB) < 10 done
clear
B)
Warranty (months) < = 12 done
clear
C)
Screen Size (in.) < = 2 done
clear
D)
Price > $ 70 done
clear
View Solution play_arrow
-
question_answer105)
You want to create a query for this database of used cars.
|
|
which query will find cars where the engine size at least 1.8L and the price is less than $ 18,000?
|
A)
Engine size \[\ge 1.8\] AND Price \[<\$18,000\] done
clear
B)
Engine size \[>1.8\] AND Price \[\le \$18,000\] done
clear
C)
Engine size \[\ge 1.8\] OR Price \[<\$18,000\] done
clear
D)
Engine size \[>1.8\] OR Price \[\le \$18,000\] done
clear
View Solution play_arrow
-
question_answer106)
A news agency keeps product data in this database table. Product
PRODUCT_ID | PRODUCT_NAME | PRICE |
1002 | DISK CASE | 8.99 |
1004 | MOUSE HOLDER | 12.50 |
1005 | MOUSE MAT | 6.58 |
After running a query, these data were extracted.
PRODUCT_NAME |
DISK CASE |
MOUSE MAT |
Which query below will generate these results?
A)
SELECT Product_Name FROM Product WHERE Price > 9 done
clear
B)
SELECT Product_Name FROM Product WHERE Price < 9 done
clear
C)
SELECT Product_Name, Price FROM Product WHERE Price < 9 done
clear
D)
SELECT Product_Name, Price FROM Product WHERE Price > 9 done
clear
View Solution play_arrow
-
question_answer107)
The correct order of SQL expression is
A)
Select, Group by, Where, Having done
clear
B)
Select, Where, Group by, Having done
clear
C)
Select, Having, Where, Group by done
clear
D)
All of above done
clear
View Solution play_arrow
-
question_answer108)
Which of the following statements) is/are true for UPDATE in SQL? |
I. You can update only a single table using UPDATE command |
II. You can update multiple tables using UPDATE command |
III. In UPDATE command, you must list what columns to update with their new values |
IV. To update multiple targeted records, you need to specify UPDATE command using the WHERE clause. |
Select the correct option: |
A)
I, III and IV done
clear
B)
II, III and IV done
clear
C)
III and IV done
clear
D)
I only done
clear
View Solution play_arrow
-
question_answer109)
Which of the following statement is correct about 'CREATE TABLE' command while creating a table?
A)
We need to assign a data type to each column done
clear
B)
We have flexibility in SQL. We can assign a data type to column even after creating a table done
clear
C)
It is mandatory to insert at least a single row while creating a table done
clear
D)
None of these done
clear
View Solution play_arrow
-
question_answer110)
The SQL used by front-end application programs to request data from the DBMS is called.............
A)
DML done
clear
B)
DDL done
clear
C)
VDL done
clear
D)
SDL done
clear
View Solution play_arrow
-
question_answer111)
Which statement in SQL allows us to change the definition of a table is?
A)
ALTER done
clear
B)
UPDATE done
clear
C)
CREATE done
clear
D)
SELECT done
clear
View Solution play_arrow
-
question_answer112)
A .................... helps to display the data in a summarized data.
A)
Report done
clear
B)
Form done
clear
C)
Query done
clear
D)
None of the above done
clear
View Solution play_arrow
-
question_answer113)
Which of the following acts as an interface to view, enter and change data in database?
A)
Report done
clear
B)
Table done
clear
C)
Query done
clear
D)
Form done
clear
View Solution play_arrow
-
question_answer114)
A.................... provides a systematic way of storing information into the database.
A)
Report done
clear
B)
Query done
clear
C)
Form done
clear
D)
None of the above done
clear
View Solution play_arrow
-
question_answer115)
Which of the following database object produces the final result?
A)
Forms done
clear
B)
Reports done
clear
C)
Queries done
clear
D)
Tables done
clear
View Solution play_arrow
-
question_answer116)
Referential integrity means
A)
Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table done
clear
B)
Do not enter a value in the primary key field of child table if that value does not exist in the primary key of the parent table done
clear
C)
Do not enter a value in the foreign key field of a parent table if that value does not exist in the primary key of the child table done
clear
D)
All of the above done
clear
View Solution play_arrow
-
question_answer117)
A relational database management (RDBMS) package manages data in more than one file at once. How does it organise these files?
A)
Tables done
clear
B)
Relations done
clear
C)
Tuple done
clear
D)
Both (a) and (b) done
clear
View Solution play_arrow
-
question_answer118)
Which of the following database object can be used if you need to mail the invoice to customers?
A)
Form done
clear
B)
Query done
clear
C)
Report done
clear
D)
Table done
clear
View Solution play_arrow
-
question_answer119)
What do you mean by one to many relationships between student and class table?
A)
One student can have many classes done
clear
B)
One class may have many students done
clear
C)
Many classes may have many students done
clear
D)
Many students may have many classes done
clear
View Solution play_arrow
-
question_answer120)
To print information from a table, the ............... tool is the best choice.
A)
Form done
clear
B)
Query done
clear
C)
Table done
clear
D)
Report done
clear
View Solution play_arrow
-
question_answer121)
Which of the following cannot be done to data using a Form?
A)
Store done
clear
B)
Sort done
clear
C)
Edit done
clear
D)
print done
clear
View Solution play_arrow
-
question_answer122)
................. database is a type of database that stores data in several tables. (C.B.S.E. Sample Paper 2022)
A)
Flat done
clear
B)
Relational done
clear
C)
Both (a) and (b) done
clear
D)
None of them done
clear
View Solution play_arrow
-
question_answer123)
In database ................. helps us to retrieve the filtered data based upon some conditions. (C.B.S.E. Sample Paper 2021)
A)
Forms done
clear
B)
Reports done
clear
C)
Queries done
clear
D)
Table done
clear
View Solution play_arrow
-
question_answer124)
Rudrakshh wants that the name column of a table must not be left blank. Help him to identify the field property for this purpose. (C.B.S.E. Sample Paper 2021)
A)
Length done
clear
B)
Default done
clear
C)
Entry Required done
clear
D)
Format done
clear
View Solution play_arrow
-
question_answer125)
................. can be set for a field if the user doesn't provide any value while entering the values in the table. (C.B.S.E. Sample Paper 2021)
A)
Required done
clear
B)
Default done
clear
C)
Primary Key done
clear
D)
Format done
clear
View Solution play_arrow
-
question_answer126)
Aadya wants to create a connection between two or more tables. Suggest her me option to accomplish the task. (C.B.S.E. Sample Paper 2021)
A)
Table done
clear
B)
Form done
clear
C)
Relationships done
clear
D)
Sorting done
clear
View Solution play_arrow
-
question_answer127)
............... data type takes the values in the form of 0 and 1 in the database. (C.B.S.E. Sample Paper 2021)
A)
Integer done
clear
B)
Text done
clear
C)
Boolean done
clear
D)
Memo done
clear
View Solution play_arrow