Oracle 1Z0-051 Questions Answers

Which two statements are true regarding views? (Choose two.)

A. A sub query that defines a view cannot include the GROUP BY clause
B. A view is created with the sub query having the DISTINCT keyword can be updated
C. A Data Manipulation Language (DML) operation can be performed on a view that is created with the sub query having all the NOT NULL columns of a table
D. A view that is created with the sub query having the pseudo column ROWNUM keyword cannot be updated

Answer: CD
 

Which statements are regarding indexes? (Choose all that apply.)

A. For each data manipulation language (DML) operation performed, the corresponding indexes are automatically updated.
B. A nondeferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a unique index.
C. A FOREIGN KEY constraint on a column in a table automatically creates a non unique key
D. When a table is dropped, the corresponding indexes are automatically dropped

Answer: ABD

 

 https://ccsdschools.instructure.com/eportfolios/1708/Central_Technical_School/HuaweiHCS_Pre_Sale_IVS_Huawei_Certified_Presales_Specialist_IVS
https://atsu.instructure.com/eportfolios/386/Accelerated_Academy/VMwareProfessional_VMware_NSXT_Data_Center
https://ycs.instructure.com/eportfolios/234/Ravenwood_High/AmazonAWS_Certified_Solutions_ArchitectProfessional
https://iebh.instructure.com/eportfolios/732/Foundations_Academy/CompTIA_SY0601
https://umarycontinuinged.instructure.com/eportfolios/2140/Cypress_University/Splunk_Core_Certified_Consultant_SPLK3003

Oracle 1Z0-051 Question Answer

You issue the following command to drop the PRODUCTS table:
SQL>DROP TABLE products;
What is the implication of this command? (Choose all that apply.)

A. All data in the table are deleted but the table structure will remain
B. All data along with the table structure is deleted
C. All views and synonyms will remain but they are invalidated
D. The pending transaction in the session is committed
E. All indexes on the table will remain but they are invalidated

Answer: BCD


Which three statements are true regarding the data types in Oracle Database 10g/11g? (Choose three.)

A. The BLOB data type column is used to store binary data in an operating system file
B. The minimum column width that can be specified for a VARCHAR2 data type column is one
C. A TIMESTAMP data type column stores only time values with fractional seconds
D. The value for a CHAR data type column is blank-padded to the maximum defined column width
E. Only One LONG column can be used per table

Answer: BDE

Oracle 1Z0-051 Question Answer

You need to calculate the number of days from 1st Jan 2007 till date:
Dates are stored in the default format of dd-mm-rr.
Which two SQL statements would give the required output? (Choose two.)

A. SELECT SYSDATE - TO_DATE('01/JANUARY/2007') FROM DUAL;
B. SELECT TO_DATE(SYSDATE,'DD/MONTH/YYYY')-'01/JANUARY/2007' FROM DUAL;
C. SELECT SYSDATE - TO_DATE('01-JANUARY-2007') FROM DUAL
D. SELECT SYSDATE - '01-JAN-2007' FROM DUAL
E. SELECT TO_CHAR(SYSDATE,'DD-MON-YYYY')-'01-JAN-2007' FROM DUAL;

Answer: AC

Which two are true about aggregate functions? (Choose two.)

A. You can use aggregate functions in any clause of a SELECT statement.
B. You can use aggregate functions only in the column list of the select clause and in the WHERE clause of a SELECT statement.
C. You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.
D. You can pass column names, expressions, constants, or functions as parameter to an aggregate function.
E. You can use aggregate functions on a table, only by grouping the whole table as one single group.
F. You cannot group the rows of a table by more than one column while using aggregate functions.

Answer: AD

Oracle 1Z0-051 Question Answer

Which are /SQL*Plus commands? (Choose all that apply.)

A. INSERT
B. UPDATE
C. SELECT
D. DESCRIBE
E. DELETE
F. RENAME

Answer: D


Which two statements are true regarding the COUNT function? (Choose two.)

