Font size
WorksheetsDatabases 701
Total questions: 15
Worksheet time: 9mins
Copy and complete the sentence using the following words: organized, related, database.
A________________________ is an ________________________ collection of ________________________ data.
(The answer should appear answer1, answer2, answer3)
(a)
A database is used to
Calculate figures
Store data in a logical order
Layout pages attractively
Present material using animations
Rows in a database tables are called...
Fields
Tables
Records
Forms
Which of the following would be used to uniquely identify a record
Field size
Validation
Data type
Primary Key
To find a particular set of data in a database you would use a:
Table
Form
Query
Report
What do we use to connect tables in a relational database:
Foreign Key
Query
Fields
Table
How would you define a relational database?
A database consisting of data relating to families
An online database
A database linked to another database
A database consisting of multiple tables, that are linked using keys
Which of the following is a Structured Query Language (SQL) command that lets you view information stored in a database?
GRANT
RETRIEVE
SELECT
CREATE VIEW
Which of the following is a SQL statement?
if len(sys.argv) != 2: print usage sys.exit(0)
SELECT * FROM Orders WHERE OrderID=5
=IF(C3>=65,"Pass","Fail")
var rollDie = (Math.floor(Math.random() * 6) +1
What does SQL stand for?
Sequal Query Language
Structured Quotes Language
Structured Query Language
Sequential Query Language
A data structure in a relational database that is comprised of fields (columns) and records (rows).
Table
SQL
NoSQL
Report
INSERT command helps to...
Delete information from a table
Add new information to a table
Change the information of a field in a table
There is no INSERT command in databases
Difference between DROP and DELETE is:
DROP: eliminates a table.
DELETE: eliminates a record (row)
DROP: eliminates a record (row)
DELETE: eliminates a table.
There is no difference, both do the same
DROP doesn't exist and DELETE eliminates a table.
Line 35 is made to:
Add a row (record) to add phone numbers with a lenght of 10 digits
Add a column (field) to delete phone numbers in the 10th row of a table
Add a column (field) to add phone numbers with less than 10 digits
Add a column (field) to add phone numbers with a lenght of 10 digits
