Font size
WorksheetsClass 12 RDBMS
Total questions: 40
Worksheet time: 22mins
In a database, what is one piece of information called?
Field
Record
Table
Entry
What is a database?
A piece of software to do calculations
A device to load information onto the computer.
A structured collection of records
A calculator
One specific piece of information about a person or thing is called:
Field
File
Record
Table
What data type would be used to store the following item code: 0024
Text
Numeric
Calculated
Boolean
Text, Integer, Decimal, Boolean ,Date and Time are all examples of...
Data Types
Filters
Sorts
Validations
A unique identifying field.
Primary Key
Integer
Verification
Boolean
SQL is
Structured Query Language
Simple Query Language
Structured Question Language
Structure Quality Language
Which is the correct DDL group
CREATE, DELETE, DROP
ALTER , DROP, INSERT
UPDATE, SELECT, DROP
CREATE, DROP, ALTER
Which SQL statement would add a record to the database?
INSERT INTO Designer VALUES ('SMI01', 'M Smith', 'mail@msmith.com', '01224123456');
INSERT INTO Designer ('SMI01', 'M Smith', 'mail@msmith.com', '01224123456') ;
INSERT Designer VALUES ('SMI01', 'M Smith', 'mail@msmith.com', '01224123456') ;
INSERT INTO Designer VALUES (SMI01, 'M Smith', 'mail@msmith.com', '01224123456');
Where does the CREATE Command belong?
DML
DDL
DCL
DQL
A primary key can be NULL in the table.
TRUE
FALSE
which of the following is true for the above table.
EMPLOYEE has DEGREE 4 and FOREIGN KEY as EMP_ID
DEPARTMENT has CARDINALITY 2 and DEGREE 6
EMPLOYEE has DEGREE 8 and DEPARTMENT has CARDINALITY 2
EMPLOYEE has DEGREE 4 and PRIMARY KEY as EMP_ID
When David try to create a database table STUDENT he is getting an error. He is not able to create it. It is because that database table is .......................
already existing table
Not a valid name
primary key not set
foreign key not set
Which of the following is not a keyword of MYSQL?
Select
Top
Use
Insert
The _________ statement is used to delete a table.
DROP TABLE
DELETE TABLE
DEL TABLE
REMOVE TABLE
Which of the following not a valid keys
Alternate Key
Candidate Key
Participant Key
Foreign Key
INSERT________ Persons (FirstName,LastName) ________
('Lars','Monsen');
VALUES, INTO
INTO , VALUES
TABLE , VALUES
INTO TABLE, VALUE
SQL is not case sensitive. SELECT is the same as select.
TRUE
FALSE
With SQL, how do you select all the columns from a table named "Persons"?
SELECT * FROM Persons;
SELECT ALL Persons;
SELECT [all] FROM Persons;
SELECT *.Persons;
Number of Tuples is called as ____________
Domain
Cardinality
Degree
Which of the following is NOT a type of SQL constraint?
Primary Key
Foreign Key
Alternate Key
NOT NULL
What will be the degree and cardinality of the cartesian product of two tables if the degree of first table is 3 and second table is 5. The cardinality of first table is 10 and cardinality of second table is 6.
Degree 15, Cardinality 16
Degree 8 Cardinality 16
Degree 8 Cardinality 60
Degree 15 cardinality 60
Select DDL commands from among the options...
SELECT
ALTER
DROP
DELETE
The restrictions or conditions applied on data are known as ______________
Constraints
Key word
Scheme
Term
Which type of database management system is Oracle /MySQL?
Object-oriented
Hierarchical
Relational
Network
How many tuples are there in the relation?
5
6
4
3
Which command is used to add a column to an existing table?
Create
Update
Alter
None of the above
The SQL statement that queries or reads data from a table is ________
SELECT
READ
QUERY
None of the above is correct.
A database table can have __________ primary keys.
any no: of
exact one
three
two
A database table can have ____ no : of Foreign Keys.
1
2
4
any
Which of the following is not a DML command?
Update
Insert into
Delete
Create Table
