SQL Online Quiz, SQL MCQ Quiz & Online Test

1 .

What does SQL stand for?

A)

Structured Query Language

B)

Structured Question Language

C)

Strong Question Language

D)

None of the above

Correct Answer : Option (A) : Structured Query Language

2 .

With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "FreeTime" and the "LastName" is "FreeTime"?

A)

SELECT FirstName='FreeTime', LastName='Learning' FROM Persons

B)

SELECT * FROM Persons WHERE FirstName<>'FreeTime' AND LastName<>'Learning'

C)

SELECT * FROM Persons WHERE FirstName='FreeTime' AND LastName='Learning'

D)

None of the above

Correct Answer : Option (C) : SELECT * FROM Persons WHERE FirstName='FreeTime' AND LastName='Learning'

3 .

With SQL, how do you select all the records from a table named "Persons" where the "LastName" is alphabetically between (and including) "FreeTime" and "Learning"?

A)

SELECT * FROM Persons WHERE LastName BETWEEN 'FreeTime' AND 'Learning'

B)

SELECT LastName>'FreeTime' AND LastName<'Learning' FROM Persons

C)

SELECT * FROM Persons WHERE LastName>'FreeTime' AND LastName<'Learning'

D)

None of the above

Correct Answer : Option (A) : SELECT * FROM Persons WHERE LastName BETWEEN 'FreeTime' AND 'Learning'

4 .

Which SQL statement is used to extract data from a database?

A)

OPEN

B)

GET

C)

EXTRACT

D)

SELECT

Correct Answer : Option (D) : SELECT

5 .

Which SQL statement is used to update data in a database?

A)

UPDATE

B)

SAVE AS

C)

SAVE

D)

SAVE

Correct Answer : Option (A) : UPDATE

6 .

Which SQL statement is used to delete data from a database?

A)

COLLAPSE

B)

DELETE

C)

REMOVE

D)

All of above

Correct Answer : Option (B) : DELETE

7 .

Which SQL statement is used to return only different values?

A)

SELECT DIFFERENT

B)

SELECT DISTINCT

C)

SELECT UNIQUE

D)

None of the above

Correct Answer : Option (B) : SELECT DISTINCT

8 .

Which SQL keyword is used to sort the result-set?

A)

SORT

B)

SORT BY

C)

ORDER

D)

ORDER BY

Correct Answer : Option (D) : ORDER BY

9 .

With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?

A)

SELECT * FROM Persons ORDER BY FirstName DESC

B)

SELECT * FROM Persons SORT 'FirstName' DESC

C)

SELECT * FROM Persons SORT BY 'FirstName' DESC

D)

SELECT * FROM Persons ORDER FirstName DESC

Correct Answer : Option (A) :

SELECT * FROM Persons ORDER BY FirstName DESC

10 .

Which SQL statement is used to insert new data in a database?

A)

ADD NEW

B)

ADD RECORD

C)

INSERT INTO

D)

INSERT NEW

Correct Answer : Option (C) : INSERT INTO

11 .

What is returned by INSTR(‘FREETIMELEARN’, ‘M’)?

A)

7

B)

6

C)

MELEARN

D)

FREETI

Correct Answer : Option (A) : 7

12 .

Which of the following is not true about Natural Joins?

A)

Natural join is based on all columns in two tables having same name

B)

It selects rows from the two tables having different values in the matched columns.

C)

If columns having same names have different data types, it returns error.

D)

None of the above.

Correct Answer : Option (B) : It selects rows from the two tables having different values in the matched columns.

13 .

With SQL, how do you select a column named "FirstName" from a table named "Persons"?

A)

EXTRACT FirstName FROM Persons

B)

SELECT Persons.FirstName

C)

SELECT FirstName FROM Persons

D)

None of the above

Correct Answer : Option (C) : SELECT FirstName FROM Persons

14 .

With SQL, how do you select all the columns from a table named "Persons"?

A)

SELECT Persons

B)

SELECT *.Persons

C)

SELECT [all] FROM Persons

D)

SELECT * FROM Persons

Correct Answer : Option (D) : SELECT * FROM Persons

15 .

With SQL, how can you insert a new record into the "Persons" table?

A)

INSERT VALUES ('Ram', 'Raj') INTO Persons

B)

INSERT INTO Persons VALUES ('Ram', 'Raj')

C)

INSERT ('Ram', 'Raj') INTO Persons

D)

None of the above

Correct Answer : Option (B) : INSERT INTO Persons VALUES ('Ram', 'Raj')

16 .

With SQL, how can you insert "Ramana" as the "LastName" in the "Persons" table?

A)

INSERT INTO Persons ('Ramana') INTO LastName

B)

INSERT INTO Persons (LastName) VALUES ('Ramana')

C)

INSERT ('Ramana') INTO Persons (LastName)

D)

None of the above

Correct Answer : Option (B) : INSERT INTO Persons (LastName) VALUES ('Ramana')

17 .

Which of the following is true about a group function?

A)

Group functions operate on sets of rows to produce multiple results per group.

B)

DISTINCT keyword makes a group function consider duplicate values.

C)

Group functions ignore null values.

D)

None of the above.

Correct Answer : Option (C) : Group functions ignore null values.

18 .

Which of the following query will result in an error?

A)

select dept_id, avg(salary) from employees group by dept_id;

B)

select avg(salary) from employees group by dept_id;

C)

select dept_id, job_id, avg(salary) from employees group by dept_id, job_id;

D)

select dept_id, count(name) from employees;

Correct Answer : Option (D) : select dept_id, count(name) from employees;

19 .

Which of the following is not true about removing rows from a table?

A)

You can use a subquery in a DELETE statement.

B)

Specific rows are deleted based on the WHERE clause condition.

C)

A statement like, DELETE , would cause deletion of the table from the database.

D)

All of the above.

Correct Answer : Option (C) : A statement like, DELETE , would cause deletion of the table from the database.

20 .

How can you change "Ramana" into "Suresh" in the "LastName" column in the Persons table?

A)

MODIFY Persons SET LastName='Suresh' WHERE LastName='Ramana'

B)

UPDATE Persons SET LastName='Suresh' WHERE LastName='Ramana'

C)

UPDATE Persons SET LastName='Ramana' INTO LastName='Suresh'

D)

MODIFY Persons SET LastName='Ramana' INTO LastName='Suresh

Correct Answer : Option (B) : UPDATE Persons SET LastName='Suresh' WHERE LastName='Ramana'

21 .

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Reddy"?

A)

SELECT [all] FROM Persons WHERE FirstName='Reddy'

B)

SELECT * FROM Persons WHERE FirstName<>'Reddy'

C)

SELECT [all] FROM Persons WHERE FirstName LIKE 'Reddy'

D)

SELECT * FROM Persons WHERE FirstName='Reddy'

Correct Answer : Option (D) : SELECT * FROM Persons WHERE FirstName='Reddy'

22 .

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"?

A)

SELECT * FROM Persons WHERE FirstName='a'

B)

SELECT * FROM Persons WHERE FirstName LIKE '%a'

C)

SELECT * FROM Persons WHERE FirstName='%a%'

D)

SELECT * FROM Persons WHERE FirstName LIKE 'a%'

Correct Answer : Option (D) : SELECT * FROM Persons WHERE FirstName LIKE 'a%'

23 .

What type of query gets information from a database?

A)

GET

B)

UPDATE

C)

SELECT

D)

RETRIEVE

Correct Answer : Option (C) : SELECT

24 .

What type of query removes information from a database?

A)

REMOVE

B)

DELETE

C)

SUBTRACT

D)

ELIMINATE

Correct Answer : Option (B) : DELETE

25 .

In the query “SELECT address FROM users”, what is the column being selected?

A)

SELECT

B)

FROM

C)

address

D)

users

Correct Answer : Option (C) : address

26 .

What keyword wraps the data that you would like to insert in an INSERT query?

A)

DATA()

B)

RAWDATA()

C)

VALUE()

D)

VALUES()

Correct Answer : Option (D) : VALUES()

27 .

If you want to apply a second condition to your statement where both statements must be true, what keyword would you use between the conditions?

A)

AND

B)

BOTH

C)

TRUE

D)

WHERE

Correct Answer : Option (A) : AND

28 .

