Linkedin Transact-SQL (T-SQL) Assessment Answers

LinkedIn Transact-SQL (T-SQL) Assessment Answers 2023 (Top 5%) – Easy to Pass

/ Linkedin Skill Test Answers 2023 / By

LinkedIn Transact-SQL (T-SQL) Assessment Answers 2023 : Some people might wonder why they should consider taking an Transact-SQL (T-SQL) LinkedIn Assessment. Well, the answer is pretty simple. It helps you understand how you work and what your strengths and weaknesses are. It also helps you find out what careers would be a good fit for you, what jobs would be a good fit for you, and what skillsets would be a good fit for you.

The best thing about this LinkedIn Transact-SQL (T-SQL) Assessment is that it doesn’t take too much time to complete and it can help provide some really valuable information about yourself that will help shape your future career decisions.

LinkedIn Transact-SQL (T-SQL) Assessment Answers 2023

LinkedIn Transact-SQL (T-SQL) Skill Test Answers 2023: Transact-SQL (T-SQL) Skill Badge: Transact-SQL (T-SQL) LinkedIn Test Answers: In this post you will get all the correct answers of LinkedIn Transact-SQL (T-SQL) Assessment answers given by the experts. Get All LinkedIn Quiz Answers.

Note: Choose the correct answers marked with [x].

What is an LinkedIn Transact-SQL (T-SQL) Assessment and How Does it Work?

The LinkedIn Transact-SQL (T-SQL) Assessment is a skills test that helps LinkedIn users identify their top skills and develop a career plan. The Assessment is designed to help people get the most out of LinkedIn by highlighting their skills and helping them set goals.

This LinkedIn Transact-SQL (T-SQL) Assessment will help you identify your strengths so that you can make the most of your online presence.

LinkedIn Transact-SQL (T-SQL) Assessment That Check Your Knowledge

The LinkedIn Transact-SQL (T-SQL) Assessment to tests your knowledge on the Transact-SQL (T-SQL) that will happen on August 21st.

This LinkedIn Transact-SQL (T-SQL) quiz answers will test your knowledge on all things Transact-SQL (T-SQL) related such as the different phases of an Transact-SQL (T-SQL), what causes an Transact-SQL (T-SQL), and how to view an Transact-SQL (T-SQL).

How to Prepare for the LinkedIn Transact-SQL (T-SQL) Assessment Answers

The LinkedIn Transact-SQL (T-SQL) Assessment is a new Assessment that is being released by LinkedIn. It will be released on the 4th of July. The LinkedIn Transact-SQL (T-SQL) Skill Test Answers will have questions about topics such as company history, company culture, and other topics that are related to the company.

To prepare for the LinkedIn Transact-SQL (T-SQL) Assessment Answers, you can find out more about LinkedIn by reading up on their blog posts and articles. You can also read up on what other people are saying about them on social media sites like Twitter and Facebook.

You can also research what other companies are doing to prepare for this LinkedIn Transact-SQL (T-SQL) Assessment. This way you can see how they are preparing for it and use their ideas to help you prepare for it as well!

Check Your Skills & Expertise with The LinkedIn Transact-SQL (T-SQL) Assessment

The LinkedIn Transact-SQL (T-SQL) Quiz is a free Assessment that will help you identify your skills and expertise. It will also recommend career paths that are suitable for you based on your interests and skills.

This LinkedIn Transact-SQL (T-SQL) Quiz Answers is a great way to get started on finding the right career path for you. You can take it as many times as you want, and it always provides new insights into your strengths and weaknesses, as well as what’s available in the job market.

LinkedIn Transact-SQL (T-SQL) Assessment Questions with Answers

Q1. Which answer is NOT a type of table index?

  • [ ] nonclustered
  • [ ] unique
  • [x] heap
  • [ ] hash

Q2. The keywords AND, IN, LIKE, and between all belong to a category called what?

  • [ ] joining operations
  • [ ] linking operations
  • [ ] criteria operations
  • [x] logical operations

Q3. What is the result of this series of statements?

BEGIN TRY
SELECT 'Foo' AS Result;
END TRY
BEGIN CATCH
SELECT 'Bar' AS Result;
END CATCH
  • [x] Foo
  • [ ] FooBar
  • [ ] Foo Bar
  • [ ] Bar

