QUIZIZZ 1

A column name is otherwise known as a _____. a) field b) table c) record d) row

a

Database commands that modify the records within the database and not the schema itself. a) Data Manipulation Language (DML) b) Structured Query Language (SQL) c) Database Management System (DBMS) d) Data Definition Language (DDL)

a

Give 3 examples of a primary key a) Student Number, Auto Number, LicenseNumber b) Student Number, Name, Birthday

a

A field in one table that is the primary key of another table and establishes a relationship betweenthe two tables a) Primary Key b) Foreign Key c) House Key d) Attribute

b

A primary key can be NULL in the table? TRUE or FALSE a) TRUE b) FALSE

b

Match the following SQL term with a description - WHERE a) The field and order used to sort the results b) The criteria which must be set c) The table used in the query d) The fields to display

b

SQL query to find all the cities whose humidity is 95. a) SELECT city FROM weather b) SELECT city FROM weather WHERE humidity= 95 c) SELECT city WHERE humidity = 95 d) SELECT humidity = 89 FROM weather

b

SQL stands for _____. a) sustainable query language b) structured query language c) sustainable question language d) structured question language

b

This SQL command is used to add a new row of data to a table a) UPDATE b) INSERT c) SELECT d) DELETE

b

Which is the best example of a primary key? a) Price b) Driver's License Number c) First and Last Name d) Home Runs Hit

b

How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table? a) MODIFY Persons SET LastName='Nilsen'WHERE LastName='Hansen' b) MODIFY Persons SET LastName='Hansen'INTO LastName='Nilsen' c) UPDATE Persons SET LastName='Nilsen'WHERE LastName='Hansen' d) UPDATE Persons SET LastName='Hansen'INTO LastName='Nilsen'

c

Referential Integrity is a) System of data b) Table constraints c) System of rules d) is related to Primary key

c

Using which word allows you to specify that more than one condition must be met in a query? a) Or b) Where c) And d) Also

c

Primary key means a) candidate key b) normal key c) subordinate key d) unique key

d

This SQL command is used to specify which table(s) data is retrieved a) INTO b) WHERE c) SELECT d) FROM

d

What does the ALTER TABLE clause do? a) The SQL ALTER TABLE clause is used to delete a database table b) THE SQL ALTER TABLE deletes data from database table c) The SQL ALTER TABLE clause is used to insert data into database table d) The SQL ALTER TABLE clause modifies a table definition by altering, adding, or deleting table columns and/or constraints

d