Explore topic-wise MCQs in Technical Programming.

This section includes 427 Mcqs, each offering curated multiple-choice questions to sharpen your Technical Programming knowledge and support exam preparation. Choose a topic below to get started.

251.

Embedded SQL is which of the following?

A. Hard-coded SQL statements in a program language such as Java.
B. The process of making an application capable of generating specific SQL code on the fly.
C. Hard-coded SQL statements in a procedure.
D. Hard-coded SQL statements in a trigger.
Answer» B. The process of making an application capable of generating specific SQL code on the fly.
Discussion
252.

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 WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID

A. Equi-join
B. Natural join
C. Outer join
D. Cartesian join
Answer» B. Natural join
Discussion
253.

Which of the following is true concerning systems information in an RDBMS?

A. RDBMS store database definition information in system-created tables.
B. This information can be accessed using SQL.
C. This information often cannot be updated by a user.
D. All of the above.
Answer» E.
Discussion
254.

Which of the following is one of the basic approaches for joining tables?

A. Subqueries
B. Union Join
C. Natural join
D. All of the above
Answer» E.
Discussion
255.

Which of the following statements is true concerning routines and triggers?

A. Both consist of procedural code.
B. Both have to be called to operate.
C. Both run automatically.
D. Both are stored in the database.
Answer» B. Both have to be called to operate.
Discussion
256.

A CASE SQL statement is which of the following?

A. A way to establish an IF-THEN-ELSE in SQL.
B. A way to establish a loop in SQL.
C. A way to establish a data definition in SQL
D. All of the above.
Answer» B. A way to establish a loop in SQL.
Discussion
257.

Which of the following is true concerning a procedure?

A. You do not create them with SQL.
B. They do not need to have a unique name.
C. They include procedural and SQL statements.
D. They are the same thing as a function.
Answer» D. They are the same thing as a function.
Discussion
258.

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

A. Equi-join
B. Natural join
C. Outer join
D. All of the above.
Answer» E.
Discussion
259.

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

A. Equi-join
B. Natural join
C. Outer join
D. All of the above.
Answer» D. All of the above.
Discussion
260.

SQL is:

A. a programming language.
B. an operating system.
C. a data sublanguage.
D. a DBMS.
Answer» D. a DBMS.
Discussion
261.

________ was adopted as a national standard by ANSI in 1992.

A. Oracle
B. SQL
C. Microsoft Access
D. DBase
Answer» C. Microsoft Access
Discussion
262.

A subquery in an SQL SELECT statement:

A. can only be used with two tables.
B. can always be duplicated by a join.
C. has a distinct form that cannot be duplicated by a join.
D. cannot have its results sorted using ORDER BY.
Answer» D. cannot have its results sorted using ORDER BY.
Discussion
263.

The SQL keyword BETWEEN is used:

A. for ranges.
B. to limit the columns displayed.
C. as a wildcard.
D. None of the above is correct.
Answer» B. to limit the columns displayed.
Discussion
264.

The SQL statement that queries or reads data from a table is ________ .

A. SELECT
B. READ
C. QUERY
D. None of the above is correct.
Answer» B. READ
Discussion
265.

SQL can be used to:

A. create database structures only.
B. query database data only.
C. modify database data only
D. All of the above can be done by SQL.
Answer» E.
Discussion
266.

To define what columns should be displayed in an SQL SELECT statement:

A. use FROM to name the source table(s) and list the columns to be shown after SELECT.
B. use USING to name the source table(s) and list the columns to be shown after SELECT.
C. use SELECT to name the source table(s) and list the columns to be shown after USING.
D. use USING to name the source table(s) and list the columns to be shown after WHERE.
Answer» B. use USING to name the source table(s) and list the columns to be shown after SELECT.
Discussion
267.

To sort the results of a query use:

A. SORT BY.
B. GROUP BY.
C. ORDER BY.
D. None of the above is correct.
Answer» D. None of the above is correct.
Discussion
268.

