Question 1

The ANSI SQL standards are also accepted by the ISO.

Accepted Answer

A) True 
 B)False  True

Question 2

is the process the DBMS uses to verify that only registered users access the database.

Accepted Answer

Authentication

Question 3

In Oracle, the command is used to change the display for a column, for example, to place a $ in front of a numeric value.

Accepted Answer

A)  DISPLAY 
B)  FORMAT 
C)  CHAR 
D)  CONVERT 
A)  DISPLAY 
B)  FORMAT 
C)  CHAR 
D)  CONVERT B

Question 4

The SQL data manipulation command HAVING:

Accepted Answer

A)  restricts the selection of rows based on a conditional expression. 
B)  restricts the selection of grouped rows based on a condition. 
C)  modifies an attribute's values in one or more table's rows. 
D)  groups the selected rows based on one or more attributes. 
A)  restricts the selection of rows based on a conditional expression. 
B)  restricts the selection of grouped rows based on a condition. 
C)  modifies an attribute's values in one or more table's rows. 
D)  groups the selected rows based on one or more attributes.

Question 5

The special operator used to check whether an attribute value is within a range of values is .

Accepted Answer

A)  BETWEEN 
B)  NULL 
C)  LIKE 
D)  IN 
A)  BETWEEN 
B)  NULL 
C)  LIKE 
D)  IN

Question 6

A(n) is performed when data are retrieved from more than one table at a time.

Accepted Answer

The answer of A(n) is performed when data are retrieved...

Question 7

The special operator used to check whether a subquery returns any rows is .

Accepted Answer

A)  BETWEEN 
B)  EXISTS 
C)  LIKE 
D)  IN 
A)  BETWEEN 
B)  EXISTS 
C)  LIKE 
D)  IN

Question 8

Which of the following queries will use the given columns and column aliases from the PRODUCT table to determine the total value of inventory held on hand?

Accepted Answer

A)  SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH/P_PRICE FROM PRODUCT; 
B)  SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH=P_PRICE FROM PRODUCT; 
C)  SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH*P_PRICE FROM PRODUCT; 
D)  SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH-P_PRICE FROM PRODUCT; 
A)  SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH/P_PRICE FROM PRODUCT; 
B)  SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH=P_PRICE FROM PRODUCT; 
C)  SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH*P_PRICE FROM PRODUCT; 
D)  SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH-P_PRICE FROM PRODUCT;

Question 9

The syntax for creating an index is .

Accepted Answer

A)  CREATE [NOT NULL] INDEX indexname FROM viewname(column1 [, column2]); 
B)  CREATE [UNIQUE] INDEX indexname ON tablename( column1 [, column2]); 
C)  CREATE [UNIQUE] INDEX indexname FROM tablename(column1 [, column2]); 
D)  CREATE [DEFAULT] INDEX indexname ON viewname(column1 [, column2]); 
A)  CREATE [NOT NULL] INDEX indexname FROM viewname(column1 [, column2]); 
B)  CREATE [UNIQUE] INDEX indexname ON tablename( column1 [, column2]); 
C)  CREATE [UNIQUE] INDEX indexname FROM tablename(column1 [, column2]); 
D)  CREATE [DEFAULT] INDEX indexname ON viewname(column1 [, column2]);

Question 10

Which of the following queries will list all the rows in which the inventory stock dates occur on or after January 20, 2010?

Accepted Answer

A)  SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE FROM PRODUCT WHERE P_INDATE >= '20-JAN-2010'; 
B)  SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE FROM PRODUCT WHERE P_INDATE >= $20-JAN-2010$; 
C)  SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE FROM PRODUCT WHERE P_INDATE = {20-JAN-2010}; 
A)  SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE FROM PRODUCT WHERE P_INDATE >= '20-JAN-2010'; 
B)  SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE FROM PRODUCT WHERE P_INDATE >= $20-JAN-2010$; 
C)  SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE FROM PRODUCT WHERE P_INDATE = {20-JAN-2010};

Question 11

Date procedures are often more software-specific than other SQL procedures.

Accepted Answer

A) True 
 B)False

Question 12

The special operator is used to check whether an attribute value is null.

Accepted Answer

A)  BETWEEN 
B)  IS NULL 
C)  LIKE 
D)  NOT NULL 
A)  BETWEEN 
B)  IS NULL 
C)  LIKE 
D)  NOT NULL

Question 13

In a 1:M relationship, a user must always create the table for the side first.

Accepted Answer

The answer of In a 1:M relationship, a user must...

Question 14

A database language enables the user to create database and table structures to perform basic data management chores.

Accepted Answer

A) True 
 B)False

Question 15

What are the wildcard characters that are used with the LIKE command? Provide one or more examples of each.

