Database Management System (DBMS) MCQs with answers Page - 60

Here, you will find a collection of MCQ questions on Database Management System (DBMS). Go through these questions to enhance your preparation for upcoming examinations and interviews.

To check the correct answer, simply click the View Answer button provided for each question.

Have your own questions to contribute? Click the button below to share your MCQs with others!

+ Add Question

A

Admin • 833.24K Points
Coach

Q. Which of the following is used to provide privilege to only a particular attribute?

  • (A) grant select on employee to amit
  • (B) grant update(budget) on department to raj
  • (C) grant update(budget,salary,rate) on department to raj
  • (D) grant delete to amit

A

Admin • 833.24K Points
Coach

Q. Which of the following is true regarding views?

  • (A) the user who creates a view cannot be given update authorization on a view without having update authorization on the relations used to define the view
  • (B) the user who creates a view cannot be given update authorization on a view without having update authorization on the relations used to define the view
  • (C) if a user creates a view on which no authorization can be granted, the system will allow the view creation request
  • (D) a user who creates a view receives all privileges on that view

A

Admin • 833.24K Points
Coach

Q. If we wish to grant a privilege and to allow the recipient to pass the privilege on to other users, we append the clause to the appropriate grant command.

  • (A) with grant
  • (B) grant user
  • (C) grant pass privelege
  • (D) with grant option

A

Admin • 833.24K Points
Coach

Q. Which of the following is used to avoid cascading of authorizations from the user?

  • (A) granted by current role
  • (B) revoke select on department from amit, satoshi restrict;
  • (C) revoke grant option for select on department from amit;
  • (D) revoke select on department from amit, satoshi cascade;

A

Admin • 833.24K Points
Coach

Q. The granting and revoking of roles by the user may cause some confusions when that user role is revoked. To overcome the above situation

  • (A) the privilege must be granted only by roles
  • (B) the privilege is granted by roles and users
  • (C) the user role cannot be removed once given
  • (D) by restricting the user access to the roles

A

Admin • 833.24K Points
Coach

Q. Which of the following is used to access the database server at the time of executing the program and get the data from the server accordingly?

  • (A) embedded sql
  • (B) dynamic sql
  • (C) sql declarations
  • (D) sql data analysis

A

Admin • 833.24K Points
Coach

Q. Which of the following header must be included in java program to establish database connectivity using JDBC ?

  • (A) import java.sql.*;
  • (B) import java.sql.odbc.jdbc.*;
  • (C) import java.jdbc.*;
  • (D) import java.sql.jdbc.*;

A

Admin • 833.24K Points
Coach

Q. Which of the following invokes functions in sql?

  • (A) prepared statements
  • (B) connection statement
  • (C) callable statements
  • (D) all of the mentioned

A

Admin • 833.24K Points
Coach

Q. Which one of the following is the right syntax for DECODE?

  • (A) decode (search, expression, result [, search, result]… [, default])
  • (B) decode (expression, result [, search, result]… [, default], search)
  • (C) decode (search, result [, search, result]… [, default], expression)
  • (D) decode (expression, search, result [, search, result]… [, default])

A

Admin • 833.24K Points
Coach

Q. Relational Algebra is a query language that takes two relations as input and produces another relation as an output of the query.

  • (A) relational
  • (B) structural
  • (C) procedural
  • (D) fundamental

Add MCQ in this Category

If you want to share an MCQ question in this category, it's a great idea! It will be helpful for many other students using this website.

Share Your MCQ

Browse Categories

Click on category to learn MCQs of that category.