NEW
Font size
S
M
L
XL
WorksheetsADV L1
Total questions: 35
Worksheet time: 18mins
Name
Class
Date
1.
What are Relation-based tables
a)
1) To store relation between entities in tables
b)
2) To store data in tables
c)
3) To store entities in tables
d)
4) To define table names
2.
What does SQL stand for?
a)
1) Structured Question Language
b)
2) Standard Query Language
c)
3) Structured Query Language
d)
4) Simple Query Language
3.
What is a candidate key?
a)
1) A key that is not unique
b)
2) A minimal super key
c)
3) A foreign key
d)
4) A super key with extra attributes
4.
What is a composite key?
a)
1) A simple key
b)
2) A key with only one attribute
c)
3) A key with multiple attributes
d)
4) A foreign Key
5.
What is a constraint in a database?
a)
1) A table
b)
2) A rule or restriction on data
c)
3) A relationship
d)
4) An attribute
6.
What is a database?
a)
1) A collection of disorganized information
b)
2) A structured collection of related data
c)
3) A type of computer virus
d)
4) A social media platform
7.
What is a derived attribute?
a)
1) That is stored in database
b)
2) That is not Stored in Database
c)
3) An Key attribute
d)
4) A foreign Key
8.
What is a foreign key?
a)
1) A primary key in another table
b)
2) A key that is not important
c)
3) A key used for sorting data
d)
4) A key used for encryption
9.
What is a many-to-many relationship?
a)
1) One entity relates to one entity
b)
2) One entity relates to many entities
c)
3) Many entities relate to one entity
d)
4) Many entities relate to many entities
10.
What is a one-to-many relationship?
a)
1) One entity relates to one entity
b)
2) One entity relates to many entities
c)
3) Many entities relate to one entity
d)
4) Many entities relate to many entities
11.
What is a primary key?
a)
1) A foreign key
b)
2) A unique identifier for a record in a table
c)
3) A common attribute
d)
4) A data type
12.
What is a Query Language
a)
1) A language to design database
b)
2) A language to retrieve and manipulate data
c)
3) A language to connect database
d)
4) A language to secure database
13.
What is a relationship in a database?
a)
1) A table
b)
2) A query
c)
3) An association between entities
d)
4) A constraint
14.
What is a subquery in SQL?
a)
1) A query within a query
b)
2) A join operation
c)
3) A stored procedure
d)
4) A user-defined function
15.
What is a super key?
a)
1)A key that cannot uniquely identify entity
b)
2)A minimal super key
c)
3)A set of attributes (one or more) that collectively identifies an entity in an entity set
d)
4)A foreign Key
16.
What is a view in SQL?
a)
1) A table
b)
2) A stored query
c)
3) A function
d)
4) A procedure
17.
What is an atomic attribute?
a)
1) An attribute which can be divided
b)
2) An attribute which cannot be divided
c)
3) An Key attribute
d)
4) A foreign Key
18.
What is an attribute in a database?
a)
1) A table
b)
2) A column in a table
c)
3) A characteristic of an entity
d)
4) A type of relationship
19.
What is an entity in a database?
a)
1) A table in the database
b)
2) Anything about which data is collected and stored
c)
3) A relationship between tables
d)
4) A type of constraint
20.
What is an index in a database?
a)
1) A table
b)
2) A pointer to data
c)
3) A constraint
d)
4) A relationship
21.
What is Data integrity?
a)
1) Accuracy of Data
b)
2) Consistency of Data
c)
3) Validity of Data
d)
4) All of the above
22.
What is data normalization?
a)
1) The process of organizing data to reduce redundancy
b)
2) The process of encrypting data
c)
3) The process of backing up data
d)
4) The process of deleting data
23.
What is metadata?
a)
1) Data about database
b)
2) Data about data
c)
3) Data about tables
d)
4) Data about entities
24.
What is Multiuser and Concurrent Access
a)
1) To allow only one user to access data
b)
2) To allow multiple user to access same data at different time
c)
3) To allow multiple user to access and manipulate data in parallel
d)
4) To prevent user to access and manipulate data
25.
What is the ACID properties
a)
1) Atomicity, Consistency, Isolation, Durability
b)
2) Consistency, Isolation, Distribution
c)
3) Atomicity, connectivity, Isolation, Durability
d)
4) Atomicity, Consistency, Information, Durability
26.
What is the advantage of Data Consistency
a)
1)Fast retrival
b)
2)Reliability
c)
3)Data integrity
d)
4)Data accuracy
27.
What is the advantage of Isolation of data and application
a)
1) Active entitiy
b)
2) Passive entity
c)
3) Easy to manage
d)
4) secured data
28.
What is the purpose of E-R model
a)
1) more graphical representation of entities
b)
2) representation of attributes
c)
3) representation of relationships
d)
4) all of the above
29.
What is the purpose of the GROUP BY clause in SQL?
a)
1) To sort data
b)
2) To filter data
c)
3) To group rows with the same values
d)
4) To join tables
30.
What is the purpose of the HAVING clause in SQL?
a)
1) To sort data
b)
2) To filter data after grouping
c)
3) To join tables
d)
4) To insert data
31.
What is the purpose of the JOIN clause in SQL?
a)
1) To filter data
b)
2) To combine rows from two or more tables
c)
3) To sort data
d)
4) To group data
32.
What is the purpose of the WHERE clause in SQL?
a)
1) To sort the result set
b)
2) To filter the result set
c)
3) To join tables
d)
4) To insert data
33.
What is the use of key constraints
a)
1) define the relationships between tables
b)
2)ensure data consistency
c)
3)ensure data integrity
d)
4)all of the above
34.
Which SQL command is used to modify data in a database?
a)
1) SELECT
b)
2) INSERT
c)
3) UPDATE
d)
4) DELETE
35.
Which SQL command is used to remove data from a database?
a)
1) SELECT
b)
2) INSERT
c)
3) UPDATE
d)
4) DELETE
Reset
