Database Sql Internship In Chennai - Femtosoft Technologies

Note: After the timer finishes counting down, the exam will be submitted automatically

📝 Online Exam Instructions – Read Carefully Before Starting

1️⃣ Exam Details:

✅ Total Questions: (25 Questions)
✅ Exam Duration: (10 Minutes)

✅ Exam Type: MCQs

2️⃣ System Requirements:

✔ Use a laptop/desktop with a stable internet connection.
✔ Recommended browsers: Chrome, Firefox, Edge (latest versions).
✔ Ensure your webcam & microphone are working (if required).

3️⃣ Before Starting the Exam:

🖊 Fill in the Exam Registration Form Correctly

- - Full Name (This will be used for the certificate)
  - WhatsApp Number (Certificate will be sent to this number)
  - Email ID (Ensure it's correct; certificate & results will be emailed)

⚠️ Incorrect details may result in delays or disqualification.

4️⃣ Submission & Certification Process:

📌 Ensure all answers are submitted before the timer ends.
📌 Once submitted, you cannot change your responses.
📌 After passing, your certificate will be automatically generated with your registered name.

🎉 Congratulations on your success!

🎯 Stay focused and give your best! Good luck!

The number of attempts remaining is 2

Please fill all the required fields carefully, information provided will be used in offer letter and Completion Certificate.

1 / 25

1. What keyword do you use to prevent the execution of multiple transactions in SQL Server?

A. SET IMPLICIT_TRANSACTIONS ON

B. SET TRANSACTIONS OFF

C. SET VIEW OFF

D. None of the above

2 / 25

2. How can you return only distinct values based on multiple columns in SQL?

A. SELECT DISTINCT column1, column2 FROM table_name;

B. SELECT column1, column2 FROM table_name DISTINCT;

C. SELECT UNIQUE column1, column2 FROM table_name;

D. None of the above

3 / 25

3. What type of indexing is best for read operations on large tables?

A. Read-optimized indexing

B. Write-optimized indexing

C. Bi-directional indexing

D. None of the above

4 / 25

4. When would you use a CROSS JOIN in SQL?

A. When you want to combine every row of one table with every row of another table

B. To filter joined records

C. To retrieve only matching records

D. None of the above

5 / 25

5. How can you find the total number of records in a table, excluding NULL values?

A. SELECT COUNT(*) FROM table_name WHERE column_name IS NOT NULL;

B. SELECT COUNT(*) EXCLUDE NULL FROM table_name;

C. SELECT TOTAL(column_name) FROM table_name;

D. None of the above

6 / 25

6. How can you remove all records from a table without removing the table itself?

A. DELETE FROM table_name;

B. REMOVE ALL FROM table_name;

C. TRUNCATE TABLE table_name;

D. DROP TABLE table_name;

7 / 25

7. What is the purpose of the INNER JOIN in SQL?

A. Retrieves all rows from both tables

B. None of the above

C. Combines rows from two or more tables based on a related column

8 / 25

8. When is it appropriate to use a temporary table?

A. When you need to store intermediate results temporarily

B. When data is static

C. When you have large datasets

D. None of the above

9 / 25

9. What type of join returns matching rows from each table based on the join condition?

A. INNER JOIN

B. OUTER JOIN

C. SELF JOIN

D. CROSS JOIN

10 / 25

10. What is multivalued dependency in a database?

A. A dependency where a single attribute determines multiple values

B. A dependency where one value depends on another

C. A dependency that does not affect normalization

D. None of the above

11 / 25

11. What is a composite key?

A. A key formed by combining multiple columns

B. A single unique key

C. A key that is automatically generated

D. None of the above

12 / 25

12. What is dynamic SQL?

A. SQL statements constructed at runtime

B. Predefined SQL statements

C. Stored SQL procedures

D. None of the above

13 / 25

13. How do you ensure that multiple SQL statements are executed as a single transaction?

A. Use BEGIN TRANSACTION followed by COMMIT or ROLLBACK

B. Use a stored procedure

C. Batch processing

D. None of the above

14 / 25

14. What is the difference between TRUNCATE and DELETE statements?

A. TRUNCATE removes all rows without logging individual row deletions; DELETE logs each row deletion

B. TRUNCATE can be rolled back; DELETE cannot

C. DELETE resets the table identity

D. None of the above

15 / 25

15. What potential issue could arise from using cursors in SQL?

A. They can lead to slower performance and increased resource consumption

B. They always execute faster than set-based operations

C. They can prevent data sources from being locked

D. None of the above

16 / 25

16. What is the purpose of indexing in a database?

A. To maintain the order of records

B. To speed up retrieval and search

C. To reduce duplication in records

D. None of the above

17 / 25

17. How do you create a user-defined function in SQL Server?

A. CREATE FUNCTION function_name(parameters) RETURNS datatype AS BEGIN ... END;

B. CREATE PROC procedure_name(...);

C. CREATE VIEW view_name AS SELECT ...;

D. CREATE TRIGGER trigger_name ON table_name;

18 / 25

18. Which of these statements is TRUE about SQL?

A. SQL is case-sensitive

B. SQL commands are not sensitive to spaces

C. SQL commands are sensitive to whitespace

D. None of the above

19 / 25

19. Which SQL statement is used to add a new column to an existing table?

A. ALTER TABLE table_name ADD column_name datatype;

B. UPDATE TABLE table_name SET column_name datatype;

C. INSERT INTO table_name (column_name datatype);

D. CREATE TABLE table_name ADD column_name datatype;

20 / 25

20. What will be the output of the following query?

SELECT * FROM users WHERE age NOT BETWEEN 18 AND 30;

A. Users aged 18 to 30

B. Users not aged 18 to 30

C. All users

D. An error

21 / 25

21. What does the CLONE command do in SQL?

A. Creates a copy of a database

B. Duplicates a table

C. It doesn’t exist in SQL

D. None of the above

22 / 25

22. Which SQL statement will display the structure of a database table?

A. SHOW TABLE table_name;

B. DESCRIBE table_name;

C. SELECT * FROM table_name;

D. None of the above

23 / 25

23. Which of the following statements is true regarding a SQL View?

A. A view is a virtual table

B. A view stores data physically

C. You cannot query a view

D. None of the above

24 / 25

24. What is the purpose of the PROCEDURE in SQL?

A. To create a single-use command

B. To store complex queries for later use

C. To generate reports

D. None of the above

25 / 25

25. What does the GROUP BY clause do in SQL?

A. Orders the data in ascending order

B. Combines multiple results into one row for grouped records

C. Filters the results

D. None of the above

DATABASE SQL INTERNSHIP

📝 Online Exam Instructions – Read Carefully Before Starting

1️⃣ Exam Details:

2️⃣ System Requirements:

3️⃣ Before Starting the Exam:

4️⃣ Submission & Certification Process: