×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
You have a table named Product that contains the following data.
The PrcducrID column is the primary key. The CategoryID column is a foreign key to a separate table named Category.
You execute the following statement:
INSERT INTO Product
VALUES (3296, 'Table', 4444)
What is the result?
The PrcducrID column is the primary key. The CategoryID column is a foreign key to a separate table named Category.
You execute the following statement:
INSERT INTO Product
VALUES (3296, 'Table', 4444)
What is the result?
2.
You need to remove a view named EmployeeView from your database. Which statement should you use?
3.
You delete rows in a table named Order. The corresponding rows in the OrderItem table are automatically deleted. This process is an example of a/an:
4.
You have a table named Employee that includes four columns.
You execute the following statement:
SELECT *
FROM Employee
Which columns are returned?
You execute the following statement:
SELECT *
FROM Employee
Which columns are returned?
5.
What defines the amount of storage space that is allocated to a value in a column?
6.
You are creating a table to store customer data. The AccountNumber column uses values that always consist of one letter and four digits. Which data type should you use for the AccountNumber column?
7.
You have a Department table and an Employee table in your database. You need to ensure that an employee can be assigned to only an existing department. What should you apply to the Employee table?
8.
You need to store the first name, last name, and student ID for 100 students. This information will be stored in a table as:
9.
You assign User1 a set of permissions that include the WITH GRANT OPTION. The WITH GRANT OPTION enables User1 to:
10.
Which type of index changes the order in which the data is stored in a table?