Question is ⇒ Which of the following do you need to consider when you make a table in SQL?, Options are ⇒ (A) Data types, (B) Primary keys, (C) Default values, (D) All of the above., (E) , Leave your comments or Download question paper.

Question is ⇒ Which of the following do you need to consider when you make a table in SQL?, Options are ⇒ (A) Data types, (B) Primary keys, (C) Default values, (D) All of the above., (E) , Leave your comments or Download question paper. Previous question Next question


Q1.	Which of the following do you need to consider when you make a table in SQL?
A.	Data types [Wrong Answer]
B.	Primary keys [Wrong Answer]
C.	Default values [Wrong Answer]
D.	All of the above. [Correct Answer]
View Answer 1 -6 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 :

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

⇒ To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:
a particular column in a particular underlying table.
a particular column in a particular row.
a particular row in a particular underlying table.
None of the above is correct.

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

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

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

⇒ What is not true of a Java bean?
There are no public instance variables.
All persistent values are accessed using get and set methods.
It may have many constructors as necessary.
All of the above are true of a Java bean.

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

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

⇒ SQL Server 2000 stored procedures can:
never be kept within the database.
be kept within the database and invoked by application programs.
be stored on the users' computer.
support BEFORE, INSTEAD OF and AFTER types.

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

⇒ Which one of the following sorts rows in SQL?
SORT BY
ALIGN BY
ORDER BY
GROUP BY

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

⇒ With this type of index, the data are stored in the bottom level of the index and in the same order as that index.
Nonclustered
Clustered
Primary
Secondary

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

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

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

⇒ How does Tomcat execute a JSP?
As a CGI script
As an independent process
By one of Tomcat's threads
None of the above is correct.

⇒ How many JDBC driver types does Sun define?
One
Two
Three
Four

⇒ SQL Server program code that is executed instead of an SQL command that needs to be processed is called a(n):
INSTEAD OF trigger.
BEFORE trigger.
AFTER trigger.
BEGIN trigger.

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

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

⇒ Which is NOT one of the most common types of SQL CHECK constraints?
System date
Range checks
Lists of values
Comparing one column value to another within the same table

⇒ SQL can be used to:
create database structures only.
query database data only.
modify database data only.
All of the above can be done by SQL.

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

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

⇒ When using the SQL INSERT statement:
rows can be modified according to criteria only.
rows cannot be copied in mass from one table to another only.
rows can be inserted into a table only one at a time only.
rows can either be inserted into a table one at a time or in groups.

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

⇒ The strictest transaction isolation level provided by SQL Server is called:
REPEATABLE READ.
SERIALIZABLE.
READ COMMITTED.
READ UNCOMMITTED.

⇒ SQL Server automatically creates an index on:
primary keys only.
foreign key only.
both primary and foreign keys.
SQL Server never automatically creates an index.

⇒ The SQL command to create a table is:
MAKE TABLE.
ALTER TABLE.
DEFINE TABLE.
CREATE TABLE.