To sort your results by a column name, what keyword would you use before the column name?

A)

IF

B)

BY

C)

SORT BY

D)

ORDER BY

Correct Answer : Option (D) :

ORDER BY

29 .

What function would you use to round all numbers down?

A)

MIN

B)

FLOOR

C)

ROUND MIN

D)

ROUND DOWN

Correct Answer : Option (B) : FLOOR

30 .

What function would you use to round all values up?

A)

ROUND UP

B)

MAX

C)

CEILING

D)

ROUND MAX

Correct Answer : Option (C) : CEILING

31 .

What function can you use to compare dates?

A)

DATEDIFF

B)

DATEDIFF

C)

DATE SUBTRACT

D)

DATE DIFFERENCE

Correct Answer : Option (A) : DATEDIFF

32 .

Which of the following is NOT true about the SQL transaction control statements?

A)

Each DML statement is automatically committed.

B)

The COMMIT statement ends the current transaction and makes all data changes permanent.

C)

The ROLLBACK statement ends the transaction and discards all the pending data changes.

D)

All are true.

Correct Answer : Option (A) : Each DML statement is automatically committed.

33 .

With SQL, how can you delete the records where the "FirstName" is "Reddy" in the Persons Table?

A)

DELETE FirstName='Reddy' FROM Persons

B)

DELETE FROM Persons WHERE FirstName = 'Reddy'

C)

DELETE ROW FirstName='Reddy' FROM Persons

D)

None of the above

Correct Answer : Option (B) :

DELETE FROM Persons WHERE FirstName = 'Reddy'

34 .

With SQL, how can you return the number of records in the "Persons" table?

A)

SELECT NO(*) FROM Persons

B)

SELECT LEN(*) FROM Persons

C)

SELECT COLUMNS(*) FROM Persons

D)

SELECT COUNT(*) FROM Persons

Correct Answer : Option (D) : SELECT COUNT(*) FROM Persons

35 .

What function would you use to return the highest value of a column?

A)

TOP

B)

MAX

C)

HIGH

D)

PEAK

Correct Answer : Option (B) : MAX

36 .

What function can you use to add all of a column’s values together?

A)

ADD

B)

EQUALS

C)

SUMMED

D)

SUM

Correct Answer : Option (D) : SUM

37 .

What keyword can you use to merge two tables based on a matching column?

A)

JOIN

B)

MERGE

C)

AND

D)

ATTACH

Correct Answer : Option (A) : JOIN

38 .

What is the most common type of join?

A)

JOINED

B)

JOINED TABLE

C)

INSIDE JOIN

D)

INNER JOIN

Correct Answer : Option (D) : INNER JOIN

39 .

What keyword can you use to search for a string in a column?

A)

FIND STRING

B)

LIKE

C)

HAS STRING

D)

CONTAINS STRING

Correct Answer : Option (B) : LIKE

40 .

If you are only retrieving one column’s values, what keyword can you add before the column name to only return unique values?

A)

ONE

B)

SINGLE

C)

DISTINCT

D)

UNIQUE

Correct Answer : Option (C) : DISTINCT

41 .

Which SQL statement is used to create a table in a database?

A)

CREATE DB

B)

CREATE TABLE

C)

CREATE DATABASE TABLE

D)

CREATE DATABASE TAB

Correct Answer : Option (B) : CREATE TABLE

42 .

Which of the following is not true about creating constraints?

A)

Constraints are defined using the CREATE CONSTRAINT statement.

B)

They are created at the same time when the table is created.

C)

They could be created after the table is created.

D)

All the constraints are stored in data dictionary.

Correct Answer : Option (A) : Constraints are defined using the CREATE CONSTRAINT statement.

43 .

A systematic collection of data stored in a central location is known as?

A)

csv

B)

Database

C)

Flat file

D)

Excel

Correct Answer : Option (B) : Database

44 .

Which of the following is true about a role?

A)

A role is a named group of related privileges.

B)

It can be it can be created and assigned to a user.

C)

It can be revoked from a user.

D)

All of the above.

Correct Answer : Option (D) : All of the above.

45 .

Which type of database management system represents relations using tables?

A)

Network DBMS

B)

Hierachical DBMS

C)

Relational DBMS