Which one of the following sorts rows in SQL?

A. SORT BY
B. ALIGN BY
C. ORDER BY
D. GROUP BY
Answer» D. GROUP BY
Discussion
269.

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

A. SELECT NAME IN CUSTOMER WHERE STATE IN (VA);
B. SELECT NAME IN CUSTOMER WHERE STATE = VA;
C. SELECT NAME IN CUSTOMER WHERE STATE = V;
D. SELECT NAME FROM CUSTOMER WHERE STATE IN (VA);
Answer» E.
Discussion
270.

When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):

A. LIKE only.
B. IN only.
C. NOT IN only.
D. Both IN and NOT IN
Answer» E.
Discussion
271.

SQL query and modification commands make up a(n) ________ .

A. DDL
B. DML
C. HTML
D. XML
Answer» C. HTML
Discussion
272.

Which of the following do you need to consider when you make a table in SQL?

A. Data types
B. Primary keys
C. Default values
D. All of the above.
Answer» E.
Discussion
273.

The SQL -92 wildcards are ____ and ____ .

A. asterisk (*); percent sign (%)
B. percent sign (%); underscore (_)
C. underscore(_); question mark (?)
D. question mark (?); asterisk (*)
Answer» C. underscore(_); question mark (?)
Discussion
274.

The HAVING clause does which of the following?

A. Acts like a WHERE clause but is used for groups rather than rows.
B. Acts like a WHERE clause but is used for rows rather than columns.
C. Acts like a WHERE clause but is used for columns rather than groups.
D. Acts EXACTLY like a WHERE clause.
Answer» B. Acts like a WHERE clause but is used for rows rather than columns.
Discussion
275.

In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:

A. all columns of the table are to be returned.
B. all records meeting the full criteria are to be returned.
C. all records with even partial criteria met are to be returned.
D. None of the above is correct.
Answer» B. all records meeting the full criteria are to be returned.
Discussion
276.

The result of a SQL SELECT statement is a(n) ________ .

A. report
B. form
C. file
D. table
Answer» E.
Discussion
277.

Which of the following is the correct order of keywords for SQL SELECT statements?

A. SELECT, FROM, WHERE
B. FROM, WHERE, SELECT
C. WHERE, FROM,SELECT
D. SELECT,WHERE,FROM
Answer» B. FROM, WHERE, SELECT
Discussion
278.

The SQL keyword(s) ________ is used with wildcards.

A. LIKE only
B. IN only
C. NOT IN only
D. IN and NOT IN
Answer» B. IN only
Discussion
279.

Which of the following is valid SQL for an Index?

A. CREATE INDEX ID;
B. CHANGE INDEX ID;
C. ADD INDEX ID;
D. REMOVE INDEX ID;
Answer» B. CHANGE INDEX ID;
Discussion
280.

SQL data definition commands make up a(n) ________ .

A. DDL
B. DML
C. HTML
D. XML
Answer» B. DML
Discussion
281.

A view is which of the following?

A. A virtual table that can be accessed via SQL commands
B. A virtual table that cannot be accessed via SQL commands
C. A base table that can be accessed via SQL commands
D. A base table that cannot be accessed via SQL commands
Answer» B. A virtual table that cannot be accessed via SQL commands
Discussion
282.

The wildcard in a WHERE clause is useful when?

A. An exact match is necessary in a SELECT statement.
B. An exact match is not possible in a SELECT statement.
C. An exact match is necessary in a CREATE statement.
D. An exact match is not possible in a CREATE statement.
Answer» C. An exact match is necessary in a CREATE statement.
Discussion
283.

Which of the following is the original purpose of SQL?

A. To specify the syntax and semantics of SQL data definition language
B. To specify the syntax and semantics of SQL manipulation language
C. To define the data structures
D. All of the above.
Answer» E.
Discussion
284.

