Question is ⇒ ________ is an open source DBMS product that runs on UNIX, Linux and Windows., Options are ⇒ (A) MySQL, (B) JSP/SQL, (C) JDBC/SQL, (D) Sun ACCESS, (E) , Leave your comments or Download question paper.

Question is ⇒ ________ is an open source DBMS product that runs on UNIX, Linux and Windows., Options are ⇒ (A) MySQL, (B) JSP/SQL, (C) JDBC/SQL, (D) Sun ACCESS, (E) , Leave your comments or Download question paper. Previous question Next question


Q1.	________ is an open source DBMS product that runs on UNIX, Linux and Windows.
A.	MySQL [Correct Answer]
B.	JSP/SQL [Wrong Answer]
C.	JDBC/SQL [Wrong Answer]
D.	Sun ACCESS [Wrong Answer]
View Answer 1 -1 Explanation:- Answer : A 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 :

⇒ A view is which of the following?
A virtual table that can be accessed via SQL commands
A virtual table that cannot be accessed via SQL commands
A base table that can be accessed via SQL commands
A base table that cannot be accessed via SQL commands

⇒ Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain:
GROUP BY.
WHERE.
ORDER BY.
FROM.

⇒ A ________ is a program that performs some common action on database data and that is stored in the database.
trigger
stored procedure
pseudofile
None of the above is correct.

⇒ 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

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

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

⇒ SQL views can be used to hide:
columns and rows only.
complicated SQL syntax only.
both of the above can be hidden by an SQL view.
None of the above is correct.

⇒ With this type of index, the bottom level of an index does not contain data, but rather it contains pointers to data.
Nonclustered
Clustered
Primary
Secondary

⇒ Which of the following is true concerning a procedure?
You do not create them with SQL.
They do not need to have a unique name.
They include procedural and SQL statements.
They are the same thing as a function.

⇒ 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

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

⇒ The SQL keyword BETWEEN is used:
for ranges.
to limit the columns displayed.
as a wildcard.
None of the above is correct.

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

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

⇒ Which of the following statements is true concerning routines and triggers?
Both consist of procedural code.
Both have to be called to operate.
Both run automatically.
Both are stored in the database.

⇒ 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 command to remove rows from a table 'CUSTOMER' is:
REMOVE FROM CUSTOMER ...
DROP FROM CUSTOMER ...
DELETE FROM CUSTOMER WHERE ...
UPDATE FROM CUSTOMER ...

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

⇒ For what purposes are views used?
To hide columns only
To hide rows only
To hide complicated SQL statements only
All of the above are uses for SQL views.

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

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

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

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

⇒ SQL is:
a programming language.
an operating system.
a data sublanguage.
a DBMS.

⇒ Which of the following is one of the basic approaches for joining tables?
Subqueries
Union Join
Natural join
All of the above

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

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

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

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

⇒ Using SQL Server 2000, which of the following symbols is used to indicate parameters in stored procedures?
#
%
&
@