You need to populate a table named EmployeeCopy with data from an existing table named Employee.
Which statement should you use?
Answer : D
You execute the following statement:
Answer : A
Which keyword would you use in a select statement to return rows that meet a specific condition?
Answer : A
You have a table named Employee that includes the following columns:
EmployeeID -
Smp1oyeeName -
Which statement should you use to return the number of rows in the table?
Answer : D
The Product table contains the following data.
Answer : C
Which command should you use to remove a table from a database?
Answer : C
You need to store the contact information for each student in your school database.
You should store each student's information in a:
Answer : C
Which category of SQL statements is used to add, remove, and modify database structures?
Answer : D
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 -
Answer : D
Data in a database is stored in:
Answer : A
You have a table named Student that contains 100 rows. Some of the rows have a NULL value in the FirstName column.
You execute the following statement:
DELETE FROM Student -
What is the result?
Answer : A
You need to establish a set of permissions that you can routinely assign to new users.
What should you create?
Answer : D
Which database term is used to describe the process of applying a backup to a damaged or corrupt database?
Answer : B
You need to disable User1's access to view the data in the Customer table.
Which statement should you use?
Answer : C
Denormalization is performed in order to:
Answer : D
Have any questions or issues ? Please dont hesitate to contact us