D)

Object Oriented DBMS

Correct Answer : Option (C) : Relational DBMS

46 .

What is a composite key?

A)

its is a key that is defined as the primary key in another table

B)

it is a key that uniquely identifies a record in a database

C)

its is an optional key and allows null values

D)

it is a primary key that consists of more than one field that uniquely identifies a record

Correct Answer : Option (D) : it is a primary key that consists of more than one field that uniquely identifies a record

47 .

Which of the following is not YES regarding ER modeling.

A)

ER models act as non technical communication tools

B)

ER models increase the database developer's productivity

C)

ER models can be converted into a database

D)

ER models waste the database developer's time

Correct Answer : Option (D) : ER models waste the database developer's time

48 .

What command is used to permanently remove a record from a database table?

A)

DROP

B)

REMOVE

C)

DELETE

D)

CUT

Correct Answer : Option (A) : DROP

49 .

Which of the following is a valid aggregate function.

A)

CURDATE()

B)

COUNT

C)

AVERAGE

D)

MAXIMUM

Correct Answer : Option (B) : COUNT

50 .

Wildcards are

A)

used to perform pattern matches

B)

not supported by MySQL

C)

use characters such as $ to perform pattern matches

D)

use characters such as % to perform single character matching

Correct Answer : Option (A) : used to perform pattern matches

51 .

Which of the following SQL statements will generate an error when executed.

A)

CREATE DATABASE students

B)

CREATE DATABASE students;

C)

create database if not exists students

D)

IF NOT EXISTS CREATE DATABASE `STUDENTS`;

Correct Answer : Option (D) :

IF NOT EXISTS CREATE DATABASE `STUDENTS`;

52 .

Which of the following scripts will run successfully?

A)

SELECT `customer name` FROM customers WHERE cat_id = 12 ORDER BY cat_id;

B)

SELECT `customer name` FROM customers ORDER BY zone WHERE cat_id = 12;

C)

SELECT FROM `customers` 'customer name';

D)

SELECT customer name FROM customers;

Correct Answer : Option (A) :

SELECT `customer name` FROM customers WHERE cat_id = 12 ORDER BY cat_id;

53 .

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)

None of the above

Correct Answer : Option (B) : limits the row data are returned.

54 .

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.

Correct Answer : Option (D) : All of the above.

55 .

The wildcard in a WHERE clause is useful when?

A)

An exact match 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.

Correct Answer : Option (B) : An exact match is not possible in a SELECT statement.

56 .

What type of join is needed when you wish to include rows that do not have matching values?

A)

Equi-join

B)

Natural join

C)

Outer join

D)

All of the above

Correct Answer : Option (C) : Outer join

57 .

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

A)

Equi-join

B)

Natural join

C)

Outer join

D)

All of the above.

Correct Answer : Option (D) : All of the above.

58 .

Which of the following is true concerning a procedure?

A)

You do not create them with SQL.

B)

They do not need to have a unique name.

C)

They include procedural and SQL statements.

D)

They are the same thing as a function.

Correct Answer : Option (C) : They include procedural and SQL statements.

59 .

A CASE SQL statement is which of the following?

A)

A way to establish an IF-THEN-ELSE in SQL.

B)

A way to establish a data definition in SQL.

C)

A way to establish a loop in SQL.

D)

All of the above.

Correct Answer : Option (A) : A way to establish an IF-THEN-ELSE in SQL.

60 .

Which of the following statements is true concerning routines and triggers?

A)

Both consist of procedural code.

B)

Both have to be called to operate.

C)

Both are stored in the database.

D)

Both run automatically.

Correct Answer : Option (A) : Both consist of procedural code.

61 .

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 cannot be accessed via SQL commands

D)

A base table that can be accessed via SQL commands

Correct Answer : Option (A) : A virtual table that can be accessed via SQL commands

62 .

The SQL keyword(s) ________ is used with wildcards.

A)

IN only

B)

LIKE only

C)

NOT IN only

D)

IN and NOT IN

Correct Answer : Option (B) : LIKE only

63 .

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

A)

Subqueries

B)

Union Join

C)

Natural join

D)

All of the above

Correct Answer : Option (D) : All of the above

64 .

