WorksheetsTrainingQIZZ(HCM22_FR_NET_01)
Total questions: 32
Worksheet time: 16mins
[LinhTP8] What is the result of the below query: SELECT SUBSTRING('DOTNET', 1, 3) AS 'Substring'
DOT
OTN
OT
None of the above.
[LinhTP8] The SELECT statement must include which of the following clause:
SELECT clause
FROM clause
Both A and B.
None of the above.
[LinhTP8] Which of the following is true?
BUILT-IN functions in SQL Server are Nondeterministic.
ISNULL function in SQL Server is Deterministic.
All of the above.
None of the above.
[ThanhVH6]Which SQL function is used to count the number of rows in a SQL query?
NUMBER()
COUNT()
AVG()
SUM()
[ThanhVH6]The FROM SQL clause is used to…
Specify range for search condition
Specify search condition
Specify what table we are selecting or deleting data from.
[ThanhVH6]The UNION SQL clause can be used with…
The UPDATE clause only
The SELECT clause only
The DELETE and UPDATE clauses
None of the other three
If no ASC or DESC is specified after the ORDER BY clause, which keyword is used by default?
ASC
DESC
DOWN
No default value
BETWEEN in SQL is used to...
Specify a column as primary key
Specify the tables to use
Specify a range to test
The UNION statement is used to combine results from multiple queries into a single result set.
True
False
[ViLTT1]. List the different privileges a user can grant to other users
SELECT, CONNECT, RESOURCES
SELECT, FROM, WHERE
DELETE, TRUNCATE
UNION, MINUS, UNION ALL
[LongNT62] Which SQL statement is used to return only different values?
SELECT DIFFERENT
SELECT DISTINCT
SELECT UNIQUE
[LongNT62] Which SQL keyword is used to sort the result-set?
ORDER
SORT
ORDER BY
SORT BY
[LongNT62] With SQL, how do you select a column named "FirstName" from a table named "Persons"?
SELECT Persons.FirstName
EXTRACT FirstName FROM Persons
SELECT FirstName FROM Persons
[KhoaNA14] The following virtual table does not exist in SQL server
Deleted
Inserted
Tất cả đều tồn tại
Updated
[ThaoTT26]_Có mấy loại Join trong sql?
(5 ) inner join, outer join, across join, self join, excluding join
(4)inner join, outer join, across join, self join,
(3) inner join, outer join, across join
(2) outer join, across join
[ThaoTT26] Left Join thuộc loại nào?
Inner Join
Outer Join
Across Join
Which operator is used to select values within a range?
BETWEEN
WITHIN
RANGE
[ThangVT5] How many types of "Join" in SQL?
3
4
5
6
The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true
True
False
[TinNH7] Please choose the option corresponding to the statement used to create the Database in SQL
Create table name_database
Update database name_database
Create database name_database
Create data name_database
The NOT NULL constraint enforces a column to not accept NULL values.
True
False
[TinNH7]To display the table in ascending order of the column ‘‘Name’’, in the select statement we use which of the following clauses:
Having Name asc
Group by Name asc
Order by Name desc
Order by Name asc
[KhoaNA14] Which of the following statements is not correct about ORDER BY .?
ORDER BY is used to sort and return data from the SELECT in the command
When using ORDER BY, there is no need to write the sort direction
ORDER BY can sort by multiple columns
ORDER BY can be sorted in descending order using the keyword ASC
Restore Database <Ten_CSDL> from disk = '<Backup file location + file name>
Is the question correct to delete DATABASE?
YES
NO
[KhoaNA14] Select true expression !
Stored Procedure trong sql server có chứa các câu trúc điều khiển (IF, FOR, WHILE, SWITCH..CASE).
Stored Procedure trong sql server có các kiểu dữ liệu như trong Dec-C.
Stored Procedure trong sql server có thể nhận vào các tham số cũng như trả về giá trị thông qua tham số.
Có thể mã hóa code của Stored Procedure trong sql server để người khác có thể xem nhưng không thể chỉnh sửa.*
[ThangVT5] If "n" is the number of columns listed in the ROLLUP,
there will be ...... levels of subtotals
n
n+1
n-2
n+2
[ThangVT5] If "n" is the number of columns listed in the CUBE, there will be ... subtotal combinations
3^n
n^1
2^n
n^2
[ViLTT1]. What TCP/IP port does the SQL server run on?
1024
1433
88
80
[TinNH7] Please select the Select statement that performs correctly in the Select statements below:
SELECT * FROM t1 ORDER BY id DESC;
SELECT * FROM t1 WHERE BY id;
SELECT * WHERE t1 ORDER BY id ASC;
SELECT % FROM t1 WHERE BY id;
[ViLTT]. Suppose a Student column has 2 columns, Name and Marks. How to get the scores of the top 3 students?
SELECT Name, Marks FROM Student s1 where 3 >= (SELECT COUNT(*) FROM Student s1.marks = s2.marks)
SELECT Name, Marks FROM Student s1 where 3 <> (SELECT COUNT(*) FROM Student s1.marks = s2.marks)
SELECT Name, Marks FROM Student s1 where 3 <= (SELECT COUNT(*) FROM Student s1.marks = s2.marks)
SELECT Name, Marks FROM Student s1 where 3 != (SELECT COUNT(*) FROM Student s1.marks = s2.marks)
DECLARE @variable_name datatype [ = initial_value ],
@column_name datatype [ = initial_value ],...;
Is the question to create variable correct?
YES
NO,Correct is :
DECLARE @variable_name datatype [ = initial_value ],
@variable_name datatype [ = initial_value ],...;
(SELECT* FROM table_name WHERE _Conditional);
is a subquery in SQL?
YES
NO
