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 is schema binding in SQL?

A. It binds the view or function to the schema, preventing changes

B. It allows any changes to the time column

C. It is used to track schema changes

D. None of the above

2 / 25

2. What is the purpose of the EXPLAIN command in SQL?

A. To analyze and optimize the execution plan

B. To display current database statistics

C. To run a dry execution of the query

D. None of the above

3 / 25

3. 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

4 / 25

4. What is an example of a non-correlated subquery?

A. SELECT * FROM table1 WHERE column1 IN (SELECT column1 FROM table2);

B. SELECT * FROM table1 WHERE column1 = (SELECT column1 FROM table2 WHERE condition);

C. SELECT * FROM table1 WHERE column1 < (SELECT MAX(column1) FROM table2);

D. None of the above

5 / 25

5. Which SQL function will return the current user ID?

A. CURRENT_USER

B. USER_ID()

C. GET_USER()

D. USER()

6 / 25

6. What happens if you attempt to insert a record with a primary key that already exists in the table?

A. It results in a violation of the primary key constraint

B. The record gets updated

C. It gets ignored

D. None of the above

7 / 25

7. Which SQL statement is used to give someone access to a database?

A. GRANT [privileges] ON database_name TO user;

B. ALLOW user ON database_name;

C. ASSIGN ACCESS TO database_name;

D. None of the above

8 / 25

8. How does the CASE statement work in SQL?

A. It allows conditional logic in SQL queries

B. It filters results based on conditions

C. It creates temporary columns

D. None of the above

9 / 25

9. 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

10 / 25

10. How do you perform a full outer join in SQL?

A. SELECT * FROM tableA FULL OUTER JOIN tableB ON tableA.id = tableB.id;

B. SELECT * FROM tableA JOIN tableB

C. SELECT * FROM tableA LEFT JOIN tableB;

D. None of the above

11 / 25

11. How can you create an index on multiple columns in SQL?

A. CREATE INDEX index_name ON table_name (column1, column2);

B. CREATE INDEX column1, column2 ON table_name;

C. CREATE MULTI INDEX ON table_name;

D. None of the above

12 / 25

12. What is the impact of enabling full-text search on your database?

A. It can improve search performance but may increase resource usage

B. It does not affect performance

C. It reduces query execution speed

D. None of the above

13 / 25

13. What does the HAVING clause do in conjunction with GROUP BY?

A. Filters results after aggregation

B. Filters results before aggregation

C. Sorts the results

D. None of the above

14 / 25

14. Which function is used to get the current date and time in SQL Server?

A. CURRENT_TIMESTAMP

B. GETDATE()

C. NOW()

D. SYSDATE()

15 / 25

15. What is the difference between an INNER JOIN and a LEFT JOIN?

A. Inner join returns only matched records; left join returns all records from the left table

B. Inner join returns all records

C. There is no difference

D. None of the above

16 / 25

16. What is a materialized view?

A. A view that stores actual data

B. A view that presents a virtual table

C. A type of index

D. None of the above

17 / 25

17. What is the purpose of index fragmentation?

A. It can affect database performance and retrieval speed

B. It contributes to faster insert operations

C. It holds unnecessary data

D. None of the above

18 / 25

18. What is the output of the following SQL?

SELECT 1 + 1 AS x;

A. An error

B. 1

C. 2

D. x

19 / 25

19. What output will be produced by this SQL command?

SELECT UNIX_TIMESTAMP();

A. Current timestamp in seconds

B. Current date

C. Current timestamp in milliseconds

D. Compilation Error

20 / 25

20. What type of JOIN returns all rows from the left table and matched rows from the right table?

A. RIGHT JOIN

B. INNER JOIN

C. OUTER JOIN

D. LEFT JOIN

21 / 25

21. What is a default value in SQL?

A. The value assigned when a record is created

B. A value that must always be provided

C. The value assigned before querying

D. None of the above

22 / 25

22. What is the purpose of the JOIN clause in SQL?

A. To combine rows from two or more tables

B. To sort the result set

C. To filter results

D. To modify records

23 / 25

23. What will be the output of the following SQL?

SELECT * FROM employees ORDER BY age DESC;

A. Employees sorted by age in ascending order

B. Employees sorted by age in descending order

C. Random order of employees

D. An error

24 / 25

24. What does the GROUP BY clause do?

A. Selects all records

B. Aggregates data

C. Filters results

D. Arranges alphabetically

25 / 25

25. What is the default collation in MySQL for string comparison?

A. BINARY

B. LATIN1

C. utf8mb4

D. utf8

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: