DBA LPU - Affixious

Created on February 17, 2023 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. Scalar subqueries are also useful in SQL.

1. Insertion statements

2. Deletion statement

3. Update statements

4. Retrieval statement

2 / 20

2. What operator performs pattern matching?

1. IS NULL operator

2. ASSIGNMENT operator

3. LIKE operator

4. NOT operator

3 / 20

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

1. Count

2. Mean

3. Min

4. All are aggregate function

4 / 20

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

1. ZIP

2. PACK

3. COMMIT

4. SAVE

5 / 20

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

1. Administrator

2. Author

3. Authorizer

4. Authenticator

6 / 20

6. 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?

1. SELECT sname from tblstaff WHERE salary IN (15000, 25000);

2. SELECT sname from tblstaff WHERE salary BETWEEN 15000 AND 25000;

3. Both A and B

4. None of the above

7 / 20

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

1. natural

2. full outer join

3. on

4. using

8 / 20

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

1. update instructor set salary=salary * 0.03 where salary > 100000;

2. update instructor set salary=salary * 0.03 where salary =100000;

3. update in instructor set salary=salary * 0.03 where salary >=100000;

4. update into instructor set salary=salary * 0.03 where salary >=100000;

9 / 20

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

1. Access

2. Secondary key

3. Foreign key

4. None of these

10 / 20

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

1. Any

2. In

3. Between

4. All

11 / 20

11. SQL has how many main commands for DDL:

1. 1

2. 2

3. 3

4. 4

12 / 20

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

1. avg

2. min

3. count

4. sum

13 / 20

13. 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?

1. CROSS JOIN

2. Right JOIN

3. Full OUTER JOIN

4. LEFT Join

14 / 20

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

1. Integrity constraint

2. Assertion

3. Authorization

4. Uniqueness

15 / 20

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

1. Entity relationship model

2. Relational Model

3. Object-based Data model

4. Semi structured data model

16 / 20

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

1. DISTINCT

2. UNIQUE

3. NULL

4. EXISTS

17 / 20

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

1. LIKE ton$

2. LIKE *ton

3. LIKE %ton

4. LIKE &ton

18 / 20

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

1. Delete column

2. Alter, Drop

3. Truncate column

4. Update table

19 / 20

19. Grant is a command from SQL type :

1. DDL

2. DCL

3. DML

4. All of the above

20 / 20

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

1. Grant access

2. Privilege

3. Assignment

4. Access

Your score is

The average score is 19%

0%

CAMPUS RECRUITMENT EXAMINATION BY AFFIXIOUS