WorksheetsFinals Quiz
Total questions: 25
Worksheet time: 13mins
SQL stands for:
Standard Query language
Structured Questioning Language
Structured Query Language
Standard Querying Language
Which of the following can add a column to an existing table?
Delete
Insert
Update
Alter
Which SQL statement is use to add a new data in a database?
Insert Into
Update
Add
Insert New
What SQL clause is use to restrict the rows returned by a query?
AND
WHERE
HAVING
FROM
A SELECT command without a WHERE clause returns?
All the records from a table that match the previous WHERE clause
All the records from a table, or information about all the records
SELECT is invalid without a WHERE clause
Nothing
What language is use to query data in a Relational Database?
BASIC
SQL
C++
JAVA
What command retrieves data from the database?
Insert
Select
Alter
Describe
If an SQL statement returns data from two or more tables, which SQL capability is being used?
Projection
Selection
Joining
Insertion
You query the database with this SQL statement: SELECT * FROM students; Why would you use this statement?
To display the table structure
To view data
To delete data
To insert data
SELECT * FROM departments; is a
Statement
Keyword
Strategy
Declaration
What would you use in the SELECT clause to return all the columns in the table?
A plus sign (+)
A minus sign (-)
The ALL keyword
An asterisk (*)
The basic storage structure in a Relational Database is a _________:
Row
Field
Table
Key
In which clause of a SELECT statement would you specify the name of the table or tables being queried?
The FROM clause
The SELECT clause
The WHERE clause
Delete from
In a SQL statement, which clause specifies one or more columns to be returned by the query?
Select
From
Where
None of the above
Columns in a database table contain data with the same _________:
Row
Type
Field
Key
Every time you shop online, it is likely you will be accessing a database. True or False?
True
False
Databases are use in most countries and by most governments. Life, as we know it, would change drastically if we no longer had access to databases. True or False?
True
False
Every row in a relational database table is unique.
True
False
SELECT *FROM employees; this statement will retrieve all the rows in the employees table. True or False?
True
False
The Delete from statement will delete specific records from the table.
True
False
Is this syntax correct? 'Update SampleTable set Columnname = Values where ColumnKey = values;'
Yes
No
Is this syntax correct? 'Insert into SampleTable(columnames) values(Values);'
Yes
No
Is this Syntax correct? Delete columname from Sampletable;
Yes
No
Is this syntax Correct? CREATE TABLE CartTable (dateToday date(10),food varchar(20), profit float);
Yes
No
Is this syntax Correct? SELECT * FROM employee join department on employee.id = book.id;
Yes
No
