Question
Answered

Need help with this Multiple Choice: Question31 Not yet answered...

Need help with this Multiple Choice:


Question 31

Not yet answered

Marked out of 1.00

Flag question

Question text

Using INSERT INTO statement, several rows can be added at a time.

Select one:

True

False

Question 32

Not yet answered

Marked out of 1.00

Flag question

Question text

tblProducts Table

 ProductID 

 SupplierID 

 CategoryID 

 ProductName 

1

1

1

Chai

2

1

1

Chang

3

1

2

Aniseed Syrup

4

2

2

Chef Anto's Cajun 

Using the tblProducts Table shown above, which of the following SQL statements returns just the ProductID and ProductName of all the products whose CategoryID is either 2 or 3?

Select one:

a. Select ProductID, ProductName from tblProducts;

b. Select ProductID, ProductName from tblProducts Where CategoryID = 2 and CategoryID = 3;

c. Select ProductID, ProductName from tblProducts Where CategoryID <> 1;

d. Select ProductID, ProductName from tblProducts Where CategoryID = 2 or CategoryID = 3;

Clear my choice

Question 33

Not yet answered

Marked out of 1.00

Flag question

Question text

After a database has been created, there are two ways of populating the tables - either from existing data or through the use of the user applications developed for the database.

Select one:

True

False

Question 34

Answer saved

Marked out of 1.00

Flag question

Question text

Which of the following is wrong about domains of a relation?

Select one:

a. Two or more attributes can be defined on the same domain

b. Two attributes that include values from different domains can easily be compared

c. A tuple can draw values from different domains

d. A pool of atomic values constitutes a domain

Clear my choice

Question 35

Not yet answered

Marked out of 1.00

Flag question

Question text

Which of the following is true about a relation?

Select one:

a. There is a single attribute in each relation

b. The order of the tuples of a relation is determined by the primary key

c. A relation is a one-dimensional table

d. All the values in any column must be of the same type

Question 36

Answer saved

Marked out of 1.00

Flag question

Question text

Data analysis begins with the statement of data design.

Select one:

True

False

Question 37

Not yet answered

Marked out of 1.00

Flag question

Question text

To be in third normal form, the relation doesn't need to be in second normal form.

Select one:

True

False

Question 38

Not yet answered

Marked out of 1.00

Flag question

Question text

Look at the below SQL create command. Consider that there is only one profession which is named as "Student". Which of the following statements is wrong about this SQL create statement?

CREATE TABLE USERS

(NAME CHAR(20),

AGE INTEGER,

PROFESSION VARCHAR(30))

Select one:

a. Stored data for the NAME column requires more database space than stored data for the PROFESSION column.

b. Table name is USERS.

c. There are three columns in this table.

d. CHAR (7) can also be used for the PROFESSION column. 

Question 39

Answer saved

Marked out of 1.00

Flag question

Question text

A relational database query normally returns many rows of data. But an application program usually deals with one row at a time. Which of the following is used to bridge this gap allowing the program to deal with on row at a time?

Select one:

a. Cursor

b. Trigger

c. PL/SQL

d. Sub select join

Clear my choice

Question 40

Answer saved

Marked out of 1.00

Flag question

Question text

tblProducts Table

 ProductID 

 SupplierID 

 CategoryID 

 ProductName 

1

1

1

Chai

2

1

1

Chang

3

1

2

Aniseed Syrup

4

2

2

Chef Anto's Cajun 

Using the tblProducts Table shown above, which of the following SQL statements returns just the ProductID, CategoryID and ProductName of all the products with SupplierID of 1?

Select one:

a. Select * from tblProducts;

b. Select * from tblProducts Where ProductID=1;

c. Select ProductID, CategoryID, ProductName from tblProducts Where SupplierID =1;

d. Select ProductID=1, CategoryID, ProductName from tblProducts;

Clear my choice



Question 21

Answer saved

Marked out of 1.00

Flag question

Question text

The SQL ALTER statement can be used to:

Select one:

a. change the table structure.

b. change the table data.

c. add rows to the table.

d. delete rows from the table.

Clear my choice

Question 22

Answer saved

Marked out of 1.00

Flag question

Question text

Which of the following is wrong?

Select one:

a. If A → BC, then A → B and B → C

b. If A → B and B → C, then A → C

c. If A → B and A → C, then A → BC

d. If A → B and C is another attribute, then AC → BC

