SQL Quiz 4

1. Question

Which of the following can be used to import data in SQL

Both from SQL object explorer or from BULK INSERT query
using SQL object explorer
IMPORT query
Using BULK INSERT query

2. Question

What are the fields that has to be filled in bulk insert query for importing an external file?

Format
Firstrow
Fieldterminator
rowterminator

3. Question

What is the path to import external file in SQL using object explorer?

files->open new->select file
Database->azure data studio->new notebook
Database->tasks->import flat file
Database->tasks->import data

4. Question

While uploading external file from object explorer we have a option to modify the datatype of given columns

True
False

5. Question

What is the correct syntax for a comment?

– this is a comment
// this is a comment
[this is a comment]
— this is a comment

6. Question

Which of the following points are true about comment?

comments makes the query legible
they are not executable
they are for reference
comments makes the query more readable

7. Question

What is the functionality of where clause?

used to add in data
used to find the location of the file
used to filter records
none of the above

8. Question

What is the functionality of like clause?

used to find similar files
used for pattern matching
used for locating a file
used for locating a file

9. Question

any number of characters
represent single character
specify a range
all of the above

10. Question

What does “%” represent in like clause?

any number of characters
represent single character
specify a range
all of the above

11. Question

Datatypes of variables have to specified while creating a table

True
False

12. Question

Which of the following will insert values in the table?

insert in <table tame> values (values);
insert into <tablename> values (data types);
insert into <tablename> values (values);
insert values into <table tame> (values);

13. Question

What is the functionality of update clause?

modify the new records in a table
append records in a table
add in new records in a table
modify the existing records in a table

14. Question

What is the functionality of delete clause?

modify the existing records in a table
delete the existing records from a table
add in new records in a table
append records in a table

15. Question

delete table will erase the entire table from database

True
False

Quiz Summary

Information

Results