Live Help (Start Chat)
View Count: 0
Duration: 55 mins
Accessed date:
Not Yet Viewed
Post your comment / feedback here
 
 

Be the first one to comment about this video

Sorry!For this module there is no Assignments.
Question No: 1 of 30
Using ALTER TABLE statement , can we change the data type of an existing column? 
Options:
  1. Yes
  2. No
View Answer/Explanation:
a
Explanation:
The ALTER TABLE statement can be used to add,drop columns and also modify the data type of an existing column

Question No: 2 of 30
What can be done to insert a NULL value using an INSERT statement 
Options:
  1. The column name can be skipped
  2. We can specify a NULL value for the column
  3. Both a and b are correct
View Answer/Explanation:
c
Explanation:
For inserting NULL value into a column either column name can be skipped or NULL can be used for the value

Question No: 3 of 30
Which of the following options is correct? 
Options:
  1. DDL statements can be ROLLED back.
  2. DDL statements cannot be ROLLED back
  3. None of these
View Answer/Explanation:
c
Explanation:
DDL statements (CREATE, ALTER, DROP) cannot be rolled back

Question No: 4 of 30
Which of the following statement deletes all records from a table Employee? 
Options:
  1. DELETE * FROM Employee
  2. DELETE FROM Employee
  3. DROP * FROM Employee
  4. DROP FROM Employee
View Answer/Explanation:
b
Explanation:

Question No: 5 of 30
The identity column value is reset in case of which statement? 
Options:
  1. DELETE
  2. TRUNCATE
View Answer/Explanation:
b
Explanation:

Question No: 6 of 30
Which statement executes faster? 
Options:
  1. TRUNCATE
  2. DELETE
View Answer/Explanation:
a
Explanation:

Question No: 7 of 30
Can TRUNCATE statement be used on a table referenced by a foreign key constraint? 
Options:
  1. Yes
  2. No
View Answer/Explanation:
b
Explanation:

Question No: 8 of 30
Which statement is true? 
Options:
  1. Records using TRUNCATE statement can be rolled back
  2. Records using TRUNCATE statement cannot be rolled back

Question No: 9 of 30
Which of the following is false? 
Options:
  1. A primary key allows one null value
  2. A primary key can be made of more than one column
  3. A table can have only one primary key
View Answer/Explanation:
c
Explanation:
A primary key column cannot contain any null values.

Question No: 10 of 30
Which option is correct? 
Options:
  1. A UNIQUE KEY allows one null value
  2. A UNIQUE KEY allows more than one null value
View Answer/Explanation:
a
Explanation:
A UNIQUE KEY is similar to a PRIMARY KEY but unlike a PRIMARY KEY it allows only one NULL value.

  1