Back to Top

Quiz Discussion

SELECT emp_name
FROM department
WHERE dept_name LIKE ’ _____ Computer Science’;

Which one of the following has to be added into the blank to select the dept_name which has Computer Science as its ending string?

Course Name: SQL -Structured Query Language

  • 1]

    %
  • 2]

    _
  • 3]

    ||
  • 4]

    $
Solution
No Solution Present Yet

Top 5 Similar Quiz - Based On AI&ML

Quiz Recommendation System API Link - https://fresherbell-quiz-api.herokuapp.com/fresherbell_quiz_api

#Quiz
1
Discuss
 
SELECT * FROM employee WHERE dept_name="Comp Sci";

In the SQL given above there is an error . Identify the error.

  • 1]

    Dept_name
  • 2]

    Employee
  • 3]

    “Comp Sci”
  • 4]

    From
Solution
10
Discuss

In SQL the spaces at the end of the string are removed by _______ function.

  • 1]

    Upper
  • 2]

    String
  • 3]

    Trim
  • 4]

    Lower
Solution
2
Discuss
 
SELECT *
FROM instructor
ORDER BY salary ____, name ___;

To display the salary from greater to smaller and name in ascending order which of the following options should be used?

  • 1]

    Ascending, Descending
  • 2]

    Asc, Desc
  • 3]

    Desc, Asc
  • 4]

    Descending, Ascending
Solution
3
Discuss

The most commonly used operation in relational algebra for projecting a set of tuple from a relation is

  • 1]

    Join
  • 2]

    Projection
  • 3]

    Select
  • 4]

    Union
Solution
4
Discuss

The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.

  • 1]

    Where, from
  • 2]

    From, select
  • 3]

    Select, from
  • 4]

    From, where
Solution
5
Discuss

A domain is atomic if elements of the domain are considered to be ____________ units.

  • 1]

    Different
  • 2]

    Indivisbile
  • 3]

    Constant
  • 4]

    Divisible
Solution
6
Discuss

Which one of the following is procedural language?

  • 1]

    Domain relational calculus
  • 2]

    Tuple relational calculus
  • 3]

    Relational algebra
  • 4]

    Query language
Solution
7
Discuss

Course(course_id,sec_id,semester)

Here the course_id,sec_id and semester are __________ and course is a _________

  • 1]

    Relations, Attribute
  • 2]

    Attributes, Relation
  • 3]

    Tuple, Relation
  • 4]

    Tuple, Attributes
Solution
8
Discuss
 
SELECT name
FROM instructor
WHERE salary <= 100000 AND salary >= 90000;

This query can be replaced by which of the following ?

  • 1] 
    SELECT name
FROM instructor
WHERE salary BETWEEN 90000 AND 100000;

     
  • 2] 
    SELECT name
FROM employee
WHERE salary <= 90000 AND salary>=100000;

     
  • 3] 
    SELECT name
FROM employee
WHERE salary BETWEEN 90000 AND 100000;

     
  • 4] 
    SELECT name
FROM instructor
WHERE salary BETWEEN 100000 AND 90000;

     
Solution
9
Discuss

For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.

  • 1]

    Domain
  • 2]

    Relation
  • 3]

    Set
  • 4]

    Schema
Solution
#Quiz
Showing 1 to 10 of 10 entries

About Fresherbell

Best learning portal that provides you great learning experience of various technologies with modern compilation tools and technique

Important Links

Social Media

Copyright © 2020 Inovatik - All rights reserved