CAMPUS RECRUITMENT EXAMINATION BY AFFIXIOUS

0 votes, 0 avg
5
Created on By Priyanshu Maithani

DBA LPU

Are you a driven mind with impeccable skills? We at Affixious bring to you our eagerly awaited campus recruitment exam duly designed to evaluate your technical skills. Take this short test and stand a chance to be part of the Affixious family.

Kindly fill in your contact details.

1 / 20

1. In SQL, testing whether a subquery is empty is done using

2 / 20

2. Which of the following is an authorization command of SQL ?

3 / 20

3. Which one of the following aggregate SQL function returns number of rows ?

4 / 20

4. A collection of tables to represent both data and the relationships among data, is known as.

5 / 20

5. In a LIKE clause, you can could ask for any value ending in “ton” by writing.

6 / 20

6. Which one is not an aggregate function in SQL ?

7 / 20

7. Which one of the following is a valid join type ?

8 / 20

8. The command that all instructors with salary over $100,000 receive a 3 percent raise, would be written as

9 / 20

9. The JOIN which returns all the records from the right table in conjunction with the matching records from the left table
and if there are no matching values in the left table, it returns NULL. Which is this JOIN?

10 / 20

10. Which of the following SQL query is correct for selecting the name of staffs from ‘tblstaff’ table where salary is 15,000 or 25,000?

11 / 20

11. The database manager who authorizes all the new users, modifies database and takes grants privilege is, is known to be.

12 / 20

12. Grant is a command from SQL type :

13 / 20

13. SQL has how many main commands for DDL:

14 / 20

14. In SQL, the grant statement is used to confer.

15 / 20

15. Which operator is used to compare a value to a specified list of values?

16 / 20

16. Each of the types of authorizations is called a/an.

17 / 20

17. In SQL, which command is used to make permanent changes made by statements issue since the beginning of a transaction?

18 / 20

18. What operator performs pattern matching?

19 / 20

19. The command used to delete a particular column in a relation is

20 / 20

20. Scalar subqueries are also useful in SQL.

Your score is

The average score is 19%

0%