Sawaal
0
Q:

 What SQL command will allow you to change the table STUDENT to add the constraint named GradeCheck that states that the values of the Grade column must be greater than 0?

A) ALTER TABLE STUDENT ALTER CONSTRAINT GradeCheck (Grade > 0); B) ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck (Grade > 0);
C) ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0); D) None of the above is correct.

Answer:   C) ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0);



Explanation:
Subject: Database
Related Questions
Q:

The FROM SQL clause is used to 

A) specify what table we are selecting or deleting data FROM B) specify search condition  
C) specify range for search condition   D) None of these
 
Answer & Explanation Answer: A) specify what table we are selecting or deleting data FROM

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

4 1620
Q:

A data dictionary is a special file that contains

A) The width of all fields in all files B) The data type of all fields in all file
C) The name of all fields in all files D) All of the above
 
Answer & Explanation Answer: D) All of the above

Explanation:

A data dictionary is a special file that contains a set of information describing the contents, format, and structure of a database and the relationship between its elements, used to control access to and manipulation of the database.

Report Error

View Answer Report Error Discuss

Filed Under: Database
Exam Prep: Bank Exams
Job Role: Analyst , Bank Clerk , Database Administration , IT Trainer

7 4908
Q:

Cloud computing is not suited for situations

A) where complex legacy systems have to be ported B) characterized by limited-time tasks
C) involving offloading of expensive computing tasks D) with no existing regulatory compliance issues
 
Answer & Explanation Answer: A) where complex legacy systems have to be ported

Explanation:

Cloud computing is not suited for situations where complex legacy systems have to be ported.

Report Error

View Answer Report Error Discuss

Filed Under: Database
Job Role: Analyst , Database Administration , IT Trainer

4 2507
Q:

Which of the following is not true about cloud computing?

which_of_the_following_is_not_true_about_cloud_computing1539240737.jpg image

A) Cloud-based management platforms cannot support internally hosted server platforms B) Cloud-based management platforms can support multiple cloud-virtual server vendors
C) Cloud-based management platforms can support multiple cloud-virtual server operating systems D) Cloud-based management platforms can support change management methodologies
 
Answer & Explanation Answer: A) Cloud-based management platforms cannot support internally hosted server platforms

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database
Job Role: IT Trainer , Database Administration , Analyst

6 14964
Q:

Which of the following is true about cloud computing?

A) Cloud computing has brought about a drop in hardware and software sales, while augmenting service revenues B) You can access your data from any computer in the world, as long as you have an Internet connection.
C) Both A & B D) It's always going to be less expensive and more secure than local computing.
 
Answer & Explanation Answer: C) Both A & B

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database
Job Role: Database Administration , IT Trainer , Project Manager

2 8425
Q:

Cloud computing uses Server virtualization.

A) TRUE B) FALSE
Answer & Explanation Answer: A) TRUE

Explanation:

Cloud computing :: 


Cloud computing is an information technology (IT) paradigm that enables ubiquitous access to shared pools of configurable system resources and higher-level services that can be rapidly provisioned with minimal management effort, often over the Internet.


 


Server virtualization :


Server virtualization is a virtualization technique that involves partitioning a physical server into a number of small, virtual servers with the help of virtualization software. In server virtualization, each virtual server runs multiple operating system instances at the same time.


cloud-computing_server_virtuaization1532503685.jpg image


 


Server virtualization is more for a good reason. It offers the potential to dramatically save space and improve server efficiency. Vendors are in fierce competition to offer the most advanced tools that they hope will earn them the virtualization crown.


 


Hence, the given statement that 'Cloud computing uses Server virtualization.' is TRUE.


 


 

Report Error

View Answer Workspace Report Error Discuss

Subject: Database
Job Role: Database Administration , IT Trainer , Network Engineer

5 3103
Q:

Which of the following describes a relational database?

A) It retrieves data related to its queries B) It provides a relationship between floats
C) It provides a relationship between integers D) It consists of separate tables or related data
 
Answer & Explanation Answer: D) It consists of separate tables or related data

Explanation:

A relational database is a digital database based on the relational model of data, a database structured to recognize relations between stored items of information. A software system used to maintain relational databases is a relational database management system.

 

Computer database in which all data is stored in Relations which (to the user) are tables with rows and columns. Each table is composed of records (called Tuples) and each record is identified by a field (attribute) containing a unique value. Every table shares at least one field with another table in 'one to one,' 'one to many,' or 'many to many' relationships. These relationships allow the database user to access the data in almost an unlimited number of ways, and to combine the tables as building blocks to create complex and very large databases.

Report Error

View Answer Report Error Discuss

Filed Under: Database
Exam Prep: Bank Exams
Job Role: Analyst , Bank Clerk , Bank PO , Database Administration , IT Trainer , Project Manager , Software Architect

4 3297
Q:

The command to eliminate a table from a database is

A) REMOVE TABLE CUSTOMER; B) UPDATE TABLE CUSTOMER;
C) DELETE TABLE CUSTOMER; D) DROP TABLE CUSTOMER;
 
Answer & Explanation Answer: D) DROP TABLE CUSTOMER;

Explanation:

The SQL DROP TABLE statement is used to remove a table definition and all data, indexes,...

Report Error

View Answer Report Error Discuss

Filed Under: Database
Exam Prep: AIEEE , Bank Exams
Job Role: Analyst , Bank PO , Database Administration , IT Trainer , Project Manager

4 3909