Database Test 6 Computer Subject
Database Test 6 Computer Subject
Question 1
SQL is a _____?
SQL is a non-procedural language because it focuses on what data to retrieve rather than how to retrieve it.
Not clear enough?
Question 2
To form a projection with SQL _____?
Projection in SQL involves naming the relation and listing the specific columns to be displayed.
Not clear enough?
Question 3
To remove duplicate rows, this _____ qualifier must be specified.
The DISTINCT keyword is used in SQL to eliminate duplicate rows from the result set.
Not clear enough?
Question 4
Which SQL keyword is used to name a new table and describe the table's columns?
The CREATE keyword in SQL is used to define new tables along with their column structures.
Not clear enough?
Question 5
Which SQL keyword is used to change the structure, properties or constraints of a table?
ALTER is used in SQL to modify the structure of an existing table, such as adding or removing columns.
Not clear enough?
Question 6
Which one of the following is used to define the structure of the relation, deleting relations and relating schema's?
DDL is used to define, modify, and delete database structures such as tables and schemas.
Not clear enough?
Question 7
If table PRODUCT has a column PRICE with data type Numeric (8,2), it stores values as _____?
Numeric(8,2) allows 8 digits in total, of which 2 are after the decimal point, so it stores 6 digits before the decimal and 2 after.
Not clear enough?
Question 8
If the table PRODUCT has a column PRICE that has the data type Numeric (8, 2), the value 12345 will be displayed by the DBMS as _____?
Numeric(8,2) shifts the decimal point two places, so 12345 is stored and displayed as 123.45.
Not clear enough?
Question 9
Which SQL keyword is used to delete a table's structure?
DROP is used to delete a table’s structure permanently along with its data.
Not clear enough?
Question 10
When the correct SQL command is used to delete a table's structure, what happens to the data in the table?
Using DROP removes the table structure and deletes all its data permanently.
Not clear enough?
You might like
'There are diversities of gifts, but the same spirit, but all these worked that one and the same spirit, dividing to every man severally as he wills.' The words 'as he wills' mean
Two spheres of masses 5.0 kg and 10.0 kg are 0.3 m apart. Calculate the force of attraction between them. ($G=6.67\times10^{-11}\ \text{N·m}^2\text{·kg}^{-2}$)
Select the option nearest in meaning to the underlined word or phrase.
The student's union leader delivered his speech extempore.