01st
Sep
Database MCQ

Database MCQ

  • Admin
  • 01st Sep, 2020
  • 719 Followers

Database MCQ Quiz

Following are mostly asked Database MCQ test that are designed for professionals like you to crack you interviews. You can take this Database online test before appearing to you real interview. This Database quiz there are around 30+ multiple choice questions on Database with four options.

1) The DBMS acts as an interface between what two components of an enterprise-class database system?

  • A. Database application and SQL
  • B. Data and the database
  • C. The user and the database application
  • D. Database application and the database

2) Which of the following products was an early implementation of the relational model developed by E.F. Codd of IBM?

  • A. R:base
  • B. DB2
  • C. IDMS
  • D. dBase-II

3) An on-line commercial site such as Amazon.com is an example of

  • A. An on-line commercial site such as Amazon.com is an example of
  • B. multiuser database application
  • C. e-commerce database application
  • D. data mining database application

4) The following are functions of a DBMS except .........

  • A. processing data
  • B. creating databases
  • C. creating and processing forms
  • D. administrating databases

5) Which of the following is not considered to be a basic element of an enterprise-class database system?

  • A. Users
  • B. DBMS
  • C. COBOL programs
  • D. Database applications
Download Free : Database MCQ PDF

6) The command to eliminate a table from a database is:

  • A. DROP TABLE CUSTOMER;
  • B. DELETE TABLE CUSTOMER;
  • C. REMOVE TABLE CUSTOMER;
  • D. UPDATE TABLE CUSTOMER;

7) SQL data definition commands make up a

  • A. DML
  • B. DDL
  • C. XML
  • D. HTML

8) Which of the following is valid SQL for an Index?

  • A. ADD INDEX ID;
  • B. CHANGE INDEX ID;
  • C. CREATE INDEX ID;
  • D. REMOVE INDEX ID;

9) Which of the following do you need to consider when you make a table in SQL?

  • A. Data types
  • B. Primary keys
  • C. Default values
  • D. All are Correct

10) Which one of the following sorts rows in SQL?

  • A. SORT BY
  • B. ALIGN BY
  • C. GROUP BY
  • D. ORDER BY

11) Which of the following SQL statement that queries or reads data from a table?

  • A. READ
  • B. QUERY
  • C. SELECT
  • D. None of the Above

12) Which of the following was adopted as a national standard by ANSI in 1992?

  • A. DBase
  • B. SQL
  • C. Oracle
  • D. Microsoft Access

13) SQL is a:

  • A. DBMS
  • B. Data sublanguage
  • C. Operating system
  • D. Programming language

14) Which of the following is a group of one or more attributes that uniquely identifies a row?

  • A. Tuple
  • B. Key
  • C. Relation
  • D. Determinant

15) A relation is considered a:

  • A. one-dimensional table
  • B. two-dimensional table
  • C. three-dimensional table
  • D. None of the Above

16) A relation in this form is free of all modification anomalies.

  • A. First normal form
  • B. Domain/key normal form
  • C. Third normal form
  • D. All are Correct

17) The SQL statement to create a view is

  • A. MAKE VIEW
  • B. SELECT VIEW
  • C. CREATE VIEW
  • D. INSERT VIEW

18) Which of the following is NOT a type of SQL constraint?

  • A. PRIMARY KEY
  • B. ALTERNATE KEY
  • C. FOREIGN KEY
  • D. None of the Above

19) What is an SQL virtual table that is constructed from other tables?

  • A. A view
  • B. A relation
  • C. Query results
  • D. Just another table

20) What is not an advantage of stored procedures?

  • A. Code sharing
  • B. Greater security
  • C. SQL can be optimized
  • D. Increased network traffic

21) Database redesign is not terribly difficult if the:

  • A. Database is structured.
  • B. Database has no data.
  • C. Database is well-designed.
  • D. Database is relatively small.

22) How many copies of the database schema are typically used in the redesign process?

  • A. One
  • B. Two
  • C. Three
  • D. Four

23) What type of join is needed when you wish to return rows that do have matching values?

  • A. Equi-join
  • B. Outer join
  • C. Natural join
  • D. All are Correct

24) Which of the following is one of the basic approaches for joining tables?

  • A. Subqueries
  • B. Natural join
  • C. Union Join
  • D. All are Correct

25) Which of the following is true concerning triggers?

  • A. You do not create them with SQL.
  • B. They have an event, condition, and action
  • C. They cannot cascade (cause another trigger to fire).
  • D. They execute against only some applications that access a database.

26) he most popular way to materialize XML documents is to use:

  • A. DTD
  • B. HTML
  • C. XSLT
  • D. SOAP

27) XML Schemas consist of:

  • A. Structure and data
  • B. Elements and attributes
  • C. Properties and methods
  • D. Tables and relationships

28) A _____ indicates an absent value that may exist but be unknown or that may not exist at all.

  • A. Empty tuple
  • B. Null value
  • C. Old value
  • D. New value

29) Using the ______ clause retains only one copy of such identical tuples.

  • A. Null
  • B. Unique
  • C. Distinct
  • D. Not null

30) A Boolean data type that can take values true, false, and________

  • A. 1
  • B. Null
  • C. Unknown

31) The ________ keyword is used to access attributes of preceding tables or subqueries in the from clause.

  • A. In
  • B. With
  • C. Lateral
  • D. Having

32) Which of the following is not an aggregate function?

  • A. Sum
  • B. Avg
  • C. Min
  • D. With

33) A Delete command operates on ______ relation.

  • A. Null
  • B. One
  • C. Several
  • D. Two

34) The problem of ordering the update in multiple updates is avoided using

  • A. Set
  • B. Case
  • C. Where
  • D. When

35) Which of the join operations do not preserve non matched tuples?

  • A. Inner join
  • B. Natural join
  • C. Left outer join
  • D. Right outer join

36) The operation which is not considered a basic operation of relational algebra is

  • A. Join
  • B. Union
  • C. Selection
  • D. Cross product

37) Which of the following is the syntax for views where v is view name?

  • A. Create view “query expression”;
  • B. Create view v as “query name”;
  • C. Create “query expression” as view;
  • D. Create view v as “query expression”;

38) Which of the following makes the transaction permanent in the database?

  • A. View
  • B. Commit
  • C. Flashback
  • D. Rollback

39) Which of the following is not an integrity constraint?

  • A. Unique
  • B. Not null
  • C. Positive
  • D. Check ‘predicate’

40) Which of the following is the right syntax for the assertion?

  • A. Create assertions ‘predicates’;
  • B. Create assertion check ‘predicate’ ‘assertion-name’;
  • C. Create assertion ‘assertion-name’ check ‘predicate’;
  • D. None of the Above

41) Which of the following is used to store movie and image files?

  • A. Blob
  • B. Clob
  • C. Image
  • D. Binary

42) 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. Dynamic SQL
  • B. Embedded SQL
  • C. SQL data analysis
  • D. SQL declarations

Leave A Comment :

Valid name is required.

Valid name is required.

Valid email id is required.

Related MCQ/Quiz

01st
Dec
Laravel MCQ
01st
Mar
IOS Swift MCQ
01st
Dec
MongoDB MCQ
01st
Mar
JSF MCQ
01st
Mar
Scala MCQ
01st
Mar
Cobol MCQ