Common Jobs

Common Jobs Logo

SQL

1 / 39

What is the advantage of the clustered index?

2 / 39

Which statement is used to get all data from the student table whose name starts with p?

3 / 39

________ is a program that performs some common action on database data and also stored in the database.

4 / 39

Which of the following statement is correct to display all the cities with the condition, temperature, and humidity whose humidity is in the range of 60 to 75 from the 'whether' table?

5 / 39

Find the cities name with the condition and temperature from table 'whether' where condition = sunny or cloudy but temperature >= 60.

6 / 39

 ______ is NOT a type of constraint in SQL language?

7 / 39

When the wildcard in a WHERE clause is useful?

8 / 39

Which of the following options are correct regarding these three keys (Primary Key, Super Key, and Candidate Key) in a database?

  1. Minimal super key is a candidate key
    II. Only one candidate key can be a primary key
    III. All super keys can be a candidate key
    IV. We cannot find a primary key from the candidate key

 

9 / 39

Which of the following statement is correct regarding the difference between TRUNCATE, DELETE and DROP command?

  1. DELETE operation can be rolled back but TRUNCATE and DROP operations cannot be rolled back.
    II. TRUNCATE and DROP operations can be rolled back but DELETE operations cannot be rolled back.
    III. DELETE is an example of DML, but TRUNCATE and DROP are examples of DDL.
    IV. All are an example of DDL.

10 / 39

Which operator is used to compare the NULL values in SQL?

11 / 39

Which of the following are the synonyms for Column and ROW of a table?

  1. Row = [Tuple, Record]
  2. Column = [Field, Attribute]
  3. Row = [Tuple, Attribute]
  4. Columns = [Field, Record]

12 / 39

What is the difference between a PRIMARY KEY and a UNIQUE KEY?

13 / 39

Which of the following is the correct order of a SQL statement?

14 / 39

A sequence in SQL can generate a maximum number

15 / 39

Sequence can generate

16 / 39

Shared locks are applied while performing

17 / 39

Group of operations that form a single logical unit of work is known as

18 / 39

Why we need to create an index if the primary key is already present in a table?

19 / 39

Which of the following is the basic approaches for joining tables?

20 / 39

Which statement is true regarding routines and triggers?

21 / 39

A CASE SQL statement is ________?

22 / 39

Which type of JOIN is used to returns rows that do not have matching values?

23 / 39

Which command is used to change the definition of a table in SQL?

24 / 39

How can you change "Thomas" into "Michel" in the "LastName" column in the Users table?

25 / 39

_________ command makes the updates performed by the transaction permanent in the database?

26 / 39

Which of the following is true about the SQL AS clause?

27 / 39

_______ clause creates temporary relation for the query on which it is defined.

28 / 39

The SQL statement:

  1. SELECT ROUND (65.726, -1) FROM DUAL;  

Prints:

29 / 39

Which of the following is true about the HAVING clause?

30 / 39

Which of the following is also called an INNER JOIN?

31 / 39

A command that lets you change one or more field in a table is:

32 / 39

What is returned by INSTR ('JAVAT POINT', 'P')?

33 / 39

Which of the following statement is true?

34 / 39

If we have not specified ASC or DESC after a SQL ORDER BY clause, the following is used by default

35 / 39

In which of the following cases a DML statement is not executed?

36 / 39

What operator tests column for absence of data

37 / 39

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

38 / 39

Which data manipulation command is used to combines the records from one or more tables?

39 / 39

Which of the following is not a valid aggregate function?

Your score is

The average score is 33%

0%