Which of the following statements is true concerning subqueries?

A)

Involves the use of an inner and outer query.

B)

Does not start with the word SELECT.

C)

Cannot return the same result as a query that is not a subquery.

D)

All of the above.

Correct Answer : Option (A) : Involves the use of an inner and outer query.

65 .

The command to eliminate a table from a database is:

A)

REMOVE TABLE CUSTOMER;

B)

DROP TABLE CUSTOMER;

C)

DELETE TABLE CUSTOMER;

D)

UPDATE TABLE CUSTOMER;

Correct Answer : Option (B) : DROP TABLE CUSTOMER;

66 .

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

Correct Answer : Option (A) : SELECT, FROM, WHERE

67 .

Which of the following is a correlated subquery?

A)

Uses the result of an inner query to determine the processing of an outer query.

B)

Uses the result of an outer query to determine the processing of an inner query.

C)

Uses the result of an inner query to determine the processing of an inner query.

D)

Uses the result of an outer query to determine the processing of an outer query.

Correct Answer : Option (B) : Uses the result of an outer query to determine the processing of an inner query.

68 .

ON UPDATE CASCADE ensures which of the following?

A)

Normalization

B)

Data Integrity

C)

Materialized Views

D)

All of the above.

Correct Answer : Option (B) : Data Integrity

69 .

A subquery in an SQL SELECT statement is enclosed in:

A)

braces -- {...}.

B)

parenthesis -- (...) .

C)

brackets -- [...].

D)

CAPITAL LETTERS.

Correct Answer : Option (B) : parenthesis -- (...) .

70 .

SQL data definition commands make up a(n) ________ .

A)

DDL

B)

DML

C)

HTML

D)

XML

Correct Answer : Option (A) : DDL

71 .

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, MAX, NAME

Correct Answer : Option (A) : COUNT, SUM, AVG, MAX, MIN

72 .

The following SQL is which type of join:

SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM
CUSTOMER_T,ORDER_T WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_IDâ€‹

A)

Equi-join

B)

Natural join

C)

Cartesian join

D)

Outer join

Correct Answer : Option (A) : Equi-join

73 .

How many tables may be included with a join?

A)

One

B)

Two

C)

Three

D)

All of the above

Correct Answer : Option (D) : All of the above

74 .

Which of the following is valid SQL for an Index?

A)

CREATE INDEX ID;

B)

CHANGE INDEX ID;

C)

ADD INDEX ID;

D)

REMOVE INDEX ID;

Correct Answer : Option (A) : CREATE INDEX ID;

75 .

Embedded SQL is which of the following?

A)

Hard-coded SQL statements in a trigger.

B)

Hard-coded SQL statements in a procedure.

C)

Hard-coded SQL statements in a program language such as Java.

D)

The process of making an application capable of generating specific SQL code on the fly.

Correct Answer : Option (C) : Hard-coded SQL statements in a program language such as Java.

76 .

A UNION query is which of the following?

A)

Combines the output from no more than two queries and does not include the same number of columns.

B)

Combines the output from multiple queries and must include the same number of columns.

C)

Combines the output from no more than two queries and must include the same number of columns.

D)

Combines the output from multiple queries and does not include the same number of columns.

Correct Answer : Option (B) : Combines the output from multiple queries and must include the same number of columns.

77 .

Which of the following is true concerning triggers?

A)

They have an event, condition, and action.

B)

You do not create them with SQL.

C)

They execute against only some applications that access a database.

D)

They cannot cascade (cause another trigger to fire).

Correct Answer : Option (A) : They have an event, condition, and action.

78 .

In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:

A)

all columns of the table are to be returned.

B)

all records meeting the full criteria are to be returned.

C)

all records with even partial criteria met are to be returned.

D)

None of the above is correct.

Correct Answer : Option (A) : all columns of the table are to be returned.

79 .

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

A)

Data types

B)

Default values

C)

Primary keys

D)

All of the above.

Correct Answer : Option (D) : All of the above.

80 .

Which one of the following sorts rows in SQL?

A)

SORT BY

B)

ALIGN BY

C)

ORDER BY

D)

GROUP BY

Correct Answer : Option (C) : ORDER BY

81 .

