Question 1

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

Accepted Answer

1 one

Question 2

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

Accepted Answer

A) True 
 B)False  True

Question 3

An alias cannot be used when a table is required to be joined to itself in a recursive query.

Accepted Answer

A) True 
 B)False  False

Question 4

DATE()and SYSDATE are special functions that return today's date in MS Access and ,respectively.

Accepted Answer

The answer of DATE()and SYSDATE are special functions that return...

Question 5

You can select partial table contents by naming the desired fields and by placing restrictions on the rows to be included in the output.

Accepted Answer

A) True 
 B)False

Question 6

The conditional LIKE must be used in conjunction with wildcard characters.

Accepted Answer

A) True 
 B)False

Question 7

The specification is used to avoid having duplicated values in a column.

Accepted Answer

The answer of The specification is used to avoid having...

Question 8

A common practice is to create a(n)on any field that is used as a search key,in comparison operations in a conditional expression,or when a user wants to list rows in a specific order.

Accepted Answer

The answer of A common practice is to create a(n)on...

Question 9

An alias is especially useful when a table must be joined to itself in a(n)query.

Accepted Answer

The answer of An alias is especially useful when a...

Question 10

String comparisons are made from left to right.

Accepted Answer

A) True 
 B)False

Question 11

When a user issues the DELETE FROM tablename command without specifying a WHERE condition,.

Accepted Answer

A) no rows will be deleted 
B) the first row will be deleted 
C) the last row will be deleted 
D) all rows will be deleted 
A) no rows will be deleted 
B) the first row will be deleted 
C) the last row will be deleted 
D) all rows will be deleted

Question 12

A database language enables the user to perform complex queries designed to transform the raw data into useful information.

Accepted Answer

A) True 
 B)False

Question 13

The constraint assigns a value to an attribute when a new row is added to a table.

Accepted Answer

A) CHECK 
B) UNIQUE 
C) NOT NULL 
D) DEFAULT 
A) CHECK 
B) UNIQUE 
C) NOT NULL 
D) DEFAULT

Question 14

All SQL commands must be issued on a single line.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following queries is used to list a unique value for V_CODE,where the list will produce only a list of those values that are different from one another?

Accepted Answer

A) SELECT ONLY V_CODE FROM PRODUCT; 
B) SELECT UNIQUE V_CODE FROM PRODUCT; 
C) SELECT DIFFERENT V_CODE FROM PRODUCT; 
D) SELECT DISTINCT V_CODE FROM PRODUCT; 
A) SELECT ONLY V_CODE FROM PRODUCT; 
B) SELECT UNIQUE V_CODE FROM PRODUCT; 
C) SELECT DIFFERENT V_CODE FROM PRODUCT; 
D) SELECT DISTINCT V_CODE FROM PRODUCT;

Question 16

The ANSI SQL standards are also accepted by the ISO.

Accepted Answer

A) True 
 B)False

Question 17

To list the contents of a table,you must use the DISPLAY command.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

The SQL aggregate function that gives the number of rows containing non-null values for a given column is .

Accepted Answer

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

Question 20

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

Accepted Answer

A) SELECT P_DESCRIPT,P_QOH,P_MIN,P_PRICE,P_INDATE FROM PRODUCT WHERE P_INDATE >= '20-JAN-2016'; 
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-2016'; 
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};

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

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

An alias cannot be used when a table is required to be joined to itself in a recursive query.

DATE()and SYSDATE are special functions that return today's date in MS Access and ,respectively.

You can select partial table contents by naming the desired fields and by placing restrictions on the rows to be included in the output.

The conditional LIKE must be used in conjunction with wildcard characters.

The specification is used to avoid having duplicated values in a column.

A common practice is to create a(n)on any field that is used as a search key,in comparison operations in a conditional expression,or when a user wants to list rows in a specific order.

An alias is especially useful when a table must be joined to itself in a(n)query.

String comparisons are made from left to right.

When a user issues the DELETE FROM tablename command without specifying a WHERE condition,.

A database language enables the user to perform complex queries designed to transform the raw data into useful information.

The constraint assigns a value to an attribute when a new row is added to a table.

All SQL commands must be issued on a single line.

Which of the following queries is used to list a unique value for V_CODE,where the list will produce only a list of those values that are different from one another?

The ANSI SQL standards are also accepted by the ISO.

To list the contents of a table,you must use the DISPLAY command.

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

The SQL aggregate function that gives the number of rows containing non-null values for a given column is .

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

Database Systems

Data Models

The Relational Database Model

Entity Relationship Ermodeling

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

Big Data Analytics and NoSQL

Database Connectivity and Web Technologies

Database Administration and Security

Filters

Exam 7: Introduction to Structured Query Language SQL

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

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

An alias cannot be used when a table is required to be joined to itself in a recursive query.

DATE()and SYSDATE are special functions that return today's date in MS Access and ,respectively.

You can select partial table contents by naming the desired fields and by placing restrictions on the rows to be included in the output.

The conditional LIKE must be used in conjunction with wildcard characters.

The specification is used to avoid having duplicated values in a column.

A common practice is to create a(n)on any field that is used as a search key,in comparison operations in a conditional expression,or when a user wants to list rows in a specific order.

An alias is especially useful when a table must be joined to itself in a(n)query.

String comparisons are made from left to right.

When a user issues the DELETE FROM tablename command without specifying a WHERE condition,.

A database language enables the user to perform complex queries designed to transform the raw data into useful information.

The constraint assigns a value to an attribute when a new row is added to a table.

All SQL commands must be issued on a single line.

Which of the following queries is used to list a unique value for V_CODE,where the list will produce only a list of those values that are different from one another?

The ANSI SQL standards are also accepted by the ISO.

To list the contents of a table,you must use the DISPLAY command.

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

The SQL aggregate function that gives the number of rows containing non-null values for a given column is .

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

Database Systems

Data Models

The Relational Database Model

Entity Relationship Ermodeling

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

Big Data Analytics and NoSQL

Database Connectivity and Web Technologies

Database Administration and Security

Filters