A. COUNT(*) returns the number of rows including duplicate rows and rows containing NULL value in any of the columns
B. COUNT(cust_id) returns the number of rows including rows with duplicate customer IDs and NULL value in the CUST_ID column
C. COUNT(DISTINCT inv_amt) returns the number of rows excluding rows containing duplicates and NULL values in the INV_AMT column
D. A SELECT statement using COUNT function with a DISTINCT keyword cannot have a WHERE clause
E. The COUNT function can be used only for CHAR, VARCHAR2 and NUMBER data types

Answer: AC

How Oracle Is Bringing Tech And Data Science To The Hospitality Sector

Dan Bell, vice president of sports and entertainment at Oracle Hospitality, explains how his company is at the forefront of the hotel industry's initiative to turn data into profits.

Technology is transforming all aspects of the sports industry, and one sector that has undergone particularly radical changes as a result is hospitality.

Advances in connectivity infrastructure in stadiums and stadiums have opened up new opportunities for operators to work in smarter and more sophisticated ways, which in turn has revolutionized the game day experience for both regular and guest viewers VIP.

For companies like Oracle Corporation, the giant of American multinational computer technology, hospitality is an area of the sports business that can benefit significantly through innovative applications of technology. Oracle Hospitality, its hospitality division, offers a range of software, hardware and related services for the industry, working with clients from sectors such as food and beverages, hotels and resorts, casinos and games, cruises and sports and entertainment.

Based in Columbia, Maryland, Oracle Hospitality has developed a variety of solutions that range from cloud backend services and event management software to point-of-sale (POS) tablets and other hardware specifically designed for the stadium environment. In sports, its client base includes teams, venues and dealerships on both sides of the Atlantic, including Miami Marlins baseball teams, the Hamburg Barclaycard Arena and food service management companies such as Delaware North, Aramark and Centreplate.

Although now well established in the industry, Oracle Hospitality dramatically improved its sports and entertainment capabilities when it acquired MICROS Systems Inc, a provider of integrated software and hardware solutions for the hospitality industry and the retail industry, in 2014. The acquisition brought with it more than 35 years of experience in sports and entertainment at Oracle fold, and the company has been investing heavily in space ever since.

Much of that investment has gone into developing new forms of software and hardware designed to ensure perfect operation of food and beverages, an important aspect of the general experience of the fans that, according to Dan Bell, vice president of sports and entertainment at Oracle Hospitality, has sometimes been overlooked in favor of more attractive and attractive elements.


"One of the most important things is the speed of service, we catch the fans quickly and do not miss any of the events," says Bell. "That could mean either a traditional concession line or seat service with a tablet-type device, I could be working with a colleague to place the order on the seat and deliver it to the seat." Kiosks seem to be arriving every time. more to play for self-ordered in the stadiums too ".


45 percent of attendees at events around the world left the lines because the wait was too long: the Experience Report of the fans of Oracle 2016


Bell's comments are evident in the findings of Oracle's 2016 Fan Experience Report, which found that 45 percent of attendees around the world left the lines because the wait was too long. The same investigation found that almost two-thirds of the fans 'would probably use' or 'definitely' use the order on the seat if they were available at their stadium, while more than half indicated that they would consider using a mobile application to order and pay for them. food and beverages to be collected from an express line.

Those results should arouse the interest of local teams and operators looking to improve their viewing experience, says Bell. The Oracle report points out how reducing wait times can generate direct ROI and how the use of mobile technology to improve order and payment can boost sales, especially since fans from all the countries surveyed said they would spend up to 30% more on average. if the waiting times were reduced by half.

But satisfying the hunger and thirst of an increasingly impatient customer base is only part of the story. For local operators, Bell says, the beauty of software like Oracle's Simphony Venue Management system is that its back-end capabilities can be customized and integrated into third-party mobile devices or digital menu boards, further streamlining the operation of food and drinks. In addition, you can also align with Oracle technology products to drive customers to other offers, such as ticket promotions and loyalty programs.

"It provides a great infrastructure and we have opened our APIs to our partners," says Bell. "If another place has a particular idea of how to improve or increase the speed of the service, we work with that place or partner to try to make it a reality."


Another advantage is that Oracle's software is rooted in the cloud, which improves operational efficiency, while reducing investment for local operators and opening up new opportunities for smaller organizations. "We can reach places that we have not traditionally been able to reach," says Bell (left). "Things like minor league baseball have been opened, or they could be colleges and universities."

