01st
Sep
Database MCQ

Database MCQ

  • Admin
  • 01st Sep, 2020
  • 617 Followers

Database MCQ Quiz

1) 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

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

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

3) The SQL statement to create a view is

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

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

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

5) 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
Download Free : Database MCQ PDF

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

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

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

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

8) A Delete command operates on ______ relation.

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

9) 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”;

10) 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

11) 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

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

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

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

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

14) SQL is a:

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

15) 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;

16) SQL data definition commands make up a

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

17) What is not an advantage of stored procedures?

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

18) 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

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

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

20) 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

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

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

22) XML Schemas consist of:

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

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

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

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) 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

26) 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

27) 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.

28) 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

29) 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

30) 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

31) 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

32) 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;

33) A relation is considered a:

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

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

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

35) 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

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

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

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

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

38) 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

39) 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

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

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

41) 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.

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

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

Leave A Comment :

Valid name is required.

Valid name is required.

Valid email id is required.

Related MCQ/Quiz

01st
Dec
Laravel MCQ
01st
Dec
React JS MCQ
01st
Jan
AngularJs MCQ
01st
Jul
Node js MCQ
01st
Jul
Angular 2 MCQ
01st
Jul
JSON MCQ