Question is ⇒ SQL query and modification commands make up a(n) ________ ., Options are ⇒ (A) DDL, (B) DML, (C) HTML, (D) XML, (E) , Leave your comments or Download question paper.

Question is ⇒ SQL query and modification commands make up a(n) ________ ., Options are ⇒ (A) DDL, (B) DML, (C) HTML, (D) XML, (E) , Leave your comments or Download question paper. Previous question Next question


Q1.	SQL query and modification commands make up a(n) ________ .
A.	DDL [Wrong Answer]
B.	DML [Wrong Answer]
C.	HTML [Wrong Answer]
D.	XML [Correct Answer]
View Answer 1 -4 Explanation:- Answer : D Discuss it below : !! OOPS Login [Click here] is required to post your answer/result Help other students, write article, leave your comments

Previous question Next question

Also Read Similar Questions Below :

⇒ Which of the following do you need to consider when you make a table in SQL?
Data types
Primary keys
Default values
All of the above.

⇒ A CASE SQL statement is which of the following?
A way to establish an IF-THEN-ELSE in SQL.
A way to establish a loop in SQL.
A way to establish a data definition in SQL.
All of the above.

⇒ With which type of SQL Server recovery model are all database changes logged?
Differential recovery
Full recovery
Simple recovery
Bulk-logged recovery

⇒ The Microsoft Access wildcards are ____ and ____ .
asterisk (*); percent sign (%)
percent sign (%); underscore (_)
underscore(_); question mark (?)
question mark (?); asterisk (*)

⇒ The SQL WHERE clause:
limits the column data that are returned.
limits the row data are returned.
Both A and B are correct.
Neither A nor B are correct.

⇒ What is the full form of SQL?
Simple Query Language
Structured Query Language
Structured Query List
None of these

⇒ Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';
SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');
SELECT NAME IN CUSTOMER WHERE STATE = 'VA';
SELECT NAME IN CUSTOMER WHERE STATE = 'V';
SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');

⇒ A JSP is transformed into a(n):
Java applet.
Java servlet.
Either 1 or 2 above.
Neither 1 nor 2 above.

⇒ What is sent to the user via HTTP, invoked using the HTTP protocol on the user's computer, and run on the user's computer as an application?
A Java application
A Java applet
A Java servlet
None of the above is correct.

⇒ What is an SQL virtual table that is constructed from other tables?
Just another table
A view
A relation
Query results

⇒ Which of the following refers to the SQL Server transaction isolation level which places and holds locks on all rows that are read?
REPEATABLE READ
SERIALIZABLE
READ COMMITTED
READ UNCOMMITTED

⇒ A reason for using an SQL view to hide columns is:
to simplify a result only.
to prevent the display of sensitive data only.
to accomplish both of the above.
None of the above are reasons for using an SQL view.

⇒ Where is metadata stored in MySQL?
In the MySQL database
In the MySQL database
In the MySQL database
None of the above is correct.

⇒ How many tables may be included with a join?
One
Two
Three
All of the above.

⇒ What is not an advantage of stored procedures?
Greater security
SQL can be optimized
Code sharing
Increased network traffic

⇒ ON UPDATE CASCADE ensures which of the following?
Normalization
Data Integrity
Materialized Views
All of the above.

⇒ To run a compiled Java program, the machine must have what loaded and running?
Java virtual machine
Java compiler
Java bytecode
A Web browser

⇒ What programming language(s) or scripting language(s) does Java Server Pages (JSP) support?
VBScript only
Jscript only
Java only
All of the above are supported

⇒ Who invented Java?
Netscape
Microsoft
Sun
None of the above is correct.

⇒ What mode of authentication does SQL Server NOT provide?
Windows-only security
Both SQL Server and Windows-only security
Mixed security
SQL Server only security

⇒ Which JDBC driver Type(s) can be used in either applet or servlet code?
Both Type 1 and Type 2
Both Type 1 and Type 3
Both Type 3 and Type 4
Type 4 only

⇒ The SQL -92 wildcards are ____ and ____ .
asterisk (*); percent sign (%)
percent sign (%); underscore (_)
underscore(_); question mark (?)
question mark (?); asterisk (*)

⇒ What MySQL property is used to create a surrogate key in MySQL?
UNIQUE
SEQUENCE
AUTO_INCREMENT
None of the above -- Surrogate keys are not implemented in MySQL.

⇒ An SQL Server 2000 language that adds programming elements like parameters, variables, IF, WHILE loops, and so forth, to the basic capabilities of SQL is called:
COBOL.
VB.NET.
TRANSACT SQL.
Visual Basic.

⇒ In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:
all columns of the table are to be returned.
all records meeting the full criteria are to be returned.
all records with even partial criteria met are to be returned.
None of the above is correct.

⇒ Which JDBC driver Type(s) is(are) the JDBC-ODBC bridge?
Type 1
Type 2
Type 3
Type 4

⇒ What type of join is needed when you wish to return rows that do have matching values?
Equi-join
Natural join
Outer join
All of the above.

⇒ Which of the following is not a factor in determining the concurrency control behavior of SQL Server?
Lock level
Transaction isolation level
Cursor concurrency setting
Locking hints

⇒ A ________ is a stored program that is attached to a table or a view.
pseudofile
embedded SELECT statement
trigger
None of the above is correct.

⇒ ________ is an open source DBMS product that runs on UNIX, Linux and Windows.
MySQL
JSP/SQL
JDBC/SQL
Sun ACCESS