The command to remove rows from a table 'CUSTOMER' is:

A. REMOVE FROM CUSTOMER ...
B. DROP FROM CUSTOMER ...
C. DELETE FROM CUSTOMER WHERE ...
D. UPDATE FROM CUSTOMER ...
Answer» D. UPDATE FROM CUSTOMER ...
Discussion
285.

You can add a row using SQL in a database with which of the following?

A. ADD
B. CREATE
C. INSERT
D. MAKE
Answer» D. MAKE
Discussion
286.

If an XML document does not have a DTD, then by definition it is:

A. not-type-valid.
B. type-valid.
C. an HTML document.
D. None of the above is correct.
Answer» B. type-valid.
Discussion
287.

The document that is used by XSLT to indicate how to transform the elements of the XML document to another format is a(n):

A. HTML page.
B. DOCTYPE procedure.
C. stylesheet.
D. stored procedure.
Answer» D. stored procedure.
Discussion
288.

XML is:

A. a subset of SGML only.
B. a hybrid of document processing and database processing only.
C. a standardized yet customizable way to describe the content of documents only.
D. XML is all of the above.
Answer» E.
Discussion
289.

If the XML data instance conforms to the DTD, the document is said to be:

A. type-invalid
B. type-valid.
C. not-type-valid.
D. an HTML document.
Answer» C. not-type-valid.
Discussion
290.

What is not true about XSLT?

A. XSLT is a declarative transformation language.
B. XSLT uses a set of rules that govern how a document is to be materialized is created
C. XSLT uses a set of procedures that specify how a document is to be programmed.
D. XSLT is used to transform the input document into another document.
Answer» D. XSLT is used to transform the input document into another document.
Discussion
291.

What is not true about XML?

A. Web page display is the most important application of XML
B. With XML, there is a clear separation between document structure, content and materialization.
C. XML is more powerful than HTML
D. XML documents have two sections.
Answer» B. With XML, there is a clear separation between document structure, content and materialization.
Discussion
292.

The DTD begins with the word:

A. #PCDATA.
B. XML
C. DOCTYPE.
D. HTTPS.
Answer» D. HTTPS.
Discussion
293.

XSLT processors evaluate each statement in the context of the match that has been made. That is, XSLT processors are:

A. context oriented.
B. procedural oriented.
C. object oriented.
D. relational oriented.
Answer» B. procedural oriented.
Discussion
294.

HTML is an application of a more robust document markup language called:

A. XHTML.
B. XML.
C. SGML.
D. None of the above is correct.
Answer» D. None of the above is correct.
Discussion
295.

An XML component that defines the structure of a document is known as a(n):

A. DOCTYPE
B. DTD.
C. #PCDATA.
D. HTML Stylesheet.
Answer» C. #PCDATA.
Discussion
296.

ADO.NET provides the ability to create and process in-memory databases called:

A. views.
B. relations.
C. tables.
D. datasets.
Answer» E.
Discussion
297.

The expression FOR XML RAW tells SQL Server to:

A. place the values of the columns as attributes in the resulting XML document.
B. place the values of the columns into elements rather than attributes.
C. place some columns into elements and others into attributes.
D. None of the above is correct.
Answer» B. place the values of the columns into elements rather than attributes.
Discussion
298.

XML Schemas consist of:

A. properties and methods.
B. elements and attributes.
C. structure and data.
D. tables and relationships.
Answer» C. structure and data.
Discussion
299.

What is not true about SOAP?

A. SOAP originally meant Simple Object Access Protocol.
B. SOAP was defined as an XML-based standard for providing remote procedure calls over the Internet.
C. SOAP now is just a name, not an acronym
D. SOAP was an early form of XML.
Answer» E.
Discussion
300.

To eliminate definition duplication, XML Schemas define:

A. an intersection table.
B. global elements.
C. a normalized definition table.
D. None of the above is correct.
Answer» C. a normalized definition table.
Discussion