NEW
Font size
S
M
L
XL
WorksheetsRDBMS for class10
Total questions: 10
Worksheet time: 5mins
Name
Class
Date
1.
A relational database developer refers to a record as
a)
Criteria
b)
a relation
c)
a tuple
d)
an attribute
2.
An advantage of DBMS approach is
a)
data is dependent on programs
b)
data redundancy increases
c)
data can be integrated and can be accessed by multiple programs
d)
none of the above
3.
What is full form of SQL
a)
Structured Query Language
b)
Strong Question Language
c)
Structured Question Language
d)
Strong Query Language
e)
Structure Query Language
4.
With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?
a)
SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'
b)
SELECT * FROM Persons WHERE FirstName='Peter'
c)
SELECT * FROM Persons WHERE FirstName<>'Peter'
d)
SELECT * FROM Persons WHERE FirstName<>'Peter'
e)
SELECT * FROM Persons WHERE FirstName=='Peter'
5.
With SQL, how can you insert a new record into the "Persons" table?
a)
INSERT INTO Persons VALUES ('Jimmy', 'Jackson')
b)
INSERT ('Jimmy', 'Jackson') INTO Persons
c)
INSERT VALUES ('Jimmy', 'Jackson') INTO Persons
d)
INSERT VALUES ('Jimmy, Jackson') INTO Persons
e)
INSERT ('Jimmy', 'Jackson') VALUES into Persons
6.
With SQL, how can you insert a new record into the "Persons" table?
a)
INSERT INTO Persons VALUES ('Jimmy', 'Jackson')
b)
INSERT ('Jimmy', 'Jackson') INTO Persons
c)
INSERT VALUES ('Jimmy', 'Jackson') INTO Persons
d)
INSERT VALUES ('Jimmy, Jackson') INTO Persons
e)
INSERT ('Jimmy', 'Jackson') VALUES into Persons
7.
The DROP TABLE statement:
a)
deletes the table structure only.
b)
deletes the table structure along with the table data.
c)
works whether or not referential integrity constraints would be violated.
d)
is not an SQL statement.
e)
deletes the data only.
8.
Which of the following is NOT a type of SQL constraint?
a)
Primary Key
b)
Foreign Key
c)
Alternate Key
d)
Unique
e)
NOT NULL
9.
Which of the following function cannot be performed by SQL ?
a)
Setting permissions on tables
b)
Creating views in a database
c)
Updating records
d)
Creating Complex UI
e)
Delete database
10.
Which one of the following sorts rows in SQL?
a)
SORT BY
b)
ALIGN BY
c)
ORDER BY
d)
GROUP BY
e)
SORT
Reset
