Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.

You are the administrator of a SQL Server 2000 computer. The server contains a database named FinanceData that is used by a client/server application. Each employee has a SQL Server login that the application uses to access the server.Your company hires a new employee named Andrew. You create a SQL Server login named Andrew. You also create a database user named Andrew in the database and grant the database user full permissions in the database.Whenever Andrew runs the client/server application, he receives the following error message: "Invalid object name." Andrew also reports that he cannot access the database by using the application.You need to ensure that Andrew can use the application. Which Transact-SQL statement should you execute?

A

EXEC sp_defaultdb 'Andrew','FinanceData'

B

GRANT ALL ON FinanceData TO Andrew

C

EXEC sp_addlogin 'Andrew'

D

EXEC sp_grantdbaccess 'FinanceData','Andrew'GOsp_addrolemember 'db_datareader','Andrew'

Read the passage carefully and choose thebest answer to each question out of the four alternativesand click the button corresponding to it. To know language is to be able to speak it; even a childwho does not yet attend school can speak his or herlanguage. In order to speak a language it is important tolisten to it and to read a few pages in it everyday. A childpicks up language and learns to talk just as (s)he learnsto walk. Walking and talking comes naturally to a child asit grows. In our country, a child may grow up speakingmore than one language, if these languages are spoken inthe home and in the neighbourhood. we call this multilingualism. A child speaks a language or languagesmuch before (s)he starts going to school. To know alanguage then is first of all to be able to speak it as easilyand naturally as a tree year old child does. Later on thechild will learn to read and write in that language. In orderto read and write in a language, one has to speak it. But itis possible to speak a language but not able to read orwrite in it. A baby does not speak until it is nine monthsold but it understands a few words at six months of age.It has been listening ever since it was born, and even alittle before that. So the first strategy in speaking alanguage is to listen. It is necessary for one to __________ the language before(s)he writes in that language.

A

sing

B

spell

C

speak

D

none of the above

The SQL MAKE TABLE command is used to construct tables, define columns, define column constraints and create relationships.

A

True

B

False

Data manipulation language (DML)

A

describes how data are structured in the data base

B

specifies for the DBMS what is required; the techniques used to process data

C

determine how data must be structured to produce the user's view

D

All of the above

E

None of the above

Which of the following is not included in DML (Data Manipulation Language)?

A

UPDATE

B

CREATE

C

INSERT

D

DELETE

Which of the following is not included in DML (Data Manipulation Language)

A

INSERT

B

UPDATE

C

DELETE

D

CREATE

Which of the following statements are true?
Statement I Big data refers to no precise quantity, but generally refers to data in the range of Petabytes and Exabyte, i.e. billions to trillions of records, all from various sources. Big data is generated much faster. than traditional data in much larger quantities.
Statement II Big data interests industries because they are able to learn more patterns and curious variances than smaller data sets, with the capability to provide valuable insights into consumer behaviour, weather systems, financial market activity, or other phenomena.
Statement III Various departments and product lines use various applications within most organisations and store data in separate datasets. These separate databases may contain similar data, but data from one data base to another is not always consistent. This is called data silo.

A

Both statements I and II

B

Both statements II and III

C

Both statements I and III

D

All of the above

Five tables T1, T2, T3, T4 and T5 are kept one above the other (Not necessarily in the same order) Number of tables above T4 are same as the number of tables below T5. T3 is just above T1. T5 is at the bottom. There are two tables between T2 and T5. Which of the following is the correct position of T1?

A

T1 is just below T5

B

T2 is two places below T1

C

T1 is just above T5

D

T1 is three places below T2

UPDATE statement is a DML statement. What does DML stand for?

A

Data Manipulation Language

B

Data Manipulation Level

C

Data Markup Language

D

Data Markup Level

Three statements are given followed by four conclusions numbered I, II, III and IV. Assuming that the statements are true even if they seem to be at variance from commonly known facts, decide which of the conclusions logically follows from the statements. Statements: 1. All carpets are beds. 2. Some tables are carpets. 3. All pillows are tables. Conclusions: I. All pillows are beds. II. Some pillows are beds. III. Some beds are tables. IV. All tables are beds.

A

Only conclusion III follows.

B

Conclusions I and II both follow.

C

Conclusions II and III both follow.

D

Only conclusion I follows.

Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.

Related Questions