Question is ⇒ You can add a row using SQL in a database with which of the following?, Options are ⇒ (A) ADD, (B) CREATE, (C) INSERT, (D) MAKE, (E) , Leave your comments or Download question paper.

Question is ⇒ You can add a row using SQL in a database with which of the following?, Options are ⇒ (A) ADD, (B) CREATE, (C) INSERT, (D) MAKE, (E) , Leave your comments or Download question paper. Previous question Next question


Q1.	You can add a row using SQL in a database with which of the following?
A.	ADD [Wrong Answer]
B.	CREATE [Wrong Answer]
C.	INSERT [Correct Answer]
D.	MAKE [Wrong Answer]
View Answer 1 -1 Explanation:- Answer : C 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 :

⇒ The benefits of a standard relational language include which of the following?
Reduced training costs
Increased dependence on a single vendor
Applications are not needed.
All of the above.

⇒ A subquery in an SQL SELECT statement is enclosed in:
braces -- {...}.
CAPITAL LETTERS.
parenthesis -- (...) .
brackets -- [...].

⇒ To sort the results of a query use:
SORT BY.
GROUP BY.
ORDER BY.
None of the above is correct.

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

⇒ What is an advantage of placing computations in SQL views?
To save users from having to write an expression.
To ensure that the results are consistent.
To accomplish both of the above.
None of the above is correct - computations cannot be placed in a view.

⇒ Which of the following is NOT a type of SQL constraint?
PRIMARY KEY
FOREIGN KEY
ALTERNATE KEY
UNIQUE

⇒ How many copies of a JSP page can be in memory at a time?
One
Two
Three
Unlimited

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

⇒ You can add a row using SQL in a database with which of the following?
ADD
CREATE
INSERT
MAKE

⇒ Which of the following is an SQL trigger supported by Oracle?
BEFORE
INSTEAD OF
AFTER
All of the above.

⇒ The wildcard in a WHERE clause is useful when?
An exact match is necessary in a SELECT statement.
An exact match is not possible in a SELECT statement.
An exact match is necessary in a CREATE statement.
An exact match is not possible in a CREATE statement.

⇒ 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.

⇒ 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.

⇒ The SQL keyword(s) ________ is used with wildcards.
LIKE only
IN only
NOT IN only
IN and NOT IN

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

⇒ The SQL ALTER statement can be used to:
change the table structure.
change the table data.
add rows to the table.
delete rows from the table.

⇒ Which type of SQL Server cursor concurrency places an update lock on a row when the row is read?
READ_ONLY
SCROLL_LOCK
OPTIMISTIC
READCOMMITTED

⇒ When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):
LIKE only.
IN only.
NOT IN only.
Both IN and NOT IN.

⇒ Which of the following is the original purpose of SQL?
To specify the syntax and semantics of SQL data definition language
To specify the syntax and semantics of SQL manipulation language
To define the data structures
All of the above.

⇒ The command to eliminate a table from a database is:
REMOVE TABLE CUSTOMER;
DROP TABLE CUSTOMER;
DELETE TABLE CUSTOMER;
UPDATE TABLE CUSTOMER;

⇒ The HAVING clause does which of the following?
Acts like a WHERE clause but is used for groups rather than rows.
Acts like a WHERE clause but is used for rows rather than columns.
Acts like a WHERE clause but is used for columns rather than groups.
Acts EXACTLY like a WHERE clause.

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

⇒ Which of the following is a correlated subquery?
Uses the result of an inner query to determine the processing of an outer query.
Uses the result of an outer query to determine the processing of an inner query.
Uses the result of an inner query to determine the processing of an inner query.
Uses the result of an outer query to determine the processing of an outer query.

⇒ With this type of SQL Server cursor concurrency no lock is obtained until the user updates the data.
READ_ONLY
SCROLL_LOCK
OPTIMISTIC
PESSIMISTIC

⇒ 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.

⇒ What is bytecode?
Machine-specific code
Java code
Machine-independent code
None of the above is correct.

⇒ 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');

⇒ To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.
ONLY
UNIQUE
DISTINCT
SINGLE

⇒ What is invoked via HTTP on the Web server computer when it responds to requests from a user's Web browser?
A Java application
A Java applet
A Java servlet
None of the above is correct.

⇒ 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
Equi-join
Natural join
Outer join
Cartesian join