Quiz  /  DBMS Gate & PSU MCQ Questions With Answers

  • 1. 
    How will a data analyst retrieve a list of all employees' first_name, last_name and hire_date from the employees table?

  • select first_name,last_name,hire_date, from employee;
  • select first_name,last_name and hire_date from employees;
  • Select first_name,last_name& hire_date from employees;
  • select first_name,last_name,hire_date from employees;

  • 2. 
    Count function in SQL returns the number of

  • Values
  • Distinct values
  • Groups
  • Columns

  • 3. 
    Which of the following commands is used to save any transaction permanently into the database?

  • Commit
  • Rollback
  • Save point
  • None of the above

  • 4. 
    Which of the following refers to the number of attributes in a relation?

  • Degree
  • Row
  • Column
  • All of the above

  • 5. 
    If you were wanting to filter data, which clause would you use?

  • Where
  • Order by
  • From
  • Select

  • 6. 
    A view of database that appears to an application program is known as

  • schema
  • subschema
  • virtual table
  • none of the above

  • 7. 
    Match SQL language with SQL commands1)DDL i)Revok, Grant2)DML ii)rename a table3)TCL iii)insert, update4)DCL iv)rollback , commit

  • 1-iii,2-i,3-ii,4-iv
  • 1-iii,2-ii,3-iv,4-i
  • 1-ii,2-iii,3-iv,4-i
  • 1-i,2-iii,3-ii,4-iv

  • 8. 
    DDL stands for__________.

  • Data Definition language
  • Database Development language
  • Database Design language
  • None of the above

  • 9. 
    Database admins are responsible for the design of the database and software.

  • True
  • False

  • 10. 
    ........... represents Entity sets.

  • Square
  • Circle
  • Rectangle
  • Oval

  • 11. 
    Which of the following is not included in DML

  • insert
  • update
  • delete
  • create

  • 12. 
    This is an authorization command of SQL

  • Access
  • Grant
  • Allow
  • None of these

  • 13. 
    In the relation model, the relation are generally termed as ________

  • Tuples
  • Attributes
  • Rows
  • Tables

  • 14. 
    The database management system can be considered as the collection of ______ that enables us to create and maintain the database.

  • Translators
  • Programs
  • Keys
  • Language activity

  • 15. 
    8) The term "DFD" stands for?

  • a) Data file diagram
  • b) Data flow document
  • c) Data flow diagram
  • d) None of the above
Report Question
warning
access_time
  Time