Accepted Answer

The LIKE special operator is used in con

Question 16

Some RDBMSs, such as Oracle, automatically data changes when issuing data definition commands.

Accepted Answer

A)  COMMIT 
B)  ROLLBACK 
C)  UNSAVE 
D)  UPDATE 
A)  COMMIT 
B)  ROLLBACK 
C)  UNSAVE 
D)  UPDATE

Question 17

Entity integrity is enforced automatically when the primary key is specified in the CREATE TABLE command sequence.

Accepted Answer

A) True 
 B)False

Question 18

What is a subquery? When is it used? Does the RDBMS deal with subqueries any differently from normal queries?

Accepted Answer

A subquery, also known as a nested query

Question 19

The ANSI prescribes a standard SQL-the current fully approved version is known as SQL-07.

Accepted Answer

A) True 
 B)False

Question 20

The SQL aggregate function that gives the arithmetic mean for a specific column is .

Accepted Answer

A)  COUNT 
B)  AVG 
C)  MAX 
D)  SUM 
A)  COUNT 
B)  AVG 
C)  MAX 
D)  SUM

The ANSI SQL standards are also accepted by the ISO.

is the process the DBMS uses to verify that only registered users access the database.

In Oracle, the command is used to change the display for a column, for example, to place a $ in front of a numeric value.

The SQL data manipulation command HAVING:

The special operator used to check whether an attribute value is within a range of values is .

A(n) is performed when data are retrieved from more than one table at a time.

The special operator used to check whether a subquery returns any rows is .

Which of the following queries will use the given columns and column aliases from the PRODUCT table to determine the total value of inventory held on hand?

The syntax for creating an index is .

Which of the following queries will list all the rows in which the inventory stock dates occur on or after January 20, 2010?

Date procedures are often more software-specific than other SQL procedures.

The special operator is used to check whether an attribute value is null.

In a 1:M relationship, a user must always create the table for the side first.

A database language enables the user to create database and table structures to perform basic data management chores.

What are the wildcard characters that are used with the LIKE command? Provide one or more examples of each.

Some RDBMSs, such as Oracle, automatically data changes when issuing data definition commands.

Entity integrity is enforced automatically when the primary key is specified in the CREATE TABLE command sequence.

What is a subquery? When is it used? Does the RDBMS deal with subqueries any differently from normal queries?

The ANSI prescribes a standard SQL-the current fully approved version is known as SQL-07.

The SQL aggregate function that gives the arithmetic mean for a specific column is .

Database Systems

Data Models

The Relational Database Model

Entity Relationship Er Modeling

Advanced Data Modeling

Normalization of Database Tables

Advanced Sql

Database Design

Transaction Management and Concurrency Control

Database Performance Tuning and Query Optimization

Distributed Database Management Systems

Business Intelligence and Data Warehouses

Database Connectivity and Web Technologies

Database Administration and Security

Filters

Exam 7: Introduction to Structured Query Language Sql

The ANSI SQL standards are also accepted by the ISO.

is the process the DBMS uses to verify that only registered users access the database.

In Oracle, the command is used to change the display for a column, for example, to place a $ in front of a numeric value.

The SQL data manipulation command HAVING:

The special operator used to check whether an attribute value is within a range of values is .

A(n) is performed when data are retrieved from more than one table at a time.

The special operator used to check whether a subquery returns any rows is .

Which of the following queries will use the given columns and column aliases from the PRODUCT table to determine the total value of inventory held on hand?

The syntax for creating an index is .

Which of the following queries will list all the rows in which the inventory stock dates occur on or after January 20, 2010?

Date procedures are often more software-specific than other SQL procedures.

The special operator is used to check whether an attribute value is null.

In a 1:M relationship, a user must always create the table for the side first.

A database language enables the user to create database and table structures to perform basic data management chores.

What are the wildcard characters that are used with the LIKE command? Provide one or more examples of each.

Some RDBMSs, such as Oracle, automatically data changes when issuing data definition commands.

Entity integrity is enforced automatically when the primary key is specified in the CREATE TABLE command sequence.

What is a subquery? When is it used? Does the RDBMS deal with subqueries any differently from normal queries?

The ANSI prescribes a standard SQL-the current fully approved version is known as SQL-07.

The SQL aggregate function that gives the arithmetic mean for a specific column is .

Database Systems

Data Models

The Relational Database Model

Entity Relationship Er Modeling

Advanced Data Modeling

Normalization of Database Tables

Advanced Sql

Database Design

Transaction Management and Concurrency Control

Database Performance Tuning and Query Optimization

Distributed Database Management Systems

Business Intelligence and Data Warehouses

Database Connectivity and Web Technologies

Database Administration and Security

Filters