Q4. Given these two tables, which query generates a listing showing student names and the department office location where you could reach each student?

  • [ ] SELECT Students.first_name, Students.last_name, Departments.office_location FROM Students, Departments;
  • [x] SELECT Students.first_name, Students.last_name, Departments.office_location FROM Students JOIN Departments ON Students.department = Departments.department;
  • [ ] SELECT Students.first_name, Students.last_name, Departments.office_location FROM Students JOIN Departments;
  • [ ] SELECT Students.first_name, Students.last_name, Departments.office_location FROM Students ON Students.department = Departments.department;

Q5. What is an example of a DDL command in SQL?

  • [ ] TRUNCATE TABLE
  • [ ] DELETE
  • [ ] MERGE
  • [x] DROP

Q6. Given the Games table pictured, which query generates the results shown?

  • [ ] :
  SELECT GameType, MaxPlayers, count(*) AS NumberOfGames
  FROM Games
  GROUP BY MaxPlayers, GameType
  ORDER BY MaxPlayers, GameType;
  • [x] :
  SELECT GameType, MaxPlayers, count(*) AS NumberOfGames
  FROM Games
  GROUP BY GameType, MaxPlayers
  ORDER BY GameType;
  • [ ] :
  SELECT GameType, count(Players) AS MaxPlayers, NumberOfGames
  FROM Games
  GROUP BY GameType, MaxPlayers
  ORDER BY GameType;
  • [ ] :
  SELECT GameType, MaxPlayers, count(*) AS NumberOfGames
  FROM Games
  GROUP BY GameType
  ORDER BY MaxPlayers;

Q7. Which answer is a possible result of the sequence of commands below?

  DECLARE @UniqueID uniqueidentifier = NEWID();
  SELECT @UniqueID AS Result;
  • [ ] 1
  • [x] bb261196-66a5-43af-815d-123fc593cf3a
  • [ ] z350mpj1-62lx-40ww-9ho0-4u1875rt2mx4
  • [ ] 0x2400001155F04846674AD4590F832C0

Q8. You need to find all students that are not on the “Chemistry Cats” team. Which query does NOT work for this task?

  • [x] :