The SQL keyword BETWEEN is used:

A)

as a wildcard.

B)

for ranges.

C)

to limit the columns displayed.

D)

None of the above

Correct Answer : Option (B) : for ranges.

82 .

A subquery in an SQL SELECT statement:

A)

can only be used with two tables.

B)

can always be duplicated by a join.

C)

has a distinct form that cannot be duplicated by a join.

D)

has a distinct form that cannot be duplicated by a join.

Correct Answer : Option (C) : has a distinct form that cannot be duplicated by a join.

83 .

The SQL -92 wildcards are ____ and ____ .

A)

asterisk (*); percent sign (%)

B)

percent sign (%); underscore (_)

C)

underscore(_); question mark (?)

D)

question mark (?); asterisk (*)

Correct Answer : Option (B) : percent sign (%); underscore (_)

84 .

The Microsoft Access wildcards are ____ and ____ .

A)

asterisk (*); percent sign (%)

B)

percent sign (%); underscore (_)

C)

underscore(_); question mark (?)

D)

question mark (?); asterisk (*)

Correct Answer : Option (D) : question mark (?); asterisk (*)

85 .

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.

Correct Answer : Option (A) : use FROM to name the source table(s) and list the columns to be shown after SELECT.

86 .

________ was adopted as a national standard by ANSI in 1992.

A)

Oracle

B)

SQL

C)

DBase

D)

Microsoft Access

Correct Answer : Option (B) : SQL

87 .

The benefits of a standard relational language include which of the following?

A)

Reduced training costs

B)

Applications are not needed

C)

Increased dependence on a single vendor

D)

All of the above

Correct Answer : Option (A) : Reduced training costs

88 .

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 FROM CUSTOMER WHERE STATE IN ('VA');

D)

SELECT NAME IN CUSTOMER WHERE STATE = 'V';

Correct Answer : Option (C) :

SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');

89 .

DBMS provides insulation between program and data. This is referred to as _______

A)

program-data independence

B)

program-data dependence

C)

database-data dependence

D)

program-database independence

Correct Answer : Option (A) : program-data independence

90 .

Which of the following is NOT a typical DBMS functionality?

A)

Manipulating the database

B)

Manage the user interface of database application

C)

Define a particular database in terms of its data types, structures and constraints

D)

Processing and sharing by a set of concurrent users and application programs

Correct Answer : Option (B) : Manage the user interface of database application

91 .

Which of the following is NOT one of the three phases for Database Design phase?

A)

Global Database Design

B)

Conceptual Database Design

C)

Logical Database Design

D)

Physical Database Design

Correct Answer : Option (A) : Global Database Design

92 .

Data model comprises all of the following, except _________

A)

a structural part

B)

a manipulative part

C)

a set of integrity rules

D)

a managerial part

Correct Answer : Option (D) : a managerial part

93 .

Which is not one of the evaluation criteria during testing phase?

A)

Learnability

B)

Performance

C)

Creativity

D)

Robustness

Correct Answer : Option (C) : Creativity

94 .

AVG, COUNT, MAX, MIN and SUM are known as what?

A)

Aggregate functions

B)

Wildcard filters

C)

Calculated field

D)

Subqueries

Correct Answer : Option (A) : Aggregate functions

95 .

You must always use _____ when filtering string values.

A)

exclamation point

B)

percent signs

C)

astericks

D)

quotes

Correct Answer : Option (D) : quotes

96 .

Use what to separate multiple table names in the FROM clause?

A)

commas

B)

periods

C)

spaces

D)

semicolons

Correct Answer : Option (A) : commas

97 .

To join a table, connect the ______ of one table to the ______ of the other.

A)

filtered by, foreign key

B)

primary key, foreign key

C)

group by clause, primary key

D)

aggregate function, where clause

Correct Answer : Option (B) : primary key, foreign key

98 .

Use what to remove spaces from the beginning and end of the string value?

A)

SPACE

B)

NOSPACE

C)

CROP

D)

TRIM

Correct Answer : Option (D) : TRIM

99 .

SELECT MAX(price)FROM PRODUCT will return how many rows?

A)

0

B)

1

C)

2

D)

As many rows that are in the table

Correct Answer : Option (B) : 1