Clear my choice

Question 23

Not yet answered

Marked out of 1.00

Flag question

Question text

A relational database can be defined as a self-describing collection of non-integrated relations.

Select one:

True

False

Question 24

Answer saved

Marked out of 1.00

Flag question

Question text

Given only the following part of an E-R diagram, what does the foot mark across the relationship line near the entity in the figure below indicate?


Select one:

a. A minimum cardinality of zero

b. A minimum cardinality of one

c. A maximum cardinality of one

d. A maximum cardinality of many

Clear my choice

Question 25

Answer saved

Marked out of 1.00

Flag question

Question text

The Database Administrator is responsible for developing the logical data model.

Select one:

True

False

Question 26

Answer saved

Marked out of 1.00

Flag question

Question text

tblProducts Table

 ProductID 

 SupplierID 

 CategoryID 

 ProductName 

1

1

1

Chai

2

1

1

Chang

3

1

2

Aniseed Syrup

4

2

2

Chef Anto's Cajun 

Using the tblProducts Table shown above, which of the columns could be a Primary Key of another table?

Select one:

a. SupplierID

b. CategoryID

c. ProductName

d. All of the above

Clear my choice

Question 27

Not yet answered

Marked out of 1.00

Flag question

Question text

Which of the following is not an element of the E-R Model?

Select one:

a. Use case

b. Entity

c. Cardinality

d. Relationship

Question 28

Answer saved

Marked out of 1.00

Flag question

Question text

Considering all the other tables exist in the database, which of the following SQL statements that are used to create tables gives an error?

Select one:

a. Create Table Instructor(

    ID integer Not Null,

    Name varchar (40),

    SureName varchar (40),

Primary Key (ID),

Unique (ID)

);         

b. Create Table Instructor(

    ID integer Not Null,

    Name varchar (40),

    SureName varchar (40),

CONSTRAINT pk Primary Key (ID)

);

c. Create Table Instructor(

    ID integer Not Null,

    Name varchar (40),

    SureName varchar (40),

Primary Key (ID),

Foreign Key (Name)

);

d. Create Table Instructor(

    ID integer Not Null,

    Name varchar (40),

    SureName varchar (40),

Primary Key (ID),

Foreign Key (Name) References Departments

);

Clear my choice

Question 29

Answer saved

Marked out of 1.00

Flag question

Question text

What is wrong about a surrogate key?

Select one:

a. A surrogate is an attribute or set of attributes that uniquely identifies a record in a relation

b. A surrogate key does not exist in the real world as a real attribute of an entity set

c. A surrogate key is usually a generated unique number

d. It is not a good practice to use a surrogate key

Clear my choice

Question 30

Answer saved

Marked out of 1.00

Flag question

Question text

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

Select one:

a. Equi-join

b. Natural join

c. Outer Join

d. All of the above

Clear my choice


Question 11

Not yet answered

Marked out of 1.00

Flag question

Question text

Which of the following statements is wrong?

Select one:

a. SQL INSERT command is used to add data to a table

b. A data type of Char(30) indicates a fixed-length field of 30 characters

c. SQL was developed by IBM in the late 1970s

d. While creating a table using SQL, specifying the NULL property for a column means that only null values can be stored in that column

Question 12

Not yet answered

Marked out of 1.00

Flag question

Question text

Which of the following is NOT true about the functional dependency A → (B, C)?

Select one:

a. B is functionally dependent on A

b. A determines C

c. B and C together determine A

d. B and C are functionally dependent on A

Question 13

Answer saved

Marked out of 1.00

Flag question

Question text

Which of the following is an incorrect statement?

Select one:

a. A precompiler is required to translate embedded SQL.

b. A precompiler is required to translate SQLJ.

c. Embedded SQL uses variables in the host language to pass parameters to SQL queries.

d. JDBC uses variables in the host language to pass parameters to SQL queries.

Clear my choice

Question 14

Answer saved

Marked out of 1.00

Flag question

Question text

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 ;

Select one:

a. Equi-join

b. Natural join

c. Outer Join

d. Cartesian Join

Clear my choice

Question 15

Answer saved

Marked out of 1.00

Flag question

Question text

A data model is a plan for a database design.

Select one:

True

False

Question 16

Answer saved

Marked out of 1.00

Flag question

Question text

Given a relation R with three attributes A, B, C with the following dependencies:

C → A

C → B

