Database System Exam Quiz Questions

40 Questions | By Cloud_XII | Updated: Mar 21, 2022 | Attempts: 282

Questions

Settings

Create your own Quiz

Questions and Answers

1.

The DBMS acts as an interface between what two components of an enterprise-class database system?
- A.
  
  Database application and the database
- B.
  
  Data and the database
- C.
  
  The user and the database application
- D.
  
  Database application and SQL
2.

An application where only one user accesses the database at a given time is an example ofa(n)?
- A.
  
  Single-user database application
- B.
  
  Multiuser database application
- C.
  
  E-commerce database application
- D.
  
  Data mining database application
3.

SQL stands for
- A.
  
  Structured Query Language
- B.
  
  Sequential Query Language
- C.
  
  Structured Question Language
- D.
  
  Sequential Question Language
4.

You have run SQL statement that asked the DBMS to display data in a table named USER_TABLES. The results include columns of data labeled “TableName,” “NumberofColumns” and “PrimaryKey.” You are looking at
- A.
  
  User data
- B.
  
  Metadata
- C.
  
  Report
- D.
  
  Indices
5.

Which of the following is not considered to be a basic element of an enterprise-class database system?
- A.
  
  Users
- B.
  
  Database applications
- C.
  
  DBMS
- D.
  
  COBOL programs
6.

You can add a row using SQL in a database with which of the following?
- A.
  
  ADD
- B.
  
  CREATE
- C.
  
  INSERT
- D.
  
  MAKE
7.

The command to remove rows from a table ‘Customer’ is
- A.
  
  REMOVE FROM CUSTOMER...
- B.
  
  DROP FROM CUSTOMER...
- C.
  
  DELETE FROM CUSTOMER WHERE...
- D.
  
  UPDATE FROM CUSTOMER...
8.

The SQL WHERE clause:
- A.
  
  Limits the column data that are returned
- B.
  
  Limits the row data are returned
- C.
  
  Both A and B are correct
- D.
  
  Neither A nor B are correct
9.

Which of the following is the original purpose of SQL?
- A.
  
  To specify the syntax and semantics of SQL data definition language
- B.
  
  To specify the syntax and semantics of SQL manipulation language
- C.
  
  To define the data structures
- D.
  
  All of the above
10.

The wildcard is a WHERE clause is useful when?
- A.
  
  An exact math is necessary in a SELECT statement.
- B.
  
  An exact match is not possible in a SELECT statement.
- C.
  
  An exact match is necessary in a CREATE statement.
- D.
  
  An exact match is not possible in a CREATE statement.
11.

A view is which of the following?
- A.
  
  A virtual table that can be accessed via SQL commands.
- B.
  
  A virtual table that cannot be accessed via SQL commands.
- C.
  
  A base table that can be accessed via SQL commands.
- D.
  
  A base table that cannot be accessed via SQL commands.
12.

SQL data definition commands make up a(n)
- A.
  
  DDL
- B.
  
  DML
- C.
  
  HTML
- D.
  
  XML
13.

Which of the following is the correct order of keywords for SQL SELECT statements?
- A.
  
  SELECT, FROM, WHERE
- B.
  
  FROM, WHERE, SELECT
- C.
  
  WHERE, FROM, SELECT
- D.
  
  SELECT, WHERE, FROM
14.

A subquery in an SQL SELECT statement is enclosed in:
- A.
  
  Braces -- {...}.
- B.
  
  CAPITAL LETTERS.
- C.
  
  Parenthesis -- (...).
- D.
  
  Brackets -- [...].
15.

The result of a SQL SELECT statement is a(n)
- A.
  
  Report
- B.
  
  Form
- C.
  
  File
- D.
  
  Table
16.

Which of the following are the five built-in functions provided by SQL?
- A.
  
  COUNT, SUM, AVG, MAX, MIN
- B.
  
  SUM, AVG, MIN, MAX, MULT
- C.
  
  SUM, AVG, MULT, DIV, MIN
- D.
  
  SUM, AVG, MIN, NAME
17.

The HAVING clause does which of the following?
- A.
  
  Acts like a WHERE clause but is used for groups rather than rows.
- B.
  
  Acts like WHERE clause but is used for rows rather than columns.
- C.
  
  Acts like a WHERE clause but is used for columns rather than groups.
- D.
  
  Acts EXACTLY like a WHERE clause.
18.

The SQL-92 wildcards are
- A.
  
  Asterisk (*); percent sign(%)
- B.
  
  Percent sign(%); underscore(_)
- C.
  
  Underscore(_); question mark(?)
- D.
  
  Question mark(?); asterisk(*)
19.

To remove duplicate rows from the results of an SQL select statement, the ___qualifier specified must be included.
- A.
  
  ONLY
- B.
  
  UNIQUE
- C.
  
  DISTINCT
- D.
  
  Option 4
20.

SQL query and modification commands make up a(n)
- A.
  
  DDL
- B.
  
  DML
- C.
  
  HTML
- D.
  
  XML
21.

Find the SQL statement below that is equal to the following:SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';
- A.
  
  SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');
- B.
  
  SELECT NAME IN CUSTOMER WHERE STATE = 'VA';
- C.
  
  SELECT NAME IN CUSTOMER WHERE STATE = 'V';
- D.
  
  SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');
22.

Which of the following sorts rows in SQL?
- A.
  
  SORT BY
- B.
  
  ALIGN BY
- C.
  
  ORDER BY
- D.
  
  GROUP BY
23.

To define what columns should be displayed in an SQL SELECT statement:
- A.
  
  Use FROM to name the source table(s) and list the columns to be shown after SELECT.
- B.
  
  Use USING to name the source table(s) and list the columns to be shown after SELECT.
- C.
  
  Use SELECT to name the source table(s) and list the columns to be shown after USING.
- D.
  
  Use USING to name the source table(s) and list the columns to be shown after WHERE.
24.

The SQL statement that queries or reads data from a table is
- A.
  
  SELECT
- B.
  
  READ
- C.
  
  QUERY
- D.
  
  None of the above is correct
25.

The SQL keyword BETWEEN in used:
- A.
  
  For ranges.
- B.
  
  To limit the columns displayed.
- C.
  
  As a wildcard.
- D.
  
  None of the above is correct.