AD 140

Commands

100

How do you make LAST_NAME upper case in SQL?

UPPER (LAST_NAME)

200

 How do you add a column to an existing table in SQL?

CALL procedure_name

300

Which clause is used to change the characteristics of an existing column in a table?

ALTER

400

What are the 3 steps to use a cursor in a procedure?

OPEN, FETCH, CLOSE

500

What construct is used to handle conditions that can arise when accessing the database in SQL? (2)

EXIT HANDLER , 

ERROR HANDLER

Statements

100

 How do you add a column to an existing table in SQL?

ALTER TABLE table_name ADD new_column CHAR(3);

200

How do you change a column to an existing table in SQL Server?

ALTER TABLE table_name MODIFY COLUMN column_name CHAR(3);    

300

Which of the following SQL statements is correct? 

CREATE NODUPLICATE INDEX SSN ON SALES_REP (SOC_SEC_NUM);

CREATE UNIQUE INDEX SSN ON SALES_REP (SOC_SEC_NUM);

CREATE DISTINCT INDEX SSN ON SALES_REP (SOC_SEC_NUM);

CREATE DUPLICATE INDEX SSN ON SALES_REP (SOC_SEC_NUM);

CREATE UNIQUE INDEX SSN ON SALES_REP (SOC_SEC_NUM); 

400

Which of the following SQL statements is false? 

GRANT VIEW ON SALES_REP TO JOHNSON;

GRANT UPDATE ON SALES_REP TO JOHNSON;

GRANT SELECT ON SALES_REP TO JOHNSON;

GRANT DELETE ON SALES_REP TO JOHNSON;

GRANT SELECT ON SALES_REP TO JOHNSON;

500

Which of the following SQL statements is valid?

ALTER TABLE INVOICES FOREIGN KEY (CUST_ID) REFERENCES CUSTOMER (CUST_ID);

ALTER TABLE INVOICES ADD FOREIGN KEY (CUST_ID) CUSTOMER (CUST_ID);

ALTER TABLE INVOICES ADD (CUST_ID) REFERENCES CUSTOMER (CUST_ID);

ALTER TABLE INVOICES ADD FOREIGN KEY (CUST_ID) REFERENCES CUSTOMER (CUST_ID); 

 

ALTER TABLE INVOICES ADD FOREIGN KEY (CUST_ID) REFERENCES CUSTOMER (CUST_ID); 

"D"

100

Which command statement is used to delete existing records in a table?

DELETE

200

Information kept about tables is usually known as a _______.

data dictionary

300

SQL Server uses the ___________ function to add a month to a date.

DATEADD

400

Which SQL command removes a view from the database?  

DROP VIEW

500

Which  command is required in SQL to create a stored procedure?

DELIMITER

Throwback

100

CSS: How do you select a pseudo-element?

::

200

HTML: Write a video source tag for the video birds.mp4

<source src="birds.mp4" type="video/mp4">

300

CSS: Write the code to insert leaf.png after each section.

section::after{

content: url(leaf.png);

}

400

JavaScript: How does a WHILE loop start where i is less then or equal to 10?

while (i <= 10)  

500

How to write an IF statement for executing some code if "i" is NOT equal to 5?

if (i != 5)  

Wild

100

What is an individual user's picture of the database?

A view

200

What is the most common surname in the United States?

Smith

300

What is a procedure that is executed in response to an associated database operation, such as an INSERT, UPDATE, or DELETE command?

A trigger

400

How do I get to school?

By car

500

What is my favorite genre?

Horror