Assume that there is not any multivalued attribute, what is the best normal form that R satisfies (1NF, 2NF, 3NF, or BCNF)?

Select one:

a. 1NF

b. 2NF

c. 3NF

d. BCNF

Clear my choice

Question 17

Not yet answered

Marked out of 1.00

Flag question

Question text

Referential integrity constraints are concerned with checking INSERT and UPDATE operations that affect the parent child relationships.

Select one:

True

False

Question 18

Not yet answered

Marked out of 1.00

Flag question

Question text

Database application development is the process of obtaining real-world requirements, analyzing requirements, designing the data and functions of the system, and then implementing the operations in the system.

Select one:

True

False

Question 19

Answer saved

Marked out of 1.00

Flag question

Question text

There could be static embedded SQL applications.

Select one:

True

False

Question 20

Answer saved

Marked out of 1.00

Flag question

Question text

The result of a SELECT statement can contain duplicate rows.

Select one:

True

False


Which of the following statements is wrong?

Select one:

a. AVG() outputs the average (arithmetic mean) of the column values addressed by the query.

b. MAX() outputs the maximum, the largest, column value from those that are addressed by the query.

c. SUM() outputs the sum total of all the column values that are addressed by the query. This function can be used with every column.

d. MIN() outputs the minimum, the smallest, column value from those that are addressed by the query.

Question 2

Answer saved

Marked out of 1.00

Flag question

Question text

ODBC can be directly used with Java because it uses a C interface. 

Select one:

True

False

Question 3

Not yet answered

Marked out of 1.00

Flag question

Question text

Which of the following SQL data types should not be used to define the numeric data: 111.11?

Select one:

a. integer(3,2)

b. numeric(3,2)

c. numeric(4,2)

d. numeric(5,2)

Question 4

Not yet answered

Marked out of 1.00

Flag question

Question text

If a bank has to transfer 1,000 dollars from account A to account B, the step that increases the balance of account B by the amount of 1,000 dollars is called a transaction. 

Select one:

True

False

Question 5

Answer saved

Marked out of 1.00

Flag question

Question text

Create Table EXAMS (

    SUB_NO integer Not Null,

    STUDENT_NO integer Not Null,

    MARK decimal (3),

    DATE_TAKEN date,

    Primary Key (SUB_NO)

);

The above SQL statement is used to create the EXAMS table. Considering the EXAMS table; which of the following table contents can't be inserted to the EXAMS table (assume date format is correct)?

Select one:

a.

 SUB_NO 

 STUDENT_NO 

 MARK 

 DATE_TAKEN 

1

1

2

2

85

b.

 SUB_NO 

 STUDENT_NO 

 MARK 

 DATE_TAKEN 

1

1

05-23-2020

2

1

85

02-23-2020

c.

 SUB_NO 

 STUDENT_NO 

 MARK 

 DATE_TAKEN 

1

1

05-23-2020

1

2

d.

 SUB_NO 

 STUDENT_NO 

 MARK 

 DATE_TAKEN 

1

1

2

2

Clear my choice

Question 6

Not yet answered

Marked out of 1.00

Flag question

Question text

Which of the following is an incorrect statement?

Select one:

a. Access plans for dynamic SQL statements are generated only at runtime.

b. Dynamic SQL applications are slower than static SQL applications.

c. The access plan generated for a static SQL statement is stored in advance.

d. If the static SQL part of the application is modified, then the regeneration of access plans is not needed.

Question 7

Answer saved

Marked out of 1.00

Flag question

Question text

Once the view is created, you can use it just like any table.

Select one:

True

False

Question 8

Answer saved

Marked out of 1.00

Flag question

Question text

SQL can only be used as a Data Manipulation Language (DML).

Select one:

True

False

Question 9

Not yet answered

Marked out of 1.00

Flag question

Question text

In an E-R diagram, it is possible that an entity can have a relationship to itself.

Select one:

True

False

Question 10

Not yet answered

Marked out of 1.00

Flag question

Question text

Create Table EXAMS (

    SUB_NO integer Not Null,

    STUDENT_NO integer Not Null,

    MARK decimal (3),

    DATE_TAKEN date

);

The above SQL statement is used to create the EXAMS table. Considering the EXAMS table; which of the following SQL statements can be used to drop the DATE_TAKEN column of the EXAMS table?

Select one:

a. Alter Table EXAMS Drop DATE_TAKEN;