“`SELECT * FROM Students
WHERE team NOT ‘Chemistry Cats’;

- [ ] :

SELECT * FROM Students
WHERE team <> ‘Chemistry Cats’;

- [ ] :

SELECT * FROM Students
WHERE team != ‘Chemistry Cats’;

- [ ] :

SELECT * FROM Students
WHERE NOT team = ‘Chemistry Cats’;

Q9. You need to write a query that returns all Employees that have a LastName starting with the letter A. Which `WHERE` clause should you use to fill in the blank in this query?

- [ ] `WHERE LastName = A*`
- [ ] `WHERE LastName = LIKE '%A%'`
- [x] `WHERE LastName LIKE 'A%'`
- [ ] `WHERE LastName IN ('A*')`

Q10. Which query shows the first name, department, and team of all students with the two lowest points?

- [ ] `SELECT LIMIT(2) first_name, department, team FROM Students ORDER BY points ASC;`
- [ ] `SELECT TOP(2) first_name, deprtment, team FROM Students ORDER BY points DESC;`
- [x] `SELECT TOP(2) WITH TIES first_name, department, team FROM Students ORDER BY points;`
- [ ] `SELECT BOTTOM(2) first_name, department, team FROM Students ORDER BY points ASC;`

> the picture of table is important here and there it can be seen that there are only two value with min points. Secondly, the previous answer was wrong because order by `DESC` will put highest points into the beginning of result list and `TOP(2)` will take first two highest points, and we need the lowest points.

Q11. What is the result of this statement?

tsql
SELECT FLOOR(-1234.321)

- [ ] -1234.3
- [ ] -1234
- [x] -1235
- [ ] 1234.321

Q12. Which is the best approach to update the last name of the student Donette Figgins to Smith

- [ ] `UPDATE Students SET last_name = 'Smith' WHERE email = 'dfiggins@rouxacademy.com';`
- [ ] `UPDATE Students SET last_name = 'Figgins' WHERE email = 'dfiggins@rouxacademy.com';`
- [ ] `UPDATE Students SET last_name = 'Figgins' WHERE last_name = 'Smith' AND first-name = 'Donette';`
- [x] `UPDATE Students SET last_name = 'Smith' WHERE last_name = 'Figgins' AND first-name = 'Donette';`

Q13. Which of these data types is an approximate numeric?

- [x] real
- [ ] bit
- [ ] decimal
- [ ] numeric

Q14. You need to remove all data from a table name Products. Which query fully logs the removal of each record?

- [ ] `TRUNCATE FROM Products *;`
- [x] `DELETE FROM Products;`
- [ ] `DELETE * FROM Products;`
- [ ] `TRUNCATE TABLE Products;`

Q15. What is the result of this query?

tsql
SELECT 1 / 2 AS Result;

- [ ] 0.5
- [ ] error
- [x] 0
- [ ] 2

Q16. which data type will most efficiently store a person's age in years?

- [ ] `float`
- [ ] `int`
- [x] `tinyint`
- [ ] `bigint`

Q17. What is the result of this query?

tsql
SELECT ‘abc\
def’ AS Result;

- [ ] abc\def
- [x] abcdef
- [ ] error
- [ ] abc def

Q18. To select a random student from the table, which statement could you use?

- [x] `SELECT TOP(1) first_name, last_name FROM Students ORDER BY NEWID();`
- [ ] `SELECT TOP(1) RAND(first_name, last_name) FROM Student;`
- [ ] `SELECT TOP(1) first_name, last_name FROM Student;`
- [ ] `SELECT TOP(1) first_name, last_name FROM RAND(Student);`

[https://www.petefreitag.com/item/466.cfm](https://www.petefreitag.com/item/466.cfm)

Q19. What result is returned after executing the following commands?

tsql
DECLARE @MyVariable int;
SET @MyVariable = 1;
GO
SELECT @MyVariable;

- [x] error
- [ ] 1
- [ ] null
- [ ] @MyVariable

Q20. Which statement creates a new database schema named Sales and establish Sharon as the owner?

- [ ] `ALTER USER Sharon WITH DEFAULT_SCHEMA = Sales;`
- [ ] `ALTER USER Sharon SET SCHEMA Sales;`
- [ ] `CREATE SCHEMA Sales SET OWNER Sharon;`
- [x] `CREATE SCHEMA Sales AUTHORIZATION Sharon;`

[Reference link](https://docs.microsoft.com/en-us/sql/t-sql/statements/create-schema-transact-sql?view=sql-server-ver15)

Q21. The result of a `CROSS JOIN` between a table with 4 rows, and one with 5 rows, will give with \_ rows.

- [ ] 1024
- [x] 20
- [ ] 0
- [ ] 9

Q22. You need to write a query that returns all products that have a SerialNumber ending with "10_3". Which `WHERE` clause should you use to fill in the blank in this query?

tsql
SELECT ProductID, ProductName, SerialNumber
FROM Products______ ;

- [x] `WHERE SerialNumber LIKE '%10_3'`
- [ ] `WHERE SerialNumber LIKE ('%10'+'_'+'3')`
- [ ] `WHERE SerialNumber LIKE '%10"_"3'`
- [ ] `WHERE SerialNumber LIKE '%10[_]3'`

> The underscore will match any single character so you must bracket it to match a literal `_`, otherwise you could potentially return a serial number ending in '1013', for example.

Q23. When no join type between multiple tables in a query's `FROM` clause is specified, what type of join is assumed?

- [x] `INNER`
- [ ] `RIGHT`
- [ ] `LEFT`
- [ ] `FULL`

Q24. How many bytes of storage does the int data type consume?

- [ ] 1 byte
- [ ] 2 bytes
- [x] 4 bytes
- [ ] 8 bytes

Q25. What does a `RIGHT JOIN` ensure?

- [ ] that only records from the rightmost table will be displayed
- [ ] that no records from the rightmost table are displayed if the records dont have corresponding records in the left table
- [ ] that records from the rightmost table will be displayed only if the records have a corresponding value in the leftmost table
- [x] that all records from the rightmost table are represented in the result, even if there are no corresponding records in the left table

Q26. You execute the following three queries. What is the result?

tsql
Create table students(id int identity(1000,1), firstname varchar(20),
lastname varchar(30));
insert into students(firstname,lastname)values(‘mark’,’twain’);
select * from students;

- [ ]
  studentid firstname lastname
  1 1001 mark twain

- [ ]
  studentid firstname lastname
  1 1 mark twain

- [x] studentid firstname lastname
      1 1000 mark twain

- [ ]
  studentid firstname lastname
  1 null mark twain

Q27. Given a table with the following structure, which query returns all student names with the highest grade?

tsql
CREATE TABLE Students (
StudentName varchar(50),
Grade int );

- [ ] `SELECT StudentName FROM Students WHERE Grade = MAX(Grade);`
- [ ] `SELECT TOP(1) StudentName FROM Students ORDER BY Grade;`
- [x] `SELECT TOP(1) WITH TIES StudentName FROM Students ORDER BY Grade DESC;`
- [ ] `SELECT StudentName, MAX(Grade) FROM Students ORDER BY Grade DESC;`

> `top(1)` with ties will take the highest grade and all other students with the same grade (because they are order by grade) and matches the highest grade.

Q28. What role does "inventory" play?

tsql
select bookid, boooktitle, bookauthor,quantityonhand from inventory.books;

- [ ] you only want to see results from books currently in inventory
- [x] it instructs the query engine to find the books table in the inventory schema
- [ ] it instructs the query engine to find the books table in the inventory database
- [ ] it instructs the query engine to join the books table to the inventory schema

> `select * from dbo.books` here `dbo` is a schema and the inventory is also schema. If we'd like to specify a database we should use `db_name.schema_name.table_name`

Q29. What is the result of an `INNER JOIN` between table1 and table2?

- [x] Only records that have corresponding entries in table1 and table2 are displayed.
- [ ] No records from table1 are ever displayed.
- [ ] All records from table1 are displayed, regardless of whether the records have a corresponding row in table2
- [ ] Only records that have no corresponding records in table1 or table2 are displayed.

Q30. To remove all of the content from the Students table but keep the schema, which statement should you use?

- [x] `TRUNCATE TABLE Students;`
- [ ] `TRUNCATE * FROM Students;`
- [ ] `DROP TABLE Students;`
- [ ] `REMOVE * FROM Students;`

Q31. Review the `CREATE TABLE` statement below. Which option, when placed in the blank space, ensures that the BookISBN column will not contain any duplicate values?

tsql
CREATE TABLE Books (
BookID int PRIMARY KEY,
BookISBN char(13) NOT NULL _,
BookTitle nvarchar(100) NOT NULL
);

- [ ] `NO DUPLICATES`
- [ ] `UNIQUE CONSTRAINT AK_Books_BookISBN`
- [ ] D`UPLICATE CONSTRAINT (AK_Books_BookISBN)`
- [x] `CONSTRAINT AK_Books_BookISBN UNIQUE`

Q32. Given a table with the following structure, which query will not return the lowest grade earned by any student?

tsql
CREATE TABLE Students (
StudentName varchar(50),
Grade int
);

- [ ] :

tsql
SELECT StudentName
FROM Students
WHERE Grade = (SELECT MIN(Grade) FROM Student);

- [ ] :

tsql
SELECT TOP(1) Grade
FROM Students
ORDER BY Grade;

- [ ] :

tsql
SELECT MIN(Grade)
FROM Students

- [x] :

tsql
SELECT MIN(Grade)
FROM Students
ORDER BY Grade;

**Explanation:** Column `Students.Grade` is invalid in the `ORDER BY` clause because it is not contained in either an aggregate function or the `GROUP BY` clause.

- [x] :

tsql
SELECT MIN(Grade)
FROM Students
GROUP BY Grade;

**Explanation:** Grouping will return a list of all grades grouped by grade. The prompt wants just one returned row.

Q33. Refer to the figure below.

![T-SQL-Q33](images/Q33.jpg)

- [ ] `UPDATE Students SET last_name='Smith', email = 'dsmith@rouxacademy.com' WHERE id='56295';`
- [ ] `UPDATE Students SET last_name='Smith' AND email = 'dsmith@rouxacademy.com' WHERE id='56295';`
- [ ] `UPDATE Students SET last_name='Smith' AND email = 'dsmith@rouxacademy.com' WHERE id=56295;`
- [x] `UPDATE Students SET last_name='Smith', email = 'dsmith@rouxacademy.com' WHERE id=56295;`

Q34. You would like to have a record added to a TableB every time a record is modified in TableA. What technique should you look at implementing?

- [ ] You should create a DML trigger on the server.
- [ ] You should create a DDL trigger on the database.
- [x] You should create a DML trigger on TableA.
- [ ] You should create a DML trigger on TableB.

Q35. What is the problem with this code?

tsql
DECLARE @Counter int;
SET @Counter = 1;
WHILE @Counter > 0
BEGIN
SET @Counter = @Counter +1;
END;

- [ ] There is no END WHILE statement;
- [ ] The local varaible is not available to the WHILE block.
- [x] The query causes an infinite loop.
- [ ] "Counter" is an invalid variable name.

Q36. Which is the right query to change the name of the Philosophy Pandas team to the Philosophy Parrots?

![T-SQL-Q36](images/Q36.jpg)

- [x] `UPDATES Students SET team = 'Philosophy Parrots' WHERE team = 'Philosophy Pandas';`
- [ ] `UPDATES Students SET team = `Philosophy Parrots`WHERE team =`Philosophy Pandas`;`
- [ ] `UPDATES Students SET team = "Philosophy Parrots" WHERE team = "Philosophy Pandas";`
- [ ] `UPDATES Students SET team = Philosophy Parrots WHERE team = Philosophy Pandas;`

Q37. What is the result of this query?

tsql
SELECT 123+’123′ AS Result;

- [ ] error
- [ ] '123''123'
- [ ] 123123
- [x] 246

Q38. To combine the results of two or more `SELECT` statements, removing duplicates, which keyword can you use?

- [ ] DEDUPE
- [ ] SELECT
- [ ] MERGE
- [x] UNION

Q39. You run this series of statements. What is the final result?

tsql
CREATE TABLE MyTable (MyValue int);
INSERT INTO MyTable VALUES (1);
WHILE (SELECT MyValue FROM MyTable) < 5
BEGIN
UPDATE My Table SET MyValue = MyValue + 1;
END;
SELECT MyValue AS Result FROM MyTable;

- [ ] 5
- [ ] error
- [ ] 1
- [ ] 6

Q40. Is there an error with this query? If so, which statement best describes the problem?

tsql
SELECT OrderID, SUM(LineTotal) AS SubTotal
FROM Sales
WHERE SUM(LineTotal) > 1000
GROUP BY OrderID
ORDER BY OrderID;

- [x] Yes, a `WHERE` clause cannot be used with an aggregate function.
- [ ] Yes, you cannot `GROUP BY` and `ORDER BY` the same field.
- [ ] No, there is nothing wrong with this query.
- [ ] Yes, the `WHERE` clause should use the `SubTotal` alias.

Q41. You created the two tables below. Later, you decide that you want the database to remove all books from the Books table if the related publisher is deleted from the Publishers table. What command should you run?

tsql
CREATE TABLE Books (
BookID int PRIMARY KEY,
BookTitle nvarchar(100) NOT NULL,
PublisherID int NOT NULL
);
CREATE TABLE Publishers (
PublisherID int PRIMARY KEY,
PublisherName nvarchar(50)
);

- [ ] :

ALTER TABLE Books
ADD CONSTRAINT FK Books_PublisherID
FOREIGN KEY (PublisherID)
REFERENCES Publishers (PublisherID) ON UPDATE SET NULL

- [x] :

ALTER TABLE Books
ADD CONSTRAINT FK Books_PublisherID
FOREIGN KEY (PublisherID)
REFERENCES Publishers (PublisherID) ON DELETE CASCADE

- [ ] :

ALTER TABLE Books
ADD CONSTRAINT FK_Books_PublisherID
FOREIGN KEY (PublisherID)
REFERENCES Publishers (PublisherID)

- [ ] :

ALTER TABLE Publishers
ADD CONSTRAINT FK_Publishers_PublisherID
FOREIGN KEY (PublisherID)
REFERENCES Books (PublisherID) CASCADE DELETE

Q42. Your database currently has a table called Inventory in the Warehouse schema. You need to move the table to the Products schema. Which query accomplishes this goal?

- [x] `ALTER SCHEMA Products TRANSFER Warehouse.Inventory;`
- [ ] `ALTER TABLE Warehouse.Inventory TRANSFER Products.Inventory;`
- [ ] `ALTER TABLE Warehouse.Inventory ADD SCHEMA Products;`
- [ ] `ALTER SCHEMA Warehouse ADD TABLE Inventory;`

Q43. Which option—when placed in the blank space—establishes the PersonlD column as the primary key for the table with a nonclustered index?

sql
CREATE TABLE People (
PersonID int NOT NULL,
PersonName nvarchar(50),

);

- [ ] `INDEX ON PersonID (PRIMARY KEY PK_People)`
- [ ] `ADD NONCLUSTERED PRIMARY KEY CONSTRAINT PK_People ON PersonID`
- [ ] `CONSTRAINT PK_People PRIMARY KEY NONCLUSTERED (PersonID)`
- [x] `PRIMARY KEY CONSTRAINT (PersonID) NONCLUSTERED INDEX`

Q44. Which statement could you use to select a random student from this table?

![T-SQL-Q36](images/Q36.jpg)

- [x] `SELECT TOP(1) first_name, last_name FROM Students ORDER BY NEWID();`
- [ ] `SELECT TOP(1) RAND(first_name, last_name) FROM Student;`
- [ ] `SELECT TOP(1) first_name, last_name FROM Student;`
- [ ] `SELECT TOP(1) first_name, last_name FROM RAND(Student);`

Q45. You need to create a simple database backup in the server's `Z:\Backups` directory. Which query should you use?

- [ ] `BACKUP MyDatabase TO LOCATION = 'Z:\Backups\MyDatabase.bak';`
- [ ] `CREATE BACKUP (DATABASE = 'MyDatabase' TO DISK = 'Z:\Backups\MyDatabase. bak');`
- [ ] `BACKUP DATABASE MyDatabase ON 'Z:\Backups\MyDatabase.bak';`
- [x] `BACKUP DATABASE MyDatabase TO DISK = 'z:\Backups\MyDatabase.bak';`

Q46. Suppose you want to have the name of a transaction called myTransaction recorded in the transaction log. Which statement represents the best way to accomplish this?

- [ ] `BEGIN TRAN myTransaction BEGIN LOG;`
- [ ] `BEGIN TRAN myTransaction WITH LOG;`
- [x] `BEGIN TRAN myTransaction WITH MARK;`
- [ ] `BEGIN TRAN WITH MARK myTransaction;`

Q47. Though not currently a requirement, what will a future release of SQL Server require of all SQL statements?Though not currently a requirement, what will a future release of SQL Server require of all SQL statements?

- [x] `All statements must end with a semicolon.`
- [ ] `All statements must operate on a table of data.`
- [ ] `All statements must always be written in uppercase letters.`
- [ ] `All statements must include more than one variable.`

Q48. Which is the best approach to update the last name and email address of a student with ID 56295?

- [ ] `UPDATE Students SET last_name='Smith', email = 'dsmith@rouxacademy.com' WHERE id='56295';`
- [x] `UPDATE Students SET last_name='Smith', email = 'dsmith@rouxacademy.com' WHERE id=56295;`
- [ ] `UPDATE Students SET last_name='Smith' AND email = 'dsmith@rouxacademy.com' WHERE id=56295;`
- [ ] `UPDATE Students SET last_name='Smith' AND email = 'dsmith@rouxacademy.com' WHERE id='56295';`

Q49. What is the result of this query?

sql
SELECT 123+’abc’ AS Result;

- [x] 123abc
- [ ] 123'abc'
- [ ] '123abc'
- [ ] error

Q50.What output will the following SQL sequence produce? Assume that the tables have been created and all the columns exist.

tsql
INSERT INTO Account (acct,bal) VALUES (‘12345’, 100);
UPDATE Account SET bal=bal+100;
BEGIN;
UPDATE Account SET bal=bal+100.
ROLLBACK;
SELECT bal FROM Account WHERE acct=’12345′;
);
“`

  • [ ] 100
  • [x] 200
  • [ ] 300
  • [ ] You will get an error because ROLLBACK deletes the row that was update

Reference link