- All Exams Instant Download
Which keyword can be used in a create table statement?
Which keyword can be used in a create table statement?A . ORDER BYB . DISTINCTC . GROUP BYD . UNIQUEView AnswerAnswer: D
Which key uniquely identifies a row in a table?
Which key uniquely identifies a row in a table?A . foreiqnB . primaryC . localD . superkeyView AnswerAnswer: B
Which constraint ensures a unique value in the ID column for each customer?
Which constraint ensures a unique value in the ID column for each customer?A . DISTINCTB . FOREIGN KEYC . SEQUENTIALD . PRIMARY KEYView AnswerAnswer: D
How many rows are returned?
You have the following table definition: CREATE TABLE Product (ID INTEGER PRIMARY KEY, Name VARCHAR(20), Quantity INTEGER) The Product table contains the following data. You execute the following statement: SELECT Name FROM Product WHERE Quantity IS NOT NULL How many rows are returned?A . 0B . 1C . 2D ....
Which keyword should you use in your where clause?
You are writing a select statement to find every product whose name contains a specific character. Which keyword should you use in your where clause?A . FINDB . BETWEENC . INCLUDESD . LIKEView AnswerAnswer: D
You have a table named Product. You create a view that includes all the products from the Product table that are in the Furniture category. You execute a statement on the Product table that deletes all the products in the Furniture category.
You have a table named Product. You create a view that includes all the products from the Product table that are in the Furniture category. You execute a statement on the Product table that deletes all the products in the Furniture category. After you execute the statement, the result set...
Which statement should you use?
You need to populate a table named Employee Copy with data from an existing table named Employee. Which statement should you use? A . Option AB . Option BC . Option CD . Option DView AnswerAnswer: D
Which type of join do these results represent?
You have a Customer table and an Order table. You join the Customer table with the Order table by using the CusromerID column. The results include: - All customers and their orders - Customers who have no orders Which type of join do these results represent?A . complete joinB ....
Which command should you use?
You need to enable a new employee to authenticate to your database. Which command should you use?A . ALLOW USERB . CREATE USERC . ADD USERD . INSERT USERE . ALTER USERView AnswerAnswer: B
You have a table that contains the following data.
You have a table that contains the following data. This process is referred to as:A . defragmentation.B . normalization.C . fragmentation.D . denormalization.View AnswerAnswer: B