b. Alter EXAMS Drop DATE_TAKEN;

c. Alter Table DATE_TAKEN Drop EXAMS;

d. Alter Table Drop DATE_TAKEN;

Answer & Explanation
Verified Solved by verified expert
Rated Helpful
<p>itur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pe</p> Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet

Unlock full access to Course Hero

Explore over 16 million step-by-step answers from our library

Subscribe to view answer

fficitur laoreet.

amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequ

sus ante, d

tesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac


inia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet

nec


pulvinar tortor nec facilisis. Pellentesque dapibus efficit


nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a mo

m ipsum dolor sit amet, consectetur adipiscing elit.

usce dui lectus, congue vel laoreet ac, dictum v


sque dapibus efficitur laoreet. Nam risus ante,

sus ante, d

sus ante, dapibus a molestie consequat, ul

tesque dapibus efficitur laoreet. Nam risus ante, dapibus



lestie consequat, ultrices ac magna. Fusce dui lectus,

ffic


ng elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur

ffic


m risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipisc

a molestie consequ

dictum vitae o

itur laoree

a. Fusce dui lectus, co


or nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultric

gue

Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante

itur laoreet



fficitur laoreet.

amet, consectetur

a. Fusce dui lect

gue vel laoreet a

usce dui lectus, co

c

c

c

o. D

o

c

c

o. Do

u

c

o

trices ac mag

o

o

o

ec aliquet. Lorem ips

icitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit


ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec



ac, dictum vitae odio. Donec aliquet.

, ultrices ac magna. Fusce dui l



amet, consectetur adipiscing eli

ec facilisis. Pellentesque dapibus efficitur laore


m ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis.

ffic


rem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risu

ipsum dolor sit amet, consectetur


facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a m

ffic


fficitur laoreet.

amet, consectetur

a. Fusce dui lect

gue vel laoreet a

usce dui lectus, co

c

c

c

o. D

o

c

c

o. Do

u

c

o

trices ac mag

o

o

o

ec aliquet. Lorem ips


iscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam ri

e vel laoreet ac, dict


risus ante, dapibus a molestie consequat, ultrices ac magn

dictum vitae


amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibu

, dictum vitae odio. Donec aliquet

acinia pulvinar tortor nec facilisis

sus ante, dapibus a molestie cons

onec aliquet. Lorem ipsum dolor sit am

m ipsum dolor si

Fusce dui lectus

u


a molestie consequat, ultrices ac ma

sus ante, d

m ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facil


a. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum d

a. Fusce dui lec


molestie consequat, ultrices ac magna. Fusc

fficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae


gue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, c

ctum vitae odio. Donec aliquet. L


ongue vel laoreet ac, dictum vitae odio. Donec al

sque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ul


a. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit.

ec aliquet. Lorem ip


e vel laoreet ac, dictum vitae odio. Donec al

nec


Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam laci

inia pulvi

dictum vit

facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce

onec aliq


, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis

ffic


ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque da

nec


inia pulvinar tortor nec facilisis. Pellentesque

nec


risus ante, dapibus a molestie consequat, ultrices ac magna.

nec


molestie consequat, ultrices ac magna. Fusc

risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet.


nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ant

ffic


ec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie con

ipsum dolor sit am


cing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus,

ffic


o. Donec aliquet. L

, ultrices ac magna. Fusce dui lectus,

ctum vitae odio. Donec aliquet. Lorem ipsum

icitur laoreet. Nam risus ante, d

sum dolor sit amet, consectetur

amet, consectetur adipiscing elit. N

s

ipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel la

s

a. Fusce dui l

iscing elit. Nam l

trices ac ma

consectetur adipis

c

c

m ipsum do

c

o

en


molestie consiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet.


ongue vel laoreet ac, dictum vitae odio. Donec al

ia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie cons


ce dui lectus, congue vel laoreet ac, dictum vitae odio. Don

nec


consectetur adipiscing elit. Nam lacinia pulvinar tortor ne

ffic


icitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fu

nec



o. Donec aliquet. L

, ultrices ac magna. Fusce dui lectus,

ctum vitae odio. Donec aliquet. Lorem ipsum

icitur laoreet. Nam risus ante, d

gue vel laoreet ac, dictum vit

s

cing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel

, dictum vitae odio. Donec aliquet. Lor

Student reviews
88% (16 ratings)