Database Management System MCQs
749+ questions with answers
A JSP is transformed into a(n):
What programming language(s) or scripting language(s) does Java Server Pages (JSP) support?
What is bytecode?
Where is metadata stored in MySQL?
Which of the following is true for Seeheim model?
Which of the unit operation is used in Model view controller?
Memory address refers to the successive memory words and the machine is called as _______________
Which layer deals which deals with user interaction is called _____________ layer.
The _____________ layer, which provides a high-level view of data and actions on data.
The ______________ layer, which provides the interface between the business-logic layer and the underlying database.
Which among the following are the functions that any system with a user interface must provide?
Which of the following is the main task accomplished by the user?
What are the portability concerns founded in Seeheim model?
Which schema object instructs Oracle to connect to a remotely access an object of a database?
Which of the following object types below cannot be replicated?
How to force a log switch?
In the following query, which expression is evaluated first? SELECT id_number, (quantity - 100 / 0.15 - 35 * 20) FROM inventory
The ORDER BY clause can only be used in
What is the purpose of SMON background process?
Which of the following queries are legal?
Which of the following queries displays the sum of all employee salaries for those employees not making commission, for each job, including only those sums greater than 2500?
The indirect change of the values of a variable in one module by another module is called
Which of the following data structure is not linear data structure?
Which of the following data structure is linear data structure?
Which of the following criterion is NOT written using the proper syntax?
The operation of processing each element in the list is known as
Finding the location of the element with a given value is:
Linked lists are best suited
Each array declaration need not give, implicitly or explicitly, the information about
The elements of an array are stored successively in memory cells because
In _________________ attacks, the attacker manages to get an application to execute an SQL query created by the attacker.
A Web site that allows users to enter text, such as a comment or a name, and then stores it and later display it to other users, is potentially vulnerable to a kind of attack called a ___________________ attack.
_________ is an attack which forces an end user to execute unwanted actions on a web application in which he/she is currently authenticated.
Many applications use _________________ where two independent factors are used to identify a user.
Even with two-factor authentication, users may still be vulnerable to_____________attacks.
A single ______________ further allows the user to be authenticated once, and multiple applications can then verify the user’s identity through an authentication service without requiring reauthentication.
The __________ standard is an alternative for single sign-on across organizations, and has seen increasing acceptance in recent years.
_______________ allows a system administrator to associate a function with a relation; the function returns a predicate that must be added to any query that uses the relation.
VPD provides authorization at the level of specific tuples, or rows, of a relation, and is therefore said to be a _____________ mechanism.
___________ is widely used today for protecting data in transit in a variety of applications such as data transfer on the Internet, and on cellular phone networks.
In a database where the encryption is applied the data is cannot be handled by the unauthorised user without
Which of the following is not a property of good encryption technique?
In which of the following encryption key is used to encrypt and decrypt the data?
Encryption of small values, such as identifiers or names, is made complicated by the possibility of __________
Which one of the following uses a 128bit round key to encrypt the data using XOR and use it in reverse to decrypt it?
Assymmetric Encryption: Why can a message encrypted with the Public Key only be decrypted with the receiver’s appropriate Private Key?
Which is the largest disadvantage of symmetric Encryption?
Which is the principle of the encryption using a key?
Which of the following is a physical storage media?