He adds: "That really has opened things up from a market perspective in the sense that the IT demands of a stadium operator diminish if they are willing to go to the cloud because we manage the entire IT back-end for them. They do not have to worry about things like PCI security and refreshing servers and things like that. "

By combining those capabilities in the cloud with the power of machine learning and artificial intelligence (AI), Bell says Oracle Hospitality has positioned itself at the "cutting edge" of the hospitality industry's drive to turn data into profit. The strategy, he explains, has been to apply Oracle's state-of-the-art data analytics capabilities to the food and beverage industry, bringing data scientists, database engineers and seasoned hospitality consultants to an industry where margins are visible. constantly restricted.

One way to do this is through its new product Data Science Cloud Services, which analyzes a large amount of information in real time, monitors sales data, guests, marketing and staff performance to generate ideas that can be used to optimize efficiency and increase revenues.

•     Introducing SportsPro SmartSeries - Smart cities

By analyzing the behavior and preferences of customers, the technology allows food and beverage managers to evaluate menus and identify improvements, highlighting the best possible direct sales or cross-selling options by location or time of day. Meanwhile, an integrated Adaptive Forecast service allows operators to predict stock and labor needs at each location, using variables such as weather, type of event, time of day and day of the week to identify appropriate levels of inventory and personnel.

"This is really great for me because it goes beyond the doorbell of an order, you know, a hot dog, a beer and chips," says Bell. "It really does more backend analysis to meet the fans, ticket holders, members of loyalty a lot, much better in terms of what their patrons have been when ordering food on the spot.

"Later we can join that in ticketing solutions that we have, we can make an offer for them: if, for example, you enter the park at a certain moment, you get a special promotion." Therefore, it provides that artificial intelligence capacity to the solutions and I think it's a really innovative offer that we have now and we're very excited. "

 

https://missouriwestern.instructure.com/eportfolios/876/Accelerated_Academy/HCS_Pre_Sale_IVS_Huawei_Certified_Presales_Specialist_IVS
https://american-heritage.instructure.com/eportfolios/80054/Meadows_University/VMwareProfessional_VMware_NSXT_Data_Center
http://52.38.197.118/eportfolios/139/Granite_Bay_School/VMwareAssociate_VMware_Data_Center_Virtualization
https://wilkescounty.instructure.com/eportfolios/1428/Crestview_School/_Amazon__AWS_Certified_Solutions_Architect__Professional
https://canvas.barker.college/eportfolios/360/Eagle_Mountain_College/CompTIA_SY0601_Exam
 

Oracle 1Z0-051 Question Answer

Which two statements are true regarding single row functions? (Choose two.)

A. They can be nested only to two levels
B. They always return a single result row for every row of a queried table
C. Arguments can only be column values or constant
D. They can return a data type value different from the one that is referenced
E. They accept only a single argument

Answer: BD


Which two statements are true regarding working with dates? (Choose two.)

A. The default internal storage of dates is in the numeric format
B. The RR date format automatically calculates the century from the SYSDATE function but allows the user to enter the century if required
C. The default internal storage of dates is in the character format
D. The RR date format automatically calculates the century from the SYSDATE function and does not allow the user to enter the century

Answer: AB

Oracle 1Z0-051 Question Answer

Evaluate this SQL statement:
SELECT e.emp_name, d.dept_name
FROM employees e
JOIN departments d
USING (department_id)
WHERE d.department_id NOT IN (10,40)
ORDER BY dept_name;
The statement fails when executed. Which change fixes the error?

A. remove the ORDER BY clause
B. remove the table alias prefix from the WHERE clause
C. remove the table alias from the SELECT clause
D. prefix the column in the USING clause with the table alias
E. prefix the column in the ORDER BY clause with the table alias
F. replace the condition
"d.department_id NOT IN (10,40)"
in the WHERE clause with
"d.department_id <> 10 AND d.department_id <> 40"

Answer: B


Examine the statement:
Create synonym emp for hr.employees;
What happens when you issue the statement?

A. An error is generated.
B. You will have two identical tables in the HR schema with different names.
C. You create a table called employees in the HR schema based on you EMP table.
D. You create an alternative name for the employees table in the HR schema in your own schema.

Answer: D