Database Iitu Quiz

150 Questions | Attempts: 611
Share
SettingsSettings
Please wait...
  • 1/150 Questions

    A table can be created with or without data

    • True
    • False
Please wait...
About This Quiz

.

Database Iitu Quiz - Quiz

Quiz Preview

  • 2. 

    With SQL, how do you select all the columns from a table named "Persons"?

    • SELECT [all] FROM Persons

    • SELECT Persons

    • SELECT * FROM Persons

    • SELECT *.Persons

    Correct Answer
    A. SELECT * FROM Persons
  • 3. 

    A table can be created with or without data.

    • True

    • False

    Correct Answer
    A. True
  • 4. 

    You can add and drop columns from a table using the ALTER TABLE command.

    • True

    • False

    Correct Answer
    A. True
  • 5. 

    Which keyword is used to provide an alias to a column?

    • COLUMN

    • AS

    • ALIAS

    • IS

    Correct Answer
    A. AS
  • 6. 

    What does SQL stand for?

    • Structured Query Language

    • Strong Question Language

    • Structured Question Language

    • Slow Query Language

    Correct Answer
    A. Structured Query Language
  • 7. 

    You can add and drop columns from a table using the ALTER TABLE command.

    • True

    • False

    Correct Answer
    A. True
  • 8. 

    With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?

    • SELECT * FROM Persons WHERE FirstName'Peter'

    • SELECT [all] FROM Persons WHERE FirstName='Peter'

    • SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'

    • SELECT * FROM Persons WHERE FirstName='Peter'

    Correct Answer
    A. SELECT * FROM Persons WHERE FirstName='Peter'
  • 9. 

    Which of the following is a concatenation operator?

    • &

    • +

    • ||

    • *

    Correct Answer
    A. ||
  • 10. 

    Transaction control determines when data manipulation becomes permanent in a database. 

    • True

    • False

    Correct Answer
    A. True
  • 11. 

    Which of the following is a concatenation operator?

    • &

    • &

    • ||

    • *

    Correct Answer
    A. ||
  • 12. 

    Which keyword is used to provide an alias to a column?

    • COLUMN

    • AS

    • ALIAS

    • IS

    Correct Answer
    A. AS
  • 13. 

    What will be the result of the following SQL statement? (SYSDATE is a date of your exam)SELECT TO_CHAR(SYSDATE, ‘Day’) FROM Dual;

    • 31.05.2013

    • Friday

    • 31

    • 31-05.2013

    Correct Answer
    A. Friday
  • 14. 

    With SQL, how do you select a column named "FirstName" from a table named "Persons"?

    • SELECT Persons.FirstName

    • SELECT FirstName FROM Persons

    • EXTRACT FirstName FROM Persons

    • EXTRACT FROM Persons

    Correct Answer
    A. SELECT FirstName FROM Persons
  • 15. 

    Which SQL keyword is used to sort the result-set?

    • ORDER

    • SORT BY

    • SORT OR

    • ORDER BY

    Correct Answer
    A. ORDER BY
  • 16. 

    Queries containing set operators are called ______ .

    • Compound queries

    • Subqueries

    • Inner queries

    • Outer queries

    Correct Answer
    A. Compound queries
  • 17. 

    With SQL, how can you return the number of records in the "Persons" table?

    • SELECT LEN(*) FROM Persons

    • SELECT NO(*) FROM Persons

    • SELECT COLUMNS(*) FROM Persons

    • SELECT COUNT(*) FROM Persons

    Correct Answer
    A. SELECT COUNT(*) FROM Persons
  • 18. 

    Transaction control determines when data manipulation becomes permanent in a database. 

    • True

    • False

    Correct Answer
    A. True
  • 19. 

    Privileges, roles, and synonyms are all used to implement security in an Oracle Database.

    • True

    • False

    Correct Answer
    A. True
  • 20. 

    Which symbol do you use if you need to choose all the columns from the table to the result query?

    • *

    • +

    • All

    • %

    Correct Answer
    A. *
  • 21. 

    Which SQL statement is used to update data in a database?

    • MODIFY

    • SAVE

    • UPDATE

    • SAVE AS

    Correct Answer
    A. UPDATE
  • 22. 

    Which SQL statement is used to insert new data in a database?

    • INSERT INTO

    • INSERT NEW

    • ADD RECORD

    • ADD NEW

    Correct Answer
    A. INSERT INTO
  • 23. 

    Queries containing set operators are called __________ .

    • Outer queries

    • Subqueries

    • Inner queries

    • Compound querires

    Correct Answer
    A. Compound querires
  • 24. 

    The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true

    • True

    • False

    Correct Answer
    A. True
  • 25. 

    What is the most common type of join?

    • JOINED

    • JOINED TABLE

    • INSIDE JOIN

    • INNER JOIN

    Correct Answer
    A. INNER JOIN
  • 26. 

    By default, the foreign key restricts deletes of any parent row has a corresponding child row(s).

    • True

    • False

    Correct Answer
    A. True
  • 27. 

    You can add to and drop columns from a table using the ALTER TABLE command.

    • True

    • False

    Correct Answer
    A. True
  • 28. 

    The NUMBER data types is usually the best choice for a primary key.

    • True

    • False

    Correct Answer
    A. True
  • 29. 

    Queries containing set operators are called __________ .

    • Outer queries

    • Subqueries

    • Inner queries

    • Compound querires Compound querires Compound querires

    Correct Answer
    A. Compound querires Compound querires Compound querires
  • 30. 

    Which of the following is the correct order of keywords for SQL SELECT statements?

    • SELECT, FROM, WHERE

    • FROM, WHERE, SELECT

    • WHERE, FROM,SELECT

    • SELECT,WHERE,FROM

    Correct Answer
    A. SELECT, FROM, WHERE
  • 31. 

    Privileges, roles, and synonyms are all used to implement security in an Oracle database.

    • True

    • False

    Correct Answer
    A. True
  • 32. 

    Which keyword is used to eliminate duplicate rows in the result?

    • DISTINCT

    • DESCRIBE

    • HAVING

    • GROUP BY

    Correct Answer
    A. DISTINCT
  • 33. 

    Which SQL statement is used to extract data from a database?

    • GET

    • OPEN

    • SELECT

    • EXTRACT

    Correct Answer
    A. SELECT
  • 34. 

    With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?

    • SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'

    • SELECT * FROM Persons WHERE FirstName'Peter' AND LastName'Jackson'

    • SELECT FirstName='Peter', LastName='Jackson' FROM Persons

    • SELECT * FROM Persons WHERE FirstName='Peter' OR LastName='Jackson'

    Correct Answer
    A. SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'
  • 35. 

    A table can be created with or without data

    • True

    • False

    Correct Answer
    A. True
  • 36. 

    Which operator is used to select values within a range?

    • RANGE

    • WITHIN

    • BETWEEN

    • AND

    Correct Answer
    A. BETWEEN
  • 37. 

    Queries containing set operators are called __________ .

    • Outer queries

    • Subqueries

    • Inner queries

    • Compound querires

    Correct Answer
    A. Compound querires
  • 38. 

    The result of a SQL SELECT statement is a(n) ________ .

    • Report

    • Form

    • File

    • Table

    Correct Answer
    A. Table
  • 39. 

    Queries containing set operators are called ______ . 

    • Compound queries

    • Subqueries

    • Inner queries

    • Outer queries

    Correct Answer
    A. Compound queries
  • 40. 

    What will be the result of the following query?SELECT ROUND (63.548, -1) FROM DUAL;

    • 64

    • 60

    • 63

    • 70

    Correct Answer
    A. 60
  • 41. 

    The TRUNCATE command removes all data permanently from a table.

    • True

    • False

    Correct Answer
    A. True
  • 42. 

    By default, the foreign key restricts deletes of any parent row has a corresponding child row(s).

    • True

    • False

    Correct Answer
    A. True
  • 43. 

    Which command is used to view the structure of the table LOCATIONS?

    • DESCRIBE LOCATIONS

    • SHOW STRUCTURE LOCATIONS

    • SELECT * FROM LOCATIONS

    • PRINT LOCATIONS

    Correct Answer
    A. DESCRIBE LOCATIONS
  • 44. 

    The TRUNCATE command removes all data permanently from a table.

    • True

    • False

    Correct Answer
    A. True
  • 45. 

    What will be the result of the following query?SELECT ROUND (63.548, -1) FROM DUAL;

    • 64

    • 60

    • 63

    • 70

    Correct Answer
    A. 60
  • 46. 

    Consider the EMPLOYEES table. Which condition in the WHERE clause limit the employees to those who do not work in the departments 90 and 60?

    • WHERE department_id = 90 AND department_id = 60

    • WHERE department_id IN (90,60)

    • WHERE department_id NOT IN (90,60)

    • WHERE department_id =90 PR department_id = 60

    Correct Answer
    A. WHERE department_id NOT IN (90,60)
  • 47. 

    Which of the following are the five built-in functions provided by SQL?

    • COUNT, SUM, AVG, MAX, MIN

    • SUM, AVG, MIN, MAX, MULT

    • SUM, AVG, MULT, DIV, MIN

    • SUM, AVG, MIN, MAX, NAME

    Correct Answer
    A. COUNT, SUM, AVG, MAX, MIN
  • 48. 

    Consider the EMPLOYEES table. Which condition in the WHERE clause limit the employees to those whose salary is greater than 5000 but less than 18000?

    • WHERE salary > 5000 OR salary < 18000

    • WHERE salary < 5000 AND salary > 18000

    • WHERE salary > 5000 AND salary < 18000

    • WHERE salary >5000 AND salary > 18000

    Correct Answer
    A. WHERE salary > 5000 AND salary < 18000
  • 49. 

    Which command is used to view the structure of the table LOCATIONS?

    • DESCRIBE LOCATIONS

    • SHOW STRUCTURE LOCATIONS

    • SELECT * FROM LOCATIONS

    • PRINT LOCATIONS

    Correct Answer
    A. DESCRIBE LOCATIONS

Quiz Review Timeline (Updated): Dec 14, 2017 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Dec 14, 2017
    Quiz Edited by
    ProProfs Editorial Team
  • Dec 14, 2017
    Quiz Created by
    Daniyar
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.